Hello, I'm using Access 2003 to work on cleaning up and modifying records in a database with about 7k records.
I've been trying to run a Make-Table Query on the table with 7k records, but every time I run it, Access almost instantly pops up the "Microsoft Access has encountered an error and will be closing. Please send error report to Microsoft" etc.
I thought it was because there were too many records, but 7k doesn't...
3 results in 0.0041 seconds.
-
Database Shuts Down Upon Query
-
"Too Few Parameters" error
I'm trying to allow database users to click on a button on a form and send e-mail to certain clients based on what criteria they select from a drop-down box on said form.
The send e-mail function works fine - as long as there are no criteria/parameters/clauses (in my case, these criteria reference the combo boxes on the form) in the query from which the e-mail addresses are pulled. Criteria results in an "too few parameters,... -
Want to create a make table query using vba
Hi I am newbie, can you please help me to create this query through vba
I want to create a make table query.Code:SELECT [010710_pri].Field1, [010710_pri].Field2, [010710_pri].Field3, [010710_pri].Field4, [010710_pri].Field5 FROM 010710_pri GROUP BY [010710_pri].Field1, [010710_pri].Field2, [010710_pri].Field3, [010710_pri].Field4, [010710_pri].Field5 HAVING (((Count(*))=1));
