Search results

CJ Yes that works for me now. Is there a way to remove from the drop down list, the resources that are booked and have no free stock? For instance, if i am booked on a course Monday to Wednesday, I shouldn't appear in the list for a course to be booked on say Tuesday to thursday?

CJ Works well, but I seem to be having huge problems with dates. Using the date picker to select the start and end date is fine, its when it transposes that information tothe sub form, the dates end up in american format. Any way out of that?

CJ Thanks for that. I wasn't expecting you to be doing it that late into the day, although I know what you mean about 'real work' getting in the way. I have had a quick look and it looks great, will need to have a look at the underlying queries and tables etc to understand what you have done...

CJ Thanks. Yes, we do go round in circles... I know I have been for ages now!!!

CJ Would I need two sets of dates in the tblBookedResources table? If the resource is booked out for a course, and the trainer has an extra day either side, would we not just use the earliest and latest dates irrespective of the course dates?

CJ Thanks I'll look forward to it and of being further educated.

CJ Thanks for looking and your continued support. I have added the extra date fields to the tblBookedCourses It is a business rue tha we drive up the night before and return the day after, obviously having the extra data fields in the tblBookedCourses will highlight this. I have added the...

CJ thanks for your response I have add a very simple database in A2007 format. There are three courses within the database. Normally, the trainer will take the laptops the day before the start date and return the day after the finish date. On courses starting on a Monday, the trainer will...

I am building a database for the company I work for. We offer software training on a specific software. We have 12 laptops and currently two trainers. Courses are generally 2 days in length but due to having two trainers, both trainers can be out either at the same time or overlapping each...

Paul Here is my scenario. I am a software trainer for a company that offer the following: In House Courses for specific clients at the clients offices Public Course at a hotel / conference centre for anyone to come along to. I am one of two trainers. We have twelve laptops. We have one...

Paul Many thanks for your. I will take on board your comments about using Bound Forms for this particular project though and I think you are right, I am complicating things probably way too much!!!

Hi paul Thanks for your response. I hoped that I could create a new recordset, I just can't see how to create a second one. In answer to your questions, I've not used bound forms as I want to control every aspect of the form, I know it means more work and maybe I should re-think that part of...

Hi all i have an unbound form with the following code which works as it should Dim rst As DAO.Recordset Set rst = CurrentDb.OpenRecordset("tbl_Courses", dbOpenDynaset) With rst .AddNew rst!DateCreated = DateCreated rst!Originator = Originator rst!CourseTitle =...

Hi all Long time since i asked a question here, been busy with other stuff, however, here I am back with Access. Im currently working for a client who offers training on their software. The have a stock of laptops (12 in total say) Three Course Trainers Courses which last between 1 and 2 days...

Ok Having googled and search this forum, I have now found the answer to my problem

Hi Simon Thanks for that, however it hasn't made any differance. I'll keep googling :)

Hi all I have an unbound form containing textfields that are populated on the afterupdate event of the combo box. The combobox is driven by a query which among other things contains a currency value. When I run the query, the format of the field is correct (£23.00) however, when I use the...

Hi JZW Thanks for that. I will download it and have a look at it and see where it takes me. The reserved word of Date I was aware of but as usual it had slipped my mind. The idea of putting invoices and quotes in the same table hadn't really occurred to me simply because the invoice number...

Hi all Been taking a break from Access recently ,but been dragged back into it. My application is a bespoke quotation/invoicing/customer address type affair. The main structure is up and running. I want to be able to create one report only for both Invoices and Quotations. This is all driven...

The conditions are, if both fields are null or "" then present the message. Both sides of the AND are TRUE. If one side was populated and the other side not populated, the AND would not be true