Search results

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...

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...

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...

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...

I have a main table that is called 'Floor' which has several fields in it RefID being one of these. Also there is FlrID. One is for the actual building you are in the other will be for the floor level you are on as you do the site survey. I have another table called Block and another Level. The...

Hi Folks, Does anyone know how I can stop the tab button advancing through the records on a form when it has gone through all the other tab stop positions? It driving me nuts! Ta

Hi All, I am writting a report and would like to cut and paste clips of code from the VBA window into the word document. Cut & paste works obviously but what would be nice is if it kept its formatting for layout and also the way it colours the code. I dont really want to do a screen grab if I...

Hi Folks, I would like to know if there is a way of testing for values using an IF statment. I know there is but my knowledge of IF statments does not extend to this senario. So what I want to do is basically test for the following: OrderPlaced = -1 AND FromStock = 0 AND Arrived = -1 AND...

Hi Folks, I have one table with say 4 fields, Name, Address, Size, Order and InStock. Order and InStock are checkboxes. I want a query that displays records that have a -1 status in 'Order' OR 'InStock'. Any help would be apreciated. Thanks

Can anyone help me please. This was my code that basically sorted records displayed in a form by assending order then by descending order if you clicked the header MasterLbl. Private Sub MasterLbl_Click() If Me.OrderBy = "[MastRef]" Then Me.OrderBy = "[MastRef] DESC" Else Me.OrderBy =...

I use this code to sort aphabetically on a field. Double clicking the header (DeptLbl) simply sorts it fine. But I want it to sort it on this field first but then on a sub field called 'Room'. In other words I want it in Department order first followed by Room order next. Any ideas ...

My problem is simple. I want to join field1 and field2 and store the result in field3. The fields are text fields and I would also not want to perform the action every time the query or form or whatever opens as this could slow things possibly in the future. It would be fine to do the join...

I have an access table that contains an exported file from another application, its electrical consumption data actually. My problem is that the export function on the metering equipment will export it in only one way. It exports it in a vertical fashion down to a set number of rows but then...