Search results

Each day at 7:00 a.m., a macro within Access appends records from Oracle 9 database into local Access table. Specifically, I have a passthru query that is converted to an append query and within a macro. Currently, trying to capture possible errors encountered when appending the records. Upon...

Appreciate assistance concerning the following problem; Background: Upon clicking on an option button to sort data in ascending order within listbox, List2, the data is not sorted correctly. For example, the order of the KarianceCurrent column is $1991.75, $1.00, $1.45, $1.68, $1.81...

Appreciate a resolution concerning the following: Able to display a message box that indicates the correct text box that is missing data. However, after the message box displays, the end-user is able to go to the next record which is unacceptable. I would desire that if the missing data issue...

Assistance needed, Have several text box controls for data entry on my form; Amount Submit, Date Submit, Amount Received, Date Received, and Followup Date. If Amount Submit is populated, then Date Submit should not be empty and Followup Date should not be empty. If Amount Received is...

I am relatively new to the use of VBA and ADO to append Oracle data to a Access Table. The code below was my first attempt and it doesn't work!! Upon your review, you can see that there are quite a few calculated fields in the table which is generally considered to be a maintenance problem...

I am relatively new to Access Databases and have been trying to use the following to append Oracle data to an Access table without much success at all! The error message that is received is "Invalid Precision For Decimal Data Type." Any insight as to the possible reason/resolution would be...