Recent content by grahamsyuk

hi Sam, how did you do the check for the excel file being present in the directory? if not i want to create the file regards, G

Hi Guys, thanks very very much for your support. I will be getting stuck into this again later today. thanks again, G

OutputTo hi i have no idea, im getting out of my depth here :) If only if it was so simple as to use the following code to export queries tospecific worksheets within an excel file :( DoCmd.OutputTo acOutputQuery, "Query", "MicrosoftExcel(*.xls)", "C:\test.xls", True, "" Thanks for your...

outputTO Hi Again, thanks for your endeavours. What i did find was that the following code gives my desired effect but not completely: DoCmd.OutputTo acOutputQuery, "Query", "MicrosoftExcel(*.xls)", "C:\test.xls", True, "" This keeps the formatting from the query but i cannot append more...

Excel worksheet and formatting Hi there, thanks for your reply. I have craeted a temp table as you suggested but again i cant get it to keep the percentage formatting in some of the columns that is presnt in the query. I used the following code: DoCmd.RunSQL "SELECT * into tempTable FROM...

Hi Guys, i'm trying to export multiple queries to on excel file with multiple worksheets and keep the formatting from each query. i.e. one query on each sheet. This works fine for one query by using the following : DoCmd.OutputTo acTable, "Query1", "MicrosoftExcelBiff8(*.xls)", "C:\My...

hi i am trying to use the following iif statement in a query. IIf([Forms]![MainForm]![cmb_ExcessStatus]="Resolved",1,IIf([Forms]![MainForm]![cmb_ExcessStatus]="Outstanding",2,IIf([Forms]![MainForm]![cmb_ExcessStatus]="All Records",([MainTable].[Status])=1 Or...

Hi all I wish to create a VBA function that will write details of any form item to a db table for auditing purposes. I had planned that I could call my function in the beforeUpdate event on every form item ( passing in the form and the activeControl. ) Private Sub Text21_BeforeUpdate(Cancel...

sql server express and access front end Hi sorry for not explaining myself. I have a test database created using SQL server express on my own PC. This is my first time using it. I also have access 2002 running on my PC. i wish to connect access to the SQL server database and create a front end...

Hi guys, im new to Access and SQL server. Im trying to connect to SQL server express on my own PC but im not having any luck. Is there any documentation anywhere that will explain what i need to do? any help would be much appreciated