Recent content by Michael Barkemeyer

Thank you CJ. I have made the suggested changes to include year([ServiceDate]). But am getting a data type error when attempting to filter by year.

Hello, I have paired down an existing db to be able to attach it here. My issue is that I don't know what the proper syntax is when using DoCmd.BrowseTo acReport that is pulling data from a query containing an Expression. The code that is producing an error is tied to the first DropDown called...

Thank you for your reply. The concern I have with ignoring rows with null (not that I would know how to do that), is that other fields for that row may have fields that have changed that I may need to know about.

Hello, Attached is a db which shows the results of a simple Unmatched Query. I am confused by the results. I would expect the query to return no records at all as the two tables are identical with regards to their record data. It seems the query is picking up empty or null fields and treating...

Yes, I found out the hard way. I'm trying On Exit

Thank you. I think your solution will work for my purposes if I use it with 'On Change'

Sorry, I meant to say that I am using On Dirty, but once a single field is changed any subsequent fields that are changed does not trigger On Dirty any more. I need to re-set On Dirty or find a different way. Thanks

I am trying to generate an event each time the user changes a field on a single record. In other words, the user changes one field, then the event gets triggered, when the user moves to another field on that same record and changes that field another event would be generated. I can get the...

I am attempting to pass logic operators via TempVars to query to filter a list box. What is the proper syntax as "<>5" does not seem to pass to the query properly? Sample DB attached. Private Sub Frame0_AfterUpdate() Select Case Frame0.Value Case 1 TempVars.Add "tmpSelected", "<>5"...

Thank you for your note. I will keep this information as well to see if changing resolutions would work. Just to let you know though, I have not saved this DB while on another monitor for at least 2 months now. Thanks again

Thank you. I did not think I was going to get a solution and so, I rebuilt the query. I will keep this handy as it is not the first time this has happened to me.

Thanks for the suggestion. No luck

Thanks for the reply. I have closed all objects and forms as well as closed access itself. I have attempted to move, add other tables, resize those that I can see, re-save, no change.

Does anyone know how to fix what seems to me to be a bug in the query view? Using Access Office 365. The tables and links are partially hidden and can't be adjusted. Scroll bar is all the way up yet I don't see the top of the view box to be able to adjust the tables in the view.

Thank you again.