Recent content by twosides

Cheers for the reply. Yes I agree its funny. Made me smile at 06.45 am in the UK !! How could I do the count for each date value in turn? To be fair the TrainDate tavle is a one to many with the Staff table so I do have a DateRef field in the Staff table; so this could be counted I guess. But...

Hi Folks, Does anyone know how I would count the records in a table (called STAFF) for a given date and then add a flag if the count was over say 20 from a form? Cheers

Hi Folks, My problem is simple. I have 2 tables TrainDate and Staff of a simple traiing database. I have a main form with a combobox on it that selects the training date. The subform is then the staff appertaining to the relavent date selected in the combobox. On the form I even have a simple...

Yes I appreciate that. In fact I was looking at the calender and also the code. Wow that is some going. Fair credit to you for that !!

Thanks for the help, it has given me a pointer in the right direction. In actual fact I willl have several different fields on the one form to capture a name for any of the 'course dates' Do I use one table with say 5 fields for 5 training dates or should I have 5 separate tables, one table for...

Hi Folks, At work I need to create a simple form to allow users to sefl book a training date. Thats easy. There are seveeral dates etc. No probs so far. All I want to do is have a form that displays a blank field (without any other persons name in) that the user type there name in and when...

Hi All, I have created a very small database that acts as a booking system for 5 training dates. There are 20 spaces available on each date, after that the room is full. I have located the back end database on our firms server. I have created a front end user form that I intend to hyperlink or...

Yep I thought that was the way to go but could do with a pointer to start. As I say, I thought a quick scan of the forums would reveal a bit of code I could start with but to be honest my mind is totally frazzeled !! Could do with a starting point to begin kicking it about with. Cheers

I have been using Lebans code to print a report to PDF. This it does superbly. The database itself is very simple and consisits of just a few fields in one table. Essentially it is a list of 'equipment' and their 'location'. There are a few other fields but nothing major. In the report I have...

Hi Folk, Simple problem but I have my thivk head on tonight !!! I have a form that has several fields that hold data pulled from a query. I have a particular field that looks up in a pull down list a 'Department' If the Department is new and not already listed one (ie not in the Dept Table) then...

Hi Folks, Hope you can help. I have a touch screen small format PC (A5 size). I have written a small database to log survey results as I go around a site etc. To make it more 'touch screen' friendly I have made the combo boxes bigger. This has worked to an extent but not brilliant. How can I...

Fantastic. Job done. This does what I want. I want to improve the functionality a bit. When I open the database initially there are no values stored and thus displayed in the combo boxes which I can cope with and is preferable I have to say. I have made a popup form which is basically two...

Great I will try it later Thanx

I use a combo box to select and enter data into a field. I feel sure there is a way to get the combo box to 'remember, what the last selected value was and get it preselected or populated when you create a new record. Would this be also possible if there were say three combo boxes on the form...

Your help above has solved the issue. I can actually do what I need to re the joining of this data visually. The problem of not all records being displayed was due to the join method ie did not allow for blank fields. What is the best way of writing the joined or concatenated information back...