Search results

Thanks! It's so simple now you say it ha. I have replaced all instances in MSG of Me.[field] with REC("FIELD") and it works perfect.

Hi All. I have the below code to look at a query and create an automatic email containing data from the query. There are currently only two records in the query. When I click on the command button, my message box works OK and tells me that it has found two records, from the Rec.RecordCount...

I tried this too, when I count the DevType, I got the same results. I have just created a new query to look at the results of the initial query and have managed to get the data I require.

Thanks for the reply. If I uncheck the location field, I get this... What I want to do is combine the records where each device type appears more than once so it would look like this... BED ELECTRIC DRIVEN 10 BED PLINTH ELECTRIC 1 DOCKING STATION 1 DOPPLER VASCULAR...

Hi All. I have the below query which selects data and then counts the number of records that fits the criteria. The criteria is that the Equipment's Owner Department is 'Equipment Pool' and location is 'Equipment Pool'. Working query I now want to be able to count the records where the...

Thanks for this, I'll start doing this.

Perfect, works a treat.

Sorry Gasman, I'm not sure how to do this. I've tried looking at a few things online but can't figure out how to go about this.

Yes my BookingID is a sequential auto number. What I want to do now is... If TotalRecords > 0, I want to locate the record with the BookingID which = LastID, and then update the DateIn, TimeIn etc. I have tried to do this with the following code but I am getting a Run-time error 3061, Too few...

Thanks Minty that has certainly worked a lot easier. Is there a way to select the most recent BookingID from the records the DCount finds? I was adding the AND [DateIn] is Null to the end of the strSql like so.... strSql = "SELECT * FROM PoolBookings WHERE [CodeNo] = " & "'" &...

Hi All. I am creating a new equipment library database. The user will log when they are taking a piece of equipment from the library using a booking out form called 'PoolBookings'. This saves a record of the equipment's asset number, their name and department, and the current date and time. It...

Thanks all for your help. I have now got the data that I need with the max for each field as seen below in a continuous form. It shows the last 12 months data in order. This is what was used for the query in the end: SELECT Format([DateStamp],"yyyy") AS [Year] Format([DateStamp],"mmm") AS...

Hi CJ. I would not be looking for a record but rather the 2 highest values from each field. So the query would look at the data in the LSA field and would select 10 and then 10 from ASA field too. Hopefully this makes senses. Maybe it would be best for 2 queries instead of one for this as I...

Hi All. I have a table called PPMTarget that stores our planned preventative maintenance performance targets, when a command button is clicked. A click of the command button stores the below information: TargetID Date LifeSupportTarget LifeSupportSpread AcuteSupportTarget AcuteSupportSpread...

Hi All. Just in the past week on my database I have found that I cannot use the * filter in a numbers field. I get an invalid syntax message when trying to do so. I have used the * filter in a numbers field for years and have not changed anything in the database. I have changed the field to a...

Hi All. I have copied a table in my database with the structure of it staying the same. I have then appended data from another table in to this new table. Now when trying to add a new record I receive a message that this would create duplicate values in the index key. If I was to create a new...

Thanks for your help. However, the unbound text box is now showing #Name? instead of #Error. I will look in to why this is.

Hello All I have a continuous subform called ContractsReadSubform, that is based on a query called QueryContractsSubform. One of the fields in the query is called CodeNo, which relates to the unique equipment number of a device. Every CodeNo has a serial number which is stored in the...

Hi All. I have a query that is ordered to order the [Date Out] field in descending order. The [Date Out] field is the last to be completed on a record. So until a record (job in this case) is completed, the date out has a null value, which means it shows at the bottom of the records. I have...

@arnelgp @Gasman Hi Both, I always archived the .mdw file with the .mdb As it will be painful getting IT to reinstall the older version, I will get hold of an old copy on my personal PC and try it there. Thanks for your help.