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

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

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

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

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

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

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

3 Tables: Names2, State, Country Names2 has a State and Country Field that need to be lookup fields to lookup the state abbreviation and the country abbreviations State: StateID,Abbreviation,STATE Country: CountryID,Abbreviation,COUNTRY The Names2 table already has 4800+ records. How do I...

3 Tables: Names2, State, Country Names2 has a State and Country Field that need to be lookup fields to lookup the state abbreviation and the country abbreviations State: StateID,Abbreviation,STATE Country: CountryID,Abbreviation,COUNTRY The Names2 table already has 4800+ records. How do I...

I have a form, with a tab control, with a list box. In the row source of the list box I have the following code: SELECT [Name] FROM msysobjects WHERE ((([msysobjects].[Type])=-32764)) AND ((Left([name],3)="lst")); This code is to pull up all my reports that have the prefix...

I have two tables "Cities" and "Counties". I would like my form update the County field when I enter a city that is in that county. For some reason I am just stumped and can't figure it out. Can someone help out? Beth **Learning Access**

I have several reports that I feel go into different categories. I want to use a tab format on a form to separate them into their categories. I would like each tab to have a list box and in that list box I would like to have a list of reports in that category that can be opened. I tried...