Search results for query: *

Thanks for the help, all working fine now. Both have a star for your help with this problem, what would we do without the internet and the help people give? Probably be sat scratching our heads and buying mountains of books until a brainwave or a book showing the exact problem turned up

I have used the following code to get a pick box to pop up when a button on a main is pressed, the user selects the file and this is used as the import into the table. This all works fine, but how do I get the pick box to start in a particular directory, rather than the root and having to...

Step two worked fine. For step one, I followed the links but can't seem to get the code samples to work, they are coming with all sorts of erors on undefined calls, etc. I just want to open a box, find and point ot a file and get it's name, then the transfer command can do the rest. I will...

Cheers, I will give them both a go and see if it works. Thanks for the help mate

I have 2 questions which I am stuck on, can anyone help. I am using Access 2000 1. I am using the "DoCmd.TransferText acImportFixed" to import a fixed length text file. The file imports correctly, but the name of the file changes all the time, so how do I open a search box to select the file...

I use a MAC and PC at work with Freehand MX. The question is a stupid one, but I need to know for a particular reason. If I create a Freehand document at work and then either burn to CD or email it to my home, carry on working on that document at home and then email or burn back to another CD...

These commands depend on the font availability in the printer and the emulation of PCL, but should help you a little in working out what to do to get what you want. Hope these commands help. e$=chr$(27$) ' <esc> 'Letter Gothic e$;"(8U";e$;"s0p???h0s0b4102T"; ' ??? is pitch size ' Landscape...

Sorry Tom ... lol, I was just showing the syntax of the command, not stealing your thunder

This line allows you to set the width and height of a font, just change the Font name and width/height values to what you require FONT NAME W H /Helvetica-Bold findfont [7 0 0 6.2 0 0] makefont setfont ^ ^

Thanks. I got it working with the following <esc>&a#G # = 0 Select next face # = 1 Select front face # = 2 Select rear face Send the front side command, then data to print on the front Send the rear side command, then data to print on the rear Then form feed and it all works. Cheers

Thanks PHV, got it working, now just got to requery for updating form. Have a star m8e

Hi, I don't know if what I am trying to achieve is possible, but any help would be appreciated I have a query (based on three tables) and it is displayed on a form. On the form i have setup an option group with 5 option buttons. I want to have the query select only the records which match the...

Will try these suggestions and see if they work, Duplex page Selection looks interesting. Cheers for the help. Will let you know if I sort the problem with these suggestions.

What I am after is I set the mode to duplex laydown my text for side 1 1. send a page feed laydown text for side 2 send a second page feed or 2. laydown text for side 2 send first page feed only Am I missing a command, as I either get two pages printed with the side 1 on one sheet...

Sorry, this is not clear, I get page one ejected and then page two ejected, in affect two pages not one page with side 1 and side 2 on one sheet. I have to feed the sheet through twice using this methed to get a proper duplex page

Hi, I am quite experienced in PCL programming though I have come up against a problem which is probably easy to resolve once you know what you're looking for. I have just bought a HP9000 Duplex printer and can print through Windows in duplex, but printing through the ESC codes, I cant get the...

setup a new macro called AUTOEXEC and add the following two lines to the macro fields RUNCOMMAND (In command box select WINDOWHIDE) OPENFORM (Name of your first form to open) This runs on the database opening and hides the switchboard and opens your first form to view

Select the form and change the option 'Allow Additions' to NO. This should stop the addition of new records to the continuous form and stop your box appearing. Hope it helps

Have you tried setting the 'required' option in the table definition to 'YES' This will not allow you to leave that that field blank when entering data. You can set the validation rule and the data type of the field to ensure that the correct details are entered. Open table in design view...

Open the table in design and change the NO value to Yes (No Duplicates). This will only allow unique numbers in the table, so no duplicates. This is done automatically and does not need any user intervention. Access is a relational database so a deleted number cannot be used again to retain...