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 TouchToneTommy 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: *

  1. chrisjones99

    Usage of ' or " in SQL String

    Hello, I'm trying to get a SQL string working in a file but get very confused with the usage of ' or ". Can you help ? Thanks a lot in advance. I always get error in that SQL string. I used one of the FAQ in order to build up the query but still got some problems : Here it is Sub...
  2. chrisjones99

    Updating data trough form in crosstab mode

    Dear, I've got a table with : Country;Customer;Product;Date;Data I've tried to make a form in order to update data(revenue) for a customer that has several products for several dates(months). i want a display with the months in column, but that's trough a crosstab, so it isn't the solution...
  3. chrisjones99

    Automatic date in current record afterupdate

    Hello, Looking for a method to automatically update a field of my record with the current date and time after it has been modified.. -tried with setvalue but didn't work. So basically i want the field to contain date & time of modification so i can use it later to see which record have been...
  4. chrisjones99

    importing from excel, 12 columns in one...

    Hi everyone, I have a spreadsheet with columns looking like this: Country,Client,Product,Apr,May,Jun,Jul,Aug etc.... I'm trying to import it in access but what i want is have only one column with the months meaning for april : 01/04/04 may:01/05/04 etc... in one single column Do you know how...

Part and Inventory Search

Back
Top