Search results

Calvin and anyone else who gets this stinking error- i found the darn problem with this! if you put it as: rs!([variable]) you will get the type-declaration error. but for some reason if you put it as: rs![variable] it works fine! just get rid of the darn parens. thanks again calvin- -kermit

Calvin- thanks for the help, but i still get the same error. here is what my code looks like now: Dim db As Database Dim rs As Recordset Dim strsql As String Dim number_of_uses As String scan = Me.ScanID firstletter = Left(scan, 1) If firstletter = "t" Then scan = Mid(scan, 2...

this one has me baffled. I have created stuff like this many times before, but this one comes up with an error: "Type-Declaration character does not match declared data type. all i am doing is creating a recordset and i want to get the values out of the record that it finds. any ideas??? it...

Heres what im trying to do: I have a text box on a report and im trying to get a maximum number out of a table with specifications. I am using DMax, but it keeps pulling the largest number in the whole table. I have tried many different alterations in my syntax, but i still cant get what i want...

I am trying to get a Dlookup function to pull one number from a table(trackopupdate). I want to give it a specific item and op(two fields in my table) and i want it to return the largest ID(autonumber) that exists in the table for that item and op. here's what i have now: RevRec =...

Is it possible to take a SQL statement and assign it straight to a variable? I have tried a few different ways and it doesnt seem to work. Heres what i mean: Dim myVar as string myVar = "Select field from table where field1 = Value"; thanks for your help- -D Frog.

Exactly what i was looking for! thanks again -k

Is there a way to reference a field name from a variable? for instance: i have a field on a form named q1 I would like to reference this field from the qty expression that i set and then use the qty in the Me.qty.enabled expression. Is there a way to do this? Dim cont as string Dim qty as...

Is there a way to validate all visible fields on a form? For instance... Lets say i have a form with a heap load of fields, and based on what the user selects in a drop down box I make certain fields visible and invisible. But what ever fields are made visible i want to make sure that they...

autofill thanks for the information. but i have only one more question. MS says it cannot be dissabled. Is this true? is there a way around it? i cant believe that someone would design it so that it cannot be dissabled... -frog

I have a form that is set to datasheet and the users come in and insert records, there are about 10-12 fields that they enter. But when they hit about the third or fourth record the form starts to auto-insert data. So the user enters a "1" into the first field and if they press tab to the next...

i am trying to create a combo box that has the next twelve months as its recordsource. So if you select the combo box now in the month of February the box will have february - january, but when the next month rolls around i would like it to automatically change its recordsource to have march -...