Search results

Thanks, Misslinq! I had a similar issue...though my calculations did not involve division, I kepts getting ######## in fields where the result should have been 8. The calculations were working in every other instance, and I couldn't (and still can't) figure out why. But, I used your backslash...

I’ve been working on a little application in Access 2007 for a couple months now, and I continue to be vexed by a mysterious problem: every now and then, the comboboxes that I use to find records stop working. To be more specific, the comboboxes themselves work, but the form continues to...

Here's a great little syntax reference to keep in your favorites. I use it just about every day. :)

It's a miracle! Yaaaaaaaay!!! The noble Khawar has succeeded in appeasing the angry gods of concatenation, and mighty gifts exquistely sorted and abbreviated records rain down from my query like light from the heavens. Praise be to Khawar, and to George, and to Mailman for delivering my db...

George: I don’t know if folks in Austin are especially nice, but we can definitely come off that way, given our legendary predilection for “self-medication.” ;) Besides, in a town where jeans qualify as “business casual,” and roads close for Eeyore’s birthday celebration, what else can one do...

You would be guessing right, George, you dear, sweet, wonderful man!! Someone in Austin loves you!:D

the concatenation gods mock me still... I found another (seemingly) promising example of concatenating records from the same field in this thread. It calls a custom function from a query. Although the sample works beautifully on my computer, when I run the same module in my db, I get this...

Fantastic sample, khawar! I’m having a similar issue, and this method has gotten me farther than any other I’ve tried. I do have some questions, but I don’t want to hijack this thread since I’ve already got one of my own. By the way, cdoyle, you can get the sorting action that you’re after...

Thanks, backwards mailman! I’ve played around with your idea quite a bit, but I’m afraid I don’t have much success to report. The crosstab does get all of my days on one row, but I’m having trouble hiding the days for which there are no class times. Basically, I made a report based on the...

I don't know anything about TempVars, but I believe I had a similar problem when I neglected to explicitly define the data types of my parameters in a crosstab query. Unlike select queries where you can simply reference a form control in the criteria row and run the query, I believe that...

And now for another rambling, poorly articulated question from yours truly… I’m working on a db that, amongst other things, stores schedule information for the various classes that my organization offers at various times. Since different classes meet at different times on different days, and...

Well, I'm certainly no guru, but I usually store dates in a mm/dd/yyyy format in my tables. Then, I use query criteria to break the date down and isolate the parts I need (e.g., months or years). Although I've not used it before, I believe there is a DatePart function that will return...

You've always been my MVP, Bob!

Yeah, I think that's exactly the sort of thing that I'm after. Unfortunately, I'm pretty dense, so I still don't quite understand how I can bypass the validation rules in my table (which exclude null values) in cases where incomplete records need to be saved. My idea was to unbind the data...

I am working on a project in which accuracy in data entry is of the utmost importance and null values in tables most be avoided at all costs. Thus, I have made extensive use of validation rules/text in my tables to prevent inaccurate/incomplete records from being stored. Though is strategy...

Thanks, Pat, for the reassurance and the good ideas. As I mentioned, I've never worked on a project like this before, so I've never seen my Relationships window get so hairy. I guess that's what freaked me out. I'm not sure what motivates people like you to share your time and expertise with...

Here’s the deal: I’m no fan of the Yes/No data type. Not only do I dislike the checkbox/toggle display options on forms, but I often encounter situations where “N/A” or “Not Specified” or “Unknown” is a more appropriate designation than “True” or “False.” So, what I usually do is create my own...

Try this: On the query that you're using to calculate and sort the authors' names, add the Books_Authors and Book_ID tables so that they're showing alongside your Author_ID table. (Lines should appear between corresponding field names in your tables such that if Books_Authors is in the middle...

I am attempting to employ the oft-recommended MS solution for creating a dynamic crosstab report. The solution involves an unbound parameter collector form, a crosstab query, and report based on that query which is full of unbound textboxes. If the code was working properly, the report’s...

See if this works: Me.ControlName.Value = Null