Search results

In the AfterUpdate event of the combo box, set the focus on the control you want if the combo = no. (By the way, if it is a Yes/No choice, why are you using a combo box and not a Yes/No field?) If Me.cboComboName = "No" Then Me.txtWhereYouWantToGo.SetFocus

Thanks. That did it. I tried to cut and paste only the code I thought I needed, but I ended up just importing all 5 modules into my database.

I found that link and have read it a few times. Something just does not compute (literally and figuratively!)!

There are a couple of ways to do this (This same type of question has been posed a lot around here lately!): 1. Use a subform based on the combo box 2. In the AfterUpdate eventof the combo box, put the following code: Me.txtDuesOwed = Me.cboMemberType.Column(2) (Remember - columns are...

Why don't you use Access User-level security? That is exactly what it is designed to do and there is a wizard to guide you through it.

I am running Windows 98, so I don't know if that would help. You are right though, it seems that this should be easy!

If Len(Me.txtYourInfo) < 8 Then MsgBox("You need at least 8 letters.",,"Invalid Entry") For i = 1 To Len(Me.txtYourInfo) Select Case Mid(Me.txtYourInfo,i,1) Case B, H, X, D, T Case Else MsgBox("You must have only a B,H,X,D or T as letters.",,"Invalid Entry") End Select Next i

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.

If you do figure it out, let me know. I would love to file that away for when I need it. As for populating a table with an array, you would cycle through the array and use the .AddNew function for the table. It would look something like this VERY oversimplified example: For i = 0 to ArrayCount...

I think SQL (as you are trying to do) is the way to go. Unfortunately, I don't know SQL too well and am not exactly sure how to implement it like you are talking about. What I think you would do is, when you add a record, use the SQL statement to find the greatest number according to the...

I suppose a query is a 3rd way to accomplish this. I had been using the combo box idea listed above, but because the user does not choose who the record is associated with, the database spent time filling a combo box that was unneccessary to fill. Pat: would a query be faster (or "better")than...

I have often wondered the same thing but haven't needed to do it, so I haven't looked into it. One solution, however, would be to create a table, place the information in the table and print the report based on the created table. You could always delete the table right after printing if you...

There are a couple of things to talk about here. Without knowing a little more information, it is tough to give you a complete answer. The first thing I would say is that the best database designs do not repeat information. What I mean by that is, rather than include the FamilyID as part of the...

Sorry. Here is the story: Table 1 has: ID...Name 4....John Smith Table 2 is a linked table with other information (say, John Smith's orders). So table 2 only lists John Smith's primary Key (4). When viewing the orders table (in a form), I want, when viewing John Smith's order, to show his...

I figured it out. There is a TextWidth property that answers exactly what I was looking for: how wide is the text with the formatting as it is? It is measured in something called "Twips", which is 1440 twips = 1 inch. With that in the OnFormat event, I am able to diminish the font size if the...

Is there a way, in the OnPrint or OnFormat events, to retrieve the Top property for a control to find where it is located vertically?

OK, problem. The number of letters is not relevant because the different letters are different widths. So I can fit 50 'i's in there but only 24 'T's. I need another way to figure out whether the data is too long for the text box.

I have tables that are linked to my main tables by the primary key. The main table lists the person's name, but the "secondary" table (because it is linked) only lists the primary key. What is the better way, when viewing the secondary table information, to have the person's name (from the...

Thanks. I'll try that. By the way, if I put that code in the OnPage event, would it adjust each record individually that it prints (i.e. diminish the font size on only those records whose data was too long)?

I have a report that prints the name and address of a person onto a postcard. I have the CanGrow property set to Yes so that if someone has a long name, it won't get cut off. However, it looks kind of dumb: Mr. and Mrs. John Smith Is there a way, perhaps through the OnPage event, to find out...