Recent content by min3010

Hi, Please help. I have an access form which allows the user to enter some information (time period and date) into textboxes. What is entered by the user is then fed into a query to produce a view when the user clicks on a run query button on the form. However, I would like to allow the user...

Thankyou so much DCrake, that worked a treat!

Hi, I have a procedure to help the user import a file from the c:\ directory into the database. The user basically has to select an option from a combobox and then click on a button to do the import. I anticipate that if they click the button and the expected file is not in the C:\ directory...

Thanks so much Premy, that worked a treat! I just needed to add ammend TestMethod(SQry,SFile) to Call TestMethod(SQry,SFile).

Please help, im new to this VBA stuff so am stuck. Im trying to export the data from a query to a textfile using Docmd.TransferText. The difficult part is rather than specify the query name and file name in the code, I wish to do the following: - Allow the user to enter the query name and file...

Dataroaming is a query not a table. Is the code expecting Dataroaming to be a table? I was under the impression that in the syntax you can specify a query or table.

Hi, I am attempting to write a VBA function that transfers data from a query in access to an excel spreadsheet. The code is as follows: 'Export data to excel Public Function dataExport() DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "dataroaming", "C:\Reece.xls", True MsgBox...

Im afraid this does not work, the table name and filename are required arguments! Thanks

Hi, I have a VBA function to transfer data from a query to a text file. The code is as follows: Public Function ExportUsage() DoCmd.TransferText acExportDelim, "Usage_Export_Spec", "usagequery2", "C:\Usage.txt", No MsgBox "Export Completed!" End Function However, I need to extend this as...

Hi, I have imported a text file into access and then done an update query to change some records that held a '?' character to 0. Then I changed the datatype of that field from Text to Integer (Double). The importing and query part have been added to a macro to automate this However, I have not...