Recent content by Simtech

Sorry for the lack of clarity but thank you for your patience and solution. This is what I was looking for. I have also changed the name of the Date field to avoid problems with the reserved word. Again thanks for you solution and advice. It's much appreciated.

Here is the sql for the query. SELECT tblShiftHOData.Date, tblShiftHOData.WorkSection, tblShiftHOData.Item, tblShiftHOData.Maintenance_Software, tblShiftHOData.Entered_By FROM tblShiftHOData WHERE (((tblShiftHOData.Date)=[Forms]![frmShiftHOFindLatestDate]![LatestDate]) AND...

Hello, I have created a query that uses the MaxofDate function to retrieve logbook entries created on the last day of work in our section. This query creates a report that can be accessed from a "quick link" button on the main menu of the database. This function works great except that once a...

Welcome to the forum. I'm sure you'll find this place invaluable. It's been a great help to me.

Thanks to ypma for your suggestion. I was looking for a way to make the the InStr() function work for me when you posted your idea. I modified it for my database and it works perfectly. Thanks for you help.

I have a text box on a form where a user can enter a customer control number. These numbers are formatted as follows RED12-HK001 or RED12-1Z001 where the characters HK or 1Z represent the account codes and other characters represent equipment (RED), the year (12) and the sequence number...

Hi. My name is Bob and I work as a simulator technician here in Canada. I have been creating Access databases for some time but up until now they have been relatively simple affairs, using only the built in functions available in Access. I have recently been tasked to create a much larger...