Search results for query: *

Hi, I need to produce a query that will only ouput the values that are not present in a table. The example is... I have a dropdown box which will be used to select 1 of 3 times (06:00, 15:00 and 23:00) - but I want it to only show times in the dropdown which are not contained in a record for...

Hi BillyRayPreachersSon, Thank you for your help - the information that you provided is perfect. The email from which the link came from has been confirmed as a Phishing/Walware attack. I have had to write all this in another thread becuase what ever I do I can not submit a reply to my...

Hi All, I have got the following Javascript which I have taken from a possible Phishing/SPAM webpage. Can anyone help me decypher what is contained in the script? <script language=JavaScript> function decrypt_p(x) {var...

Thanks for the advice - I might have a look then for some known issues with my monitor type (LG1715S 17" TFT). Cheers, Chris

Monitor loses input intermittently… I am having an issue with the graphic output on my machine - the problem is intermittent with no pattern to it occurring. Whilst the machine is booted up the monitor just goes blank with a message saying lost input. I have replaced the graphics card and...

Hi Skip, I have checked that var and it is a valid sheet name. And it is deffitly that line that is causing the error. This is that line that comes beofre that last snipit of code: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, lcQueryName, strFilePathNamE, True Cheers, Chris

I think that it is this line .Workbooks(strFilePathNamE).Worksheet(lcQueryName).Activate i have also had problems with line too... .coloums("A:H").Select Cheers, Chris

SKIP, I can't believe that i have only just found out about this excel function now!!! It works a treat and saves me coding lines and lines of script to do that same thing. Thanks again, Chris

Just thought that i would add the code that i have already which returns an error saying "subscript out of range". If anybody could tell me what is not quite right with this that would be great. Dim E As Excel.Application 'Open a new instance of Excel Set E = New Excel.Application...

Ok, just thought that you might have something. Cheers for the help, Chris

Do you have any links that talk about how to do this? Thanks for the answer, Chris

Hi, didn't think of that - but yes. Altought that does leave me with the problem of them placing this data in to a sheet in the workbook but not on the first row. It needs to be pasted in to A12.

Hi, I have trawled through the FAQ's and searched for similar posts but can't seem to get what i need. I am using: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, lcQueryName, strFilePathNamE, True ...to export my query data to an existing excel workbook. Then what i need to do...

Umm yeah - sorry i am very new to VBA. Cheers for your help. Didn't mean to bug you. Chris

Ok, So what is the difference between acOutputTable and acExport? Chris

Umm, not quite sure what you mean. But here is a stab - the query does have criteria (e.g. date range entered on a form). Is that what you mean? Chris

Hold on, i have sorted that last error out now by following my own train of thought. Is there a way of automatically installing the excel reference library via code - cause this database is going to use on many pc's, and going round them all would be a realy pain. Cheers, Chris

Cool, that has sorted out that error... but you guessed it i have another. At this point: DoCmd.OutputTo acOutputTable, lcQueryName, acSpreadsheetTypeExcel8, strReportName, True, "" This error is returned: Run-Time error (3709): The search key was not found in any record. The...

Hi PHV, Thanks for the very quick reply. I have copied your code and then when i ran the code i got an error... Compile Error: User-defined type not defined. At this bit of code... myWB As Excel.Workbook This is an error that i have seen while trying out code in other posts. Any...

Hi, I have read a lot posts talking about this subject but i just can't get some of the replies to work. So i have decided to post my own question... I want to export the contents of a query to a new excel file and then to run an excel macro (that formats the data - and sub totals) at the...