Search results

Is that possible to import some data (not all) from a query in another database ? I do not want to import the whole table because the table is too big. I hope do not need to create the query in the original database as it is our master database. Can anybody advise me ?

Hi, In the VBA, I put cammand "DoCmd.Echo False", the purpose is to run some command but not to update the screen (To freeze the screen). After finished all the command, we should turn it on by using "DoCmd.Echo True", if not the screen will be hang and have to use CTRL-ALT-DEL to end the task...

I had experience form freeze up when I use the echo off and forgot to turn it on. But your case may be different, because mine is only need to close the MS Access but do not need to reset the computer.

I am from a manufactoring factory. My GM had requested me to develope a program to generate sales quotation. The program may need to consider the factors like cycle time, material cost, man power, packaging, transportation cost and so on. Is anyone has done it before? Would be very much...

I encountered this problem before Try this: sqlQry = "SELECT * FROM MoveWorksheets WHERE MoveRequest_ID='" & [Forms]![EditMoveInfo]![MoveRequest_ID] & "';" notes : add symbol (') before ...WHERE MoveRequest_ID= and before ; Hope can help you.

Hi, Can anybody tell me how to capture time (and date) from server? This is to ensure that the time captured is correct and standard and also no cheating (User can play trick with their PC by changing time and date).