Search results

Howzit On the format property tab fo the control, Set "Show Date Picker" = Never.

Howzit, Your teacher is just plain wrong. Doing what you did storing the CPH in the appointmentbookings table maintains data integrity. If you went the teachers way and only had the CPH in the appointment type table, then should you make a change to any of the CPH values, it would change the...

Howzit What about this CurrentDb.Execute "Update Equipment Set Available = 0 Where Equipment.[Equipment ID] ='" & Me.[Equipment ID] & "'"

Howzit See PBaldy's post - Post 2 - mine forgot the square brackets.

Howzit [Sorry Paul - Our posts must have crossed] Try Private Sub Submit_Click() CurrentDb.Execute "Update Equipment Set Available = 0 Where Loans.Equipment ID =" & me.[Equipment ID] End Sub

Howzit That is correct No - just combine the title in the same field that combines the last and first names. Leave the column count as 2. I also would not put the title first, as it will make it harder to "find" your client if Mr \ Mrs etc is first. I almost always put the surname...

Howzit No - you compare the one you sent to the one I returned and see if you can see the difference. Hint look at the control sources \ record sources and rowsources of your forms and in some aspects the controls on the form Let me know what you find then I'll let you know if you have missed...

Howzit Here we go. Compare this to what you have

Howzit Delete the combobox, then drag the AppointmentTypeID from your field list (You may find it called "Add Existing Field") onto the form. This will initially show as a text box and will be automatically bound to the correct field. Then Rt Click - > Change to - > Combobox. Do not rename...

Howzit Not sure about that. How did you create the combobox? Where is the AppointmentTypeID. TO create a combobox from an exiting control, in design view rt click - > change to

Howzit Do you have anything populated in the Main form? Can you give me another screenshot of the message, but make it so that I can see the form fields

Howzit Yes the dlookup is to get the price from the tblAppointmentTypes table. The syntax is correct. What error are you getting? What is the name of the combobox?

Howzit Yes that is correct. You will also need to create the after update event procedure for the combobox using the dlookup from the earlier post.

Howzit Mainform fields - what you have Subform fields - what you have except remove the AppointmentType. You already have the AppointmentTypeID using a combobox to select the appointment type from the table AppointmetnTypes - so you do not need both. The recordsource for this combobox should...

Howzit You can call the field CPH - in fact that's what I would do.

Howzit No you need to add it to the tblAppointmentBookings TABLE like I said. You already have the control on the form, but it is bound to the wrong table. On the subform you need to change the recordsource to the tblAppointmentBookings TABLE

Howzit No not at all. In regards to CPH, you also need this in your tblAppointmentBookings table to accurate calculate the total cost for the line. Your tblAppointmentTypes table is your master table that holds your CPH that is in effect currently. So when you make new bookings this is the...

Howzit You need to add a new field in the tblAppointmentBookings table to hold the CPH (what is this?). If this is Cost Per Hour then surely yu will need one other field to hold the number of hours? Then use the tblAppointmentBookings as the recordsource for your subform. The recordsource of...

Howzit The reason that you are finding your appointmenttype table being updated as you have bound your that table to your form. There is no need to join the appointmenttypes table to the appointmentbookings table in this recordsource. Is there any reason why you cannot just use the...

Howzit In design view of yor form click on the top left corner of your subform , rt clik properties -> Go to the Data tab