Search results

Actually, I believe you got me my solution. I didn't think to use the DLookup in the Default Value field. Initial testing seems to work, now I just need to fine tune the presentation of it. Much obliged! I'll report back my future success or frustrations... EDIT: Yes, I put the DLookup...

I have tried a few options but keep getting this: :banghead: I have a form for entering service information. But there is one service slightly different than the others, so I created a different form. My struggle is getting this second form to automatically show this specific service in the...

@Gemma - my "firm" is a land management agency for the US federal government (insert necessary disclaimer about how everything I say and do here does not represent said agency). I'm sure the only money spent on creating the original database was the salary of the employee who did it. Although...

Thanks for the quick reply, plog. I read it the other day and have been pondering your advice. To answer your main follow up question, permits relate to the climbers who climbed and which routes they climbed. A permit can relate to a guide company, but only if one was present for the climb (in...

Hey all - I am running into a big snag with my form design for this. I've traced the root of the problem to the many-to-many relationship(s), which create a "recordset not updateable" issue. Relationship screenshots are attached; the "Alt" is an attempt I made at circumventing this, which may...

Alright, screenshot attached for latest relationship layout. Guides can work for more than one company, so the linking table is added. TblClimbers got adjusted too with how it links to tblGuides. I also added a linking table between tblPermits and tblRoutes, so we can choose multiple routes per...

Thanks for the continued input, all. @Mark - Your question (can a guide work for more than one company) was a provoking one, and I am determining if that is something the DB needs to plan for. I am (re)reading your last post and (slowly) wrapping my head around it, figuring if that is the way...

@Mark - Not all climbs that happen here are guided. Most climbs do not have a guide, some do. And several of the guides also climb recreationally (i.e. they aren't working/guiding). Hopefully that helps clarify the situation. The park needs records of the guides and who they work for. And they...

Hey folks; I am resurrecting this thread because I have been working on this problem again. I've attached a screenshot of my latest relationships. My current concern is the relationship between tblPermits and tblClimbers. Since there can be multiple climbers on a permit, I used a trick that...

Thanks, CJ. I had read a bit about crosstab queries but did not make the connection. That did the trick. And yes my DB is normalized. I understand the importance of that principle and how it affects everything, but I didn't want to launch into a discussion of DB design when asking a basic...

Hey folks; I am trying to make a report that creates a simple chart of my data, which would look something like this: Month1 Month2 Month3 (etc) Total Year1 TotalM1,Y1 TotalM2,Y1 TotalM3,Y1 (etc) TotalY1 Year2 TotalM1,Y2 TotalM2,Y2...

Thanks for the tips, isladogs. I will test this out a little bit but it might be a few days before I get around to it. One follow up to your post though: despite the fact that it is called "Header_Label" it is actually a text box (forgive the bad naming convention). So it does have a control...

Howdy - I have several dynamic reports which use a form to filter the results. One such filter is the date range of the report. I set up a nifty way so the top of the report displays the date range entered (or a default date range if dates are not used in the filter). However, once I close that...

Thanks for the advice so far. I learned Access last year by designing a database from scratch. I don't claim to be an expert on anything, but I have learned a ton, including the all-important necessity of normalization. Attached is a screeny of the tables I created and their relationships, my...

Howdy, I work at a place that includes a popular rock climbing area. They have used an Access DB for many years to track their stats. After learning a fair amount about Access/DB design for my own purposes, I've taken a look at this climbing database, and it seems a pretty big mess. I would...

ridders - Lots of things in programming language don't make sense to me :banghead: I understand your basic point, that numbers should stay numbers and dates should stay dates. I briefly tried your solution and got a data mismatch error. Although using CStr is probably not the recommended way to...

@Mark - okay then that would be a "no." Thanks for the article. (I did an internet search of front end vs back end but did not see anything that clearly explained the concept.) I don't think that's a necessary step for me. But it's a good thing to know for the future if I ever tackle other...

@ridders - yes one of my ideas was to use the TeacherID_PK field, since that is part of the listbox query and I can set that value as the bound column. But I ran into a problem because my filter button uses a string, and the PK is an autonumber. So I'm not sure how to solve that, but currently...

Hey all - long time no posting! I am back improving my database, and have run into a little issue. Last year I stumbled on a great resource that taught me how to build forms which filter reports. I am now working on a new one of these reports and filtering forms; one of the filters is based on...

After preliminary testing of both of the above solutions, it seems as if they both work. Galaxiom did have it right, because I want to include the null values when Len() = 0. It seems like sneuberg's solution does the same, just at a different point in the code. However it's happening, thanks to...