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!

  • Congratulations dencom 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: mpsDA
  • Content: Threads
  • Order by date
  1. mpsDA

    Prevent adding a new page

    I want to set a simple page just to Stop user to add a new page, I just want the one sheet. Main reason is I have a table with two colums. when the user begins entry and reaches the end of the table colum it goes onto the next page which I don't want. How is this done?
  2. mpsDA

    Hyperlinks

    I have created Hyper links which opens PDF files. It opens the files from the Laptop where the databse sits and the folders which contain the PDf files. When moving the database to another Laptop, the links do not work. It is copied over to the same location as it would sit in the Primary...
  3. mpsDA

    Excel - Date Warrings for User

    Is there a formula where a User is prompted with a some form of warring as to when a the due date arrives. I am trying to get the Cell to change its colour When there is just 3 months left to when the due date arrives. And once it get a new date inputted it reverts back to its original colour...
  4. mpsDA

    Locking a Field After Input

    Can a Field be locked after a user enters data into the field, to prevent anyone making amendments at a later stage.
  5. mpsDA

    Auto Date of Input

    Is there a way to have a Field setup to Automaticaly have the Date of Inputting appear into the field of a record.
  6. mpsDA

    Incremental count

    How do you create a field, which will automatically assign a number to the record? I wish to have a number which will also include the year for example “1/2006”. Also once the year has ended it automatically changes the year and starts from the number 1 again e.g. 1/2007 and so on.
  7. mpsDA

    Choosing more than 1 option in a Option group

    How do you go about selecting more than 1 option in a Option Group and places the result of selected items into the correct Field.
  8. mpsDA

    How To Reset Autonumber to "1"

    How do you reset the Autonumber field so it starts from number 1 again. Also just when you delete a record it tends ignore the record number completely and jump to the next number rather than using the number just deleted. Is there a way around this?
  9. mpsDA

    Find/Replace Existing Data in a Table

    I would like to know if there is away to Find and Replace data within a Table i.e. I would like to Replace a field which is the same for all entries in the table. For example All Users on the Database Belong to Area 12, but now has changed to Area 19. Is there a SQL code which can replace...
  10. mpsDA

    OLE SERVER

    Need help!! I have an error appearing when i try to insert a picture into a record. It was working previously and now its has an error. the steps im taking are -Insert Object. -Select Choose from file. -Select the location of the Picture. -Click OK. -Following error displayed. "THE...
  11. mpsDA

    Tools MENU disapeared

    I have disabled the Tools Menu hoe do you get it back??
  12. mpsDA

    How to Set a Maximum amount of Records on a Form

    How do you set a Maximum number of Records for a form to be entered. i.e i do not want the user entering more than 20 records for this form permanently. also if the user tries to enter more than 20 records an error message should appear explaing why and what to do. Can this be done??
  13. mpsDA

    Prevent users from adding more Records

    I would like to set a form so it will only allow you to enter 20 records. Can some1 help??
  14. mpsDA

    Set a Maximum figure of records to be entered.

    How can you set a maximum number of records to be entered. i just want to enter only 20 Records.
  15. mpsDA

    Toggle box problems

    I have places two toggle boxes on a form. When you select one of them you cannot alter your choice unless you exit the form and return to it. how do you reslove this??
  16. mpsDA

    Enable and Diable Areas on a Form depending on choice

    I've seen this example within Microsoft access HELP!. I want to Create a option on my form for example YES or NO. If the User selects YES, the area is greyed out. If the user Selects NO, the area is enabled for the user to use or enter data. How can this be done please.
  17. mpsDA

    Inserting a picture into a form

    Is there a simpler way to insert a picture into a form by a user. Other than right clicking th area and going through inserting an object and so fourth.
  18. mpsDA

    Enable toggle boxes depending on input

    Im creating a result sheet for exams. I would like a toggle with PASS on it, to be automatically selected if the pass mark is 90% or above and FAIL if below 90%

Part and Inventory Search

Back
Top