Search results

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

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

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

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

I must be doing something completely wrong; it doesn't seem like this should be this hard to accomplish. Then again, it is 0400-ish here and it's been a looong night shift :rolleyes: What I have: a query that displays a number of fields depending on certain criteria. Specifically if a person...

Not sure if this would be better off in another sub-forum or not... So... I'm dealing with importing and cleaning up old data from a Works DB. I saved it as a CSV file, imported it as a new table, and now I'm working on 'scrubbing' it - cleaning up the cruft and generally making it...

I'm guessing that I'm missing something blindingly obvious here, but I could use a nudge (okay, shove) in the right direction. I have a table with various member information... one field being 'Date Expires' and two more being 'Regular' and 'Life' (both Yes/No). What I want is to be able to...

... when opened from the Switchboard. Opening it directly from the Navigation pane works as expected (it opens as a Datasheet). If I try opening it from the Switchboard, it opens in the Form view, even though form view and layout view are turned off in the properties. As soon as I select...

I'm trying to modify the Contacts.accdb template to suit my purposes - for the most part it does what I want/need. I'm having to hunt down a few places where apparently field names are referenced in some embedded macros, VBA modules, etc. and are giving me minor amounts of grief in the form of...

Hello, New guy here, go easy on me please ;) I'm working on re-doing the membership database for a local club of 700+ members (the old/existing one is in M$ Works). One of the things we've never been able to track very effectively is past membership. Currently we have people check on the...