Search results

What I am ultimately attempting to do is create a list of chapter members and officers without duplicating. Let me explain how the tables are organized. There are 5 tables pertinent to this process. Please note that I am not able to change the structure of the tables without destroying...

I have a multiselect list box and I would like to place a button below it that will clear the highlighted rows when pressed. However I am having difficulty figuring out the code to place behind it. Can anyone help me with this?

I am having difficulty appending records to my tables becaue of validation rule errors. I have recieved a complete list of newspapers, radio stations and television stations for my state from another company. The list was originally in an excel spreadsheet so I imported it as a new table. I...

I have three tables in my database. Personal Information -------------------- Personal ID Name Address Phone Attendance ---------- Personal ID Event ID Events ------ Event ID Event Name Date The obvious fields relate to each other. What I need to do is query for people who attend one...

The objects used here are: polLabels, a button, PoliticsSelect, a list box, and Branch, an option group. The idea here is to open a selected report and apply a filter based on whatever is selected in the option box The problem exists with the following two lines DoCmd.OpenReport "Address...

I have a database with three tables. People, Events, Attendance. The tables are set up as follows: People: People ID - key Name Address Events: Event Id - key Event Name Date Attendance: People ID - key Event ID - key Of course the obvious fields link to each other. What I would like to...

I currently have a form "client information" with a subform "catagories." Of course, a client can be a member of several different catagories. One catagory in particular "Chapter Member" can have many different attributes to it. I have created a button that will open second form when pressed so...

I currently have a form "client information" with a subform "catagories." Of course, a client can be a member of several different catagories. One catagory in particular "Chapter Member" can have many different attributes to it. I have created a button that will open second form when pressed so...

What am I doing wrong here? I am trying to create a data lookup that will return the county when I enter the zip code. I have a table with information on our clients, names and addresses and phone numbers) and a table that contains every zip code in the state and the counties that the zip...

I am attempting to make a macro that will check data in a subform for a specific value. The macro I have is: Condition: [Forms]![Personal Data Entry with Senate and House]![Category Link Subform1].[Form]![Category ID]="FRI" Action: MsgBox Message - Data Found Condition: ... Action...

I would like to make labels featuring the return address for my company. How can I set up a report that will print multiple labels of the same record without having to run the report over and over again. Also is there a way to specify how many copies I want?

How do I prevent my forms from maximizing to fill the whole screen when they are opened? I would like for them to open to the size I specify.

Can I have a query find all duplicate recors in a single table? If so, how do I do this?