Recent content by cpinney1120

This seems so simple but I just cant figure out how to take inventory values and get the difference. I have an item table with basic info and an inventory table with Just item no, inventory date and qty. On report, I want to calculate the difference of the inventory. Not SUM and I just cant...

I thought we were to share the front end? Should I be making copies of the front end on the desktop of each pc? NOT a shortcut, but a copy? 3 of us have to remotely log on the the server....?

Ok, so I "split" the database and it is on a server in another state. Me and my college here in this state can access the db at the same time but when I tested adding someone from the other state and she can not get in unless we are out. After she is in, we can get in but not if we are in first...

Ok, so I "split" the database and it is on a server in another state. Me and my college here in this state can access the db at the same time but when I tested adding someone from the other state and she can not get in unless we are out. After she is in, we can get in but not if we are in first...

Thank you! I appreciate your response. In this case, the other users Access programs on the shared all the time but using this "ACCESS" database is new. Could that effect it?

Thank you! Will this allow multiple to access and add/view records simultaneously without locking up the system? Do I need to change permissions?

I need help on sharing databases. I have a database located on a server that I want several people to be able to be in at a time and can not remember how to arrange that. Currently, some people just can not get in while others can. Can anyone help me please?

Thanks For Your Reply But In this case, I dont want to relate it in a different table. I already have a ton of tables related in the db.

How do I look up several fields from a table and then dump them into one field in another. Please Help! I want item description and price to go into another table field "Comp1" :confused: NEVER MIND - I JUST FIGURED IT OUT !!!! THANKS ANYWAY!!!!

Yeah, thats what I originally thought but it is a text field and there is no error when I run the query, just an error when I try to run the form based on the query. Any ideas? I really appreciate your help!!!

Thanks to help from this site, I got me "Like" query to work but now while trying to generate a form on this data, I am getting the following error msg. It pulls up the data correctly, it just always comes up with this error: "You Can't Search The Field For The Specified Value". Also, my photo...

Thank you - That was it! I just forgot the "like" - been about 7 years since i did this...

Can anyone help me? I cant figure out how to get a form to run off a query that searchs by partial field (like anything with "gum" in it). I am using this in my query criteria but after the prompt, no records come up. Please help: "*"&[Enter Key Word]&"*"