Search results

We have a database that was being used by two different people to edit the same record at the same time. They both got error messages and now there is one record on the table that is now filled with ######. The table will no longer allow any queries to be ran against it. We figured that that...

We have a database that has been working without incident for about five years. Two people, without knowing, went in to the db to try to update the same record. Now the form is no longer working and #NAME? appears in all of the controls. What happened? What does this mean? We tried repairing...

I am creating a weight loss tracking database. What I need is to create a query that shows the differences in the various areas: weight, body fat & muscle mass from the first weigh in to the most recent weigh in. There are only two tables: one that holds the participants' names and one that...

Does anyone remember what is the keying command to rerun a query? I have seveal parameters to run but can't remember how to prompt for the next parameter. Thanks

I am working with a database that is a MDB file but has the "New" button grayed out in every window. Of course the person who created this is no longer around. Is there a way to get around this? How did he do this? I thought that only MDE files did this. Thanks

I have two tables of information on employees that are not related because they come from two different sources. I need to find which employees are not on both tables. I will need to also show which ones are on both tables. Thanks.

I have a split database that is already in use by several users. Can I password protect just the backend without affecting the users?

How is it possible to use a form to create a duplicate record (with the exception of the PK)? The example here is that the sales group wants to be able to quickly create a new order by copying a prior order.

I am creating a directory. I would like the users to be able to select a category from a drop down list on a form(categories pulled from a field on the table), select the category, and have Access provide a report of the findings of the parameter query (address, phone ect).