Search results

Hi, I have a form which displays records based on a Unique identifier, the problem i have is that users may not always have the number so will have to search for it. I can get the query to see the entry in the search combo box, but if they know the number and enter into a text box without using...

Hello all, I registered a few days ago and have had to post a couple of enquires so far and have had a great response to them, thanks to all those who read and replied. I started working with Access in the lat 90's as my place of work had large piles of information which cried out for a...

Hi can anyone see what i am doing wrong with this code? Private Sub Form_Load() If Me.List19 = "John Hems" Then Command11.Visible = True Command7.Visible = False Else Command11.Visible = False Command7.Visible = True End If End Sub I want command11 visible if John Hems is in list19 and...

HI all, not sure what I am doing wrong but I have two buttons on a form, depending on the name in the login field (text19) i need one or the other button to be visible and he other hidden. the two buttons are command 11 and 12. I need command11 to display if the name is "user name" and hidden if...

Good morning all, i have a query which should pick up all records relating to a given Identifier (5 digit number). for some reason the records returned do not inlcude any in which certain fields have either a null or 0 value. I cannot work out why but i need to ensure the query returns the...