Search results

Sorry this has taken sooooooooo long to respond back to. You say use an unbound text field as the source as these can be linked to any part of a database. The query I am trying to run is based on the form the button that the append / delete queries operate from. Could I use that instead of...

I have a form with 4 date fields in for receipt of paperwork covering different sections. These all need to be selected before progressing to the next part of the form. This I have done. Noramlly the information is submitted all at the same time but sometimes the sections arrive at different...

Cheers Pat worked fine.

Created a Query that uses same field names, i.e Title, Forename and Surname. The query handles this no problem. However trying to join the fields together and getting a syntax error. I believe the problem is the way Access views same field names but different forms. Distributor.Title...

Done and now it works.

Created a Query that uses same field names, i.e Title, Forename and Surname. The query handles this no problem. However trying to join the fields together and getting a syntax error. I believe the problem is the way Access views same field names but different forms. Distributor.Title...

I have a report which is just a letter to say we have received your application. However to keep the address window small I have placed Address1 and Address2 on the same line seperated by a (,). The query to generate the report works fine but when you look at the report the spacing is all over...

In your query try putting under the Order Date section in Criteria Between [Enter Start Date] AND [Enter Finish Date] This should display only dates between the set criteria.

If I create a delete query in a relational database and delete the main record all related records from linked tables to this record disappear, which I can understand due to the relationship between them. How do I set up a query to append all this information to related tables to a set of...

I have created an append query and delete query which upon a click of a button runs a macro which requests a record number to be entered. At present the append query requests the record number to append a record to a USED TABLE. The delete query asks for the record number to be entered again...

Currently I have a form which displays customers called "Company". These customers can be of a different status. i.e. Gold or Silver. The status is obtained from a drop down list. This filed list is called "Customer Definition". If the user selects the status of Gold they enter a 3 Letter...

Thanks for the answer. I managed to solve the problem in the end. After generating a query based on the 3 fields and using the autocomplete feature, they can now look to their hearts content. When they have choosen the 3 letter prefix they hit confirm which requests them to enter it again...

I have created a table with 3 coloumns each of which has 26 single character entries. I have then generated a query which returns 17576 records. This query is used as a drop down list in a database to assign a 3 letter prefix to each company (prefix is allowed to be used only once). However...

Cheers Pat that worked fine. However one slight problem has been found. When the query returns a 0 i.e. doesn't find any matches. It causes a problem on the form because we have buttons for reports planned against the values. Example of Query Active=5 Inactive=2 In Progress=0 Rejected=1...

We have a query on our database which tells us of a company status which can be 1 of 4 possible values (i.e. Active, In Progress, Renewal and Deleted). However for quick referencing we wish to total the number of companies in these 4 fields. We have done this using a query but how can you view...

Sounds stupid I know but can anyone tell me how to achieve the following. I have built an expression to indicate if a persons record is A) Current B) Due for Renewal C) Expired! =IIf(Now()>[Expiry Date],"EXPIRED!",IIf(Now()>[Expiry Date]-31,"RENEWAL DUE","ACTIVE")) How can I set it for each...