I have a dlookup on an unbound field on a form: =DLookUp("","Organization"," = '" & Forms! !Office & "'") This works OK on the form, but when the form is...

I have a list box on a form that when you click on a record in the list box the data relating to this record automatically populates the form. As you change...

Hi, I have a text control. People will be typing either words or numbers into it. If they type 99 I want to skip down several questions. Here's the condition...

Dear Friends, I have a table named "class_grades" and with the fields of "First Name", "Last Name", "Age", "Math", "Physics", "Computer" and "State". I would...

I wonder if someone could give me some pointers on the following. I need to securely encrypt an Access 2003 database currently sitting on a server with...

I've dowloaded Steven Lebans MouseWheelOff sample db in hopes of using the code in my db. However, when I try to open it, Access gives the following...

Anyone interested in helping please let me know. I did get a reply (below) but unfortunately I don't understand it. Still looking, And thanks to...

I need to use fractions in a Access Form to calculate sq foot and other board dimentions. can't find anything in the help file or settings. I need to ba able...

Is is possible to have combo boxes in a form that are used as "selection criteria" for a list of records that appear in a subform (in a datasheet view). For...

Hi; Using A2K Runtime on XP Pro PC. Have all of the updates for XP and Access Runtime including SP-3 for both. The app opens to frmLogin correctly. On that...

I really, really, really, really, really, really tried hard not to criticize microsoft, becuase I know some of you worship Bill Gates as your God, but what...

I purchased a home version of Access from Microsoft through my job, and when I tried the following statement using the home version of Access, it wont...

I would like to set up the following to auto populate the fields below based on the value I select in the combo box: Rep field = combo box (LURequestor) with...

Hello, I have a stored proc with several inputparameters. I created an Access project file with Access2003 I would like to use the output recordset of the...

Hi, I have two similar subforms connected to two different tables. Each subform has a textbox control. I have to check its contents in the event...

I have a form, frmMain that uses a query as its underlying datasource. The query sorts the records in a certain way. How come the records aren't sorted the...

I have just converted a database from version 97 / 2000 to MS Access 2003. The Main menu form will not open, I get a message that I must convert to a newer...

working on form to select records from 2 tbls and create a new record based on selected items in a 3rd tbl. tblStudents(list of students) tblEnglish (list of...

I am in the process of upsizing an Access database to sql server (for the first time). I have been going through the forms to see if everything is still...

Hi, I have a form with a listbox control, the listbox displays access db file name in a specific directory, each database has only one table with the same...