Search results

Thanks for the response. I should probably clarify that our inspectors can take several other classes (call them Classes C, D and E) that do not have the same "refresher" requirement. Searching for the record with the Max date could possibly return a date for something other than Class A or B...

I am trying to create a simple database tool to track some training dates for some inspectors in our company. The inspectors are required to take Class A one time and then take a "Refresher" class, Class B, every 3 years. I am trying to code a query that shows the next due date for Class B for...

I'm building a query from a table that includes a set of vertical clearance measurements for each asset. The fields are named [CLD2] through [CLD9]. Not all fields will have measurements entered in them. I am trying to build an expression in the query that takes the minimum of the values from...

Thanks to all for responding. I am going on the assumption that something got corrupted when I built the form, because I deleted the form (it was a pretty simple form) and rebuilt it using the language above. It works fine now. ACCESS is a fickle mistress sometimes, that's all I can say.

I have a textbox on my form that has an event handler (on click) associated with it. The macro that launches is supposed to open a file dialog box and capture what the user selects. The forms can then use that file path to display a picture to assist in generating a section of a report...

Thanks to both for the replies. Using equals instead of Like was the right approach, and using the single quote for the text field was the syntax error that I needed to correct. I used "Like" because I was referencing short text fields. The 'missing' field code exists in the database and...

I am working in Access 2013 and have created a form to streamline data entry for some inspections. There are hundreds of assets to be inspected, but the ID code assigned to each asset is based on codes assigned to roadway intersections, meaning that one intersection code could have up to 5...

Thank you for your prompt response. I manged to figure it out this morning; the problem was in my first criteria where I was searching for certain strings within the comments. The SQL syntax looked odd to me, so I cleared the criteria field in the Design view and then re-wrote a proper OR...

Hi, I'm sure this is a simple question but it has bedeviled me this afternoon. I am assembling a database for a client that involves some inspection efforts at several hundred locations around the county. We have completed inspections and are now looking at ways to parse the data to make sure...

Thanks, I will give it a shot. The root cause may be the permission on the folder, as I discovered today that the folder where the back end resides is tagged read-only. But if I can improve my syntax in the process, I will certainly do it. Thanks!

I created a form for a database that included a textbox with an event handler (on_click). When the user clicks in the field on the form, it launches the Windows file select dialog box. When the user makes their selection, that value is stored in the database as the path to the target photo. I...

Good call, that turned out to be the problem. I could change the Read-Only attribute on my machine but not on his. I copied the front end to his local machine (it was hiding in the same folder on the server) and it works just fine now. Thanks for the prompt reply!

I built a DB in Access 2013, and I have fully tested it and placed it on a server here at work. I split it into FE and BE, but now when Users try to open the front end, they always get a message that the database can only open a Read-Only copy and asks them if they want to Save As.. in order to...

Thanks for the reply; I will look into the code that you provided. I figured this question had to have been asked before on this forum. Unless I'm failing to fully understand the Mail Merge output, I don't think it's the route I want to go. Each file has to be reviewed, signed and...

Hi, I have had great support in asking questions on this forum, so I am back with a new project. I am working in Access 2013. I'll be performing a series of inspections at a number of intersections for a small community. The data being captured is consistent from site to site and lends itself...

Thanks for pointing out the obvious. I was sorting by the cost of each item and then by whether it was needed. Moving the Needed field to the left of the item cost in the query fixed it immediately. Many thanks!

I have a query that pulls maintenance items for an individual asset, and one of the fields in the query is a Yes/No value. This field lets the client designate the maintenance item as Needed. The client wanted this so that when they complete the work, they can uncheck the box. Unchecking the...

I figured out my issue, and not to get too technical, I may have set the wrong query as the record source. It might be working correctly now that I might have corrected that. Thanks for your help.

Is the syntax for requerying the subform the same as for the form? I entered this into the VBA module and I got "Run-time Error 424: Object Required": SubForms!SingleMaintQ.Requery I tried requerying the main form, but no luck in getting the subform to update. Thanks for your consideration.

Thanks, JHB. By commenting out the error-handler language, it's now telling me that it can't find field 1 in the expression, so it looks like it won't update the subform because the field reference is coded incorrectly and the statement is just crapping out. That's where I'll focus next. Thanks.