I have a Query with fields from several tables and multiple filters and have a recordset that I would then like to move into an Audit table. This is when an Event is cancelled that has several bookings or when a single booking is cancelled. The Audit table is then used to control the issue of refunds.
Here's the code (see comments within for the 2 problems)
'Set DB = CurrentDb("JDWEventsII_be.mdb") 'PROBLEM - will not work so had to use legacy method below
'Error "Item not found in this collection."
Set DB = DBEngine(0)(0)
Set RS1 = DB.OpenRecordset("qCanxEventAudit") 'PROBLEM - the recordset I'm trying to open is query
'based and is the Record Source for the form
'Error "Too few Parameters. Expected 1."
Set RS2 = DB.OpenRecordset("tJDWAudit")
You are using a parameter: your query refers to a form.
1) Re-write the query as:
PARAMETERS [jdwb_BookingID] Long;
SELECT tJDWEvents.jdwe_EventID, tJDWBookings.jdwb_Member, tJDWBookings.jdwb_BookingID,
This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®.
Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …