Search results

I want to set up a query where i can search for all records with the date that is one week away from the actual date. So if the date is 7/11/03 the query will display all records from 01/11/03 upto today. Can any help please? Thanks in advance!

IMO thanks for that!

Mile-O-Phile i have tried that but i am still getting the same problem! Thanks

IMO Thanks for your help that worked a treat!

I have changed the background colour of a Text box to Transparrent but when i veiw the form it displays the background colour as white any ideas why this is happening as its driving me crazy! Thanks

Thanks for your reply. I have tried putting a Checkbox on and putting the code in the AfterUpdate of the Checkbox it works but only for one record. Obviously im doing something wrong?

I would to place a check box or button (dont mind which) on my continuous form that when clicked will select all of the check boxes on the form. The form is going to be used to allow the user to select which records will be displayed on an invoice. I have got this working so that the user...

Pat I worked out what a UNION query is (was being stupid) and it has worked with no problems what so ever. Thanks all for your help much appreciated!

I have had a go at using the code that GumbyD has suggested but i am getting a Run-Time error 3001 on the following line: Set rstMakeDups = CurrentDb.OpenRecordset("tblCharges", dbOpenDynaset) I am probably doing something really stupid, i have not used Recordsets much before. Hope you can...

Thanks for both replies i will look into both. Pat how would i go about creating a Union Query i am not familiar with this. Thanks again.

Im not sure if what I am trying to do can be done using a query but here goes anyway! I have a database that is used to store Customer and Supplier invoice records. Each month an export is ran from the database, basically this is a text file which contains the results from the query. The text...

It is the Process tab we are looking at.

The database is used to store customer invoice information, it does not use an SQL back-end so the processes can't be moved, there are a number of forms that are used to enter invoice information and various calculations are made which are fed back into the tables etc using various queries and...

We have a number of Access 2000 Databases that we running via Citrix using Access 2000 runtime. Most seem to run very well and have only encountered a few problems, although we have recently discovered that a couple of the databases when in use utilise a large amount of that particular servers...

Thanks very much, worked a treat!!!

I am setting up a report that prints out customer information, I have grouped this report by Customer and by a Service field. What i would like to do is to display only 1 Customer per page. How do i go about doing this? Thanks

I thought of using an update query but not sure how to tie it in with the forms i am using? How would i make sure the update query only updated the fields that have been invoiced?

I have got a form that i am using to produce invoices, the user selects each record to be included in the invoice by clicking a check box (Add to Invoice). I have set this is up and works fine, the problem i have now got is that i need to update each record so that once it has been invoiced it...

Thanks for that it worked a treat!!!

I have set up a query that will be used to export invoice information to a Text file, i need to be able to export the records from a certain date range which the user will input. I have managed to do this using input boxes from the query but i would really like the user to input the dates...