Search results

I didn't think you could have multiple primary keys in one table (thus the term "primary key). You CAN have multiple fields making up the primary key. The FK is used in a related table to make the link between the "One" table and the "Many" table, with the PK and FK being the linking fields.

I'd start with the underlying query that your form is based on (if you're basing your forms straight from the table, you'll be better off making a query on the table and then basing your form off the query). The query allows you to limit the records returned, which show up in the form. How you...

I had a similar situation. I got around it by putting code in the Open Report button to hide the pop-up form when the report opens. Then, when I close the report, the On Close code of the report checks to see if the form Is Loaded, and unhides it if it is. Works great. Is Loaded is not a...

Wayne, thanks for the offer, but no worries for us. Spectrolab, how are you making out with this issue?

Spectrolab, one thing I ran into with this is that this code saw the VERY LAST ELEMENT REPORTED in the text file like the end of the file, so it was never included with the rest of the data. I didn't know what was going on with the code to make it act that way, so I changed the SuperQ text...

Mickster, here it is in 97. I converted it with Database Tools in Access 2002. It warned me that there are some references that will have to be checked on in the Modules section, to make sure they are all accounted for , for the code this app is running. I don't have 97 version of Access, so...

g'man, I had a similar situation to deal with not too long ago, but the text file was not nearly as big as yours. Here is the post: http://www.access-programmers.co.uk/forums/showthread.php?t=83493 Wayne Ryan gave me a great solution for tackling this, and I just adapted it to what I had to...

The short answer is yes. Do a search on the site on custom autonumber or on seed. You can seed the autonumber field to get it to a certain number, if you need. Pat Hartman has posted the solution here, and you'll find her method when you do the search.

You could run an update query on the table field and make them ALL the exact same. The find a way to enforce typing "orange" in the same way, every time from now on (combo box with slection limited to the list).

There are some options. On some of my stuff, I have switched from command buttons to labels with mouse-over and on-click effects that look like internet browser links. I also have an app I did for our Safety department that has a form on it that acts as a facility map with clickable sections of...

I'm not sure you can, Jon. You are likely going to have to run one for weights and a separate, but nearly identical, one for cardio. The table for weightlifting data and the table for cardio data set into the same query won't return anything, from what I could work out. They have to be kept...

You lost me there, Jon. You had the query trying to run weights AND cardio, and now it is minus the weights, so isn't cardio still in there???

Jon, From your last post in the Samples forum, you asked why the workout query didn't work. First, don't name queries with the prefix "tbl". You might notice I use a fixed naming convention in my database objects. I didn't always do this, but have been "converted" by this site and a couple of...

Jon, let's take this out of this thread. I should have already done so. This thread is really only meant to post people's sample apps, not go into lengthy discussion on them. I'll post elsewhere. Apologies to the mods. ;)

Jon, sounds like you're a bit far to go get in a workout for me :D . The reason the member field didn't work was because something was screwy with the query. I changed the query, and left out the Member table; you don't nned it here. I also changed your Member table. You really need the member...

Way to butter up the nice people here who give their time and expertise for FREE.

Jon, lucky for you, today at work was a bit slow. Gives me a little time to practice Access skills :D . I've attached an example of what I was thinking about, to incorporate cardio into the form. I put another subform on the workout form that can be used for cardio work. I renamed a table and...

I've not done it, because I only deal with a few workstations. Others here have some good solutions for this. Do a search on this topic and you'll find some good stuff.

bambam, look into conditional formating. It's available in reports for Access versions greater than '97. It should get you what you want.

Jon, Okay, you want a projected workout plan for 2 weeks for a gym member, detailing a setup of exercises, sets, reps, and weight. Hmmm, that's a bit complicated. Say you scheduled a person to do squats/presses/calf raises/leg raises in workout A and deadlifts/rows/chins/crunches in workout B...