Search results

10 Columns are in a query, I don't use them all for a dropdown. Here is what I am doing...Using EmployeeInformationtbl (parent) getting 5 things: ID, Name, Position, Pay, Pay Method; then I want to select 2 dates...Then have a report show from EmployeeMetrictbl (child linked by Employee ID)...

Can I just have 3 queries one with the employee info, one with two date fields, one with the metrics (performance records) and then for the report on the form use those 3 queries to make 1? I guess I still have the problem of selecting the dates...Plz help!!! I'm lost!!!!

Allright, I have the query made in the combobox. I then referenced the 10th column (The one with your criteria) with the first and second date picker text boxes. Now when I click The combobox it asks for the parameters??? And another problem, the dropdown box is from one query and the report I...

Alright. Thanks so much for your help!!!! The only problem is that I don't understand all of what you are doing here. I need a report to open a form first? But i have a Form with dropdown that fills in my text boxes and 2 datetime pickers that are startdate and enddate. Can I do what you were...

Does anybody know how to have a text box on a form "satisfy" a parameter in a query? I want to enter two dates and have a subreport show information from them? (The records shown will only be between those two dates) How do I do this? (I don't want the parameter to pop up on form open)...

Doc Man, I sorta understand what you are saying. I am trying to break it down into as small of problems as I can. I am searching frantically on how to finish the things remaining for this database I have to do. Part of the problem is because I am a rookie at access, I don't know the lowest level...

this is my latest update on the db. On Forms I have the DateQueryForm and it is the "MainForm" in the forms page. It has the date as the form and the 3 tables as the subforms. The only problem is that I want it to have the main forms dates to be the subforms dates automatically. Don't really...

Yeah Access, I found it Thanks so much! It works now

I had an idea and I know u said u would look at it later but what do u think about this...Have 1 form (the date) with 3 tabs. On each tab control have a subform with the three tables? Will this work?

Thanks, I really appreciate it!:D

Here it is, It is not working but I am not sure what I am doing wrong. I have relationships made and forms made but they don't show anything.

see, I think I have tried that but it I couldn't get it to work. I had a Date table with a autoID as the key. When I would try to add a record in one it would say that I needed a record in a related table or something similar (I can't remember) I will try it again and let you know (I think I...

I have 3 tables Metrics, FixedExpenses, Variable Expenses, I want them all to have a date in a form, and a subform for all the records to be added. I want to be able to do this without having 3 seperate date tables linked to the other three tables. I am not sure how to do this correctly. (I want...

Where does this code go? in the queries, Ican only use SQL

Where does this code go? in the queries, Ican only use SQL

When all my queries run automatically how do I get them to automatically say "ok" to the boxes that pop up?

Brilliant!!! I got them all to work correctly. Thanks for your help!

HAHAHAHAHA I finally got it to work! All queries are up and running. Geez thanks so much for your help!!!!

Got it! Thanks. Now, I am reading (just bought access 2002 Developer's handbook set) and looking at update queries but I am not getting too far. I have 3 of 5 (i think 5) queries done. I have the append query that adds the records to the 2nd table "FixedExpenseReoccurranceTbl". I need the query...

I need an append query to also update a yes/no box or a text box with "yes" "no" in the field. I don't know how to do this in SQL. Please help. Query 1 is the name of the query I want updated from "yes" to "no" Something like: AFTER APPEND (I am not sure how to do the "after append" in sql)...