Search results

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

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.

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

I was wondering if anyone knows how I can programmically have GroupWise login to a general account name that I have setup. I have a database that sends an email out to certain people. What I would like it to do is before sending out the email, have groupwise login to that account and then...

I'm looking at added results queried from a table to textboxes. The query would return multiple reults and I want to put each result to s text box. Example: I have a maximum of 7 text boxes. I know in the table it should return 3 results but what function should I be using to place these 3 in...