Search results

I figured it out using a clever conditional check. That's what's called debugging. You stuck for a while then a flash of insight saves you. LOL. thanks

Hey All, I went through step by step to see where it fails. It fails when there's even just 1 space in the original source table ( rstSource). But the odd this is the count of both the source table( rstSource) and target table (rstTarget) are correct! If it's a 5X6 table then the counts are all...

Well, it's because I want it be structure in a certain way. That's why I wrote the Transpose function. thnx

Hi All, I've written this Transposer function that takes the name of the source table and transpose(switch rows,columns) into the destination table. Everything works fine, except when there's space in the data fields. For example, if the original source table was a 5X6 and was filled with...

Chris, Yes, that works. Thnx! But the pickle here is that QryMetricXXXXXXCombine queries are used for dual purposes. One for the form to lookup values via DLookUp. The SECOND purpose is for "viewing the data". Which is invoking QryMetricXXXXXXCombine. And when I revert by to normal decimal...

spikepl, I'm sorry if I sounded like I was going to chuck the sock after the mending. That's NOT the case. My question was a bit more open-ended. The reason I had all these formatting issues because I went about it the long and complicated way. But perhaps, the root of the problem is that my...

spikepl et al, Your points are duly noted. However, I'm in a bit of pickle due to some formatting requirements. So, instead of talking in generalities, I've created a testDB with just the queries, tables, and form in question to isolate the issue here at hand. I've also uploaded and attached...

spikepl, Interesting suggestion. What I meant to say is that i run/call QryMetricXXXXXXCombine as is. It just happen that when it runs it displays the data as a datasheet view. It's nothing I do. Access just returns a datasheet view. Are you implying there's something i can do to make it...

hi all, Last night, I realized that changing MetricValue table might not help since the DLookUp is looking at the QryMetricXXXXXXCombine queries. And those are the formatting issues. so, what's the best way around this? thnx, flyinghippo99

Chris, OK. That's probably a good idea. I might need to scale it down a bit to post it on here since it's rather big. What's the size limitation for posting db? So I know how much to scale down to just fix the essential issues. thanks! flyinghippo99 P.S. Also, btw, how do I post the db? I...

spikepl, Thanks for the suggestions. You wrote," But query output is not intended for human consumption, unless shown through a datasheet or another view of a form or report." Therein lies my problem. Entire story is a bit complicated and we can revisit that soon. But the short version is...

oh, btw, in MetricValueTbl the PercentCol is of the following Data Type: Number, Field Size: Double, Format: Percent, Decimal Places 3 Maybe i should change that to 4? hehe. Let me try. Is Double too big? Should I try Single? ===================================================================...

Chris, Thanks for that. I hadn't realize that FormatPercent returns a string. Interesting. I had tried using -.00001 and it still returned #Error# message but that was with FormatPercent. So, I went back to my original formulation of QryMetric120055Combine: SELECT MetricDate...

Hi All, I'm not sure where to put this question - forms, VBA, or query. So I put it here. So, I'm trying to display data that is in "percent" format in Textboxes on a form using a DLookUp of a query. Each textbox on the form has the following VBA code as its ControlSource...

It works now. Could have been strange instability with a copy of Access I was running. Now, it zips through the import. Very strange. thnx, flyinghippo99

Yep. makes sense. thnx!

Nevermind. For some reason, the Import Wizard works now. But now it showing a bunch of type conversion error. Does anyone know if the DoCmd.TransferSpreadsheet allow one to specify each column format of the spreadsheet as they come in...? thnx!

TheDocMan, there aren't that many columns in the spreadsheet(only 10 columns). The file size isn't even that big only 444kb! The rows have small characters. Nothing usual. In fact, I imported a smaller version(i.e. 100 rows instead of the 9300 rows) and it went perfectly. I didn't get the "row...

hi All, Is there a size limitation on how many rows an Excel 2007 spreadsheet can have when importing to Access 2007? I have about 9300 rows of data in Excel(not big) and the eventual size will be much bigger. The file size is not even a 1000 kb. But even now, it's taking forever to import...

hi All, Is there a size limitation on how many rows an Excel 2007 spreadsheet can have when importing to Access 2007? I have about 9300 rows of data in Excel(not big) and the eventual size will be much bigger. The file size is not even a 1000 kb. But even now, it's taking forever to import...