Recent content by memilanuk

I have three tables, one with competitor info, one with special categories that the competitors may fit into according to the rule book, and a many-to-many junction table. The categories are fairly general... things like 'Senior, Grand Senior, Junior, Intermediate Junior, Sub Junior...

Got it. I knew I just needed someone to prod me in the right direction ;) Turned out to be something I wouldn't have considered otherwise; the macro wizard for those two buttons on the 'master' form had window mode of 'dialog' selected, instead of 'normal'. Seems like 'Find' was about the...

Pop-up: Yes Modal: No Default View: Single Form Allow Form View: Yes Embedded macro; using a simple OpenForm macro to open the named form.

Okay... still gnawing away at this one. The latest is that the button works as it should when I open the form directly from the left-side Navigation Pane... but not when I open the same form from the master form (my 'switchboard'). I think I'm getting closer, but if anyone has any ideas...

Mmm... no the problem is (now) on both computers, and while the front-end was transferred via USB drive before, the most recent version (today) was transferred via a DropBox public link. Still not really understanding why I would have problems with the buttons only on pop-up forms, and not on...

Ummm... guess I should point out that I'm still fairly green at this stuff :o ...so a) where would I 'find the code which opens the recordset' when I didn't write any code; everything was done with the button wizard. Not really sure where to look. ...and b) guess I'm not following why it...

Hello, I've been fighting this one for a while now, and its about to drive me to drinkin'. Searched on another forum, didn't find much. Only suggestion there so far was to reinstall Access 2007! Searched here and found a number of threads with similar symptoms, but they each apparently had...

I don't know if it matters or not... in this particular situation, the database is single user, sitting on the local PC disk. The current version is not split; I am looking at splitting it partially because everyone seems to think it is a better idea in terms of protecting against data...

Hello, I'm working with splitting a database for the first time, and as I looked at the table relations again, I realized that many (most) of the tables are fairly static - look-up tables for the most part. Most of the other data is in one or two tables. Is there any way to (easily) split...

Well, that probably would be just the ticket for the future... but having about zero VBA knowledge at this point and I was planning on swinging by his place tomorrow afternoon to copy the forms over... the 'correct' solution may have to wait a bit :D

Hello Bob, Thanks for the response. Would that be the best solution considering I have to go over to the other person's house (volunteer organization) to update the database anyways? I've seen stuff about splitting the database before, but I'd always assumed it was just for multi-user access...

Hello, I'm working on a database based on a copy that I keep with me on a usb drive. I'm doing the design and layout work, mostly making changes to the forms and reports at this point. The end user has the actual working copy and is updating records in it, etc. - the copy I have is slightly...

Yep, got that one. I do have it counting all the records in one field (Member Since) so that I have totals for how many Regular Members, how many Life Members, etc. and finally how many Members overall (since any combination of the above won't necessarily match the overal total). If you don't...

Ah. That explanation makes the whole 'Domain' thing make a wee bit more sense. I was mucking about trying to hammer a larger report into shape - one that lists every member, and displays the checkboxes for the status of each one for each yes/no field - makes things very 'visual' and easy for...

Just haven't had a chance to focus on that. I've been going from more or less ground zero and importing the data to mostly functional with various forms and reports and queries and macros to tie them together over the last two nights. Proper case was moved down the priority list a tad ;) It's...