Search results

How many reviews will you have? If there are just 3, as in your example, or a set number, you can make your column heading in the query, in the Properties section.

Hi Jon! I hope your new gym is doing well. I imagine you're pretty busy. I would copy the 2 tables that hold the weight exercises performed and the sets/weight/reps and paste them as blank tables, renaming them for Cardio exercises and Cardio data. I probably would not rework the...

Do you have anything going on, in design view of the report, on the Grouping? Is it telling the report to order itself different from the report?

If you want the Workout form to be sorted by member, have that done in the underlying query by telling the member field to order either ascending or descending. You CAN order by in the form itself, by clicking on the field and picking the sort by option you want from the toolbar. I would rather...

I've never tried what you need, as far as showing a zero when there is a null, but this has been discussed here before. Search on showing zero for null. It looks like you will HAVE to go with the dynamic report in the Solutions app. It is not easy to understand, but it WILL work for your...

I would think so. The main w/o table, right now, only has the PK (autonumber), date of workout, and details. Add in the gym member from your Membership table, as an FK. Add that to the main w/o form's underling query. In the main w/o form, add a combo box, and makes its ROW source a query based...

Just a suggestion, but it might make it easier if you reverse the way you display the data. Especially if you have a set group of issues that are counted. Then each row represents a day, and the columns are issues. Of course, your business rules may not allow for the report being displayed that...

Thanks, Ken. This was quite useful!

I'm posting this in the Sample Database Section, so that anyone that wants to use/modify this for their own purposes can. Note that on open, the main page has 3 labels that act like web page links. These are labels that I've coded to act like command buttons, and to look like Internet links...

I've seen a few of these posted on other boards, but not a list THAT long. I had tears rolling, I was laughing so hard. Thanks for the link :D .

I have set up my own application for exercising, and pretty much agree with Pat. I set up with a main form for the exercise event-subform for exercises performed-subform for sets and repetitions. I will clean it up one day this week and post it here.

People here tend to get aggravated when they give you that help and you ignore it and go about the job the wrong way. Two posters have helped you by advising you to use a query for the calculation instead of storing the calculation in a table field. There are REAMS of posts in these forums on...

Do you have them BOTH open at the same time (excel file and linked table/form)? If so, you will run into that problem. But, you should be able to add a new record in Excel, close the file, and then open the Access table or form and see the new record. I used to use a linked Excel file quite...

Uhhh, try Date()+1 EXACTLY as typed. I just tried it in a new query and it worked like a charm.

It sounds like you are using an Access table as an Excel spreadsheet, which is no good. That's about all I can make out of your post. Please give more information on your database and what you need to get more help.

Glad it worked and glad to help. Thanks for posting back that you got your problem worked out.

Try [Forms]![yourformname]![fieldname] putting it in the criteria section for the department field you are querying off of, AND in the Parameters property area (right-click in the design view of the query and choose "Parameter" and then type it in EXACTLY as you have in the criteria for the...

There is still no reason to start a new database full of blank tables. It sounds like you are entering the leave dates, so as long as that captures the year in the date, it should ALL be in one database. If you only want forms to "see" current year, make the underlying query for the form (you...

Are you suggesting that you will make a separate database for each year??? I hope not, because there is no need to with relational databases like Access, and you would be headed down the wrong path. You can use queries on your table to pull data by year.

Kraj, from what I've seen with friends who have been nailed with a debilitating injury and can no longer work, it takes 2-3 shots at the application process before one is accepted, nowadays. And this is for persons, like your SIL, who are OBVIOUSLY disabled and no longer capable of working to...