Search results for query: *

Hi all, A little background: my database has a main table of projects with about 275 records (with about 40 fields per record), and each record is linked with 0 to 10 additional issue records in another table (depending on the project). I've got a form for entering and modifying the data...

Hi all, Since this is a question related to Windows Explorer, I hope this is the correct forum! In trying to make my Outlook messages more bearable, I wanted to try to save the individual messages directly on the disk in their own directory (rather than using .pst files). Outlook lets me drag...

Hi, I've got a DB that multiple people access, and would like to have a flexible way for them to have a query that they can easily input the parameters for (such as looking for their own name in the contact information, etc). I know I can do this directly in the query, having it prompt them...

Hi, I'm fairly new to FrontPage, and have a bunch of pages on a development server. So far, all is going well. However, I just found out that later today the development server will be inaccessible for about a week and a half, and I'd like to be able to continue to develop on my local...

Hi, I know this may sound like a bizarre question, but our corporate IT group is not allowing frames on pages, so the standard way of doing it is to create tables to do the layout. A typical page will include a standard module that has a "tabbed-style" navigation bar across the...

Hi, I've got some files on a network share drive, and we'd like to have everyone be able to read them, but only a select few be able to write/modify them. I've used the security tab on the files and can't seem to get it to work. What I've done is used the "everyone" group and set...

Hi, I've got an Access97 DB that I've split into frontend/backend databases, which works fine. Since about half of the people accessing the db are on Access2k, I converted the frontend to 2k also, so both types of users can operate natively (the backend is in 97 format, of course). However...

Hi, I've got a report that's almost where I need it to be, but need some summary information on it that I'm not sure how to accumulate. Here's the situation: I've got multiple Organizations (I'll use 2 for simplicity -- call them AA and BB), each with Divisions (call them A and B). Each of...

Hi, I need to create a field in a query that will be a logical "OR" of other fields -- for example, if I have a table with the following structure: Name Issue1 Issue2 Issue3 I'd like a query that will return Name HasIssues where HasIssues is True if any of the issues exists, False...

Hi all, I've got a DB that has about 5-10 users, some with access97 and some with access2000. The DB is in 97 format, which has caused a little trouble with the 2000 users. I've heard that splitting the DB into a frontend/backend makes for a much more robust database, so I did that and it...

Hi, I just started trying to secure a database, which seemed to work well, and then wanted to convert it to a front end/back end arrangement. So I ran the database splitter -- no problems encountered. Then I tried to make the .mde file, and got an error on one of my functions that the...

Hi folks! I just inherited a DB that is used by about 10-20 different people, and each one in the past has created their own queries and reports (many of them very similar to each other, but with slight differences, such as filtering on different names, projects, etc). I've changed the DB...

Hi, I've got a DB set up which tracks issues, causes, etc. for projects. My primary table has an ID field (primary key) and I've got a table tracking the issues, causes, and some other info. Each project can have multiple issues and causes (but may not have any). What I'd like to do is have...

Hi all, This is related to a different thread, but this topic better represents what's left to do... I've got a many-to-many relationship defined for issues and causes, and am building a nice interface to map which issues are associated with which causes. I've got a form set up with a combo...

Hi all, I'm currently in process of setting up an issue tracking DB which has a main table, a table of issues (approx. 6-10 items), and a table of causes (approx 10=20 items). The Issues table has 2 fields: the issue description and an Issue Identifier (I1, I2...) The causes table has a...