Search results for query: *

Hi I have a table for enquiries from customers and I populate this through a form.I have a field ( combo getting its values from Categories table) for category of product under enquiry. I have a separate suppliers table with a field for category to query it to get list of suppliers under the...

Hi I used the Packaging wizard to create a package for an application in MS Access. One of the users does not have MS Office or MS Access. The package has been copied in his computer. When he tries to run the setup from the package to install the application, the following message comes up: VB...

Hi My Access runtime application is a very heavy file( 160MB).The database file itself is only 10% of the file.Could someone advise me the way I could install a back up and restore procedure for the users from the Switchboard they can hold just the data in a floppy or a couple and restore in...

Hi I need to update a field ( TransactionDate)in a row selected by a criteria ( TNo = '4') in a table (tblM)as when there is an update of a control ( StartDate)in a form which populates another table (tblCompanyinfo). I tried this. On the AfterUpdate property of the StartDate control on the...

I have a table and one of its fields( account heads) is populated through a form which has a combobox from which a selection is made. I have a select query (No:1)working on a parameter input by the user. (Which account head?). Whenthe query is run for a particular account head and if the...

Dear BK I have now tried your solution and it works as follows. When an invalid date is entered, it throws a message and if I clicked okay, it then just carries on and allows me to complete the form and save it with the invalid date in the table.I need it to stop me from accepting an invalid...

I have 2 tables set up.The first table has among many,2 fields,one for 'Start Date' and the other 'End Date'.This is populated by Form 1. The other table 2 has many fields and one field is 'Transaction Date'.This is populated by form 2.I would like to achieve 2 things. 1.When the user inputs a...

Hi I have a report based on a query in which one of the fields has a criteria ( selecting a name among 9 names) for a group by. I do the [which name] now on the criteria box in the query and it works. I do get the pop up when I ask for the report.The problem is the user has to get the name...

Hi One of my report is based on a calculated field in a query.It is long expression covering a number of fields in the query.I have a need for another report based on completely different query which also requires that one figure i.e the calculated one in the first query. I tried to bring that...