Search results

I am trying to call an Oracle stored procedure from VBA on a form. The Procedure takes 1 parameter and does not return anything, it just validates data and update some tables. I have search this forum, help and Microsoft support and am confused on how to accomplish this. Below is the code I...

I have two subforms (RECEIVING_SUBFORM and RECEIVED_SUBFORM) on a main form (RECEIVING). The form is used to record receipt of expecting orders. When a partial order is received I want to add a new record with the difference of what was ordered and what was received then requery both sub...

I have a sub form (RPTSQueue_subform) on a main form that I would only like only appear when the user click a check box (Queue) on the main form. Below is the code that I am using on the AfterUpdate event of the check box, but it is giving me an error "Run-time error '424': Object required" If...

I am trying to do a cross tab Report, and having great difficulty. I have made a cross tab query with Row Headings of SubGroupID, and Column Heading of Date, Value of “Count” that is Summed. So I should the list of SubGroups going down and the Dates going across. I have tried working with the...

I have a form based on a Query that shows the total number of records in the Query. This form refreshes at a set interval using a Macro and the timer Event. After the form refreshes I would like to check the number of records and send an email if the number is Greater than 5. So under the same...

I would like to filter my form based on the value in a combo box. I have a apply filter macro, with the where condition is Forms![CronStore]![Location] = Forms![CronStore]![FilterLocation], and set it to run after update on the combo box. But when the filter is applied there are no records...

I have a Report that gets exported into Rich Text Format, and it is cutting off one of the memo fields at about 490 characters. I have tried several of the other export formats, and they are cutting off the memo also. The report in Access looks fine, it only gets cut off after it is exported...