Search results

Bob Larson has a great tool found here: http://www.access-programmers.co.uk/forums/showthread.php?t=111132

OHHHHHHHhhh lol thanks bob! also i noticed that i was setting it back to 0 every time too lol.

The login works Great but Login attempts dose not im still new to VB so i must be overlooking something. Private Sub Ok_Click() Dim LogonAttempts As Integer Dim SaiCurrentUser As String SaiCurrentUser = "" LogonAttempts = 0 If Me.Password.Value = DLookup("[Password]", "[User...

How would I do that with a query would it replace the one field or the whole colmn?

I need a macro that can Replace information in a field on a table. basicly i have a "Receiving" form with 10 spots for S/N's when the user "Saves" the infomation i want the "Location" to change to "SAI, Shelton" on my "Main Inventory" Form. or maybe there is VB code that can do this.

Works Great! thanks exactly what i was looking for simple yet effective!

Setting Criteria on a Query using VB, can it be done? Say i have "Query 1" and in "Query 1" i have my Criteria for "X" is blank. i want to use a button on "Form 1" to set Criteria for "X"

yah but if the field is empty it includes "" as part of the search so the search comes up with no records because no fields are "". i need Null to null out the "" so the records show

Basically i have a drop down that i want controlling the Criteria for each field in my query to have an advanced search. If i leave a field blank the query comes up with nothing so i tried this: IIf(IsNull([Forms]![Inventory Report Search]![Model]),Is Null,[Forms]![Inventory Report...

Got it working!

na it was no help at all

So im Trying to automaticly change the location of a product when it is received. here is what i have so far im confused as to how the replace function works. i want to replace "Location" on the "Main Inventory" table according to S/N. here is what i have so far. Private Sub Command73_Click()...

Just Tried the Filter umm i just realized that all the If IsNull([Location]) Or [Location] = "" Then Else strFilter = [Location] End If If IsNull([Manufacturer]) Or [Manufacturer] = "" Then Else strFilter = "[Manufacturer] = " & strfilter End If If IsNull([User]) Or [User] =...

yah i want to filter the advanced inventory search. and yes the query is its source. how would i go about setting that up how would i apply the filter? Private Sub Command28_Click() Dim strFilter As String If IsNull([Location]) Or [Location] = "" Then Else strFilter = [Location]...

Ahhhh Ic Ic so go with the IsNull, now (assuming that the filter works) saving the Filter as a Query at the end of the filter i put: DoCmd.ApplyFilter strFilter Requery DoCmd.Save acQuery, "IR" that do command probably not right i was just winging it there lol. dose anyone know how to save it...

I took the other if out completely at the bottom, Should i change the Len() to If [Location] = "" Then Else strFilter = [Location] End If If [Manufacturer] = "" Then Else strFilter = "[Manufacturer] = " & strfilter End If or If IsNull([Location]) Or [Location] = "" Then...

Ahhh Yes this is referring back to Here. I want to set a Filter witch im still not totally clear on but getting there i understand setting a variable and whatnot this is roughly what the code looks like from what i have learned about VB thusfar. im sory if it looks bad or if there realllly...

Saving a Filter as a Query in VB Via a button, Can it be done? P.S. I Use 07.

Ahh Ic Ic. to quote Dr Snuggles "Before you open the form you should save all the filter criteria in a string. On the Docmd.Openform command you can pass the string in the Wherecondition. It's just one way of doing it . . ." would this be something like what he (or you) are talking about, im...

What Dose Len Do? count true arguments?