Search results

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

I think you're going to have to write some VBA code if you want to accomplish this.

Have you done a compact/repair?

I would put two columns in your Word doc template. And then I would put a section break at the bottom of the first column so that text inserted on the left does not bump down text on the right.

Assuming your combo box has two columns, the first being the PK and hidden and the second being the name of whatever and visible, in the After Update event of your combo box, put something like: dim strCriteria as String strCriteria="[fieldnameID]= " & me.[comboboxname] DoCmd.OpenForm...

Make the Zip Code field a combo box with two hidden columns for city and state/province. Then you make the record source for the city field and the state/province field the appropriate columns from the Zip combo box. Make sure you put an after update even in the Zip field to requery the city and...