Recent content by theprez

You could also display a polite screen that comes up that says. Please wait while your (Query, Addition or whatever you are doing) is processing. Have the screen pop up. Use the timer Event to wait for however long you want, placing the Docmd Close form in this event. Make this "Polite...

Just wanted to make a note here. I had the same problem and this DID work. Even though, I'm using Access 2003, the problem was resolved. It's funny though, I was able to export to a spreadsheet, but was unable to import from a spreadsheet until I registered msexcl35.dll. I also registered...

Don't know if this helps. I got this error when I was trying to create an MDE version of the database to deploy. I have a procedure written to link my external tables. So I relinked the tables. I also have a protection password to view the code. I eliminated this. I also ran a compact and...

Do a search for normalization on this forum. There are great references/comments about it. In your case anything that is unique to a record can/should be in the same table (i.e. gender, name, etc...). The problem was you have so many fields you may want to break it up. If however you find...

Also, on the property form go to the Data tab and change the Allow Additions property to "No". This will prevent the new records feature on the menu bar.

What you are talking about is the essence of relational databases. It is preferable to have separate tables, each table containing related fields. So if I had a basic contact data that has ID Name Address ... 100 J. Lowe 22 Elm 123 R. Redd 33 Oak In relational terms you really...

I ususally don't have good luck exporting reports as text. My suggestion is to export as a snapshot. This retains formatting.

Two other things to look for. Maybe someone mistakenly changed the name of the person you are looking for. The other, and this is probably unlikely since you said this is a simple database, but if you built relationships between the tables and enforced referential integrity with...

Not sure if you can do this with a simple query. Queries usually refer to a particular row and does not refer to previous or next row. You may need to do this with code and build a Table with the results. The results will probably have atleast three fields, the 2 dates and the difference.

Just a thought, but would a Case Select statement work?

Just a thought, but your class attended should have a two keys. StudentID and ClassID. And now that I think about it, it probably needs 4 keys, just in case a student takes the same class more than once (i.e. they get an incomplete). So make the following fields Key fields in your class...

Listen to Bob. Before I could even get to your + problem, I could not get around your normalization problem. You only need one Drink table with a field, preferable a drop down list box or combo box that list the type of drink, Vodka, Rum, etc.. I don't thing the issue with the Plus is an...

Bodisathva was on point here. On importing, Access uses the first couple of records to determine the data type of the remainder rows. I don't know if this is an option, but I often include a dummy record at the top that forces the format. For the field in question, you could insert a dummy...

It depends on how the data is set up in the tables. If you have tables that have relationships built, the tables can be automatically deleted/updated using data integrity.

I decided to go with a suggestion from WindSailor. I documented the process very carefully for users performing the install. I instructed to use the Custom option, instead of the Typical setup. In custom, there is an option to select the destination folder. Here is where I instructed the...