Recent content by Diango

Thanks for all your help. Everything seems to be working beautifully now!

thanks, I'll try this out now. I'm not sure if I have to requery, but we'll find out soon enough :)

None of my controls are bound. The way I'm able to insert the new value from the textbox into the database is by using the CurrentDb.Execute Command. The ComboBox gets its data from the RowSource property that I have attached to a query. So Once I enter a new value into the textBox and I run...

I have a comboBox which has Degree types, when I drop down the comboBox and I select one, it shows in my TextBox What I want is the following: Right now, through the same TextBox I use I'm able to enter a new Degree Type into the database. But what I haven't been able to do is that I haven't...

Why doesn't this work? qResult = DLookup("ID", "tblEmployee", "[DateEntered]= 11/8/2007 9:38:53 AM") That date is the exact value that's in my DateEntered Field(text value field)

I'm trying to get the following SQL Query result into a TextBox. This is my Query: SELECT ID from tblEmployee Where DateEntered IN (Select Max(dateEntered) from tblEmployee) ; I know that to get a single result into a textbox I would normally use DLookup, but I don't think DLOOKUP allows...

I created the new table with the LetterGrade and Number Values. I created a Derived Table which joins the original table to the LetterGrade Values table. Then I did a left join with the original table and the derived table. That seemed to do the trick.

I want to add the values based on the student ID. It's not really adding the entire column, but it's adding those grade values based on each student ID.

I'm trying to add a set of Nested IF statements, but it's not showing me the proper result. I have a table which shows the classes that each student has taken based on the term. So I change the letter grade they receive to a numeric value, once I get that, I need to add those numeric values...

Weird, I'm still getting the same error.

This is the code I have to run that query and it's coming back with an error, something about canceling the previous operation. Private Sub cmbID_AfterUpdate() Dim strQuery As String Dim Value As String Value = cmbID.Value strQuery = DLookup("[2007_Term_GPA]", "Undergrad", "ID=" & Value) End...

How do I place that in a TextBox? Is it better to use DLookUP to query a table rather than CurrentDb.Execute?

I would like to run a query where I have a comboBox that carries ID's, if I select an ID, then I want to be able to use that selected ID to perform a Select query which will show the results in a textbox.

Cool thanks!

I guess my question really now comes down to How can I write a query to pickup the ID from the textbox and to show the result on the other textbox?