Search results

Hello- I am trying to create a VBA code that loops through each field in a table and for record cleans the data (string data with extra spacing)..... Here is the code I got so far....nothing too crazy but having trouble... Sub Test() Dim db As Database Dim rs As DAO.Recordset Dim fldLoop...

The real issue with the code is that I cannot add a variable (ie. the counter) to the DAO.Recordset once its declared for instance... Sub DefineTableFieldNames(ByRef arrIndexNames() As String) Dim dbs As Database Dim tdf As DAO.TableDef Dim IndexID As DAO.Field 'Create table definition in...

Thanks for the replies. I would like to build the table dynamically. The array is mulitdimensional (currently 16x16)... I have tried passing the array to another sub to create the field names like this.... Am I going in the right direction? Thanks! Sub DefineTableFieldNames(ByRef...

Hello- I have a code that creates a dynamic array. I would like to now put this array in a table...how would I do this in VBA? Any links with examples are much appreciated. Thanks! EK

Hello- I have a code that creates a dynamic array. I would like to now put this array in a table...how would I do this in VBA? Any links with examples are much appreciated. Thanks! EK

Hello- I've created this code below that loops through a file and perform some caclulations. However, I am having trouble with the output. The output table will have the same number of columns and rows however I cannot seem to be able to get past the first column in my array before I get a...

thanks for the reply Bob..I know it seems kind of foolish but unfortunately, using a parameter query to limit the results to one account won't work. The reason for the template is so I can have a the same report for say 3 accounts and look at them simultaneously by having them all in one larger...

that would work if I only needed to run one report at a time. However, I'm looking to have a template for all the accounts as these 'template reports' will feed into a larger report.....

Helllo- I've searched this forum numerous times and have not seen a solution to the reporting solution I am trying to accomplish. Basically, I have one report that I want to repeat the format and style for different accounts. However, I don't want to go in and create the same report for each...

Hello- I'm building a procedure that takes various time series returns by certain sectors and calculates a Covariance Matrix of the returns....As you can see from my comments in the code I am having trouble getting these values into an array. I don't have a ton of experience with them so any...

Good point. I will try that. And yes, I got the union query to work...it was the '& _' at the end of each line. Sometimes taking a break and coming back to look at some code you can see the obvious:) thanks again for your help!

fortunately for me no semi skilled users:) thanks for your input!

Hello- I have two questions that pertain to the end product I would like to achieve. I am basically creating a reporting DB that will have between 15-20 different reports in it. However, the data feeding the reports requires a few different sub queries to be created before the final output...

Hello- I have a simple design question that I am looking to get some input on. What I have are two data sources in Excel. I would like to put them into Access due to the vast amounts of data I am beginning to acquire.... For the first table I have Returns and other pieces of data that are...

OK..been going through the property sheets but not seeing anything so far....I have tried the SQL in just a query and it is not letting me edit there either so looks like it must be something with the Joins then??

yes, i took a look at that and nothing I have looks like it falls on the list so thats where the confusion comes in.....

Hello- I have the following SQL statement as my RecordSource however on the form itself a user cannot edit any records. I have the relationships set up properly (1:M on ObligorID), checked to make sure the data types were matching on the Primary and Foreign Keys, RecordsetType is set to...

Got it...needed to be Me.cboInternalRating.Column(0)...thanks for the idea! Helped big time!

Hello- I have the following code I am using in a form that flows into an SQL structure to filter data: If Not IsNull(Me.cboInternalRating) Then strWhere = strWhere & "([Internal_Rating] = """ & Me.cboInternalRating & """) AND " End If My problem is when I run the combo and look at the...

Hello- In a form I have two controls...a unbound combo box and an unbound textbox. I have the following OnChange event for the combo box to populate a value for the textbox. However, it only works when a record is found from the dropdown box...but within this combox box the user should be able...