Search results for query: *

I've learned to bypass Recordsets by using DLookup when I need to get a value from a field in a table and store it in a variable. If I need to get three fields into three variables from the same table for the same criteria is a trio of back-to-back DLookups the right way or should I crack open a...

Trying just one piece, I plugged field names in and tried to execute in a query. Error message says 'Join expression not supported' and it highlights the "b.sequence = 1" section of the code. Using Access 2003. Select bp_id ,1 From Bulkpipe a Left Join qty_detail b On a.bp_id = b.item and...

Beautiful, simple solution for exists in A and not in B. Identified 15 missing records in B. But I oversimplified the scenario thinking I could figure the harder part out based on the reply but no. I think the solution to the full scenario goes beyond SQL statements. Full scenario: Table A has...

I have 2 tables. Table A contains records for a unique key field. A record for the same key field should exist in Table B, and B contains a "pipelength" field whose value should match the "pipelength" field in A. 1-to-1 relationship between A and B. 1) I need to verify that all records in A have...

In one of your messages you ask if the table is indexed. Yes it is, how would I activate that index for the dlookup? Do I need to?

So for dlookup I don't need any preparatory Dim statements for the table I'm using?

Great looking alternatives. I'll do some experimenting over the next couple of days. Many thanks for your input.

The table can have tens of thousands of records. Is a dlookup as fast as a seek?

MajP: The user is scanning a barcode to fill a text box on the form. After the scan I seek the scanned value in the table/recordset and update a field in the table if it's found. Based on that scenario I assume recordset is the way to go but I'm always willing to learn.

Embarrassing error on my part. I'm in test mode so I delete the Bulk table at the end of each evening to save disk space. Re-importing Bulk took care of the error but I think you've answered my underlying question: am I declaring and opening the recordset properly?

I'm creating a small app that makes updates to a table based on user input. So I'm trying to open recordsets in a way that the Sub can see them every time the user inputs data. When I open the form and immediately close it I get a runtime error 91: "Object Variable or With block variable not...