Search results

Naturally the Select statement would work ... the integrity rules do not apply if you are only view data already resident in the table. How many fields are you trying to update ?? It's a little pain in the arse, but I would create a copy of the query, remove all but the primary key that you...

Post SQL statement here ... Can you paste your sql statement here .... I'll fix it for you .... I have experienced similar issues. What data type is your client# in the main table you are appending the new record to ?? QT :)

I agree ... S/He's absolutely right .... Use the same recordset ( query object ) to update your the dateComplete field of the recordset. I would attempt this via a module ..... dim db set rs=db.openrecordset (" ... etc ) then update all the records in this recordset using VBA SQL statement...

Code Conversion ... Hope this helps .... where will you be running this from?? Query, form, report, module ???? It may make a difference to the way you reference K1 .... let me know ..... but you can start with this .... ( put extra spacing to for better readability ! ) EXCEL CODING...

Had the same issue .. here is your answer ... Function RoundUP (amt) Dim num, decnum If amt - int(amt) > 0 then ' Make sure it's not a round number (1, 2, 3) decnum = Int(amt) RoundUP = decnum + 1 else RoundUP = amt end if End Function HOPE...

Yes, I understand ... I know that you cannot just take the sql code and paste it into VBA ... :rolleyes: But it doesn't really answer my question ..... I tried quoting the single quotes as in the link you posted .... same error. Any suggestions are highly welcome ... need to finish up this...

SQL Issue ... ERROR: Runtime error 3061 - Too few parameters. Expected 1. ------------------------------------------------------------------------ Not sure how to work in the '* ROLL *' into this SQL statement. The query statement works fine ... I have tried different quotation methods ( Not...