Search results

For those who have sinlessly suffered through this thread, here are some references for empty vs. "" vs. Null vs. Nothing vs. not Used vs. Missing vs. Blank vs. Argggh A fine albeit long historically oriented Taoish piece (oddly available to nonmembers, lol). BTW it and Allen purely equate ""...

CJ, how about ,, representing a null, and ,"", meaning ZLS? That's how I've always assumed, but you've definitely got me thinking about it.

Thank you for your perspective and for being the sole voice acknowledging that something seems truly amiss here. You really hit the nail on the head in my experience, particularly with midrange/mainframes. On the " " case, besides the [perhaps minor] waste of size on a delimited extract, that...

Try testing if LEN is <1 perhaps like if (len(Me.txtHouse_FlatNumber)<1 _ or len(Me.cmbStreet)<1 _ or len(Me.cmbTown_City)<1)I haven't used combo boxes for a while but one way, maybe not the best, would be to have a default choice like "(none)" (no quotes) and react to that. Sometimes...

spikepl - thank you for spelling out your idea to stage it. I apologize that I don't often use the word "staging" although I acknowledge that it's a legitimate database term and your followup makes things very clear.. (I use the vulgarian lingo "temp table" .) It wasn't indignation...

Sorry, I walked on TJPoorman's more detailed answer. Read his instead! Sorry TJ. I need to remember to refresh before posting!

Can't you simply test BuildFilter before applying it? maybe prompt user to enter something, and exit the code. (Test vs. null, a la Debug.Print IsNull(BuildFilter))

You might consider the isdate function as a backstop in case you don't catch every input variation. I don't know if you use VBA or if a UDF is off the table but this would work there. More simply, you can use IsDate([MyField]) in a query or validation. It's not a comprehensive solution, and it...

Thank you for both the interface advice and the confirmation of the problem. I'm not sure if I should mark this solved as it appears to be destined to "remain unresolved." I appreciate the clear, specific and useful message, and you earn the "thank." I'm confident that ZLS and null are not...

Last try. Has anyone tried to reproduce this issue and can they report? It's not difficult. I spent some time condensing the issue into a 45 second exercise for anyone to reproduce - see original post. If no one has a solution (and no one has, short of speculating to edit source data) it would...

Spike my name choice is explained on the about page, but in case you've drawn an incorrect impression, I'll indicate that the "design" fiasco regards the interface, not product performance and features. I knew Excel's interface was severely slashed and deproductivized in Office 2007+, but with...

I will be thankful if anyone has anything to add as the issue is not solved. I appreciate your attempts to help CJ, and would like to hear from others now. I have read your entire posts and considered their usability. Great stuff for Access 2007. Thank you for your help and concern. (Also, I'm...

Thanks, though there is no import specification. (True, I might have used one to limit which fields to ignore, but I didn't) I am grateful for the two links but unfortunately they did not add anything. So I'm still looking for an answer. No one has said they reproduce the issue, but I'll...

Try renaming the local from adjustments to overrides, then rename from overrides to adjustments, all with name correct ON. If it's just the linker, not the linkee, delete and recreate the link. No guarantees, but this type of approach, perhaps with a tweak or two that I don't recall, has made...

I'll make this as simple as possible to reproduce. Create abc.csv as "","","" "a","","" "a","b","c" Start a new Access database with a table, 3 fields, and for all 3 fields, yes for both Required and for allow zero length string (ZLS). What you've said - corroborated by MS help/web help - is...

Actually I'd parse it in Excel, so it would be one pass in Access, since the C information would be captured. So this idea saves a pass, and a join, but adds work in Excel. If anyone wants to see try all this, my original problem was, for the 3 field, 4 record table described earlier, that...

An offbeat solution occurred to me. Assuming C is assured to be less than a million, then max (1e7*B+1e6+C) and leave C out of the query. Then the right 6 positions are C; all but the right 7 are B. Is that too wacky an approach?

I'd like to do a grouping query as follows. The source table has three numbers per record. A B C 1 50 17 1 100 11 2 30 55 2 60 22I would like to do a query that groups field A; gives the max for field B; gives the field C that corresponds to the max B for each A. That...

Substituting error messages might be a bit ambitious for your experience level, although not prohibitively. I would suggest working your way up to doing that. I will address the part about error number by suggesting that you get handy with debugging. "Debugging" does not connote "fixing a bug"...

Thanks for this. I miss Usenet and this is a good resource. I've lifted plenty of strong solutions, and thought I might join in. And by clicking to read this, you are wondering about the bizarre user handle. It's really very simple. I am, like most of the people in technology, truly concerned...