Search results

Hi there i am building a search form and I want it to be able to display results from multiple criteria......Currently I am able to display results in a listbox, whenever the user types in a id number in a text box. So if a user types 63 in the ID text box the record with and ID of 63 will...

Hi there I currently have a DB with a ton of records. What I want to do is have a search box pop up when the user presses a button on the main form. When this search box comes up there is a list box with all the records. The user will then double click a record on the List box and it should...

Hi there, I currently have a search subform that will search for a specific record based on an ID or Name. However I do not want all the records to be filtered. I still want the user to be able to traverse through the other records. Is there any way that I can disable the filtering? thanks

Hi, I have a group of option buttons. A user can select more than one. However, currently all of the option buttons have a grey spot in them except for the first one which is blank. I want all of the option buttons to be blank. Any thoughts? Thanks

Hi all, I was wondering how would we change the forms row source everytime a new new item is selected in a combo box. For instance here is a table: ID Name Status 1 Joe Active 2 Fred Inactive 3 Sam Inactive So if the names were to be...

Hey Clerics, I am currently running Access 97. Is there any way that you can convert it. Thanks for the help:)

Could you please be more specific on how to do this. I am new to Access and not to familiar with VB. Thanks

Could you please be more specific on how to do this. I am new to Access and not to familiar with VB. Thanks

Hey all, I am trying to link a option group to a combo box. The combo box has a list of employee names. The option group has two options Active and Inactive. All I want the user to be able to do is check the current status of an employee (as active or inactive) and to be able to change their...

Hey I am trying to do the same thing but with True and False. Have you come up with a solutions? Thanks

Hi, Thanks for your help. I have placed your code as you specified. But it still doesnt seem to work. In the rs.FindFirst"[ID] = ...... line of the code shouldnt ID be replaced with the employeeName field since I am displaying the name in the combo box? Where do I add code in the option group...

What does is stored in the Bookmark variable?

Hi there, I am new to access and this question be a no brainer for you access gurus. What I currently have is a form with one combo box and two radio buttons. Staff and Status The staff combo box is a drop down menu of all staff members and is derived from a table called Employees. The two...

Could you possibly post this using Access 97. That is the only version I have running. Thanks

Hi, This example could be very useful to me. But could you possibly re-post this example using Access 97, as that is the version that I am currently running. Thanks

Do you have any idea on how to create my own buttons. I am new to access and any assitance would be much appreciated. Thanks

Hi Does anyone know how to remove the "Record ID" from the record selector? I want to be able to traverse from one record to the next, however I do not want the field representing what record it is on showing up ( if that makes any sense). Thanks

Hi there I am new to Access and I am currently modifying an existing DB. Currently this DB has a main table which holds a bunch of Patient info such as: Name Age AssignedStaff Condition etc.... The assigned staff field is populated from another table (Staff), which holds all the staff members...