Recent content by jsjaedon

bah, just found it in access bible. I gotta build it on a separate row in the QBE Pane. :p

hello everyone! hope someone can help me out. i have a query that does a search for a string in 1 field right now in the table. it works great, but then i found out that the string may also appear in another field. for example, my query looks for "abc" in Field 1. then i found out i also...

Hi, I've run into a big problem recently. Whenever users run a specific query they receive an error that says, ACCESS has encountered error and will be shut down. the exact error message is shown below: Microsoft Access has encountered a problem and needs to close. We are sorry for the...

Hi guys, i got a question on this as well. when setting user permissions and access rights, whatnot, do i do that in the front end or backend? thanks jerry

Hi guys, I have an Access database set up as a front-end and back-end. My problem is with multiple users trying to do edits to different records in this database at the same time. It's an inventory database, so items are being moved and quantities changed frequently. my form is set up...

hey thanks a lot doc man! i set it to edit record locking and the slowdowns disappeared! much thanks. Now im getting a new problem. every so often my users complain about not being able to edit. this message shows up on their screen. "could not update, currently locked" but the weird thing...

Hi everyone, This is my first post, hopefully you guys can help me out. I have set up an access database for my dept. stockroom. The stockroom previously was just 1 excel spreadsheet that had the shared setting enabled so multiple people could edit it and such. This became extremely...