Search results

Hi guys, I know very little about VBA; I have just put together some code bits based mostly on what I see in this forum :) There is a manual process I'd like to automate. Instead of the user manually importing an external file into a table, I want a function to grab the most recent file in a...

With all due respect, I feel like you guys aren't reading my posts all the way through. I'm having to repeat info more than once. @jdraw: I know my db isn't normalized, as evidenced by my comment above, "Someday I hope to get that all changed but meanwhile I'm stuck with the tables as they...

Please see my first example. I can manipulate the date all I want to but how do I append the date to the end of a table name? I need VBA for that, right? I don't know how to concatenate something like that in a regular query. SELECT [blah] INTO NEW_TABLE_09_12_11 or SELECT * FROM NEW_TABLE_09_12_11

Sorry for the late reply. The column names are not dates. They are just named Date1, etc. The table names do include dates, however. Someday I hope to get that all changed but meanwhile I'm stuck with the tables as they are.

Greetings from America, I know extremely little about VBA and modules, but I need to simplify some queries that I run quite a bit. They all involve dates, and I'm getting tired of typing the date all the time. Part of the problem is that the dates are in different formats (I'm not allowed to...