Search results for query: *

Dear Willir The error occurs when I am in the form view. I try to use one of the combo boxes and when I click on what I want to select for the box, an Access box pops up with the code that I have in my Tag and my only choice is to hit OK. Thanks for your response. Craig

Ormsk, Thank you for your reply. I am fairly new to Acces and VB, kinda got thrown into doing a project for a prof., so I have a couple questions I was wondering if you might be able to clear up so I can continue learn. 1) I was wondering what purpose does that POD code at the top serve? 2)...

I am developing a database where I need to search through the data based on different critera. I am using combo boxes to do this, however I have run into a problem. Right now I have two combo boxes, and I want to be able to use each independently as well as a joint search. I get in error due to...

I am developing a database where I need to search through the data based on different critera. I am using combo boxes to do this, however I have run into a problem. I can the first combo box to search correctly, however when successive combo boxes are added they wont search correctly. Right now...

Thanks for all the help! Craig

Dear FancyPrairie: Thank you very much for taking time out to help me with my problem. I created a new module for code you gave me and entered the Where statements in the respective Tag Properties for my combo boxes. The problem I am having is where does this code: Dim strSQL as String...

Thanks

JeffTullin: Thanks for your response and help. I did struggle trying to use the DLookup function. Your code makes much more sense that the bulky code that I was using, and I see how I forgot to put the ' on my strings. It is tough learning VBA on the fly. I tried the code you gave me, and the...

I am using DLookup to search for a value called CaseID from a query, qrycombo1, but I get an expected = compile error. DLookup("CaseID","[qrycombo1]", "RouteNumber = '" & Me!cboRoute.Value & "'") Could anyone point me in the right direction? Thanks Craig

Stephen: I have not tried the DLookup function, as I have never heard of it. Ive fallen into Access for a summer job for my professor, and I dont have extensive knowledge in VBA. I am more of a C++ programmer. I will look into it to see how it may help. Thanks Craig

I have a form which currently has 2 combo boxes, and I use them to sort data from a query I created. My goal is to be able to use the boxes to search independent of one another and in conjunction with one other. I have attached my code. Any help would be greatly appreciated. Option Compare...

If Ive got a combo box named, cboRoute, and it has certain values. How do I get the list box, lstCrashes, to display the query results from a query called, qryCombo1, when a value in the combo box gets selected? Thanks!

The Like operator worked well in sorting the data from the combo boxes, but I still cant seem to make them work independent, and I am not sure where the apply the IIF function.

The problem I have is that I currently have two combo boxes that produce results to a list box, however both need to be used inorder for the results to show. I need to add more boxes, but be able to get data without having to select every box. Any help would be greatly appreciated. Private...

The problem I have is that I currently have two combo boxes that produce results to a list box, however both need to be used inorder for the results to show. I need to add more boxes, but be able to get data without having to select every box. Any help would be greatly appreciated. Private...

This is my code if anyone could see what is wrong. Private Const strSQL1 = "SELECT CaseID, Milepost, Purpose, GuardrailType, TerminalType, HardwareComments " & _ "FROM qryCombo1 WHERE RouteNumber = '" Private Const strSQL2 = "'AND PostedSpeed = " Private Const strSQL3 = " ORDER by Milepost...

I've created a form where I need to use combo boxes to sort the data from a query. I currently have two combo boxes that work and display the correct data, however both boxes have to be used in order to display the search. I want to be able to have the list box show the results after the first...