Recent content by AaronC

Thanks, Wayne! Will investigate further tommorrow. Aaron

Does anyone know how to import Microsoft Project data into an Access database? I am looking to use "high level" MS Project schedule data as input to a new Access application that I am currently designing. Is this even possible? Any help or links to more information is GREATLY appreciated...

How can I prevent all remaining Macro actions from executing after getting an error in a vba module (such as an ODBC timeout) in a previous macro step? I know I can add conditions to each macro step, but don't know how to look for "any error". Any help is appreciated!! Thanks

Thanks! I created to SQL and the form parameters into the querydef and it works great.

Thanks, I was hoping for an alternative. I run into memory problems when I build the SQL statement in VB...that's why I was trying to do it in a stored query. There must be a workaround... :(

I am creating a query that retrieves data from one table and creates a second table. I want to name the columns in the new table using the contents of the controls from a form within the same mdb. The form will be open when this query is run, but I am having trouble creating and saving the...

Thanks! Worked like a charm! Thanks tons :)

Does anyone know how I can save the results of my crosstab query into a new table (like a Make Table query does)? Any help would be greatly appreciated!

Thanks Modest Thanks for your help...things are working fine now

Stills requests user to 'Enter Parameter Value" Thanks, but to no avail. Still prompts for user to enter a parameter value. When you view the generated query in Design View, it shows the field to retrieve: Expr1: WkndAbs_Small.[2/12/2005]

Any help with this is appreciated, I'm treading new territory here: I am creating a QueryDef object so that I can dynamically build a simple select statement using a value entered on a form as the field to return. It builds my SQL statement just fine (as I see in the MsgBox display). It...