Recent content by shacket

Yes, I do. The reason is that I am tracking a lot of information that is individual-specific. In other words, there are many fields in tblIndividuals that track information regarding each individual - which are generally different even between husband and wife. (Kids are actually listed in...

I have the two tables: tblFamilys lists last names of various families (key is FamID) tblIndividuals lists first names of individuals linked to their last name (in tblfamilys) through FamID Some FamIDs have two people in tblIndividuals (a married couple) and some only have one (a single...

I have a database that is constantly "running out of memory" with VBA. I have looked into the problem and it looks like my only option is to create a new database and import all of the objects over from the old one. My problem is that I have user level security that is somewhat complex and...

What I want to do is this: have a form pop up in the center of the screen with a list (continuous forms). I want to have it show a given number of form items (i.e. the height of the detail section - how many items are shown) but I can't figure out how to tell the form to be X high or to tell it...

I ask this questions for two reasons: 1. Our network consists of PCs running WinXP and PCs running Win98. The references for one don't work on the other (some come up as "MISSING"). 2. If I were to sell a database to someone across the country who has Access, but doesn't know the...

I did that. All it prints is Users and Groups. No passwords. No PID's. Nothing beyond "John is a member of the web group." Certainly not enough information to rebuild your workgroup file if need be. Any way to get at that information?

Let's say I have a form with 3 text boxes named: Text1 Text2 Text3 and I want to each text box to say: "This is box number X" (where X is the number of the box) How do I use a variable to cycle through with a For statement to refer to each box such as: For i=1 To 3 Me.Text [i] = "This...

When I set up User-Level Security, Access printed me out a nice report with all of the objects, groups, PID's etc. I have since made a lot of changes to the items (added users, etc.). Is there a way to print out another report with everyone's PID, passwords, groups, etc.?

Me.lstBoxName.RowSource = "SQL Statement"

Well, it doesn't solve everything, but I defragged the server the back end is on. Things are MUCH smoother. Maybe that was it. Thanks for the thoughts.

I figured it out. In the design mode of the table, under properties is a link master and child fields line. The wrong field was listed there.

I have a one-to-many relationship between two tables. When I first set up the database, I linked them on a certain keyID. I have since linked them on another. In fact, the first is not even in the tables anymore. However, when I am in the "one" table and click on the plus sign, it prompts me for...

My database performs incredibly slow, especially (but not only) in design mode. When I delete a text box from a form, it takes about 30 seconds. The db is compacted and I have a P4 2ghz 256k computer running XP pro. There is User-level security on the db and I am accessing the db over a...

Nope. The closest you can come is to add a colored box to the background of each tab page. It wouldn't change the tab color but it would change the background of each tab page.

It can get tricky using calculations. I always get confused as to whether to use the field name or the control name. Try putting the two numbers you want ([WarrantySum] and [Count]) in calculated controls in the form header or footer (if you are using continuous forms) and then dividing the...