Search results

I'm having trouble using public variables. I have declared several public variables to be used throughout my database, using: Public pChar1 as String, pChar2 as String I have tried declaring them in the general declarations area of class modules, also in the general declarations area of...

I'm trying to design a form which simply displays data from a select query in a continuous form format. I would like to have the user scroll through the records with the up-down arrow keys, and I'll possibly even program some jump-to-start/end keys. I have turned off the navigation buttons, but...

Thank You!

Are you testing for M![Pass] to equal an asterisk, or is the asterisk supposed to represent a wildcard? If you're thinking wildcard, then Instead of using: Else If Me![pass]="*" (Mssg box, etc) couldn't you just use: Else (Msg Box, etc.) You have already tested for the string...

I would like to have a DoCmd open a parameter query, but I do not know how to pass a single parameter to the query. Is this possible? If not, how does one automate the use of a parameter query?

I am trying to write some code which, when looking at a record, can compare a field in that record with the same field of the previous record in that dynaset. What's the syntax? I want to put in something like: Answer = Iif([Thisrecord]=[Previousrecord],"X","Y") Please help a poor ignorant...

I would like to present certain tables for the user to sort manually, similar to the form that pops up when you View Tab Order in form design - the one which allows users to grab a row or rows and move it (them) up or down, creating a particular sequence of records which I would like to use as a...