Search results

I have a form that has the data set to a query. On this form I have a text box that I want to combine two fields from the query into one and put that info in the textbox... There is a textbox on the form txtLName the fields are LName and FName the query name is qryAddress SELECT...

I have a table that has two fields for similiar information. tblName ID Name Nickname1 Nickname2 Nickname3 I have a form that I want to search for someone by nickname... on the form I have a text box for the user to input the search criteria. There is a Listbox that I need to...

Great!! Thank you....worked perfectly!

Not sure exactly how Ok I have a form (frmSrchValidByName) and on this form I have a list box (lstSearch) and the textbox for the input is txtName. (should I use a combo box?) The query I have doesn't work and I am not sure how to add the wildcard (probably why the query doesn't work) In the On...

I have a form that is bound to a table (tblAddress) and I want to be able to let the user type the last name in a textbox and then the ComboBox/List box would update as the user is typing. So if you typed in the letter R, then the combobox would list all last names that started with the letter...

I haven't had a chance to look into it in detail, but there are a couple of things I see might be the problem. You are not requerying subfrmwbs, so your total does not update, therefore your query for subfrmProposal does not update...and then in the LaborCategory1_Hrs_AfterUpdate() run a requery...

Yes it does apply

Thanks Pete, but in the before update event you can't assign a variable so it doesn't work

I have a form to input new contacts. The form has a text box for the entry of a Id# for the contact. What I want to do is check this ID# and if it already exists, let the user know and clear out the text box and return to the textbox for rentry of the correct ID#. For some reason I can't get the...

That is where I am...I have fields for dates of certain events. Some events might never happen and the others you input as they happen. I just ran into the problem where I need to save the data (that is now ZLS) into a date field...What to you suggest, Check the data to see if it is ZLS and skip...

Thanks, after running through the routine a few times I see that the error was with the ZLS in the date variable...a couple of questions on that note...can date be null? And if I use a Variant type, what downfalls might I expect down the road? For example, saving a variant null or ZLS into a...

Ok I changed the declaration to declare each one and I still have the problem...It does appear to be zero length strings, but it works on some and not on others. It doesn't appear to be the line before where the error is indicated. Any Ideas? I have posted the DB...To generate the error, click...

I saw somewhere some code for two listboxes that you can move the information from one to the other, like the query wizard. Anyone know where I can find it? Thanks

I have a form with several unbound controls (Textboxes and checkboxes). The controls get populated when the user selects some items in a cascading listbox. Some of the controls will not have any data. Then there are variables set to check if the user has made changes. I have the variables...

Thanks guys, I figured it out...I had the [ in the wrong place. [me!txtCDCNum] should have been me![txtCDCNum]. You guys are awsome

For some reason I am not able to figure this out....I have been looking all over for the answer to no avail. I have a form (frmAddInmate) that has a textbox (txtCDCNum) on it. I have a table (tblInmates) that has several fields (ID, CDCNum, and other data) what I want to do is when someone...

Yes it was late, I did transpose the message box (or cold have used NOT rs.EOF) any suggestions on why the Error....the SQL would be similiar for Dlookup. I will work on trying the Dlookup a little later. Thanks

I have a form to enter new names into a table (tblInmates). I want to check if it has already been entered into the table. The data is input into a textbox. I have tried several different methods. I have a similiar one that works but for some reason it does not work on this form. Here is the...

This is my own DB I am trying to make for work...but I don't think it would be beneficial to have all those tables...tblEthnic...would only have 4 entries and I don't think the overhead for the table would not ofset the benefit of having a dedicated table. TblCharge, to list all the possible...

This is the database, I did not remove any tables. What did you mean by a redesign?