Search:

Type: Posts; User: Stevep4; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Printer settings will not stick Staple + Collate

    I have a database that prints out around 50 reports directly from my Access database. Just this week I've run into an issue with the printer settings. When I select Staple + Collate the settings will...
  2. Replies
    2
    Views
    482

    Tighten up vb code for Access Database

    I have code in my Access Database that does the following:

    In a form (MainForm) that has a record source from a table called SectionTable. The below code is looking at the first record in...
  3. Re: Tring to get VB code to automatically scroll through a table.

    The macro is running a single query. The query is looking at the MainForm and the field TabField within the MainForm. The Tabfield is populated with a piece of data. Let's say it says "Accessories."...
  4. Re: Tring to get VB code to automatically scroll through a table.

    Thanks for replying. I'm not a programmer and I usually just have to figure things out as I go. I'll try and give as much detail as possible. I have an Access form call MainForm with a Record Source...
  5. Tring to get VB code to automatically scroll through a table.

    Hi. I have VB code that looks at a table connected to a form and runs a macro ("ApdTabtoTotalTest"). I have it set up to go to the next record. It works, but the issue is that I have to manually run...
  6. Replies
    1
    Views
    642

    Link a CSV file in an Access database

    Does anyone know how to link an csv file to an Access database? I can link xlsx or a text file, but not sure about csv. Thanks
  7. Replies
    2
    Views
    516

    loop through records in an Access form

    I literally did this 15 years ago in Access, but have forgotten. I have a form connected to a table. I want code that will simply look at the filelds in the table, loop through them so that I can run...
  8. Export an Access report as a PDF with a specific name using code

    I'm trying to export an Access report to a specific location with the file saving with a specific name that is linked to a form in the Access database. I have the below code. The problem is with the...
  9. Creating an XLSX from from tabs in an XLSM file

    I'm taking four tabs in an XLSM file and creating a new XLSX file. The XLSM has many tabs, and I'm creating 10 XLSX files from this one big XLSM file. When I run my macro, I'm getting the below...
  10. Need to save an Excel Worksheet as a PDF and KEEP print settings.

    I have the below code set up to take an excel tab and save is as a PDF file. As an Excel tab, I have the page set up the way I want. However, when I export it as a PDF, the settings are gone. It...
  11. Replies
    1
    Views
    167

    Sorting Columns Using VBA

    This one's driving me nuts. I have code to sort the active sheet of an xlsm file. Below is the code:



    With ActiveSheet.Sort
    .SortFields.AddKey:=Range("A2:A75000"), Order:=xlAscending
    ...
  12. Replies
    9
    Views
    410

    Re: VB Code is gone! Job on the line

    All I see is a white screen. All the code is gone. can't do anything. when I hit alt f11 it opens vb but it's just blank. when I go to tools, references it doesn't do anything. It's all just gone.
  13. Replies
    9
    Views
    410

    Re: VB Code is gone! Job on the line

    There's no backup. thanks
  14. Replies
    9
    Views
    410

    VB Code is gone! Job on the line

    I created a xlsm file that created like 10 reports automatically. I go to open the file and it says "Can't find project or library." All the code is gone. I can't save the file as a new file....
  15. Re: Printing a long array of excel sheets using VBA

    Thanks for folowing up. The below code does work except for one thing: The page numbers start over for each group. For the GroupA array it shows pages 1-3, and the same with GroupB. I want all 6 tabs...
  16. Re: Printing a long array of excel sheets using VBA

    Thanks so much for your reply. I'm still getting an error at the wb.worksheets(myGroup).printout. I'm going to see if I can figure out why.
  17. Re: Printing an Array of xlsx worksheets from a separate xlsm file

    Thanks! You're a life saver!
  18. Printing a long array of excel sheets using VBA

    I'm trying to use vba to print 54 tabs from a separate xlsx sheet. I've been able to get it to work. The only issue is that the list of 54 tabs is too long and causes an error. I can print, say, 30...
  19. Printing an Array of xlsx worksheets from a separate xlsm file

    I'm trying to figure out code that will print out specific worksheets from an xlsx file from an xlsm file. Let's say the file I want to print sheets off of is Print.xlsx and I want to print tabs...
  20. Printing tabs listed in a separte worksheet in Excel using VBA

    I have code provided by a fellow user that works when printing a list of tabs in cells. For example, the tab called "PrintPage" has a list of tabs from G12:G15. The following code works to print...
  21. Re: Copy data from an XLSM worksheet into a XLSX worksheet

    Thanks!
  22. Copy data from an XLSM worksheet into a XLSX worksheet

    The XLSM file is called FileA.xlsm
    The XLSX file is call FileB.xlsx

    I'm trying to copy data from the XLSM tab into the XLSX tab. Let's say the tab to I want to copy from is call COPYFROM and the...
  23. change header for tabs using vb where tab names are listed in a group of cells

    I'm trying to updatespecific tabs with a header using Visual Basic. Below is the code I have sofar. It's pointing to a specific tab ("PrintPage") and looking at G12down on PrintPage and adding a new...
  24. Re: Printing selected tabs from an array using visual basic

    Thanks again! I decided to use the first code you gave me. One more thing. Is there any way to change the headers for the same array before or after printing. Here's what I have so far but am getting...
  25. Re: Printing selected tabs from an array using visual basic

    Thank you so much!

    One question: Do you know how I can set it to print only one cell, or maybe 2 or 3? For example, I might want to set up code to print A2:A5 and then later run another job that...
Results 1 to 25 of 30
Page 1 of 2 1 2