Search results

I am trying to make a chart that shows when people have been scheduled. I want it to look something like this: 2/12 2/13 2/14 2/17 2/20 2/23 2/24 John Schd Schd Schd Laura Schd Schd Schd Lori Schd Schd Schd This would do...

is there a way that I can compare the ID number from a combo box selection and a table... in order to avoid duplicating that same entry? ie If me.cbo1.column(0) = [table name].[field] then me.cbo1.column(0) and me.cbo1.column(1), etc... = vbWhite End if What I am ultimatly trying to...

I have a table that has 300+ peoples names on it. Each of these people has a region they belong to 1,2,3,or 4. I also have a form that has 3 combo boxes that are linked to this one table. This information is sensitive and can change by importing new data as well. Is there a way that I can add...

They are dates... but what needs to be enclosed in #? Could you elaborate a bit please.

I have a form that has four combo boxes, one for events and the other three for different people. the event is selected and then three people to work that event. Each of these people have a cell of information on the database that has "unavailable dates". I am trying to make it so that if the...

MS Access 2007 I have a two tables that I am working off of. I choose a person from one table and a place from another, both from a lookup column. I need to know how to gray out (or something along those lines) the place that I choose so that it can't be chosen again. Is this possible, and does...

Follow up Question Thanks! That did what I wanted it to do. Now I have one more question that relates to this. I got it so that the combo box shows the lastname, firstname. Is there any way that i can regress back and when I export the data from that table for it to export it in the form of...

I have a lookup colum in my datasheet. Is there any way that i can change the properties so that I can view both the first name and the last name in the same box once it is chosen. Currently in design view I have a column for first name and a column for the last name. When I choose a name from...

I have a huge problem with MS Access. I am trying to develop something that uses databases, but isn't data entry. Currently I have a list box that has several columuns/rows populated with dates and locations. I also have a two combo boxes, both filled with peoples names. Both the combo and list...

I have one table that relates to the events(has all of them listed in the table and then connected to the Events listbox). I have another table that has all of my official's names and information in that. Then in the subform I have a blank table that has the headers of the events table and...

I have a form that has a list box with events in it. On the same form I have two combo boxes, each with the same information; officials names. I added a subform to form1 and I want this form to store and display the information that is chosen(officials and events). How do I make this happen? It...

What I am doing is assigning people to different events. I have a list box with the scheduled event and subsequent info and a list box with the people's names and subsequent info. I need to know how to select data from the events list box and from the officials list box(I can select it already)...

I have three list boxes. Two of them has data from a database in them. I want to chose one piece of data from one index, and choose two pieces of data from the other list, and click a button to send it to another list(database, that would later be exported to excel). Does anyone know how I would...

I have made a query for each column in my table in order to sort by ascending order. I want to assign this Query to a column heading button on my form. What is the code, or how do I go about assiging this query to this button so every time it is clicked the data is sorted according to what that...

Currently I am creating a form in Access 2003. I have a table that I has 7 column headings, events, location, date, time notes, classs, and region. I need to know how to sort these columns by clicking on a button that will be assigned to that column or by clicking the column header? This needs...