Search results

Alright, I'm trying to tie my text boxes to the table. I have Textbox1 and under it's properties I put the following in the Control Source property: =[tblInputForm]![Field1] and I get #Name? in all of the text boxes I did this for. I thought this is what "bind the form to the table" means...

Yea right now I'm trying to tie my input text boxes to the tblInput. I'll see what happens and I'll get back to you.

Okay, Input: employeeID Query 1: SELECT FirstName, LastName, JobNumber FROM tblEmployee, tblInputForm WHERE tblEmployee.employeeID = tblInputForm.Input so if Query1 Returns FirstName: John LastName: Smith JobNumber: 012345 This is another table: JobTable JobNumber: 012345 JobName...

Okay that makes sense and yes the tblInputForm will only have one row. This is kind of different but relates to the last SQL statement you typed. The results of the query below we'll name it Query1: SELECT... FROM MainTable, tblInputForm WHERE Maintable.FieldName = tblInputForm.LookUpField...

Okay and how would I query based on what's the in the temporary table? Right now I have it set up like this is my main query Like [Forms]![Form1].[LookUpField])); Can I just change the like statement to [Tables]![tblInputForm].[LookUpField]

Hey, I have an input form with about 8 text boxes on it. I want to store the values from the 8 text boxes in a table so I can access the values later. I have a table called tblInputForm that I want to store the data in. When I click a submit button how do I store the text box values into the...

Hey Guys, I've been putting a post in each section of this forum the past few days as I learn Access. But, you guys have been helpful since I am ready to generate reports based on my queries. Here's how my application is laid out: Form1 - get 3 user input values, calculate a value, and do...

Okay I've thought about making just a measurements table similar to the one you have described. That might be what I have to do. I'll explore this more later on tonight and get back to you guys in the morning. In the meantime, if anyone has links to articles that talk about using forms and...

Well 2 of the 3 inputs are going to be from a drop down list. Looking at my tables more closely, I recognized that the 3 tables use similar field names so drop down menus will probably help me eliminate the problematic nature of entering a field name. 1000 will be a measurement in mm. If the...

Hey guys, I know how to do this is Excel but don't now how to convert to Access yet. I have a table named Number of Parts that looks like this: PK | 1000 | 2000 500 | 67 | 75 650 | 72 | 80 How would I write a query to return the value 67 if I have the...

That video is excellent. How would I store the 4th variable though. How would I tell it to multiple the 3 inputs together and store that number somewhere so that I can generate a query?

Here is my problem. I have a database with 7 tables. I need to extract information from them based on input a user enters. I'm going to have 3 text boxes on a form. The first two get multiplied and divided by the third to come up with a look up value. The fourth value that is generated will be...