Search results

The value of the field was a number, so i used the code you suggested and it worked first time!! I cannot thank you enough, the generosity of guys like you on here to take time to help others really amazes me! Thanks so much again, Since your advice worked so well i wonder if you could...

Please can anyone help me? Im so close to achieving what i need apart from this little bit! any help would be awesome Lee

Thanks For Your Help Guys, I have now got that to work with some slight tweaking and playing around etc, i have since realised that i need to add a 3rd condition for the search which is a field 'Stylist ID' this is the modified code with the line i'm now having problems with in blue: Set rs...

Bob, Firstly thanks for the quick reply, i did actually write the code although some is wizard generated The Global variables are in a seperate module called 'Dates' I had no experience of using them before and so after some internet research read that this is how they had to be declared? I...

Hi, I am stuck with the following part of my system code: Set rs = Me.Recordset.Clone [Time Of Appointment] = Dates.TimeOfBooking [Date Of Appointment] = Dates.DateOfBooking rs.FindFirst Format([Time Of Appointment], "hh:mm") & Format([Date Of Appointment], "mm\/dd\/yyyy") & "#" If Not...

Thanks for the advice Paul, I have tried it but still without any luck, I have changed my form slightly again. I have uploaded another version of the database, on it the form in question is called ‘NEW’ there is a textbox on there called ‘txtDateOfAppointment’ I currently have 6 records in the...

Sure, the form im working on is called 'TEST' any advice you have would be brilliant. I should also say that as i said i need it to search for the record and display it in the subform but if that record for that date doesnt yet exist then i need it to create that record Thank-you Lee

Paul, This translates to the following in terms of my project: Me.Appointments.Form.RecordSource = "SELECT * FROM Diary_View_Table WHERE DateOfAppointment = #" & Me.cboDate & "#" I have tried running this and get the following error: 'The record source 'SELECT * FROM Diary_View_Table...

I have now adopted a slightly different approach but have run into further problems and I wondered if anyone could help me out. I have a form with a ComboBox on which allows a date to be selected from a calendar this value is then returned to the combo box. I have a subform on here which has...

Any ideas how this would be applied to my project? Sorry im not the best/most proficient at VBA :) Thanks so much

Hi All, I am developing a booking system for my final University project and have hit a stumbling block which I hope someone can help me with. Basically I have designed a daily appointment sheet with timeslots on, the is called ‘DiaryViewForm’, I have a form which has a pop-up calendar on to...