Search results

I guess I'm having an off day today, nothing seems to be working for me, and now it's my for loops. I need to go through each field in a table and return the names of those fields to determine what variables need to be set at. Granted I'm not too familiar with Access, but I've tried all the...

If you set up an input box and use the variable name from the input box you can replace it. I.e.: dim inpCompany as string dim SQL as string inpCompany = inputbox ("Which company is it?") SQL = "SELECT (extra stuff) C" & inpcompany & "_DATA_LINKED.SEARCH (the rest);" That should work...

Thanks Byte! All of the tables I'm importing seem to have a different field name and I looked over it on accident. Thanks!

Try: objword.activate Should work. Worked for me linking from Excel.

Thanks ByteMyzer! If it helps at all, I'm running Office 03 Pro I hate to be a menace, or at least annoying, but after several takes at it, I'm getting a new error. Error 3061; "Too few parameters. Expected 2." I've tried adding a parenthesis in front of Model_Number and behind the strproject...

I'm attempting to append a table using only a few fields from another table. Unfortunately, I have to take a generalized approach with the "master" table (the one being appended) since it needs to hold a listing of information from several tables. So my thought process was to add a field...