Search results

How are you referencing the two so that one table knows the EndDate for the specific customer from the other table?

To make a stand alone query, go to the main db window and select QUERIES then select CREATE QUERY IN DESIGN VIEW. Two windows should open - close the smaller window that says "Show Table" and rightclick on the other window and choose SQL VIEW. Now either write in or copy and paste the code...

First, make it a stand alone query by adding a SELECT and FROM statement and saving it with a name. Once you have created this as a stand alone query, add it as the RECORD SOURCE for your report. You can do that by right clicking on the open report, selecting REPORT DESIGN, then right...

And that my friend is the most important thing. Glad I could help.

The above code presumes you have a textbox or combo box in your form to select the customer as well as the date range. If that is the case, then when you enter a date range and pick or enter a customer, the query will filter for that date range and that name. If you leave the name blank...

The other alternative is to build a query that searches for both but disregards one or the other if it is null. Something like ... If both fields are left blank in the form, then it will return ALL records without filtering. You can continue this query for as many fields in the form as you like.

One more alternative ... WHERE ((Check_date+60)=Date()))

I suppose he could add the number on the after update event, but I would think it would be easier just to bind the textbox to the field in the record.

You're right, I was tired.

More than likely you have the combo column bound to the index and not the Data. Make sure that the INDEX is the first column and the DATA is the second column. then change bound to 1. That should solve the problem.

Your report uses a Record Source (which you can find in its properties when you are in Report View for the report) You need to create a query or change the one already there to look like this and use that as the record source. That way, the report will know exactly what to well ... report...

Create a query to use as the record source for your report that specifies the operation date from your Form - something like ... SELECT Yourtable.* FROM YourTable WHERE YourDateField = Forms!YourForm!YourControlName ORDER BY YourDateField, YourPatientNameField;

I tweaked the db a bit to show you how this would work using a simple listbox. When you doubleclick the highlighted line, it will open up the form and go to that specific record.

Private Sub List20_DblClick(Cancel As Integer) Dim db As DAO.Database Dim rst As DAO.Recordset On Error GoTo Err_vendorList_DblClick DoCmd.OpenForm "Vendors1" Set rst = Forms!vendors1.Recordset.Clone rst.FindFirst "[ContactID] = " & Me.List20...

I had made a set of querys for a particular form and used that method to change each datasheet view to be the same. When it asked if I wanted to save the changes, of course I replied Yes :)

Okay - got it. (Thanks for the link) Some like it, some don't and for various personal reasons - the only one technical having to do with porting the code to another language. I guess it's all a matter of taste. I use underscores to separate and make fields more meaningful. Like First_Name...

I have been programming since the late '70s in multiple languages and have used the underscore consistently throughout. I have never had a problem with a call because of it. I understand why spaces should be avoided, but am curious as to your reasoning for avoiding the underscore.

One of the backup methods we use is to filecopy the .be from the server and send it to a folder on my harddrive when a user uses the backup option on their fe. It's just one of many layers of BU that we use. I'm thinking you could modify that method a bit and filecopy the .be to whoever you...

That's interesting. Normally in a dual data combo, the PK would be 0 and the bound text field 1. Hmmmm. :)

Just to add to what Statsman said: If you are going to use a form to search for this data (and maybe have a subform display the results) you can use the same principle and use the following in your query along with any other criteria you may want: Where Yourtable.Date between...