Search results for query: *

In previouse Access databases I mail merged queries into word documents to get just what I wanted. In the new Access2003 I can not find where the data source for mail merge can be a existing query in an Access database. All I come up with is table links. Am I doing something wrong or has this...

I want any field that the user double clicks on a form to default to todays date without having to do VB code for each double click event on each form.

Hello Does anybody know how to set any field in a database to todays date if they press double click on a form ? I have set an event that on double click does the following Private Sub Text7785_DblClick(Cancel As Integer) Me![Job Received] = Date End Sub Is there a macro or vb module I can...

I have a .mdb database and it runs Word mail merges when I press a button. I can't figure out why it is opening the database up again when I request a mail merge document to open. This is affecting my mail merge query which runs and uses an open form to populate a parameter it has to get the...

I have just noticed that the database opens up again once I press the button to run the mail merge. If I can work out how to stop it opening up again I think it will stop asking for the parameter in the query. Has this happened to anybody else.

I have a .mdb database and it runs mail merges to produce administrative letters. When the user wishes to do this, they press a button, this links to a word document which runs a query back in Access. On one of the access fields, I have a parameter as follows The form is already open and the...

Please does anybody know about picking up data from a previous form or sending data to a new form. I have tried the method of altering the control source for the item to be =forms![formname]![fieldname] I have also sent the data when the form is being opened in the Event procedure with a docmd...

Hello, I was wondering what I am possibly missing when I try to do the following. I have a .mdb database and on it I have a combo box. This looks up the values in another table and populates the combo box with the key value of the table being looked up. If I then go and add a record that the...

Hello Please does anybody know why a form stops allowing data to be keyed in to it's fields? It is a form that adds records to tables in my Access database. I have recently added another table to the database which links to a table that is on the form. It will not allow any of the fields to...

Please can anybody help I am in the process of transferring data from an access db (MDB)to an excel spreadsheet. Access 2003 / Excel 2002 I have created a procedure that will Present a form allowing the user to select what they want to transfer Run a macro that will Run a query selects...

Can anybody help with a table design problem I am trying to get my head around. My employer wants me to store market types. Each market type has any number of sub types attatched to it. I have set up two tables as a one to many relationship. One that has Market type number and description...