Recent content by mph1

The following should give you a good idea. http://www.fontstuff.com/access/acctut12.htm HTH Maurie An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber Description - FAQ702-5106

You indicate I think the following should give you more insight on how to refer to a sub form. http://www.mvps.org/access/forms/frm0031.htm An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber Description - FAQ702-5106

If you are using Access 2000 or above, look at Condidional Formating. That will do what you want. Good Luck! An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber Description - FAQ702-5106

I think the following should help! http://www.mvps.org/access/forms/frm0016.htm Good Luck An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber Description - FAQ702-5106

It sounds like you are trying to group dates. In the design view of the report go to Sorting and Grouping. I think this may be of assistance. Since there are choices there, try various opitions. Even if this for some reason doesn't solve your problem, you will learn. Also, the field you have...

Thought -- Since, as you indicate, everything is the same on all computers, try creating a new database. Then import everything from the old database into the newly created one. Make sure you make a backup first. Hope this helps. An investment in knowledge always pays the best dividends. by...

The form you are trying to create, does it have a Control Source? Is the from you are trying to create based on a table or query? If it is a query, try runing the query by itslef. There isn't anything that I can think of that you could do to a table and not have the fields show up on a form...

Storing a calculated field is not a good idea. It goes against the rules of normalization. Based on the information given, it is not necessary since your result can alwayse be calculated on the fly either in a form or report. HTH An investment in knowledge always pays the best dividends. by...

When you print, it should be a report and NOT a form. To get the landscape orientation as a default for a report open the report in Desing View. Go To File then Page Set Up. Click on the tab Page and make the change to Landscape Orientation, then click OK. All page set ups must be made in the...

If the number you are trying to change has a Data Type in the table set to AutoNumber and acts as an ID number, then you won't be able to change the number to do what you are trying to accompolish. Look at the FAQ's to see what an autonumber' purpose is to be. If sequencial numbering is...

I am not sure if this will help in your specific situation, but look up the Nz function and what it's purpose is. Go to HELP and just type in nz. HTH An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber Description - FAQ702-5106

Not sure how not that long really is! Since you have users that want something different, you may just have to decide for them. One other thing you might try is making the font and point sizes smaller of all your objects thus trying to fit everything onto one page. Good Luck!! An investment in...

You indicate I am not exactly sure what you mean. Do you have one form that is long and broken into two parts or do you have 2 separate forms?? You may want to consider using a tabbed form. HTH An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber...

I am not sure what kind of trouble you had. Please more specific about the exact problem. Also, I would suggest that you have 2 buttons ADD, Print Current Record. In addition, are you implying that you may only want to print the current record but not save it??? An investment in knowledge...

I think the following should provide with what you want to accompolish. http://www.mvps.org/access/reports/rpt0002.htm HTH An investment in knowledge always pays the best dividends. by Benjamin Franklin Autonumber Description - FAQ702-5106