Search results

I have some VBA code which exports the Query in Excel 5.0/95 format which I feel is causing problems when I later call a Excel macro to format the exported spreadsheet. The Excel macro has been recorded using Excel 2003 format and I feel this is the problem. How can I get Access to export in...

I have some VBA code that exports a query to Excel and then is trying to call and Excel macro in the Personal.xls file to format the spreadsheet. I open the spreadsheet fine but get a message saying it cannot find the macro. when check the opened personal.xls file in Excel not all of the...

I call a macro from Access which cannot be found due it appears that for some reason when Excel is opened by an external program the Personal.xls is not opened. If the spreadsheet is opened manually personal.xls is opened ok Any ideas thank you in advance

It appears that when excel is opened by an external program it does not open the personal.xls file. its fine when opened directly. this is why i am getting the Error 1004. does anybody know why.

Has anybody have any idea what is causing the above error the line of code is XlObj.Run "sgc" “sgc” is a macro which I have in my Excel Personal.xls workbook. I have noticed that when the code opens the spreadsheet Personal.xls is not there it is just empty but when you open the spreadsheet...

Is it possible to call a Excel macro from within Access? I export an Excel spreadsheet then manually run a Excel macro on the spreadsheet I was just wionering if it call could be done within Access thank you in advance regards Desmond

Thanks Pbaldy for the advise did create a new table which worked fine once again thank you. regards Desmond

I have a question to ask you concerning the switch command below I have listed the syntax which I have in a field in a query which works fine Expr1: Switch([PROGRAM_CODE]="PM000F2C","BT.com Project",[PROGRAM_CODE]="PM000AMU","Broadband Project",[PROGRAM_CODE]="PM000AND","CORE...

What I wanted to know is can you imbed the recipients email address in the code? Thanks you in advance for your help

I have been told you email reports from Access and also you use the windows task scheduler to start the application. So my questions is Can we tie them all together and get Access to startup automatically run in the background kick a macro which starts a report distribution function via email...

I have sorted the horizontal problem. I now need to know The code which will put borders round a range of cells

I am getting the error below when I am running the code listed below. It is a the point where it is formating an Excel spreadsheet. I have copied the recorded excel macro into the VB Sub and referenced the Excel object. and get Error 1004: Unable to set the horizontal aligment property of...

I have noticed that when I export a Query to Excel manually I have the option the Save formatting and the excel formatting resembles the formatting in Access. When the DoCmd.Transferspreadsheet method is used to export the query all formatting is lost. How can I get the method to export with...

Thanks Jal, problem fixed Also thanks very much KW99 for all your help much apprecated.

There is one search criteria Enter Parameter Value Forms!Level4!List2 Sql below ELECT Milestone_Overview.Level4, Milestone_Overview.Level5, Milestone_Overview.Parent_Project, Milestone_Overview.[Project code], Milestone_Overview.[Project title], Milestone_Overview.Description...

Thanks KW99 it works you have been very helpfull. One small problem when I click run query botton on the form it displays the Enter Paramter Value first I then click Ok and the select Query runs as expected. how do I stop the Enter Paramter Value being display and let just display the...

KW99 I have the A Run Query botton on the form linked to Select Query and have the following [Forms]![Form1]![List2] in the criteria box. should i cut paste your solution replacing with Form1 and List2 Thanks for your help

Thanks KW99 I am quite new to Access can you explain what you mean by 1). Put the query as a sub form in your parameter selection form How do you do the above thanks

Correct, Using combo boxes which determine the Search criteria. But my problem is, if I wish to leave one of the combo boxes without a value it does not return any rows, essentially I would like to have a value of "ALL" in the combo boxes or do something that has the same effect Hope this is...

Thanks for your reply, my main problem is that if a value is not set in one of the combo boxes all the data is reterned for that field. at the momment if you do not set a value in one of the combo boxes no rows are returned.