Search results

make sure you have all the add-ins installed

there is a product called Monarch that you may need to scrub this data before moving to access or you may need to write some vb code to clean the data before you get the data to access.

i have similar problem where special foreign characters are not being imported into the table correctly. where can i change how the data is imported so the accents are not lost? I can import into excel without any issues.

is there a way that for for if specific part numbers are displayed as results in a report detail that a respective pdf file is also outputted in the report? part a and pdf a part b and pdf b part c and pdf c

decompile all modules is this the same as compile and save all modules?? If not can you tell me how I would go about decompiling all modules. thx

I have a corrupted db in Access 97 that I was able to convert to Access 2000 compact and repair and then convert back to Access 97 which I have successfully done several times before. The problem is now when I opened the db in 97 I get an error msg saying that my visual will be updated to the...

I tried that and I am getting an error msg that expression has a function name that MS Access can't find I am using Access 2000

FYI You don't have to rename the lis file as txt file in order for access to import it. You can open the .lis file if you specify the file naem e.g. file.lis when getting external data or if you are using a macro to import the info you can use macr to TransferText and then put in file path e.g...

Is there a way to run a script to delete all import error tables? There has a been a couple mention of this topic in this forum but I haven't been able to get the code to work for me. Any help would be appreciated. thx

Is there a way to run a script to delete all import error tables? There has a been a couple mention of this topic in this forum but I haven't been able to get the code to work for me. Any help would be appreciated. thx

An option would be to write a macro to send the object/query, then write a bat file to open access and execute the macro, and then utilize task scheduler in windows to execute the macro per your schedule.

An alternative would be to just set up a macro to e-mail the user(s) a reminder message, write a bat file to execute the macro and then schedue the bat file to run based on the task scheduler.