Recent content by chrisjones99

Thanks a lot for your explanation, I will try it right now

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

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

Thanks PHV, this worked perfectly !!!!!!!!! Many many thanks to both of you for your time..

Thanks for your answer herman, the thing is i tried afterupdate event but probably don't have the right code... can you help me with the code: i tried to create a variable X and then affect the now() formula to this variable X, then tried to take the name of the field and affects the variable...

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

Thank you Bob ! This is what I was looking for...still have some small problems with writing the VBA code and the syntax of docmd.runsql but I'll search a little.. A big thank you, this really helps a lot!!!

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