Search results for query: *

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

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

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

Many Thanks for your help.

Have you tried setting the properties of indvidual fields via the text boxes in a form design 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.

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

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.

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

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.

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

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

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

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