Search results

:confused: Hi! With help, I created a coding to duplicate a booking record. Now I need to duplicate a booking record by a number of frequency. In other words, if I want to duplicate a booking by 52 weeks, it would do so automatically with the correct future dates installed. This saves...

Duplicate form and subform Wayne Thanks for your reply. I did what you advised and the same message appeared. When I debugged it, the following line was highlighted: !BookingID = Me.BookingID which suggested that the problem lies on that line before it even gets to the .AddNew / .Bookmark...

I am trying to duplicate a form and subform. Each record in the form is identiefied by a BookingID which is an autonumber. When I run the following duplicate command, a message appears saying 'You tried to assign the Null value to a variable that is not a Variant data type.' It is a Runtime...

Can you help to finish it off / run the code? Click on the Duplicate button on the Booking form. Thanks. Paul

Do you mean attach the code to a macro, instead of attaching to a 'On Click' or [Event Procedure] of a command button? The code would be treated as a standalone, rather attached to a form? Paul

Duplicate record I debugged it and an error message appeared for the first line, Public Function DuplicateRecord..... Compile error: Member already exists in an object module from which this object module derives Paul :confused:

Error - explanation I am creating a Function Booking database with a form showing function details such as venue, date, menu selected. Each booking record (BookingID) is an Autonumber field, purely to keep each record unique. A function can be repeated on a weekly basis. So without having to...

As I said I am no expert on coding. I found this duplicate sample db on the internet and changed the fields, etc to accomodate with the fields of my database. It worked on 97 version but I hit problems in 2000 version. Using the simple duplicate wizard does not provide the solution I am...

Error The BookingID is an autonumber field. The database in question is a function booking. For repeated bookings, I created a duplicate command to copy a record and create a new one with a new next autonumber. Some fields are text or date, so maybe the string coding procedure would not work...

Run-time error '13' Thanks for your reply. As I am no expert in coding but I amended the line to: MsgBox Err.Number & "-" & Err.Description A new message appeared: -2147352567-You can't assign a value to this object This suggests that a field data type is not a number type. Correct? Paul :(

:confused: I created a Duplicate command/macro on a form and, when it is clicked on, a message appeared 'Run-time error '13' Type mismatch'. Debugging the command showed the problem was this code line: MsgBox Err.Number, Err.Description in the bDuplicateCurrentRecord section (shown below)...

Deleted and compacted but still old data appeared. After created a database governed by an autonumber field, I entered a number of records. Each record had a subform governed by a field (in this case, area name). I entered figures into the subform to test it. Then I deleted the records and...

:confused: I am trying to create a suitable expression, either on the form itself or in the underlying query, that calculate the balance after each transaction, like a bank statement. What is the best way to do it? Paul

:confused: I am creating a simple database for a small community bank. I created a current account with a subform that includes all transactions (deposits and withdrawals). I wanted to put an expression on the current account showing the balance after each transaction is made. I used the text...

Create duplicate records in a form with subform :confused: I wanted to duplicate a record without having to do the paste command. I looked at this thread and tried to re-create the SQL statement to get the results I wanted. But I could't. I am a novice on SQL. I wonder if anyone out there...

:confused: I tried to add record in the query via a combo box, but a message 'The recordset is not updatable' appeared. I am puzzled as I can update the record in the table but not in query. For example, in FunctionBookingDates query, first try to click on a department name in Department...

Foreign key Thanks for the reply. How can I get a primary and foreign keys in same table? I am allowed only one such. Regards. Paul :confused:

:confused: From a form I am working on, I get this message: 'You tried to assign the Null value to a variable that isn't a Variant data type.' The form is 'FunctionBooking2' and the above message appears when I try to select a item from a combo box in the menu selection. This suggests that...

I created a function booking form with a subform to put down a list of food ordered. I cannot get each form to have its own list of food ordered via the subform. It merely copy each subform list for each record of form. I am going round and round trying to figure out what I have went wrong in...

I created a form showing an employee's work at every hour through his shift. There is two shifts - 6am-2pm, 2pm-10pm, and 10pm-6am. The hours for the night shift were in correct order ie. 22:00, 23:00, 00:00, 01:00, 06:00. Then I created a query for a report to ask me to select which day I...