Search results

Sorry, it does appear if I enable show hidden objects, however when I try to open it I get a message stating unrecognised database format

Thanks It doesn't show in the original db or the blank one I created.

Yes I can create a new blank database. Where would I see the MsysResources table?

Hi After a Microsoft365 upgrade, my databases will not load reports. When I try to compact and repair I get a message that the MsysResources file is missing. I have copied the front end from another computer which is working fine but the error persists on my laptop. Would appreciate any...

Thanks for your response. The function loops through 134 spreadsheets and each has a different range of data, albeit each starting in cell A5. How would I select the individual ranges in each spreadsheet?

Hi all My client has modified their excel spreadsheets so the headers are now in row 5 instead of row 1. How can I modify the following function to reflect the changes? Public Function ImportHierarchyFunctionFiles() Dim MyFile As String Dim MyPath As String Dim db As Database Set db =...

Hi I have the following code to export separate excel files from a query in my database. The problem is that it is exporting all data from the query to each spreadsheet instead of the data applicable to that countrycode. Can someone please help me with this. Private Sub Command185_Click()...

Absolutely brilliant - thank you. What you gave me is so much simpler than what I was attempting to do.

Thanks for the resposne I copied your code and am getting End With without With when I compile it

Hi I am trying to create 134 Excel Macro Enable workbooks from my Access application. My code is Public Function CreateDataFiles() Dim xlApp As Object Dim xlWB As Object Dim strFileName As String Set xlWB = Workbooks.Add("C:\KPMG\Excel Templates\Member Firm DataFile.xlsm") Dim rs As...

Thanks for that. I tried that but to no avail.

Hi all I hope I am posting this in the correct part of the forum. I have an application which I designed thinking the back end was to be deployed to an sql server. I now find they want it on Sharepoint which I have never used before. I have managed to split the back end to a sharepoint site...

Hi arnelgp I am sorry to trouble you again with this. Ultimately, my back end will end up on a sharepoint site. When I tested this after migrating the tables to sharepoint it no longer works. Do I need to modify the "set" rules? I have tried changing the column number but to no avail. Thanks

Obviously the "and" is a problem. I did try to delete this from the code initially but had trouble including the syntax surrounding "andwhere". I have now sorted that out and the code is running correctly. Thank you for your help and patience.

This is now showing ...................And WHERE tblConsolRawData.CountryCode = 4

Sorry, I am trying to learn SQL but am only a beginner at it. I replaced the AndWhere as suggested and I now get "Syntax Error (Missing Operator) in query expression

Ok Thanks I understand what you mean but I am unsure how to do this as the code is actually creating the qryDefs

This is what I am getting SELECT tblDump.Id, tblConsolRawData.[Member Firm], tblConsolRawData.[Survey Methodology (Legacy Anonymous / Linked Data)], tblConsolRawData.GPID, tblConsolRawData.[First Name], tblConsolRawData.[Last Name], tblConsolRawData.[Email Address]...

Thanks for your response. The original underlying query only ran on one table. It is now extracting data from 2 joined tables. The new table is a set of rules surrounding data requirements. 1.There are no memo fields. 2. I don't think character limits are the issue here. The query runs as...