Recent content by Starman

I am trying to figure out some productivity stuff and I am stuck. I have developed an application for our security department to keep track of the various tasks they do. One of those things is standing by with combative/violent patients. Sometimes this lasts for fifteen minutes, other times it...

You are thinking like a spreadsheet when you need to be thinking like a database. You don't want the spouses to be on the same record. You want each person to have their own record and then you can use their key to link them.

I am trying to export data to Word and convert it into tables. Using code from an example by Pat Hartman, I put the following together. This works great except I would like each individual record to be its own table instead of one giant table, but I am stuck on exactly how to get that. Can...

Try holding down Shift when you open your db. It's worked for me before when I had a corrupt db.

Ack, a simulpost. Good to see you found it, though.

Assuming you are using 2k3 (though it should be about the same for other versions), it is Tools...Database Utilities...Compact and Repair Database.

Have you done a Compact/Repair?

Did you try setting the Unique Values property of your query to Yes?

Can you post the query you are trying to run?

mindjob, you are going to hear a loud chorus of voices (including mine) telling you to never, ever, ever use table lookups. You have been warned.

Not one good source in particular, no. Every time I had something I couldn't figure out, I just googled until I found the answer.

Have you tried a main form with a couple of subforms?

It sounds like you need to fix your columns. In the properties box of the combo box, make sure you set the Column Count property to the number of columns in your combo box. Then make sure your column widths are set to however wide you need them.

Try Between DateAdd("d",-45,Date()) And Date())

If the records are deleted in one table, why are they still linked in another table? There's no way of "recreating" deleted autonumbers. If you absolutely had to (and I don't know why you would), you would have to create a new table and copy your records into it. It sounds to me like you have...