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...

Re: Help Thanks Bob, will be able to do this later this week, makes sense now where i was going wrong.

Re: Help thanks, appreciate the info, was trying to get a quick response but understand it would be better to get a quick, meaningful response Idris

Re: Help Hi guys, thanks for the replies, i am trying to hide command11 which is a button to open a form which only John should be able to open. I am trying to establish if John is the user logged on (list19) and if so his button will be visible, otherwise the command7 button for all other...

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...

Thanks for the swift kick in the rear, it was indeed a join error, i changed it and all is fine now.:o

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...