Search results

Access Db Oops! Forgot to attach file.

Attached is the file that I am still not able to get the validation to work as planned on the "Review Accounts" page. For example, if txtAmtSubmitted is populated, then txtDateSubmitted and txtFollowupDate must be populated. Note, there are 4 columns for data entry - txtAmtSubmitted1...

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...

Assistance/insight appreciated - Currently, have the following that is not quite working as planned. When I attempt to add the missing information, I am prompted with something like "not using the addnew or edit..." error dialog box. So far, I have this; Private Sub Form_BeforeUpdate(Cancel...

Another thought, In the event that I cannot format as currency and sort in ascending order, is it possible to right justify all numbers within a column in a listbox?

Although I am formatting the column within the listbox as currency, it is really text? Consequently, it appears that I should cancel the formatting as currency. Additional thoughts/comments?

What about using "Cancel = True" instead of "Exit For" Consequences?

Additional context; There is a listbox at the bottom of the form that contains all accounts that have been assigned to the end-user. When the end-user highlights a account in the listbox, all of the associated controls are displayed above the listbox. So, to go to another record, one just...

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...

Data Entry Validation After modifying the code, as displayed below, the message box displays the expected error message. But, I receive a run-time error. Specifically, the run-time error is "Run-time error '2001': You canceled the previous operation." If I enter a value in the "Date...

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...

Append/Update Table with Oracle Data using ADO Thanks for the insight. I am still trying to get this to work! Basically, the design of the Access table is "demanded" by my Manager!! I have repeatedly stated that this will be a maintenance nightmare!! I have been told to finalize the...

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...