Search results

Hi, Thanks lagbolt, the Rowsource for the ComboBox SQL is as below SELECT DISTINCT Tbl_Areas.Area FROM Tbl_Areas ORDER BY Tbl_Areas.Area; And i've got the existing on click code, Private Sub Rpt_AllArea_Click() On Error GoTo Err_Rpt_AllArea_Click Dim stDocName As String...

Hi, I've built a database which produces several different reports, by using combo box's to specify certain requirements. These will now be published, but will need to be on seperate pdf's by one of the critera's in the combo box - "area". What's the best way to approach this? My initial...

Coincidentally that's exactly what I was after! any tips on how to convert it to excel files, i keep getting "could not find installable ISAM"? Cheers Tom

Cheers Rabie, That's a great help, I now have the following extra code running in Access which runs through and put's cell A1 in the 6th column in access. Here's the code; Sub InvoiceNumber() Range("F2:F2").Select ActiveCell.FormulaR1C1 = _...

Cheers David, I've carried on looking at this and started approaching it by adding a column in the excel file prior to the import. Is this bad practice? My vba knowledge also came a little unstuck as the excel macro commands, which i thought i could just copy and paste into the access VBA...

Hi, I've reached a little bit of a brick wall with this! In short, I've got a load of invoice's sitting in a directory which I need to import into Access. The Invoice contains 4 columns - 'Store', 'Location', 'Claimed' and 'Receieved'. The invoice number is in the title of the spreadsheet -...

Hi Vonnie, The treasuryreportpath was the link to which "Tbl_BankStatement" was in. I realised I must have switched acexport to acimport late last night while I was trying a few different things :confused: forgot to switch it back :rolleyes: I changed this back and your suggestion worked a...

Thanks for getting back to me Vonnie, I made the above amendment, unfortunatly this then throws up the error that it can't locate the query ''standard_feeder''? but it can locate it with a acQuery as object type. the error message is as follows; ''run time error '3011' The microsoft Jet...

Hi, I'm currently trying to transfer a query from on database (this contains the daily bank transactions so changes on a daily basis ), to a table within a seperate database so that I have a list of historical data. I'm currently using this code; DoCmd.TransferDatabase acExport, "Microsoft...