Recent content by roystreet

I'm trying to get through all of the responses here. I do not use arrow keys. I have created a form which shows all projects in a drop down menu. They then select the project they want to see. They then can select to just see report or an actual form (Project Editor). The project editor...

Now, I'm getting the feeling that I may have made more work for myself in how I've designed it, but I'm not sure just yet. I'm getting a little bit of how relationships could help, but thus far I don't see how I'd accomplish much of anything different than what I've accomplished. With the...

The database that I have actually has 12 tables. The system mainly deals with projects & correspondences. Correspondences that relate with projects, but don't always. This allows a user to open the frm_ProjectEditor form & see in a list box all of the correspondence related to that project &...

Hey Chris, I see what you mean concerning housekeeping, I've already built in integrity checks when a user opens certain forms or opens the database. They usually run a query behind the scenes that cleans up data if there's some issue. For example, there's a subject field that should have been...

What do you mean by check with the user? Physically check or use an automated way? ...Part of why I ask is I would rather have very little need to directly work with the user. Not because I'm anti-social :) but I just want it to work for them, so they can simply get their job done with...

Hello - I'm looking for ideas on something I've been considering for awhile. I have a database that partly deals with creating/modifying/reviewing projects. It is a multi-user database. I wanted to make it so that if a user had opened a project that it would mark it as the project was...

Nope - I work in an office that deals with certifying modifications to aircraft & brand new aircraft designs. Much more interesting than a taxi company - No offense to the taxi cab drivers out there :)

HaHa!! I like your comment. ;) I take it that you don't prefer to use that method? :)

So, pbaldy, does this mean that I possibly won't have to make as many queries or use less coding would be the benefit? I think how I enforce some of the data integrity is a combination of mostly VB & queries. For example, when someone clicks on "Delete Item", it will run code that deletes from...

stopher, in my case I usually use a type of "Generic" table that has all of the specific values that are available. So, say were to pick a team name, all of the team names available in that drop down menu would come from the generic table. That table could easily be updated by an admin, say...

I have a question about Access database relationships that I've never really understood the benefit. I know we can go into database tools & select relationships to create one between 2 tables. I've never really put this function to use. When I create databases, when I need the data that is...

Thank you everyone for your input, now I have some stuff to chew on!

I guess that was a quick & straight forward answer :) I'm looking into giving users a local copy of the front end & having a back end on a network location. But...I'm trying to figure out a way to force users to use a newer version of the local copy when I release one. Right now, the front end...

Hello -- I already have created & run an Access database for around 12 users. I now am looking to create a database that can have at least 30 users. Each one with a unique user ID & password (Using a security file ".mdw") Users log into a front end on a network environment. Now...My...

Hello, I have a DB that has several fields in which different times are entered. For example, when a call was received & when it was responded to. The received time access automatically "Stamps" at the table level using "Short Time" as the format & "Time()" as the default value. They can...