Search results

  1. R

    Solved Word to Access Record Set

    Thanks for everyone's help. I ended up doing a Compact/Repair on the database and it solved the issue. Runs like a champ now.
  2. R

    Solved Word to Access Record Set

    Thank you Pat. I use DAO, but now my problem is that the database that I am connecting to is already open and when I go to Set the DB I can't because it is already open. Set db = OpenDatabase(strDB, False, True) How can I Set an already open DB. Thanks
  3. R

    Solved Word to Access Record Set

    Thank you for responding, but the problem I am facing it that I don't know how to open the Access table from within Word or Excel.
  4. R

    Solved Word to Access Record Set

    Is there a way to open an Access table as a record set from within Word VBA. Basically I want to takes 6 variable out of Word and import them into an Access table and I will be looping from page to page. I'm just not sure how to open a record set in Access from Word or if it's even possible. TIA
  5. R

    Solved Delete first character

    Thank you for all of your help.
  6. R

    Solved Delete first character

    Hello, Is there a way to delete the first character of every line in a text file? TIA
  7. R

    Open Notepad and Find/Replace

    Hello, Let me start by saying, I know I don't have to open Notepad to edit a text file, but in this case I need to. So I receive a text file from a main frame. The first character of every line is an unrecognizable character, see below. I need to be able to remove this character. The...
  8. R

    Solved SetFocus

    That worked perfectly! Thank you!
  9. R

    Solved SetFocus

    I don't really have much code. I tried this on the On Click for the specific tab, which only works if you click on the body of the Tab, not the actual Tab at the top. I then set the Tab Order of the button on the Tab and that still didn't work. Private Sub REPO_Click()...
  10. R

    Solved SetFocus

    Hi, I have a form with a Tab Control on it. I have 3 tabs on the Tab Control and I am trying to SetFocus to a specific Button on each Tab when I click those tabs, but it doesn't work. It's acting like every time I click those tabs it chooses a different focus on that tab. I hope I explained...
  11. R

    Back color of Tab Controls

    Hi All! I have spent hours trying to figure this out. Is there anyway to change the back color of Tab Controls? All that shows is a white backgound. Thanks!
  12. R

    Solved Combine Records

    Hello all, I have a table that looks like this: It shows Customer Number, Name, CityState, and the days of the week with Delivery ETAs. Is there a way through code or a query where I can have customers with the same CustNo be on one line instead of the two. See below. Thanks for any help...
  13. R

    Solved Report Font Size

    Thank you! That worked perfectly!
  14. R

    Solved Report Font Size

    Is there a way to allow a user to select a font type and/or size of a report through a Form before the report is opened? The different reports are various labels and sometimes there is more of less data on them. So if there is more or less data, they can change the font size to fit the label...
  15. R

    File Select within Macro

    I have a macro that uses ImportExportSpreadsheet option, but the file is hardcoded. Is there a way, within the macro, to open a select dialog box to allow me to select a file. I know I can be done with VBA just didn't know if there was a way within the Macro. Thanks
  16. R

    Solved Open External Access Database

    Just open it and let the user have control.
  17. R

    Solved Open External Access Database

    Is there a way of opening a second database using VBA from within the first database? Thanks
  18. R

    Solved File Copy

    I am trying to copy a file from a SharePoint folder to a local folder on the C:\ and I am getting the following error. Here is my code: FileCopy...
  19. R

    Create QR code in access report

    I know this is an old post, but I just came across it. Is there away to adjust how much information can be in the barcode. I noticed there is a point when the QRCode doesn't fit and gets cutoff.
Top Bottom