Search results

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...

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...

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...

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...