Search results

oss 1) Master_Drawing_Comparison is a table 2) V_CustomerOrder_LatestLotNo_PiecePart3 is a query 3) Source : V_CustomerOrder_LatestLotNo and destination : Master_Drawing_Comparison 4) Both original objects (mean table) have same field type for the field PiecePartUnitPrice 5) i) Possible to...

This is new update query screen for better understanding ...

Docmd.RunCommand - show error "Type Mismatch" Can it be anything wrong to the Update Query instead of VBA code?

Anyone can advise how to correct the error in my attachment

My system prompt the error : DATA TYPE MISMATCH IN CRITERIA EXPRESSION How to know which fields contribute to the problem above? My SQL statement is as following insert into Master_Drawing_Comparison...

TQ. This is one way to resolve. However, the suggestion can't help me as the system / database is not fully developed by me. Any other suggestion to archive unnecessary data but in order to maintain the existing table structure?

A table say call "A" consists of duplicate records as shown in the below attachment. Can anyone recommend to me on how to detect and delete duplicate records but I wish to leave ONE record ONLY at the end of deleting process. Please take note, not all records are duplicating. You can refer to...

Yes. My question above is how to allow text from bar code scanner ONLY and not from keyboard ?

There is one text box on a form. How to allow the text box to accept value through bar code scanning ONLY and through keyboard ?

TQ, it works !!! The command above will move cursor to the first record and all records can be displayed on screen now.

Form come with scroll bars turn on BOTH. Look at the attachment below

Has followed what has been proposed, but it doesn't work. Look at the attachment below

already scroll up, can't move further up ...:)

Attached below are 3 JPEG files illustrate how the problem happen Before.jpg - show the original screen Process.jpg - show the activity I am doing. I choose No when the message box prompt out After.jpg - show the output in screen immediately after I click No My question is the data shown in...

When I link the excel into access, attached is the result i see in MS Access. I hv tried to set the all fields as GENERAL, TEXT and etc in MS Excel, but the same output I obtain. Anyone has resolution for this problem ?

Thanks for the info above. How to load worksheet name into combo box?

Yes. Any way not to use bound but still can show the correct sum? I don't plan to keep the total inside the table .

I have MDB and user can press Shift key to access in the VBA code. How to prevent this during the form loading time ?

How to create WW (Work Week) field for 1 year in query with Monday is first day and Sunday is last day of the week ?

same error as above