Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JOD59

  1. JOD59

    change the caption of a query column using VBA?

    Thanks Worked like a charm!!!
  2. JOD59

    change the caption of a query column using VBA?

    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
  3. JOD59

    change the caption of a query column using VBA?

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

    Filter combo box that looks up a record on my form??

    Thanks Zevw, ended up going another direction.
  5. JOD59

    Filter combo box that looks up a record on my form??

    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...
  6. JOD59

    Changing backcolor of combobox

    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...
  7. JOD59

    Requery not updating form

    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
  8. JOD59

    Requery not updating form

    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 '...
  9. JOD59

    Requery not updating form

    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...
  10. JOD59

    Compare table 1 to table 2 and send results to query

    Thanks that did the trick
  11. JOD59

    Compare table 1 to table 2 and send results to query

    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???
  12. JOD59

    copy current form data to new record

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

    Duplicate record and clear fields

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

    Duplicate record and clear fields

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

    Need Current Date in Combo Box / Drop Down

    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
See more

Part and Inventory Search

Back
Top