Hi Ssatech,
I agree with your solution as this is where the backup command normally appears.
In this case however its not there nor is it in Tools either.
any more suggestions
thanks
Hi Folks,
it may seem a low level question but I cannot find the backup database command on the access drop down menu. On my laptop installation of access its there in the menu bar.
All help welcome.
thanks
Hi I am new to this.
I would like to know how on the close of a form i can set a field value to no (its a yes/no field) for all of the records in an associated table.
thanks in anticipation.
Encodeme
I have a table called Customer and this is linked to a form Customers.
I would like to start a pre written parameter style query from this form but only want to include the customer information of the Customer showing on the open form i.e. the current open record.
I am not sure how to do this.
many thanks Mr Merlotti.
I found and sorted the security warning fix, but am not sure about the Where clause in the statement.
I imagine it should read on the lines of
SQLStatement:="SELECT * FROM [blended query]"WHERE tblCustomer.lastname= FormCustmers.lastname.
Aas yet Iam truly a SQL novice...
I have 2 tables, Customers and Information linked by a common field Linknumber.
They both have a form. Customers is the main form, and Information is a sub form of Customers.
A query called Blended Query takes the data from both tables
On the sub form is a Command button that starts a Macro...
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.