Search results

Hmm, I'm still getting the same error message, I tried "DELETE * FROM tbl[Dates For TET];" too just in case the brackets had to surround only the table name. It's stopping at the "*" with the same error message as before. Incidentally, I just tried running a delete table (I'd tried it...

Just to add another question - How do I get the make table query to run when a button is pressed? I don't want to display anything of the query as it's only used to create the table, however it has to run and the table has to be present for another query (which interrogates the table created...

lol - its the name of the table - "Dates for TET" TET = Total Elapsed Time is it a problem?

Thanks for responding but when I try: "DELETE * FROM tblDates For TET" I get an error saying: "Compile error - Expected: expression" with the * highlighted. Any ideas??

Hi, I need a make table query to run when a database is started - that's the easy part. What i can't figure out is how to set the table field properties as it's created. I need two of the fields to be set as Date / Time however I can't find anything which seems to give me this option. I'm...

Hi there, I've got several queries which create pivot charts displaying various data. Currently, I've got a form with buttons which when clicked display the pivot chart view of the query so that it can be printed off etc... What I now want to do is to get Access to create a report which...