Search results

Hi, The above query only brings back records where the CustName and CustDOB fields are blank in tblAR. This is not the result I'm after. Here are two sample tables: tblMain ID - Name - DOB 1 - Brady - 01/01/1950 2 - Lewis - 04/01/1960 3 - Davis - 08/03/1980 tblAR ID - Name - DOB 1 -...

I have a report and it needs to run a differnet routine depending on what form is open. eg. If frmApple = Open then run this else run this end if Can this be done?

I am trying to find records in table A (tblMain) that dont match records in table B (tblAR) I am using the Unmatching Query Wizard in Access to try and find records that dont match by Surname but I also want it to find records that dont match by DateOfBirth aswell. Here is the query: SELECT...

Aye! Seems obvious now. Thanks for the help

It does actaully change the records source but when you go to design view it diplays the records source as blank. :mad: Thats where I was going wrong!! Thanks

I did that! Are you sure it's changing the record source? How do you know?

ok here ya go I've wasted half my day trying to get this to work :mad:

Do you have access 2000? Or must it be 97 format

It doesn't seem to matter what I put in for the record source Me.RecordSource = "[tblMain_Ame2x]" or Me.RecordSource = "[arse]" It comes up with same 2101 error. It's almost as if the recordsource cant be edited unless in design view

Same 2101 error :confused: with Me.RecordSource = "[tblMain_Amex]" highlighted

No rules: If I select the first value "1" from the combo, the debuger has the following part highlighted in yellow giving the 2101 error: If I select the second item in the list "2", Me.RecordSource = "tblMBNA_Main" is highlighted

Nope, it's unbound

LimitToList is set to no.

I have just created a new form and tried the code below but I still get an error Private Sub Combo0_AfterUpdate() ==== Error 2101. The setting you entered isn't valid for this property Is it actually possible to change the record source dynamically to the name of a table?

Setting the record source of a from dynamically I have a form with a drop down. When the user changes the value in the combo the record source should change to a different table. However, when I run this code I get the following error: Runtime Error 2107: "The value you entered doesn't meet...

Of course it is! Thanks.. Im am trying to do the reverse now.. I am trying to find out which records on "M" do not match records in "A" I've tried this query but it doesn't bring back the desired results. It seems to duplicate the results to match the number of records in "A". SELECT...

Hello, I have two tables that I am trying to compare data with. Both tables contain a Surname, a DateOfBirth and a SequenceNumber. I want to return the records where the Surname and DateOfBirth match. eg. If there is a John born on 11/03/1955 in table 1 and a John born 11/03/1955 in table 2...

Hope you can help me with this one. John takes 4 credit card applications in a day. These are keyed into the database as below: tblMain ID --- SaleExec --- AppDate 100--- John ------- 01/01/2002 101--- John ------- 01/01/2002 102--- John ------- 01/01/2002 103--- John ------- 01/01/2002...

Thanks for the help. I finally just changed the table to: ID ------- NAME ------- APP --- DEC 1 -------- John ------- 1 ------- 0 2 -------- John ------- 1 ------- 0 3 -------- John ------- 1 ------- 0 4 -------- John ------- 0 ------- 1 5 -------- John ------- 0 ------- 1 6 -------- John...

But I have a backend SQL server and AFAIK is doesn't support it..