Recent content by Misty

James Madison University Tutorials Hi Modest, I looked for a VBA/Access Tutorial on the JMU website and couldn't find one. Do you happen to have a link to it?

I just finished making the first of the reports that my boss wanted. I couldn't have done it without the help you've given me. I'm going to pick up the book you suggested tonight. I'll also take a look at the website you suggested. It sounds like just what I need. You have relieved me of about...

That looks exactly like what I needed. Unbelieveable! I looked at the code behind the OnClick event of the OK button and of course got lost real quick. I'm going to go to Barnes and Noble tonight and get an Access 2003 book that will help me learn VBA from the bottom up. Is there a particular...

The form was just something to put the message on. It's not a used form. The [firstdate] is the first time the pm was ever due. The software I'm linked to keeps that date. It's really the only thing I can find in the tables to use as a starting point for future dates. If the start date was...

I have what looks like a simple thing to do, but I've discovered that I sure don't know how to make it happen. The method that "Modest" showed me how to do wouldn't work because of a problem with the data I was using. Using the data in the attached db, I need to forcast future dates based on a...

I have what looks like a simple thing to do, but I've discovered that I sure don't know how to make it happen. I've attached a small db to explain the data I have and what I'm trying to do. If anyone can show me how to do this, I would greatly appriciate it. I'm down to just a few days before...

Thank you for this example. I'm going to try to adjust it to get the exact information I need. I do have one other question. If I wanted to show the results as a query that could be used as a step in a process, how would I make that happen?

You're a nice person. Did you see the little db I put in the samples? That's the way the data looks when I run the query, except there are many, many more [Jobplan]. They are going to put A2003 on my machine at work, so I'm going to go and get another book. The last one was $45. I'll bet this...

Having two Intervals that are the same but for different [Jobnum] is fine. The 12, 24 and 48 refer to how many weeks between working the respective [Planum]. The 24 includes all of the tasks in the 12, and the 48 includes all the tasks in the 12 and the 24. It’s a matter of which of the [Planum]...

I've put a small sample of my data in the sample db area. It's named: Planum.zip (31.2 KB)

This is a sample of the Forcast Database I'll remove this db in a day or two.

For each Jobnum, the counter will always be the same number for each record. Did you say a few minutes? Gawd!

I’m using MS Access 2000, SR-1. The Data I have to use is in a linked, SQL7 database that I can only read from. In my Access Database, I've created a query that pulls the following data from the SQL Database: Query [Forcast_1] contains four fields. [Jobnum] [Planum] [Interval] [Counter]...

Sub-reports. I keep forgetting to use them. Thanks guys. I'm a little brain dead anymore. M :o

I have a table that contains work order numbers and the dates that the work orders were written. I need to create a report that shows this information seperated by these groupings: 0-15 days old 16-30 days old 31-45 days old 45 days and older Can someone give me an idea as how to make a...