Search results

just restore the program First, found this error message listed here. I am using Access 2000. Op Sys should be Windows XP, but I am not sure that matters. Anyway, got into the data, the backend, and that looked okay. So, I made a copy of everything (just in case), restored a copy of the...

sub-form order Select the form view of the sub-form in design mode. Now click on Data, third line down is Order By. Put your field in there and you should be all set.

breaking out address: zip, then state, leaving city Having just done this, I want to add to Doc Man's advice. Think about San Francisco. If you break at the first space, you will not get what you want. Instead, start with the other end and break out the zip code first. I did successive...

I think you are making this too complicated. I don't believe you need query C. Just sum your query B fields. For example: Sum([pendingreview]).

Use Datepart("m",[datefield]) to get month and Datepart("yyyy",[datefield]) for year. Sounds like you might want to create these fields as part of your query, rather than after the fact. HTH

form limits report Utmost: You seem to have posted the same question several different ways in this forum. So let me explain what I have done that I think will solve your problem, and I will try to keep it simple. First, I create a table called tblReport. I list on it the fields that all...

salary table I would suggest a table. One field is the numeric code that you want, the other is the salary range as a text field. Then, as you select the value you want, store the numeric value. Use the table as the source for the combo box. BTW: Would your 5th salary range be >$50,000?

Maybe I am making this too simple, but in your query do you show the join between the two tables? If not, then you will get what you are describing. Parent info, one side, 10 records. Child info, many side, 50 records. If you show the join in the query, then you should get 50 records...

Try this thread. It reviews both options, printing the form as is and creating a report based on the query of the form. HTH http://www.access-programmers.co.uk/forums/showthread.php?t=74062&highlight=print+form

grouping You want to group your items together, using a Select Query where you Total. Based on your sample data, it should be sorted by Award Number, by Mod, using these values: First value of Award Number First value of Award Date Last value of Completion Date Sum of Dollar Value Then, use...

Transfer Text I 'inherited' a program that has part of this. I have a macro that copies the tables one at a time using Transfer Text. I Export Fixed Width, using a Specification Name (file layout that you can create, save and reuse) for one table at a time to a named text file. I have never...

Well, my first message got lost. Here goes again. Sounds like a formatting problem. First guess is the table itself, second is in the template, or maybe in the program. Are all 3 users definitely using the same program and the same template?

Once in a while, I still get an ldb file active. It especially seems to happen after a problem -- PC hung-up, screen frozen, etc. Sometimes, all that you need to do is to go into and then out of the database. Also, once in a while, a backup utility stops (usually cause it wants a second...

compact a list I just had a private message regarding the compact/repair program. It is called Compact A List and it is from Peter's Software. I will add the link below. http://www.peterssoftware.com/cal.htm

Hopefully, you will see the network people headed out the door before you -- no backup since August indeed! I have a compress program that automatically copies the data first, then compresses. With that thought in mind, you might want to look to see if someone copied the data (or the data and...

Originally, this user was self-taught and had setup the database in Fox Pro to just track Fire Dept members (which included the Ambulance people). To give her credit, she did not do badly, even when she converted to Approach. Her biggest limitation is the same as what you said, one-dimensional...

USERS! GRUMBLE! GRUMBLE! :mad: Well, 2 weeks of work down the tube! I had the application set up (with the one-to-one relationships as outlined above, just corrected the primary key to be the same name of memberkey) far enough to show the main user the application with the separate forms...

Ken Higg -- still not quite what I was looking for. I have a start on something. The Doc Man -- Thank your for hanging in there with me. Yes, there is a bit more complexity involved, since some of our Fire Depts have Amb as part of their setup (which means a few more fields for that, but...

Time out! I am not trying to HIDE anything. I am also trying to normalize the data. That is why I visualize the data as I have broken it out. There are 4 people who will be looking at this data, but primarily ONE who will be maintaining it -- so not really able to control what they see. In...

OK, let me try it this way. The original idea from the EMS dept was to have separate databases for the Fire Dept and the Haz Mat team and the Ambulance Corp. So, if a person were in all three, then their last name, first name, street address, city, state, etc. would be listed 3 times and if it...