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

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

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

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

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

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

I am trying to create an input mask for general date field: 00"/"00"/"00" - "00:00 to give a combination of short date and short time. But the message came back saying 'The value you entered isn't valid for this field'. The only way I can round it is create the field as text. But I prefer...

I created a query to collect incidents in a ascending date order, and the date of incidents were displayed correctly. When I created a report based on that query, the date order on that report is incorrect. The dates were slightly not in order. Why is that?:confused: