Search results

Hi all, does anyone know how to create a "search" button that locates a particular record in a list box. Similar to the way a combo box behavior. Is this possible. Thanks in advance.

Hi all, Does anyone have any ideas how to search and find function on a lengthy list box. I have a list box that contains 500 records, I would like to have the user type in a specific record and that record would highlight and be selected. I've tried converting the list box to combo box, but the...

Hi All, I have a listbox that a user can select various items, On the same form I have a textbox that shows what items have been selected. My problem is that how do i save the items that appear in that textbox into a table ? I've tried some Sql statements but can't seem to make it work. Please...

Hi all. I'm really not sure on which forum this should appear in but I need help with a Error message. I have a database that allows user to delete and enter records. Everything has been working fine until a couple days ago I recieved this error message: " isn't an index in this table. Look in...

I have a simple INSERT INTO code that should take the users name and insert into the Name table, but it's asking for the name twice. Below is the code, can anyone take a look and see what i'm missing. Dim StrSQL As String StrSQL = "INSERT INTO Table1 ( Name )" & " SELECT " & Me!Text2 & ""...

Hello - I have a form that is used for data entry into a table. I would like to have the the text boxes and combo boxes clear once the user clicks on the "Submit" button. What I have now doesn't work. When a user goes into the form, the last entry is displayed. Can anyone help me in figuring...

can anyone help me with my dilemna? i have a form that prompts the user to enter a password to modify records, if the correct password is enter, the "modify" button is enabled. i'm having trouble referencing that button which is on another form. please help? thanks in advance.

Can anyone help me disable the ability for the user to right click the mouse button. I don't want the user to be able to view the access objects screen through this method. Is this possible?

I have a form opened up in design view that displays info regarding workers assignments. Several of the fields are modifiable, but I go to the next record, Access is giving me this message "Invalid Bookmark". Can anyone tell me what this means and how i can fix it.

Hopefully this is a simple one! How can I get rid of the close button in the upper right hand corner. I've tried going to properties and select no on the close button properties and the control box, but the button still appears. Can anyone help me out. Thanks in advance.

I have a field in a report that references a combo box. In the combo box there are two columns, the first column contains the full name of employees and the second column contains the employee initals. I'm using the employee initials as a criteria for the query in which the report is based on...

I have a database that holds work assignments for employees. I have an text box labeled txtEmpID, which the employees would enter their ID and hits a command button labeled cmdAccept. The command button is referencing a query which uses the text box as a criteria to requery. This all works but...

i'm trying to create an application where it will allow a supervisor to assign work to employees by moving the work id into employees work tables, but i cannot have duplicate work id's, for example if a supervisor assign work id 9999 to employee 3, that record will be removed from the...

I've created an application in Access 97, but when I try to open the same in Access 7, it gives me this error..."Database Object not recognized"...is there anyway I can get around this?

How can I setfocus to a field in a subform?

I need to modify a inputbox so that the text inside the textbox is crypted, for example in a password prompt. The user should type a password into the textbox, but the characters should appear as " ****** ". Is there any way I can accomplish this through VB code or any other method.