Recent content by RobMc

Hi I'm using Microsoft Query to get data from a MS Access database into MS Excel. It seems that whenever I pull data from a UNION QUERY or SELECT QUERY based on a UNION QUERY I get an error message: "Too few parameters...expected 8" Can anyone offer suggestions? Thanks

I wonder if anyone can help...I have a report with 2 linked objects: one is MS Word, the other MS Excel. When I send the report to MS Outlook as an attachment, the only way I can display the 2 objects is by using Snapshot format. Is there a way I can display them using either Word or Excel? I...

I don't know if it's the case here, but there may well be a Macro in your Personal.xls workbook....I've come across this a few times.

Thanks again, but the thing still counts 0. I've checked the table/field, which is formatted as short date, which I thought would be okay. Funnily enough, the value it's trying to count is 12/12/2005, so by pure chance UK or US format should have worked... Apologies for being a continuing pain...

Thanks for the right syntax. Interestingly, although this runs error-free, it returns 0 against the dcount. In the relevant table, there are 4 records with the selected date....any ideas? Thanks

I wonder if anyone can help...I'm using domain functions to get data for a pop-up detailing last record in a table & number of entries made that day...the relevant part of the code is: Dim dtLast As Date Dim intCount As Integer dtLast = DMax("[Date Received]", "tblLoad") intCount =...

Thanks Many thanks for trying to help. I've gone via the 'create a new one, delete the old' route!

Hopefully someone can help.... I'm trying to change the name of a column in a table using SQL. I've tried different combinations but always get "Syntax error in Alter Table statement" SQL I've tried alter table tblImport rename column F1 to [Date];* alter tblImport rename column F1 to...