Recent content by jboomer

I need to right a query that list items with matching fields. So I have a database that list a bunch of colors. The database looks likes this: ID Color 1 Black 2 Red And then another table list a bunch of product like this: ID Product Color 1 Tee- Shirt Red 2...

Is there anyway to use this in a query instead of a form or report?

Im not sure how to do it right now this is what i have and i'm not use what i'm missing: Dim db As Database Dim rst As Recordset Dim strSQL As String Set db = CurrentDb() strSQL = "SELECT * from [Table]" set rst = db.openrecordset("Table") with rst msgbox .fields(10).name & ": " *...

I am wanting to use it in a query not a measagebox? would i still use this?

how would i do this in the query view since i have to use SQL?

I'm at my wits end tryting to figure out how to get this to work. I am trying to build an access database that looks at an outside csv file. The CSV file gets updated by an out side piece of software and the data in this tab;e looks like this: SKU | 7-25-2010 | 7-26-2010 | 7-27-2010|...

I have attached a rough of the database and what i would like to see. please help.

Ok this is what i got i ahve a database with 5 fields. ID, Product, description, SRP, SELLING price. Really super simple. Then i Have one unbound form that has 10 combo boxes all labeld product 1-10 and looking up the Product and ID from the table above. I want to put a button at the bottum...

A list box that displays all the records for a particular student. There is a subform on the page as well that has detailed information. The List box source is: SELECT [Record Review].[Record Review ID], [Record Review].[Record Review Item] FROM [Record Review] WHERE [Record Review].[Student...

HOW DO i CREATE A ForeignKey field ?

Relationship There are Many tasks to one meeting. baiscally when having a meeting tehere will be 3-5 tasks per meeintg.

I have created 2 tables (Meeting & Tasks) in the meeting table i have a record called Meeting tasks that references the id of the Tasks table. I want to create a button that will create a new Task record in a new form and that it will be assigned to the current meeting. Anyone got any ideas...

I tried that. The List box behaves the same way. Maybe i didn't make myslef clear. the list box in the form. still shows all records from the IEPTasks Table. but i only want it to the tasks from the IEPTasks Table where the [IEPMeetings].[Meeting Task.Value]=[IEPTasks].[TaskID]. But te...

Not sure what you mean. I tried to creat a lookup on the meetig table to the task name and it has the same problem. The list box show all records in the IEPTask Database.

Hey guys i need some help i am almost finished with a datbase but can't seem to get the filter to work. Here is the deal I have 2 tables: First table is Called "IEPMeetings" and the second is called "Tasks" Each table has an ID field that coresponds to the table, such as "MeetingID" and...