Does anyone know how to validate a list box in a form in Access so that the user has to make a selection from the list box before running a query? Trying to do it for work however there seems to be now simple way of doing it as Access is a pile of crap…urgh
Any help would be great
MySQL + PHP it up!
I used to know how to use Access, but can’t remember any more, sorry :<
Yeah my colleague had the same problem, he had an example of it but because access is so ridiculous he couldn’t remember how to do it
What exactly are you trying to do? It sounds like you want the user to select from a combo box and for a query to be run when a choice has been made…
The query basically shows details about customers. In the list box are certain details which if the user clicks on they just get shown them details. This works fine BUT I want it so it doesn’t let the user run the query is an option in the list box hasn’t been selected
How are you triggering the query?
Ah, can you just, in the options of the query, make sure that the input you are running the query on is not null, or if you are using a custom form with a button to run the query do an
if(ComboBoxWhatever.Value <> “”) Then
<>
Else
<<Show Error?>>
EndIf
ahh it’s all sorted now. I set Microsoft Access on fire after telling me it can’t do things because it sucks. Feels good man
I thought the title said “Minecraft Access is the Devil”
I was confused.
I thought people used dBase IV still.
access? must be some voodoo stuff
Founded in 2004, Leakfree.org became one of the first online communities dedicated to Valve’s Source engine development. It is more famously known for the formation of Black Mesa: Source under the 'Leakfree Modification Team' handle in September 2004.