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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mikelt

  1. mikelt

    Can't change Page Setup

    Running a Access 2000 application under windows 2000 I am having problems printing address labels to a dot matrix printer, Epson LQ-300+. In design view of the label the page setup is set to; Margins Top margin 0.12mm Bottom Margin 0mm Page Portrait Size: fanfold 210 X 305 mm Source: Tractor...
  2. mikelt

    OOPS!! I didn't mean to click Close Button

    If a user clicks the Close Button of a form you can put code into the On Close event to check if specific data fields have been entered but how do you then stop the form from closing and take the user back to the partially completed form? Any help would be appreciated. Thanks mikelt
  3. mikelt

    Automation of Outlook Express with Access 97

    Can anybody assist me in writing the VBA code so that from a command button I can transfer a csv file of data as an attachment to an email to a specific email address. On clicking on the command button I create a csv file using transfertext and then want to put the operator into Outlook Express...
  4. mikelt

    Selecting a table record in datasheet view

    Many Thanks for your help.
  5. mikelt

    Formatting datasheets

    Have you tried setting the properties of indvidual fields via the text boxes in a form design view?
  6. mikelt

    Selecting a table record in datasheet view

    Dear Jim Many thanks for your assistance which works if the Keyboard Option 'Behaviour Entering a Field' is set to Select Entire Field. Do you know of any way of changing this setting for different forms or even text boxes within a single form? Many thanks in anticipation.
  7. mikelt

    to move tab form one subform to another

    You will need to write the procedure in the Keydown event of the last, or only, text box of each subform.
  8. mikelt

    to move tab form one subform to another

    You can move from one subform to another by testing the key that was pressed in the KeyDown event procedure.eg. If KeyCode = 9 then Forms![MainForm]![Subform].setfocus Endif Alternatively, you can program a function key to sendkeys Ctrl-Tab to move between subforms.
  9. mikelt

    Database Corruption

    I have a Program .mdb and a data .mdb with the tables linked from the program .mdb to the data .mdb. The Access 97 system is an multi-user Order processing application and is running on Windows NT4 Server, service pack 6, with 4 workstations. Every day, about 3 or 4 times the data .mdb has to...
  10. mikelt

    Selecting a table record in datasheet view

    Does anybody know of how a record can be selected from a datasheet view of a table using keystrokes. The only way in which an operator can select a specific record is by clicking on the record selector using the mouse. Any suggestions would be appreciated.
  11. mikelt

    Multiple Choice selection boxes

    Thank you Kathryn, I understand what you are getting at but how do you delete an item in the left list box and add the item to the right list box?<br><br>The scenario is a order item line product code where the customer can select say any 3 items from a list of 10 items. So in an order entry...
  12. mikelt

    Multiple Choice selection boxes

    When you first go into the Simply Query Wizard you are presented with a screen showing all the available fields in a list box&nbsp;&nbsp;(left hand side) and an empty list box ( right hand side) ready to receive the selected fields.<br><br>Buttons in between the to list boxes provide the...
  13. mikelt

    TEXT BOX Text - Insert/Overwrite mode

    When a text or memo box receives focus, how do you PREVENT all the text in the text or memo box from being selected such that when you type a single character&nbsp;&nbsp;the whole text in the text or memo box gets replaced with the single character just typed.<br><br>What I would like to be in...
  14. mikelt

    HOW TO STOP ACCESS 97 LOCKING UP AFTER REPORTING AN ERROR

    When Access 97 reports an error in the system eg. 'Invalid Use of Null'&nbsp;&nbsp;and then asks whether you want to Debug, Ignore or End.&nbsp;&nbsp;Going to Debug just locks Access and the only solution is to close down Access or End Task.&nbsp;&nbsp;Has anybody got a solution?<br><br>My...
See more

Part and Inventory Search

Back
Top