Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bgibsonIYD

    Merging look up fields from access into MSWord

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

    Track years

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

    I have a form called "Report List".

    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**
  4. bgibsonIYD

    I have a form called "Report List".

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

    I have a form called "Report List".

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

    Form is not saving--dont know why!!! HELP!!!!

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

    Form is not saving--dont know why!!! HELP!!!!

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

    Form is not saving--dont know why!!! HELP!!!!

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

    Need help with totals

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

    Totals on a 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...
  11. bgibsonIYD

    Problems opening form with a command button

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

    Problems opening form with a command button

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

    Open a linked record/form with double-click event

    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**
  14. bgibsonIYD

    Open a linked record/form with double-click event

    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**
  15. bgibsonIYD

    Open a linked record/form with double-click event

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

    I have a table with several fields,

    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**
  17. bgibsonIYD

    Double Click event in a list box to open a report

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

    Double Click event in a list box to open a report

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

    Need idea's for Conference Registration

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

    Need idea's for Conference Registration

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

Part and Inventory Search

Back
Top