| Thread | Last Post | Replies |
|
| Import all excel files in a particular folder into one master tabl | 01 May 2008 11:40 GMT | 4 |
I wish to import all the files in the folder c:/test/
I prepared a macro but it is very troublesome to set the macro for 50 files.
Please help me with a code which imports data from worksheet "Full recon"
into one master table of MS Access. the format of all the files is same.
|
| Access 2007 File Disappears | 01 May 2008 08:08 GMT | 5 |
What would make a Access 2007 file disappear after it compresses? I have the
option selected to compress on close, but after it compresses and closes the
file just disappears. The file is located on a MS 2003 Server with shares to
appropriate users that interface it with Access ...
|
| Corrupt forms that can’t be open ed! | 01 May 2008 07:11 GMT | 5 |
Sometimes, when I try to save a form after I have been working in design mode
an error message appear. The error message says some thing like this “Can’t
save the form. Out off memory”. Then, after closing the application without
saving changes, the form isn’t possible to open ...
|
| How to write an append query on a recordset | 01 May 2008 05:53 GMT | 1 |
I have some code running on an event procedure. At one point in the code I
need to run an append query. If the data to be appended to the table
LETTERHISTORY was in another table, I would just have an append query and
DoCmd.OpenQuery "QueryName".
|
| How to do an append query to a table from a recordset | 01 May 2008 01:51 GMT | 2 |
I have some code running on an event procedure. At one point in the code I
need to run an append query. If the data to be appended to the table
LETTERHISTORY was in another table, I would just have an append query and
DoCmd.OpenQuery "QueryName".
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread