Search results

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

Urgent I have been beating my head agianst the wall trying to get this to work to no avail. If anyone would be willing to work i will let them have access to the database and possibly pay. I am desperatly needing help I need to have this database done before next week. Also i am wanting to...

I have attached the database As you can see in the database between the two records the check box will become checked or unchecked. Not sure how to filter it? Please advise.

I am having problems with a Form. Let me xplain what i have going on. I have 2 Tables One is called tasks and one is called meetings. I have a fiels in my meetings table called tasks which is a lookup to the task ID in the task table. I have it set for multiple values as i will have many...

I have a contact for For paents everything works except for the Go to drop down. Here is the row source for the drop down: SELECT [Parent ID], [Parents Name], [E-mail Address] FROM Parents WHERE [Parent ID]<>Nz(Form![ID],0) ORDER BY [Parents Name]; I have included 2 pictures of the macro...

I need to creat a global Name Query. I have 4 Tables. Each table has a Unique Name and a name Field, Such as: Table: Parents Field: Parents name Table: Students Field: Student Names I need to Create a Query That just has one Field Call Name. And i need it to pull all the names from the...