Search results

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

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

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

I had developed an entire treeview control on a form in my database. It no longer works because the reference is no longer available in VBA. The file still exists in my system folder, but when I try to add it to the references dialog, it tells me that it can't link to that file. Anyone know...

tblSundays - dates that are all Sundays tblDates - dates that occur any day of the week I want to count the total number of dates in tblDates that occur any time during the week (Sun-Sat) of each Sunday in tblSundays. Any ideas?

I know about TransferText - i.e. creating a delimited text file with values from a table. What I want to do is have VBA create a string (I can do that) and write a text file that is the string. In other words, VB creates the string: "This is a great Access forum" and writes a text file whose...

I have a membership db that links to pictures of each family. I am trying to add some links to families whose pictures I just received and all I get is an icon, not the picture itself. I do not check the "Display as icon" box and I have checked the properties for the picture and it says to...

I am trying to figure out the best way to store information. What I have is product that are priced differently at different quantity levels. I am going to want to access the information even in between the levels. In other words, let's say I'm selling frisbees and the pricing structure is: 10...

I have an IIf statement in a Union Query that has been working fine forever. (Isn't this always the way?!) On ONE user's computer, this IIf statement doesn't work (causes an error). I have checked the VB references and they are all there (although I had problems with a missing reference on her...

I have Visual Basic 6.0 and I would like to learn how I could make an .exe that would do something to an .mde (say, add a record to a table, or make a new query, copy in a new form, etc.) The idea is that I would like to be able to send a disk to a client that would upgrade their application...

I have some users that tend to leave Access open when they leave work. This obviously exposes our information to anyone that happens to sit down at that computer. (User-Level Security is set up) Is there a way to have Access close itself if nothing has happened for 30 minutes or so? Will this...

I'm sorry. I have tried to look this up and can't seem to find the answer to this question. It should be simple. In Visual Basic 6, where do you store the information? To use Access terminology, where are the "tables"? Thank you to anyone that can help.

I want to export a query to an HTML format. To use DoCmd.TransferText, it asks for a specification name. The help file says: "A string expression that's the name of an import or export specification you've created and saved in the current database." How do you create that?

I am getting a confusing message with this. I have a field that is a combobox on the form. I want to, under certain conditions, "undo" what the user has done (you will see what I mean in the code). When I run this, I get the following error message: RunTime 2115: The Macro or Function set to...

Can anyone give me a code that I could use to find the name (i.e. "HP LaserJet III") of the default printer on the computer? I have looked up the prtDevMode property and I just can't seem to get it. I only need the name of the default printer.