Search results

when i run the following off the click event of a button, I get a "Enter Parameter Value" dialog box with the value of "me.txtTypeOfArea" followed by the input text field. strSQLInsert = "INSERT INTO tblAreaTypeLookup ([txtTypeOfArea]) VALUES ([" & Me.txtAddTypeOfArea.Value & "]);"...

I have a form with 1 listbox, this is based on a table, with 1 field in it. what do i need to do, to be able to add and remove items from this listbox! Also with the removing part of it, removing many rows at once would be good aswell! Any help would be muchly appreciated.

Hi All, I have a form that when loads, runs some VBA on the "On Current" event. Some of that code, fills in text boxes, with concatenated (?) strings. So every time I use the record selector and get to the end of all the records, the "On Current" fires adds the concatenated string (even if it's...

I've created a form to search my database using the Query by Form Using Dynamic QueryDef. Everything is working fine, except... I want to setup file and folder permissions to let a group of Editors to "Edit" the records and everyone else to just have read permissions. I have this working up...

Hi, I was wondering if any one has used the "Query by Form Using Dynamic Query Def" (MS KBA 210242) to create a search form, which searches the main form and a subform within the main form. Currently it works fine to search the Main form, but if I put any criteria into the sub forms to search...

I've created two forms, my main form, and a search form which is a straight copy of the main form but called search form. The search form has a command button which runs the "Query by form" from Microsofts web page (KB210242), for the most part it works, but on the forms they have two sub...

I wasn't too sure where to post this, Queries or in Forms. Anyway, I have a database, with the main form (frmMain) to enter data, I have copied this form to turn into the search form(frmSearch), I have done the straight copy paste, to get the search form looking and feeling the same as the...

I've got a search form which uses the Query by Form code from MS web site http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242 This all works, except for one of the fields is a drop down list, if I select a name and do the search no results are displayed, I can do a case statement for...

I'm in the process of creating a simple data access page address book, but I can't seem to figure out how to do a search on multiple fields, e.g. I want to be able to search by first name and surname. At the moment I have two command buttons one to search first name and one to search surname. I...

I have just created a form based on a query of a number of tables, when I enter data into the form, the data goes to the tables, but when I close the form and re-open it, the records I have entered aren't displayed. I opened up the query and it didn't show any results, but again like the form I...

I have created a Search form using the code at this URl : http://support.microsoft.com/default.aspx?scid=kb;EN-US;210242 it works except I cant use it to search by date, which I need to do. It will only search in U.S. format, MM/DD/YYYY, as I am in Australia I need to search in the following...

Hope this is the right group, I have a continuous form that has a 3 column drop down list box, on selecting a value from the drop down list it fills in two text boxes. This all works, my problem is: When I select a value from the list it fills in one of the text boxes, when this text box is a...

I had a form based on query, to enter data in, it was displaying everything fine, I have since done something, which I don't know what, and now everytime I open the form it opens blank with no fields at all. I have checked filters and none are set. If I enter data directly in to the table the...

I have a lookup combo box which fills in text box1 and text box2, I have then set text box1 for if it recieves a specific value, it will fill in another text box(text box3). This all works, but occasionally, text box3 will require a different value, if I type in another value, going from one...

If I have a memo field, which lists people's names, is there anyway I can extract, each persons name to fill in other fields. I'm designing a database as an application form, which has the main applicant, and "other people accompanying", this can have from 0 other people up to a coach load of...

I keep getting an error message on a form of mine, when I click on either of the command buttons that I set up, which I created from the wizard, one to print and one to close the form. The attachment has the error message. (in word2000 format)

I have a form which has a list box, I want to be able to select one of it's options, and on it's selection, have some fields on the form become visible. How would I go about doing this?