Recent content by TexRanger

many thanks to you paul and mailman, i modified the dcount statement as suggested by you and it works like a charm, many thanks

Dear Paul the missing "AND" was a typo, my apologies, converted my statement to your reply, the DCount Still does not work. and the whole thing goes for a toss. I am trying to count the containers moved by a truck between two dates. Would converting the whole thing to a count query help, and if...

Dear all, I am facing the following problem with dcount() the following statement works perfectly well =DCount("Numx","tx_container"," VehicleId = " & [VehicleId] & " AND CMRDate > " & [TempVars]![PR_006_LowerDate]) but when the above statement is modified to...

The Original Query was --- SELECT Count(clubbox) AS LoadSingles FROM moves WHERE (((moves.cmrdate)>[Forms]![CPanel]![Text44] And (moves.cmrdate)<[Forms]![CPanel]![Text46]) AND ((moves.driverid)=[Forms]![CPanel]![Text38]) AND ((moves.move)<>35) AND ((moves.clubbox)=32)); and this returned a...

can i use 6 or 7 conditions, in the dcount[] criteria part, are there any restrictions with regards to total number of criteria that may be used. many thanks

ooops, terribly sorry and my apologies, the query returns a count of 60 records, i wish to store this value of count into tempvars.

The Query 'SELECT Count(clubbox) AS MTSingles FROM moves WHERE (((moves.cmrdate)>[Forms]![CPanel]![Text44] And (moves.cmrdate)<[Forms]![CPanel]![Text46]) AND ((moves.driverid)=[Forms]![CPanel]![Text38]) AND ((moves.move)=35) AND ((moves.clubbox)=32));' returns about 60 records, how do i assign...

Dear All, After a lot of investigation into the matter, it just dawned on me, that it is the only at the time of insertion of new record that the whole thing fails with a "COULD NOT INSERT into [table name]-ODBC error", now i just need to get around this problem. thanks for all your support ;):o

It seems that the mysql config, is the source of all the problems, I am using MYSQL Server 5.x on LAN, so would appreciate it you all could look at the configs, or alternativly provide me with config that works. many thanks

pat, many thanks to you, went through your post, and got the udpates part working flawlessly, how ever, i have attached the mysql config files so may be you can suggest changes to mysql odbc driver. As you, even i am at sea, as to why i should need a pass through query. howver it is the only...

freinds here is the mysql odbc config kindly advise if any changes are required

oops sorry, i missed out the attachments will upload it as soon as i get home. Access returns a ÏNSERT FAILED error, only when i try to insert a new record into the mysql table, if the record already exists, then i am allowed to edit and save / update the record without any problem

Hi, Answer to all your who,what why and whens 1]What are the main pros and cons with access - Quick Turnaround - Very Zippi response, provided you configure mysql properly - Extremely good presentation - Good master detail design type and versatile forms 2]What are the main pros and cons with...

hi, I am enclosing a snapshot of the MYSQL odbc config, I am not very sure if this would help, but my sincere request to all to have a look at the attachment and help me, understand or figureout the problem area many thanks once again, in advance :)

Successfully inserted a record from access into the table (attachment-1 & 2). however doing it from the forms fails miserably. I guess, i have to use the passthrough at the time of insert/update into the table.