Recent content by wchitamb

Thanks.i ended up having a text-box and a button (behind the button was a query that read the parameter on the text-box) and run the query to display the results

I have a textbox & a button on a form and would like to search a table. and have the result either on a subform or excel. with the code below nothing is happening. Private Sub Command114_Click() Dim strSQL As String Dim strMyString As String Dim rs As DAO.Recordset strMyString =...

Thanks i am missing the bit where i want to rename the file using the excel value in cells A1 & B1

I am trying to have a upload feature that allows the user pick a file (excel) from any location/ folder on their computer and the database will record the file path and store in a variables, rename the file (eg TestFile.xlsx- a generic name that i will use on the import) then move the file for a...

Thanks it worked, I had a typing error on my form name. when i did the copy and past it work. Thanks so much.

Hi guys ,How do I run a query based on a result on a form (unbound text) I have a database that I have created and I have a result on the form and I want to click a button that runs query based on that result... how best can I do that? If I click on the button I want it to return all products...