Search results

Set the rowsource of the combo box to be a "value list" with one column. The rowsource will be: cboLetters: a;b;c;d;e;f;g;h(...);z The Second combo would have a rowsource something like: cboSearch: SELECT YourTable.YourField FROM YourTable WHERE YourField like [Forms]![MyForm]![cboLetters] &...

Hi llkhoutx It appears I have done a bad job in explaining what it is I'm trying to do! I'm *not* trying to filter one combo box based on the selection made in another. What I'm trying to achieve is a self-limiting combo that would be used in a continuous subform. Basically, I want the combo...

Hi, thanks for your reply llkhoutx. I appreciate that the only way to achieve this is through filtering the RowSource, but what do you think is the best way to achieve this? I have tried to make a query as the rowsource that took its criteria from the subform in question but with no success...

Hi, Just a quick question, is it possible to have a combo box in a continuous subform that automatically limits its rows based on the selections made in the other child records/combos (for the same parent record)? Cheers, Bobadopolis

apologies for the multiple occurence of this thread

Hi, My users wish to have a feature in my db that allows them to compare the records within it and view a report on it. I have implemented such a form but the functionality is not great. Basically it's a form with two subforms - the top where you choose the projects and the bottom where you...

Hi, My users wish to have a feature in my db that allows them to compare the records within it and view a report on it. I have implemented such a form but the functionality is not great. Basically it's a form with two subforms - the top where you choose the projects and the bottom where you...

Hi, My users wish to have a feature in my db that allows them to compare the records within it and view a report on it. I have implemented such a form but the functionality is not great. Basically it's a form with two subforms - the top where you choose the projects and the bottom where you...

Me.Parent!subformName.ControlName 'or Me.Parent!subformName.Property 'e.g. Me.Parent!subformName.Requery 'where items in Bold need to be replaced by your names I believe

Better still use a hidden text box (I don't like variables in these kind of circumstances). Make it's default value 0 and increment accordingly: Else MsgBox "Password Invalid. Please Try Again", vbOKOnly, "Invalid Entry!" me.txtLogonAttempts = me.txtLogonAttempts + 1 Me.txtPassword.SetFocus End If

I take it then this runs on the AfterUpdate event of the password box? Have u declared intLogonAttempts somewhere in the event? Dim intLogonAttempts as Integer intLogonAttempts = 0

So you want to increment the login attempts when the user fails to type the correct password: 'This is the code that runs when the user types the wrong password: Else MsgBox "Password Invalid. Please Try Again", vbOKOnly, "Invalid Entry!" intLogonAttempts = intLogonAttempts + 1...

When are you calling this code? Particularly the line: intLogonAttempts = intLogonAttempts + 1 Surely that needs to go in this statement: Else MsgBox "Password Invalid. Please Try Again", vbOKOnly, "Invalid Entry!" Me.txtPassword.SetFocus End If So that the count actually increases...

Hi All, I just thought I'd probe the forum and enquire about how people deal with unknown data (esp regarding combos). Up until now I have had a record in the underlying table that feeds the combo with a record for "Not Available". This is ok (sort of) but if the combos are cascading then...

Sorted (at last!!) Hi RuralGuy, Yes I was doing that so that must have been the behaviour i was experiencing (due to the error in my syntax). But after muchos fiddling I finally fixed it: DLookup("VehicleID", "tblVehicles", "[VehicleMakeID] = " & !cboVehicleMake & " And [VehicleModel] Like...

Hmmm Thanks for the reply RuralGuy. Ok, so I've done that: DLookup("VehicleID", "tblVehicles", "[VehicleMakeID] = " & !cboVehicleMake & " And [VehicleModel] Like '" & "Unknown*" & " '") But as I have done all along I still get run-time error '3162': "You tried to assign a Null value to a...

One more thing... Hey ppl, just another quick question on this problem... what if I wanted to use a wildcard in this expression? Moreover the * wildcard following the word 'Unknown' in this code: DLookup("VehicleID", "tblVehicles", "[VehicleMakeID] = " & ![cboVehicleMake] & " And...

Genius! Pure Genius!! Thanks a lot RuralGuy!!! Bobadopolis

Hi everyone. I appreciate that there are many threads on this subject but I have searched and puzzled and become desperate!! I have an input form that automatically sets any blank fields (mostly combos) to "Not Available" if the user does not enter any data into them. On the form are some...

Getting there... Right. I have managed to fudge a way to make the random numbers distribute themselves more evenly. I did this using a crosstab query that counts occurences of each number (1 to 4) and inserted these fields into my form. I then used some vb to force numbers when one number...