Search results

Kevin wrote << Rich - I work for the government.... its not that easy! >> Must be state or local. My client (a federal agency) is more up to date. RichM

Kevin, Sounds like a lot of the folks in your shop are bozos. I use Access 97 and 2000 as a front end to Oracle databases and it works well. The Oracle DBAs in my shop are good people and they set up stored procedures with parameters and I just use em for reports and/or forms. Plus I use...

Kevin, Tossing in my 2 cents' worth: The concept of an "intelligent key" is dead as the dodo. Any clever plan to make one part mean this and another part mean that will always fall apart over time. As Pat H mentioned, you can make a unique index from multiple fields and the users can use the...

No Bill, it still does not make sense. If all the data fields for one client - Client Info and Qualification - were in ***one*** table, would that cause a problem ?? If so, what is the problem ? RichM

Bill << So, I guess it is a one-to-one relationship but I am using 2 separate tables. "Qualification" is for the data-entry and "ClientInfo" contains client specific information for all clients and is only used as a lookup to autopopulate those fields on the form (ideally/hopefully). >>...

Bill, OK, there is one client per qualification. Is there one qualification per client ? If the answer is yes, then you seem to have a one-to-one relationship. Then you really don't need a subform. Anything you need to do to "autopopulate" data can be accomplished with one form. HTH, RichM

Main froms with subforms are used to manage one-to-many relationships. What is the relationship between Qualification and Client ? Does one Client "have" many Qualifications ? Does one Qualification "have" many Clients ? Or if there is one Client to a Qualification, then why have a subform ...

A search on "cascading combo box" produces 64 threads. RichM

jeremie, Yes, the 2 fields are a concatenated primary key, to avoid duplicates. alan, As jeremie wrote, you do not want 51 tables of counties. You would create one list box based on States. Next, you would create a query that uses the State selected. This query selects all County Numbers from...

Alan, Table 1 ===== State Number State Name Table 2 ===== County Number Count Name Table 3 ===== State Number County Number This is the standard method for many-to-many relationships. Table 3 is the "junction" table. It represents that fact that a State contains many Counties and a County...

I would guess that you are falling through all the Ifs. Assign a zero value to cbStatus right after the Dim statements. Then try it again. RichM

Kevin, Renaming an attached table does not cause any problems. RichM

Tables are not sorted by index. Rows are stored physically "as added". Indexes are used to find data. An index is basically an extra table with index key values that point to a physical record location. So you have not screwed anything up by resorting the table. Access will remake the indexes...

Jason, Looks like you have 2 columns in the list box. One column contains "97" and the other contains some name that goes with 97. Right ? The column with 97 is the "bound" column and that's what shows when you pick something from the list. You can't change that behaviour. What you can do is...

You wrote << See for Rate tests and Durability tests, they can each have zero or more static and dynamic tests, >> On the diagram, I don't see any relationship between Durability and Dynamic/Static. As to relating a Request to a Rate to a Static and/or Dynamic, your key structure should do...

I join tables in queries. I do not use "relationships". That's an old habit but it works for me. See Access Help on "join". You will find examples of left joins. You will join the Request table to the 3 Test tables via the Autonumber that is the primary key of Request. That means that when you...

Sounds like you want something like this: 1) One "Request" table and use an Autonumber as the primary key. 2) Three separate "Test" tables; one for Rate, one for Durability, and one for Creep. 3) For the three types of Test tables, one Static and one Dynamic "sub test" table. That sounds...

See Access Help for "dir" or "$dir". There are good examples of checking for existence of a file name. RichM

Pat, I am trying to produce rows of this type: Site=1 X=1 Y=2 Site=2 X=null Y=3 Site=3 X=4 Y=null etc. The Cartesian would be (more or less) 1 X=1 1 Y=2 2 Y=3 3 X=4 RichM

OK, you need any site with: X and Y, or X, or Y And you probably want a site "together" in one row. Query1 will select all sites from table 1. Query2 will select site and X from table 2. Query3 will select siet and Y from table 3. Query 4 will put it all together. It will have Query1 on the...