Search results

I'm not sure if you still need those quotes since it's a Date field How about: Def: IIf([30 day notification]<#1/1/2005#,"h","Show Something Else")

How about: strFilter1 = "[StaffID] = " & Me!StaffID strFilter2 = "[ProjectID] = " & Me!ProjectId2 Me!ActRole = DLookup([ProjectRole], "tblProjectStaff", strFilter1 And strFilter2)

Use Combobox.RemoveItem after selected

I'm not sure about what you said because I can set the inputmask of a textbox to display asterisks. When users type in anything, it shows as *.

Correct me if I'm wrong but as I remember that in order to use ItemData, you will have to use ItemsSelected together with ItemData. If not, your ItemData would be Null because none of the items in your listbox is selected. You can make all the items in your listbox auto-selected when loaded...

Should have made it clearer, my bad. Create a dummy textbox, make its Enable=False if you want. Do not link this box to your field4. Then enter this into the dummy's controlSource. =[control linked to field 2]&[control linked to field3] Then your "linked to field4" box should be set equal...

Wrong box - Access related only please. There might be a "big" virus (spelled right?) jumping around in your PC. BEWARE!

Enter into the ControlSource of your combine-textbox =[control linked to field 2]&[control linked to field3] Link the textbox to your field 4, make it hidden if you want.

The code that FlyerMike gave was assuming that Mainarea, unitval and portionval are controls, not fields in your table. Try replacing those with your controls, the ones that are bound to the above fields.

This is a several-step process. This is what I would do (haven't tried it): Click on button1 to open Form1, set Data Entry to No and set Record Source to query1 Click on button2 to open Form1, set Data Entry to Yes and set Record Source to query2. Private Sub button1_OnClick() OpenForm1...

Add to your Form_OnLoad sub: DoCmd.GoToRecord , , acNewRec

Why do you have Balance as text (txt), I wonder? Should it be number instead?

What are the data types of your fields (Department and Shift) in your table? Can you post a sample database?

Try this instead: = Nz(Department, "Unknown")

... strPersonalID = Me.lstSearchResults.Column(0) ... How does it know what you've selected? You might want to think of using a combination of ItemsSelected and ItemData. Search for their syntax in Access VB. Good Lucks

Try this instead: ... Confirmed = MsgBox "Are you sure you want to overwrite the current invoice amount", vbYesNo If Confirmed = vbYes Then ... Else Exit Sub End If

I guess we will need to see all the codes or maybe you can zip a sample of it and post it here.

I don't get what you're trying to accomplish. What do you mean by "getting them out again when the record is displayed"? If they are selected, why need to mark them as itemsselected again?

Linking Forms See attached - Look in the tblAccess for passwords....

See attached - After the form (frmAccess) loaded, press F8, enter or select criteria, press F9 to apply the filter. Applying a filter will display results and the criteria itself also. Pressing F9 will also remove filters. Therefore, pressing F8 after F9 will enable the filter by form...