i'm a new user and followed a tutorial every step of the way untill i went to insert the recordset and it give the error
[!Microsoft][ODBC Microsoft Access Driver]Syntax error in FROM clause
but the from clause is simply insert all??
i've three tables in my databse, the others work apart...
i just created a form with lots of button that run queries. they all work but for some reason it wont let me save it because of an 'automation error'--please help!! i don't want to lose my work
i just created a form with lots of button that run queries. they all work but for some reason it wont let me save it because of an 'automation error'--please help!! i don't want to lose my work
help! trying to put in an overall aggerate function in the footer of my report but they alway give the response.
i'm using a text box but changing the control source to something like =Count([OrderID])
well do they? i've got a query that counts the no of items delivered in a particular sailing which i based a report on. i grouped it by port and it looks well but i'd likean total at the bottom at gives the over-all total of items delivered.....soooo...do i need to set up a new query to include...
i've setting up a simple databases that records crew member that take part in sailing. the main form has a key field-"Sailno", whereas the sub table which contains the various crew taking part has a key feild of "SailingID"
I'm tring to run an SQL query that find who have...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.