Recent content by bgibsonIYD

I have a table Names which has the look up field State. The look up table has the following fields: StateID, Abbreviation, State The StateID field is the primary key. When I merge the document into Word, the StateID shows up rather than the Abbreviation. How can I get this to show the...

I need to be able to track years for a campaign. Each person in my database is in the Fall 2000 campaign (what we are starting with). We will be getting new names for the Fall 2001 Campaign soon. Some of those names I will already have in the database, and some will be new names. I would...

Jeff got it! :) I knew it was going to be something as simple as that also! Ugh! Thank you Jeff! Now I feel dumb, but that's okay. We learn from that sort of thing right?! :) Thanx for your help everyone! Beth Beth **Learning Access**

The debugger goes to the line: rptName = Me.PreReg.[Column](1) There is no other code involved, just the double click even for each list box. Yes the list box fills with the correct report names. Yes I know that they are 0 based, and that column one is really column 0, which is the...

I have a form called "Report List". The form has 3 tabs, and on each tab is an unbound list box. I have filled the list boxes RowSource with the following code: SELECT Right([name],Len([Name])-3) AS NameWithoutList, [msysobjects].[Name] FROM msysobjects WHERE...

None of the above worked. I have found that I can enter the information in the Main address form, and it saves, but I still get an error message saying "Microsoft Access might have encountered an error while trying to save a record. If you close this object now the data changes you made...

The following is the code that I have on the "OnClick" event of the Register button on the Main address form. Is there any other code that you need? Private Sub cmdRegister_Click() On Error GoTo Err_cmdRegister_Click Dim Value1, Value2 As String If...

I have a registration databaase that I am creating. It was working fine until Tuesday--then saving the records went haywire. I have the database set up like this: Form Main address has all the contact's information, then it has a "Register" button on it, where the Registration form...

I have a form called "Totals", with the fields: TOTAL AMOUNT DUE, AMOUNT PAID, and AMOUNT NOT PAID. I want these fields to be filled in by another form "Registration". The fields to be used are REGISTERED (checkbox), REGISTRATION FEE (listbox), & PAID (checkbox). The TOTAL...

I have a form called "Totals", with the fields: TOTAL AMOUNT DUE, AMOUNT PAID, and AMOUNT NOT PAID. I want these fields to be filled in by another form "Registration". The fields to be used are REGISTERED (checkbox), REGISTRATION FEE (listbox), & PAID (checkbox). The TOTAL...

The NAME ID field is a number. Okay, now I have entered the =forms!Main Address![NAME ID] so it will fill in the name id, but when I go to enter a new record in the registration table I get the following error: You cannot add or change a record because a related record is required in table...

I have a form "Main Address" and another form "Registration". On the "Main Address" form I have a button cmdRegister that I would like to open the "Registration" form with. I would like both forms to have the same NAME ID field, and have it carried over...

Okay--now I got that code to work. I wasn't reading the code right. But, now i'm getting the message: "The OpenForm action was canceled" Suggestions? Beth **Learning Access**

I am still getting the same error message. This code works fine with a click event that I have on a command button on another form. I dont understand why it's not working here. Beth **Learning Access**

I have a form "Registration" and a list box on the form [GROUP ID]. I would like the user to be able to double click on the [GROUP ID] field to pull up another form called "Group Members" with the corresponding record. I have the following code: Private Sub...