Recent content by Kylor

Thanks Doc Man I will try your suggestions and we'll see what works.

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

thanks Thank you so much! Everyone around here was telling me that I couldn't.

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

Crosstab exporting Excellent! Can you e-mail me the details/copy of the macro? Thanks Kglover@gbc.com

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

CrossTab Export You are not crazy. I am having the same problem. So, is the answer...don't export a crosstab or is there a fix or solution?

Got It!

full outer join Sounds good. I'll try it when I get back into the office. Thanks so much!

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.