Recent content by eepok

That works perfectly! Thanks!

Wow! Long time, no see! I played a lot with Access 2003 about 4 years ago, but stopped and work no longer required it. I'm now presented with a very, very simple database (1 table with a form view) that I want to make better (remove the option for human error). Issue: I don't understand the...

You, BonBon are the BOMB!

Has anyone noticed that quotation marks (" ") transferred from MS Word are not recognized as quotation marks in Access? I will sometimes use the text-coloring effects of MS word to sort out, visually, some functions in some of my more complicated expressions if I mess up the parenthesis or...

Ok... I got lucky on this one. I had no idea that "isNumeric" was a function but I searched it out of sheer boredom and it came up. I would pat myself on the back, but I'm thinking that was sheer dumb luck.

Hey guys, Is there a function that would let me know if a field value is purely numeric (no symbols, no letters, no spaces)? I'm thinking of using in an if/then statement like: iif([field] isNumeric, "Jump Around", "Ice Ice Baby")

Thanks for reading through my rather jumbled description. That looks like it does exactly what I need. I was in the middle of re-writing the whole thing when you replied! =P (4 wisdom teeth extracted recently = no coffee = crazy typing)

Hey all, again, Situation: "Table1" <-- Data Entry storage Record 1: FieldA, other stuff, other stuff, FieldB, more stuff, more stuff Record 2: FieldD, yadda, yadda, FieldA, etc, etc "Table2" <-- Field Data Source Record 1: FieldA, Adata1, Adata2 Record 2: FieldB, Bdata1, Bdata2 Record 3...

I read your response and thought to myself, "That can't be it! I've been looking in the property sheet for an hour, now!" But, I opened up the report in design view, opened up the property sheet, and it was right there! My confusion: I will often do another task in the report before looking...

Hey all, How do I go about changing the query a report references for data? I know I've done it before, on accident, but can't seem to figure it out now. Thanks in advance.

This is precisely part of the issue. I can't figure it out. It just happened again, too. It's been sitting idle for while and I went to try it out with june1-june30 and boom... query wiped. I'm going to try to nail it down with some methodology and I'll let you know when I know more. Thanks...

Ok, uploading now. Sorry it's been so long, but I'm hoping you can still take a look at it. I've trimmed out a good deal of the DB and all that's left is what I think may be involved with the error as it's been reproduced in what's in there right now. (Yes, it was a little premature to say it...

Using Access 2007 on XP Pro SP2. I cannot install any updates whatsoever because my hard drive is almost completely write-locked. (*sigh*) It works, so that's good. But I wish I new why it wasn't.

The message box if/then has prevented the query from being wiped thus far in all of my testing. It looks like a win! One last question, though: I don't, with my limited knowledge of VB, understand why it helps. Is there an interrupt in the code I'm not seeing? I would think it would work like...

Ok, maybe I didn't get it *just* right. It seems that if there's no data in the fields designating the boundaries of the range to filter ([FilterStart] and [FilterEnd]), everything in the Query gets deleted-- fields, formulae, etc. I have to rebuild the query (go back-ups!) if I click without...