Search results

Also I have tried to add But it doesn't work. It still selects the same item. The highlight doesn't move down.

Hi there, I have another problem about the escape identifier. There is a text box in my form. When I input any word without apostrophe('), it is fine to run the query and save the input in the table. On the contrary, I got a syntax error message when there is an apostrophe in the textbox. I...

the item in list box selection? Hi everyone, I have added "Move up"/"Move down" button for the list box in my form. However, when I select an item in the list and click "Move up"/"Move down" button, the item below/above the selected item is selected. How do I set the original item selected...

Thanks John. I have suggested it to my supervisor. However, my supervisor insisted that the sub_classification need to be auto-completed after entering Drawer field. :mad: Any other way?

Hi there, Some people may have read the thread I have posted for combo box. However, the previous solved combo box problem results in another problem. Here is the situation. I have a combo box called File in Log Entry Form, which saves all the file names to the File field in the Maintable. This...

Yes. I did revise my question since I did not expect to get answer so fast. Sorry about that. For the clear form question, I use the requery() function to execute the query so that the results can be refreshed every time clicking the Clear Button. The query is "Select ID, Name, Date from...

Hi, I have a search form to show results of a query. I need to clear all the forms when the Clear Button is clicked. However, I couldn't clear all the research results. Any idea to solve this problem?

Thanks, Maxmangion.

Hi, Is there any way to set the form to full screen when it is opened? Thanks in advance! vicgirl

Hi everyone, Many may have seen this problem before. This is the re-post of "Another combo box problem". However, in order to explain more clearly, I have attached the sample db. My supervisor asked me to do a combo box which can auto-complete the third column when the first column is...

Hi, I have another combo box problem. I have a combo box called FileCombo, which saves all the file names to the field called FileName in a Table1. The source type of this combo box is Table/Query. It gets the file names from a table called FileTable, including Drawer, Classification...

Hi, Does anyone know how to import a certain rows of worksheet in Excel to Access table? For example, I want to import row 1-35 from Excel worksheet to Access.

Hi, Does anyone know if there is clear_form function to set all texboxes or combo boxes empty in Access? Thanks in advance!

However, there is only one Column in my combo box, which stores the string. And I have set Bound Column = 0. The value of Purpose_combo is a number. I think that is the way how Access stores the value list.

Hi, I've created a combo box called Purpose_combo in Access. I populate this combo box with a list of values (such as "Response";"Reply"; "Advice")that are not generated from an SQL query. I only get its indexed number instead of the string when I use debug.print Purpose_Combo, such as I have...

I see. However, my supervisor doesn't want to redesign those tables since there are lots of data saved already. It is going to have problems when I adapt the db to those existing file. In addition, she doesn't want me to spend too much time on it. :(

Thanks for your help, Wayne. Sorry about the inconvinience. My supervisor did the Entry form and created the maintable, and I have to do the searchform. Both of us are beginners to Access. I have took a look at your sample search form. However, it shows only one record matching with the...

Thanks again, Wayne. I will use that way to post my db files next time. I didn't really get what you need. My permission?

I see. Thank, Wayne. I have many problems when I use requery(), which is listed in the other topic "VBA in Forms and Combo box" I have posted today. The Column() function is not recognized in the Sql statement(that is, you can write forms!search_form!Purpose.Column(0)) to get the string value of...

Hi, Could anyone post some database for search form which containing the value list? I am doing one search form, however, the query doesn't work for the combo box containing value list. Thanks!