Search results

Hi I am building a database in which to record hotel room bookings. I need to ensure that a room cant be double booked but I need more than a multi-field primary key for 'date' and 'room_number' as I need to ensure that if a room is booked on the 1st January for 7 nights that it cannot be...

Hi I have a subform on a form. I know that there is a certain word in a field on the subform, but when I try to use the in-built search feature to search for it, I get an error. It seems that the search on the subform only searches in the child records related to the current parent record...

Thanks John I later noticed that two of my refereences were in fact MISSING. I unchecked them and it fixed the problem. I dont understand the mechanics behind it and why Access doesnt figure out the problem for itself. Thanks again Al

Hi Yes, I later noticed that there were two references that were missing. I unchecked them and it fixed the problem. Thanks guys Al

Hi Thanks for that. Ive now noticed that 2 references are missing... Microsoft Office Project 12.0 Calendar Control and Microsoft Windows Common Controls-2 6.0 (SP6) but how do I add them ? Al

I have the same problem. I have checked the references on both computers and the same references are checked on both computers. The computer where the code IS working seems to have more references than the computer where it ISNT working, but the extra ones are not checked. Thanks in...

Hi I have been using a bit of code in a form to calculate the exact age from a Date of Birth control... If IsNull(txt_DOB) Or IsNull(txt_Customer_ID) Then Exit Sub End If txt_Age = DateDiff("yyyy", [DOB], Date) + (DateSerial(Year(Date), Month([DOB]), Day([DOB])) > Date) It...

Thank you for this. I did find the same article and I followed it. I created a blank form Inserted the Calendar View Control Named the Calendar control "ocxOutlookView" Added the code to the Form Load event Me![ocxOutlookView].Folder = "Calendar"Me![ocxOutlookView].View = "Day/Week/Month"...

I am currently recording patient's appointment dates and times in table via a form by having 2 separate controls; a date text box and a time text box. I still have to use Outlook to display the appointments in a Calendar form (double entry of data is annoying) as I cant find a Calendar control...

thank you so much Alan - that worked great

I have a Patient Table linked to an Appointment table. Each patient can have many appointments and all patients SHOULD HAVE a planned appointment in the future (but some dont). I need a query that will return the patients that do not have a future planned appointment date and to only show...

Hi Ive found this good article, which works fine. But does anyone know how I could Update the Outlook appointments from Access ? Thanks in advance Allan

Hi Im trying to call control event (click procedure) on a Sub Form from a Main Form. Ive tried various syntax on this page but I cant get it to work. Ive tried all of these... Call frmAppointments.btn_AddToOutlook_Click Forms!frm_Holding![frmAppointments].Form.btn_AddToOutlook_Click...

Hi John I found this article I followed it to the word and it works great. The problem with this is, I view my appointments in Datasheet View and when I view in datasheet, the button disappears. If you or anyone else has any ideas of how I can make this work in Datasheet view, I would be...

I have 3 related tables... tbl_Customer tbl_Customer_Treatments tbl_Appointments It might be obvious, but a customer can purchase many treatments and each treatment can occur over many appointments. In the appointments table I am capturing the Date, Start Time and End Time of the...

Thanks Dave - worked a treat

I have used the piece of code below from PNGBill and it is just returning "Admin" when I open it up on my PC and a number of colleagues PCs. I was expecting to see their Windows Logon ID.

What is the simplest way to retrieve a User ID using VBA ?

Its fine guys - I found the answer in the thread below... http://www.access-programmers.co.uk/forums/showthread.php?t=91392

In the attached query (qry_Had_Jabs) I am trying to get all the data relating to one student on one row, not multiple as is happening now. Does anyone know the solution ? Thanks