Recent content by Ruzz2k

Hi Namilam, I dont know how to do that as I believe I would have to rewrite the whole access database. I am only using domain functions as I feel there is no easy way around what I am trying to acheive. here is the code with my quotes like you said, it says error 3061 expected 5 I am presuming...

Hi, thanks for that I have used the theory and now I get the following error run time error 3065 too few parameters. Expected 5 any ideas what this means? Thanks

Any help please? Thanks

Hi Namilam, how do I fix this? I still not sure how to fix the quotes. Thanks

To differentiate text from the sql string? is this bit the issue ,'[Document Type] = 'Quality Manual'') from the dlookup? am i close?

Sorry namliam I am struggling, I debug printed it and get the following. I copied this sql from the sql window for my qry called qryOutputL. It does not error until the 9th line strSQL = strSQL & " , IIf([tblDocs].[Active]=0 " SELECT tblDocs.Section , tblDocs.[Document Code] ...

thanks, will have a look when I go home. I do not know how to show the generated SQL? hence you would roll your eyes at me again. but I will look through the code before asking any more questions.

Error is with the quotes in the strSQL first line, but no clue how to fix this? Thanks

Hi I get runtime error 3075 with the following sql, trying to open query and then create table in email based on query. Any ideas thanks Sub ReportToOutlookBody() Dim rst As DAO.Recordset Dim strSQL As String Dim olApp As Outlook.Application Dim objMail As Outlook.MailItem...

Hi I have opening a csv file from access changing the date to a number and then linking it to access and then doing a lookup. Problem is the lookup only works if i open the csv file and go to saveas and click yes on the message attached and then when i close the csv it makes me do this once...

Hi, I converted the DB to access 2010 and ensured the options are as you stated but it still happens. found nothing rgearding this in a google search either Confusing?

Hi i am running some code from vba to add a linked table and the do some lookups, then delete the linked tables. When the linked table gets added, the navigation pane gets displayed. I have set it to do not display in the settings and it does not when it opens but when this code runs it opens...

thanks spikepl sorted all works now. been struggling for days

Hi my code does exactly what I want it to do except I cannot get the excel instance to close, I know its my coding but I have no clue where I am going wrong. please could someone help me, many thanks in advance my code does the following, user selects excel file, opens it, renames sheets...

Hi thanks for the explanation, unfornately I cannot get the excel instance to close, if I put XL.Quit after the set XLApp as nothing then I get and error. Could you be kind enough to explain it with my code in the first box, as I just cant get it to close the instance, im pretty sure the...