Search results

I have a form with an unbound Listbox that finds a record on a form. When you select the Company Name, the two subforms show the records associated with the selected company name. The listbox contains thousands of companies. I would like to be able to enter text into a textbox that filters the...

I would like to write an INSERT INTO SQL that contains both a variable and field reference. Something like this: "INSERT INTO Table1 ([Field1],[Field2],[Field3]) SELECT " & Var1 & "([Field2],[Field3] FROM Table2 WHERE [Field4] = n" Is something like this possible?

I have a form with a list box in it. I also have a button that deletes a record out of the table depending on whatever is selected in the list box. The issue I am having is when I return to the form after the code has run, and I choose another option in the list box, it says, "The data has...

Hey, I am still learning the syntax in VB. This is saying that the types don't match up. CurrentDb.Execute "DELETE * FROM ItemList WHERE ([ItemKey]= & Me.ItemKey & )" ItemKey is a number. How would I write this?

Is there a way to make a form in datasheet view reverse direction. So the newest entry is at the top? That way, everytime I load the form the most recent entry is visible and it is ready for a new entry. Right now I have to scroll through all the entries before I get the new one.

I have a main form called OvenCodes. It has a subform called sfrmOven1. I need a control in the main form that calculates an average of 5 fields in the subform. The text boxes in the subform are these: GlossA GlossB GlossC GlossD GlossE I need something like this: =Avg(Forms!sfrmOven1.GlossA...

I have a table with a DateTime field. I would like to create a query that queries only the 3rd most recent record in the table. So there would only be one record per ID. If there is only two records for an ID, it would show nothing. I have tried a few things already, but none of them have worked...