Search results

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...

Perfect. =) And might I add that I appreciate your hands off approach there. Makes me learn the syntax of the commands. ;)

Hey all, Need some help here. I need a single-button/click export of a query to excel. I can't seem to find any built in function to do it and I really don't know VBA/SQL to make the function on my own (go go Access GUI survival!). I know how to slap a button on a form and I've played with...

In access 2003, you used to be able to right click on the displayed report and select "export to excel". The results were mixed and were highly dependent on whether or not you prepared your report in format that could easily be translated to a spreadsheet. In access 2007, the function or option...

Hey baldy, I just wanted to write back and let you know that I researched a bit of the vocabulary often taken for granted (the term "control" as a noun is still new to me), learned what you said, and implemented your suggestion which works perfectly. I would give you another boost to your...

Hey all, Using the built-in query builder, how can I filter the query by a user defined range of record IDs? I know about the "like" command in the criteria field, but I don't know how to implement a range of criteria (IDs 27-54).