Search results

First of all, thanks for your assistance on my previous postings. It is greatly appreciated. Second, I have some queries that I copied from my current database to my new database. I changed the names of the fields, tables, and forms, but not the logic, etc. in the queries. The problem is that...

Thanks guys. I'm learning this by the seat of my pants and am just trying to understand how it works. Plus, I've been given a six month job and told to do it in two. We have over 2000 records in just this one table and will be tripling it over the next few months, so I was trying to not only...

How is referencing a combo box in a table that has three columns different than referencing a combo box on a form with three columns? The field in the table is a lookup combo box with three columns.

It just says syntax error and when I hit debug it highlights the entire code, error code 3075 I think. Well how would I reference it and still get the column I need? What about this: "WHERE ((('" & tbl_PPLInstances.FirstFlight.Column(3) & "' " ) " & _ The query is dynamic. It pulls three...

I've looked at this so long that I can't figure out where the errors are. It's probably something simple though. Would you folks please take a look at this and tell me where I went wrong please? I took a SQL Query and am trying to convert it to use in VBA instead. stDocName =...

That's what I've done for the sort id on the form since the user actually chooses the flight. The unbound text field then holds the sort id used in the query. That sort id is what the query needs to go look in the table for but I can't have a text field on the form holding information from the...

But doesn't DLookup only find a unique value in a column? :confused: I need to find multiple values in a column that contains twolookup columns but the data is in column 2 of the lookup column. Here's my query: WHERE ((([tbl_PPLInstances].[FirstFlight]) Between...

I know that on a form I can refer to a specific column of a multi-column combo/list box and then use that information in a query, but how do I refer to a specific column of a lookup field that's in a table and use that in a query? TIA