Search results

I am creating a DB for a work permit scheme, in the form header the user will add the Contractors name and his companies details. All our suppliers are stored on a separate table. Currently a Combo Box allows the user to search for the company name but I would then like it to populate with...

Combo Box is an alternative but there are over 4000 contracts. Gemma - the field name in the table is SALESORDER the table is called Ctcts on your response you put "contractre f"????? Is this an error? I understand what you are saying however. Lookup the field called 'SALESORDER' in table...

My first live, online database is about to go live. The query asks the user for a 'Contract Number' which they enter and the form the displays the Contract details, which it obtains from an imported table. But if they input an incorrect contract number it just displays a blank form and I would...

Like "Blue"

I am relatively new to Access but I am just creating my first database for the workplace. Everything was going to plan until I came up against this. In a query when I type Like "Blue" in the criteria it changes it to ALike and the query shows nothing. I have searched and searched and asked...

Private Sub PermitToWorkMaster_Activate() Me.PermitToWorkMaster.SetFocus End Sub Private Sub LocationofWork_LostFocus() If IsNull(Me.LocationofWork) Or Me.LocationofWork = "" Then MsgBox ("Sorry") Me.LocationofWork.SetFocus End If End Sub My Form is called PermitToWorkMaster and the...

Hi Bob, I am new to all this Forms/Reports etc. I am trying to get your solution to work but Access keeps telling me that it can't find a the Macro. You couldn't give me an idiots guide to how to input this code? and where? Thanks Stem