Search results

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.

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...

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 -...