Search results

Hi I am no access expert and somewhat of a novice butI have an issue with a database I have, to book appointments, this was a pre prepaired database and I have been playing around with it and customising it to my own needs. The problem I have is that it uses the customer name field as the...

Hi Many thanks for all your help, I eventually sorted it. the problem mwas with my Vehicle table structure, I re created it and altered my other tables and it all works fine. Thanks again for all your input. Regards Chris

Hi I think ive sort of nailed it, I created a query with the following SQL INSERT INTO tblAppointments ( ApptVehicleID ) SELECT tblVehicles.VehicleID FROM tblVehicles WHERE (((tblVehicles.VehicleID)=[Forms]![frmBookAppointment]![tblVehicles subform].[Form]![VehicleID])); Now with the...

Cheers for the help Will post the SQL and all the info tomorrow if thats ok as its on my laptop and i dont have it to hand at the moment but appreciate your help and look forward to your input. Thanks in advance Chris

Thanks for your suggestion. I have tried an append query but cant seem to get it to work , I have changed the subform from datasheet to continuous forms and added a command button at the edge of the form, but not sure how to code it to work. Or would you suggest leaving it in datasheet form...

Hi I have a question regarding a subform, when opening the main form (frmBookAppointment) with a customer record on it which is based on an appointment query, the subform (tblVehiclesSubform) data is opened with that particular customers vehicles displayed. this form is linked to the main form...

Hi all Thanks for your replies and sorry for the delay in responding , been on hols for a while. Anyway i know exactly what you are saying and i have tried to achieve what i want using a good table structure but i am struggling to acheive what i want. I have attached a screenshot of my...

Hi Is it possible to select three column values from a list box I have a form with a list box (ListBox1) based on a table, (tblAlpha) with three fields used, FieldA, FieldB and FieldC, this was created using a wizard and stores the bound column (FieldA) in (tblBrava) in FieldD of that...

Thanks for your reply Lagbolt your help is greatly apreciated as im a real novice at this :confused: My main issue is to try and make this database as user friendly and idiot proof as possible.The tblAppointments fields are all filled with the relevant appointment data regarding each...

Hi I did consider this but my logic behind this method is that when an operator opens the frmBookAppointment and clicks the combo box to select the customer name it immidietly refreshes the subform with the vehicles that are linked to that customer so the operator can see if the right customer...

Hi I have an appointments database on which I have a table “tblAppointments with fields named Manufacturer, Model and Registration . There is a tblCustomers and tblVehicles,table , the Customers table has a Primary Key CustID and is linked to the vehicles table via a CustID field also with one...

Thanks again for your help i'll find where these events are and paste that code. Cheers Chris

Thank you very much for an amazing fast result. That works perfectly, how can i get it to requery when i add or delete an appointment on the form. Thanks again for your help (cats hair is safe again now) Cheers Chris

Hi im fairly new to Access and would like to thank any help I recieve in advance. Here's my problem, I have an appointments database with an appointments table, the two relevant fields are ApptDate and CourtesyCar, ApptDate is a short date field and CourtesyCar is a yes/no field, this table is...