Search results for query: *

Thanks Worked like a charm!!!

Trevil, thanks for your response, but I'm not quite sure what you mean. I'm fairly new to VBA. Could you show me a sample of code? Thanks for any help

Is there a way to change the caption of a query column using VBA?

Thanks Zevw, ended up going another direction.

I need help with a combo box function that I have on a form. I used the combo wizard and created a combo box that looks up a record on my form, based on the value selected in my combo box. What I would like to do is filter the combo box . My database uses the project number as the unique...

I have a combo box that I want to change the back color depending on the selection made. I have the code working but my problem is that when I switch records the color from the previous record remains. Is there a way to reset it to the default color? I'm some what new to all the coding options...

Yes, thats what I would like. The way the query is set up is each search rewrites the query that is linked to the form. Thanks

pwise, I'm not sure what you mean, I'm new to all this. Here is the code I used for the search. Everything works fine except it will not requery the form unless I close and reopen it. Thanks Private Sub Search_Data_Click() ' Pointer to error handler On Error GoTo Search_Data_Click_err '...

I have a DAO database that has a search built in SQL that creates a query with the search results each time its run. To activate the search you click a command button. The rest of the form has text boxes to display the results. The problem that I'm having is that when I run the search, the...

Thanks that did the trick

I have 2 tables that have asset numbers. I want to compare the first table to the secound and get a list of the assets that do not match the second. Does anyone know how I would do this???

Thanks AceMan, that seems like the best way to go. I like the Idea of changing the defaults. I'll give it a try

Hi Remou, I'm running MSA 2000, the code will run because it comes before End Sub.

Remou, not sure what you mean? this is what I tried but this also clears original

Hi Grippy, here is a site I found very helpful for Date info. this is a link that has a tutorial on how to create a pop up calendar. http://www.fontstuff.com/access/acctut09.htm

The default is not an option because the information may be different depending on the user. As projects change the default information will change.

oops forgot to include the code!!!! Private Sub cmdDupRecord_Click() On Error GoTo Err_cmdDupRecord_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 5, , acMenuVer70...

Aceman Thanks for the quick reply, but I don't think I was real clear in my earlier post. What I would like to do is copy all the contents of the current form to a new record but I need to clear a few fields when I do so. Here is the code I have tried but it has one problem. It clears the...

Does anyone know how to copy the current Form record data in to a new record. I would also like to clear some of the fields in the new record. This will save the person inputing from having to retype information.

I want to use the "Duplicate record command" to copy information to a new record. I also want to clear a few of the fields when I do so. I have tried this code and it works accept for one problem. It also clears the fields in the original. thanks in advance for any suggestions. Private...