Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: mph1
  • Order by date
  1. mph1

    Colored tab controls

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

    Keeping sub form locked until data entered on main form

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

    Change field color depending on value

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

    Disable Page Up and Down Key

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

    Make header display horizontal not vertical?

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

    Unable to open Microsoft Access database

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

    Data in forms not showing up

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

    Calculate Fields retained in table?

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

    DEFAULT PAGE ORIENTATION

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

    Record number

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

    Form won't open to "Read Only"

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

    DoCmd.GoToPage problem

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

    DoCmd.GoToPage problem

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

    Print Current Record on Form Before Add

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

    Print Current Record on Form Before Add

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

    how to transfer record from one table to another?

    Access, like most anything else in life, there is usually more then one way to accompolish a task. The result can be the same, however, some ways may take longer, ie, steps required that aren't necessary. As Tim pointed out, what you want to do can be done the way in which you want, but we don't...
  17. mph1

    how to transfer record from one table to another?

    Please excuse me for butting in! I think Tim is correct. Taking into account your last comment "One is that the table, in the long run, will become very large and unweildy"You shouldn't be to concerned with the number of records in a table, rather the size of the database itsef. It the database...
  18. mph1

    Scroll disable

    This question has been asked many times and the solution is not the easiest. Check out the following from Microsoft: http://support.microsoft.com/default.aspx?scid=kb;en-us;278379 This refers to Access 2000. It is something that can obviously be a major problem and am not sure why MS didn't...
  19. mph1

    Input mask for phone # with extension

    Suggestion - since the phone number & extension are merely a note and evidently won't be used for any type of sorting, why not just use a memo field instead. Or you could just create a new field named Extention. By doing this, you won't be using much space in the database. Keep in mind, all...
  20. mph1

    Macro to assign ID Numbers

    Instead of using a macro, try the following. 1. Table - create a feild and name it Invoice. a. It's Data Type is Number. b. Field Properties of the field Invoice Field Size - Long Integer Required - Yes 2. Form - create a bound text box from the field Invoice. In the...

Part and Inventory Search

Back
Top