Search results

This is my query:[ SELECT NAIC, [Time to Maturity], RBC_CLASS, SumofBookValue FROM [qryDUMMIES] UNION SELECT [qry ReconD1 Tenure].NAIC, tblWALGroups.[Time To Maturity], IIf(([sec_group]="BONDS" Or [sec_group]="MBS / CMO") And Not ([new_type]="PFD SEC" Or [new_type]="PFD SEC YA" Or...

thanks for the replies!

Hi guys, I am trying to import a dynamic range I made in Excel into a table in access. I use the code below to import a range from excel into a table. The range I have in excel is defined as =OFFSET(ybport!$A$2,0,0,COUNTA(data!$A:$A)-1,5) and is named yieldbookMort. The VBA code below in...

This may be a dumb question, but how would I go about transfering the querydef? Is it the same way? Also. The original problem was that the parameter was [Forms]![frmExistingAssets].[txtPortfolio] but if I put it that way the query doesn't find the object.

All, I am having difficult with some code that is making use of a query that has a parameter in it. I have read the discussions here and think that I have made use of the suggestions to overcome the error. However, even with the code in place I am getting a popup box prompting me to enter the...