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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Event2020
  • Order by date
  1. Event2020

    create and run a update query totally in code

    Hi Jim, Many thanks for the reply, I really appreciate it. I tried your suggestion and Access 2000 is giving the following error: Runtime error '3319': Syntax error in union query. I dont understand this as all I did to get the SQL was create a normal update query (that works fine) and then...
  2. Event2020

    Add time values together to get total time NOT elapsed or difference ?

    Hi, Before I carry on I just want to say that some very kind people have tried to help me before (I am so grateful to them) but sadly it still does not work. I have searched and searched for help on this but all the postings I can find are about time differences between a start time and end...
  3. Event2020

    Adding a specific range of time values to get total running time

    Att: Mossoft. Hi ya, Thank you for your reply and code, I really appreciate it. One question if I may - how do I get the value generated by the function into a text box on my main form? Thank you again, Event2020
  4. Event2020

    Adding a specific range of time values to get total running time

    Hi gang, I wondered if I can impose on you for some help. I have been trying to sort this for 2 months now with out any joy, I have posted into all the Access News groups and forums that I can find and either have had no answers or the ones I did get were too complicated and beyond my skill...
  5. Event2020

    select from a combobox using listbox column 5 as criteria??

    Hi Doug and Cosmo, Just a note to say thank you to you both - it works perfect now, I appreciate your help. Regards, Event2020
  6. Event2020

    select from a combobox using listbox column 5 as criteria??

    Hello, I am using access2000 and I have a combo box [cmbProduct] on a form that is based on a lookup field [productID] in a table called [tblLines]. I also have on the same form a listbox called [lsbFound] and i want to use column 5 to select from the combo box. In other words, when the user...
  7. Event2020

    select from a combobox using listbox column 5 as criteria??

    Hello, I am using access2000 and I have a combo box [cmbProduct] on a form that is based on a lookup field [productID] in a table called [tblLines]. I also have on the same form a listbox called [lsbFound] and i want to use column 5 to select from the combo box. In other words, when the user...
  8. Event2020

    List Box works great but NOT in the way I need??

    Hi Terry, Many thanks for your reply and your suggestion of removing "*" from the text box search string, the list is now populating in the correct way - kindof :P What is happening now is this: When you open the form for the first time, the list box is still populated with ALL...
  9. Event2020

    List Box works great but NOT in the way I need??

    Hi - I am not sure if this is the correct forum to ask the following in but here goes. I am using Access 2000 and I have a list box that is populated by a text box on a form. The user types an item in the text box (for example the letter A) and all items in the database that begin with the...
  10. Event2020

    why dont this work now - asny ideas please ???

    Hi Can anyone help with the following code and why Access keeps chucking error messages at me when it worked perfectly in a exact copy of the DB Its in. The code is on the OnNotInList event of a txt box called txtArtistID which is on my main data entry form called frmDataEntry, txtArtistID is...
  11. Event2020

    Why dont this work now - suggestions please

    Hi Can anyone help with the following code and why Access keeps chucking error messages at me when it worked perfectly in a exact copy of the DB Its in. The code is on the OnNotInList event of a txt box called txtArtistID which is on my main data entry form called frmDataEntry, txtArtistID is...
  12. Event2020

    Why dont this work now !!!!!

    Hi Can anyone help with the following code and why Access keeps chucking error messages at me when it worked perfectly in a exact copy of the DB Its in. The code is on the OnNotInList event of a txt box called txtArtistID which is on my main data entry form called frmDataEntry, txtArtistID is...

Part and Inventory Search

Back
Top