Search results

OK...to my surprise... apparently it was something in the form itself. I created a new form (actually just made a copy of it) and that resolved the issue. For the life of me I can't figure out why a corrupted form would only affect 2 users when they are all using the same db file. Anyway...

Thanks for the replies... As a test, I did place a version on the end-user's C-Drive. There was NO change. All users have the same version for Access on their desktops. Also, these are UNBOUND forms. No forms in the db are bound. Db has been working fine for all users for over...

Hello All; I have a weird situation for your review and thoughts on. I have a db (Office/Access 2013) that is used by 5 users. I have a VBA record write in a procedure under a Save button on a form that files data from the form into a table. It's a split db with both components on a server...

Hello All; Any thoughts on why a lock file becomes locked to the point that only someone with system admin level privileges needs to kill the file? I have a log-off function (hidden page with timer on startup) that is effective most days, but some days not so much, and still other days where...

Thanks everyone so much. The above code is working like a charm. You folks are the best !

Moke... I like the idea but I'm still hung up on runtime error of Missing ),], or Item in query expression. Here is what I'm using now: If Not IsNull(Me.cb_Manager) Then strWhere = "tbl_AOG_Errors_Master.Processor = '" & [Forms]![frm_ErrorEntry]![cb_SelectAnalyst] & "'" Else strWhere =...

It's not actually missing... that's the result of only one of the two parameters being entered. Users can search using either of the two fields (controls on the form), but not both. You can see in the "VBA SQL here" section in OP, that both are controls on the form. Also, I remind viewers...

Hello All... What am I missing here. The below VBA Sql works in the QBE grid but pops an error of Item Not Found in the Collection when executed by a button on the form. I have 2 combo boxes on a form, and the user can enter search text in either of the fields but not both. When I place a...

JDraw... thanks for the reply. Getting close I think. Your suggestion produced the following error: Run-time error 3075 Syntax error (missing operator) in query expression (((tbl_WorkOrderTickets_Converted.dDateTicketAssigned) Like 12/6/2016'*' AND...

Thank you for the response... The date fields in the table are in "General" data format. The textbox field on the form is also date format, but "Short Date". Not sure which "code" you are referring to. As indicated previously, ALL code behind the button functions properly, except of...

Sorry for the assumption... All code is behind a button on a form. Once the parameters of the form are selected by the user, the intent is to launch the query (VBA SQL) and return the results to an unbound form. The user has several options to chose from, with several text/combo boxes on...

Hello All; I have been struggling with this query. I have tried what seem to be a thousand different combinations, but no luck getting it to run error free. Can anyone see what I am doing wrong ? I either get missing operator errors, or type mismatch errors. dDateTicketAssigned is...

Sorry CJ if I wasn't clear. The term "blank", as I used the term, means, the user enters nothing in that field. tb1 and tb2 are unbound, and no calculations are being preformed on the data being entered. Thank you for your response.

Hello All... I have been struggling to solve an issue with a multi-condition IF statement. If anyone has any ideas, I would certainly appreciate hearing them. Here is the situation: MS Access 2010. Unbound form, unbound text and combo boxes. 4 controls: (me.tb1), (me.tb2), (me.cmb1) and...