Search results

How-do! Spot of bother with one of my reports. Bit of background first to help explain... Have a Query (Query1) that pulls together data. Based on the criteria it outputs a single record (finds the serial number entered in another form). This query contains basic info, some of which is linked...

Had this on one of my forms: =DCount("[Serial]","tblMainData","AreaID = 1 AND StateID = 1 AND TypeID = 1")I also need it to count TypeID = 2 So i have 10 records of Type ID = 1 and 5 of TypeID = 2, my total should come to 15.

I have a number of forms, all based on different queries. All the forms look the same, but obviously return different record sets depending on the query parameters. Form1 | Query1 Form2 | Query2 Form3 | Query3 and so on for 3 more forms/queries. Each Query returns around 100 records from a...

Thanks Pat.

I have a query running on a combo box result (select option, run query). No problems here, but i could do with an "ALL" option for the query (the query runs on multiple criteria, such as location, equipment type, status etc and sometimes we want to display all locations, but only faulty...

Hi, on one of the reports i have, the results can vary between 10 and 40 for each grouping. Sometimes these result wrap onto a new page and the titles are not included at the top of the subsequent page??:confused:

Spot on. Thanks Rabbie.

Data integrity is not a problem here. Once the fault has been raised and closed, the data cannot be changed and neither do we want the data to be changed. Even if the data is changed at a later date, the original value of days in between is the one that is important since that is what we will...

I did Brian, but since my original post I changed what i needed to do on advice from people who posted. I now don't need to store a calculated field, i just want a message box to appear displaying the difference between two dates after the end date has been entered. The user can then enter the...

Sorry, since my last post was another question, is it better to keep in this running thread or start a new one?

Right, i see you point now. Since the calculated value is much more than just two or three digits representing the days in between, it is much easier to have a formula work the figure out and enter the result manually in the field. Is it then possible to have a message box pop up with the...

After thinking i may not need this one any more, i have been proven wrong by our supplier so i need to rehash this. After a bit of guidance and some research i think i can make it much simpler. Two date fields DateDown and DateReturned. Is it possible to get an on update event in the...

Took a little fiddling (had to use column 2) but got it! Again, many thanks.

Having trouble with my date again! She doesn't appreciate what I.........oops wrong forum! No seriously, is it possible to have a form automatically enter a date in a text box? frmTraining is the main form. On adding a new training course event (for example, First Aid) a combo box obtains the...

Once again, the speed and quality of replies is tip top. Thank you for being so helpful.

Hi all... Looking for a bit of assistance with a message/pop-up box. On one of my forms i have a combo box that takes its values from another table. On selection of a certain option (3) i would like a message box to appear to offer the user a reminder. Any suggestions are greatly appreciated.

Spot on bob!

Hi, I have a form frmRunReport that runs a report based on a query. The query requests a date range for the report (from and to) and outputs the report based on this range. This is done through two text boxes on frmRunReport, and they are txtFrom and txtTo. Ii want to be able to display the...

No, single form

Sorry, every time i try to explain, i think i post enough information to cover it. Wazz - Correct, i want staff from a certain location to be displayed. The second combo box is to further filter the form frmStaff to only show that one person. This form is for people who don't know how to scroll...