Search results

I'm actually not even using transfersheet but was going to change if it did support Excel limitations. I'm currently using copyfromrecordset if there is a way to tweak it? Set dbs = CurrentDb Set objXL = CreateObject("Excel.Application") 'edit this if template is moved...

ouch. Is there a work around?

Trasfering a large query to Excel will it create new sheets if it reaches Excel 2003's limitation? DoCmd.TransferSpreadsheet acExport, , QueryName, PathNameFileName, True

That was it. Thank you!!

why do I get the new record (blank row) at the bottom of a query? Hopefully I can explain this well. When you run a query the last row should just contain the last result. In my case when I run it the last row contains the asteric and a blank row to add. This causes the Invalid use of Null error...

Hmm.. I couldn't get it to work. Can we dumb it down a bit for me. I have 2 queries now (qAccountInfo, qFunds) qAccountInfo contains ID, AccountNumber, TotalShares qFunds contains ID, Fund What exaclty does TOP 1 do? Wouldn't it be better if I used Last(ID) where qFunds.ID <= qAccountInfo.ID...

Thanks. I can't believe I'm working on this gorgeous day but I am and I'm from Boston too. I actually messed up my example though. There could be multiple account numbers under each fund and not just 1 account number so the autoID + 2 wouldn't work. I figured out a way using code but basically...

Not sure how to do this. SQL or VBA or what. Basically when I import an excel sheet into a table it looks like this: [F1] (first column) Fund: 4329 AccountNumber 13224233 Fund: 3343 AccountNumber 23939393 Fund: 2299 AccountNumber 23939321 Fund: 4329 AccountNumber 39328393 I want this: [F1]...

Its a text file report from an old unix system

Not sure what to do. Right now from the import I only have one field in my table (field1). It contains account number followed by 5,6, or 7 rows for the address. I would like to have it On the same row multiple fields It looks like this.. 123456789-00 123 main st Boston, ma 02216...

Forgot to mention the error message.. 1004 - Method 'Range' of object'_global failed but it doesn't show me in my code.

I can only run it once and it works fine. Then i have to close the database and open it again. If i run it once close the excel sheet then clear the values on my form and run it again it doesn't work. Private Sub ReconReport() Dim dbs As DAO.Database Dim rstGetExportData As Recordset...

Only one of the fields will be filled at one time. They are text fields and i use Len()<1 but isnull() should also work. For most of the stuff I use both isnull() and len()<1

I believe Nz is for Access though? Not a valid function in Crystal

Ok, I have 3 Account fields: ACCT, PHAC and TACT and I'm trying to just create one single formula field called ACCOUNT. if all 3 are null or len() < 1 then display "N/A" else I want it to display the actual account.

currently have a string that looks like this: 00000000038683132 I need 386831.32 Thanks,

I got it to work. Thank you.

I can't use transfersheet due to the special format wanted. Anyone have any solutions?

still having issues.. if isnull({AccountReps.DealerNumber})= true and isnull({AccountInfo.TrustDealerNumber})=true then {AccountInfo.AccountNumber} else if isnull({AccountReps.DealerNumber})= true and isnull({AccountInfo.TrustDealerNumber})= false then {AccountInfo.TrustDealerNumber} else...

Thanks!! I guess it's just like VB/VBA.