Search results for query: *

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

I have a table with several fields, but the one's in question are: NAME ID, PREFIX, LAST NAME, & SALUTATION I would like to fill the SALUTATION field by using the PREFIX and LAST NAME field--how can I do this? Beth **Learning Access**

This was GREAT!!! It worked perfectly! Thank's for the help! Beth **Learning Access**

I have a form, with a tab control on it with 4 tabs (Lists, Labels, Communities, Other). On each of those tabs I have a list box. In the row source of the list box I have the following Code (this one is for the tab called "Lists". All the reports I have begin with 3 letters...

The database will contain a list of registrants. All of the registration will be done through this database. What will happen is that we will mail to the entire database letting them know that we are putting the conference on, then people will register. At that time some people will register...

In the near future I will be designing a database for a conference that our company will hold. This conference will allow people to come in groups and pay a special price for those groups. I am trying to figure out what will be the best way to capture those groups. I think a group might have 5...