Recent content by RevJeff

Let me explain further. The table I am using has all of the fields. Within that table there is a field called "Tiers" and they can be "Tier 1", "Tier 2" and "Tier 3". The current recordset looks at all records from yesterday and assigns them to the users for review. Because of the volume of...

I have three separate recordsets that have the same fields. Is there a way to combine them into one recordset? TIA

It was a lot easier to just move the autonumber primary key field to the last field in the table.

Hello everyone, I'm trying to import an excel spreadsheet using VBA into an existing table that has an autonumber primary key as the first field. How can I import the spreadsheet starting with the second field in the table? I hope that makes sense. TIA

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.

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

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.

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

Thank you for all of your help.

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

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...

That worked perfectly! Thank you!

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()...

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...