Search results

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

Thanks for the ideas. I'll try them one at a time and see what happens. You can guess what the potential for mayhem is on this. I'll drop a note when things are fixed and let you all know what the problem was. M.

I've opened more than 10 of the db's in the exclusive mode and still have the same problem. The db's are in many different directorys on my LAN and also on my hard drive. None of them work properly. I'm freakin!!!!!!!!! Could my IT department have caused this somehow?

Somehow, every db on my PC and Lan now will not allow me to use the "New" option for tables or queries. Even when I enter in the "Exclusive" mode. What in the world can cause this? To make changes, I had to create a new db and import everything from the db I was making changes to. That worked...

The field I'm importing into is in 3rd party software. I have no way of changing the 50 character limit. It's 50 per/line max. I don't want to break any words. That's why I worded my question as I did. Thanks for the try. M

I have to import a field from Excell that contains more than 50 characters in the field. I need the line to stop at the last complete word prior to 50 characters and start the next record in that field automaticly and continue to fill and wrap at the last complete word prior to 50 characters...