Search results

Ok.. just found out it was in the Query Properties. Thanks

Is there a way to only show the last 30 records of a query? I was looking into throwing the data into a chart and only want to show the last/top 30 records.

Hi There, I'm having difficulty exporting a query to a CSV file and retaining the numbers after the decimal points. DoCmd.TransferText(acExportDelim, , "qry_ExportToCSV, OFFTRN.csv", False) Well it's more like it does'nt retain the 3rd number after the decimal point. Eg. 1258.016 ->...

I have this in a module annd I keep getting a Type mismatch error on "set db = CurrentDB" Would anyone know why? Sub GetAllUM() Dim db As DAO.Database Dim rs As DAO.Recordset set db = CurrentDB Set rs = CurrentDb.OpenRecordset(strsql) . . . end sub

I have it selected as spool print. What do you have under print processor? I have "winprint" ~> "RAW" Under Printing Defaults I have the paer source as "Automatic" I'll try some other settings tomorrow as I do not have the printer with me now. Thanks for all your help.. I'll try tomorrow and...

The printer is hooked up directly to my notebook.

What kind of printer do you have? Where did you insert the page break in the report?

I'm using windows XP.. and it does go to alarm when it's out of paper. So when you print a report to your dot matrix printer. Does it automatically set the form to the tear position once it finishes printing?

Printing from Word, Access, Excel, Notepad... it all seems to act the same way. I'm printing a Packing slip with mutilple line items on to the form. Once it finishes the first page. It does not go to TOF to print onto the second page. Rather, it continues to print on the bottom of the first...

Tried this and still no go.. must be a setting on the printer. The printer seems to not want to set the form to the TEAR position after it finishes printing. Does not recognize where the end of the paper is either. :(

I looked at that but it does not seem to work for me. The data has to align properly in the form fed carbon paper.

It's probably in Graphics mode.. In the driver settings, it's set to print on letter size paper. The print jobs are more like order forms. But I'm trying to print multiple orders at once and when the next order comes up.. it does not do a form feed to the next form but continues to print the...

It's a Oki Microline 590 (24 Pin). How can I tell which mode it's in?

I'm using the the driver that came with windows. Added the page break control.. but it's still not sending the form back to the top

Is there a way to send a form feed command to a dot matrix printer? I have a report needs to be printed to a dot matrix printer (Carbon Copies) but after the first page, it does not resert to the top of the page for the next print.

These tables are not created yet so how will I linked these tables? What I do know is that when month end approaches. a new table is create with a prefix "ITM" followed by the month number. eg. ITM01 for January. I'm looking for a way to have Access look for a say table 'ITM03'. If it does...

I already have an ODBC dirver established... It's just that every month, there's a new table and I need the new table's info. The only possible way for me to link/ import the new table is to manually do it.

Does anyone know how to link tables automatically/VBA? I'm trying to import files from our DB2 database in which one file is created monthly and instead of manually importing / linking the files manually, I'm looking to have access link to the new file automatically. The file names are...

Does anyone know what it means when your linked table manager shows an "~>" followed by a "?".

Can you repost please.. seems like all the links are gone. Thanks