I am trying to write a VBA script in Excel that will allow me to access other spreadsheets that have been posted to a Public Folder in Exchange. I have researched this for a long time, tried some code samples, but nothing seems to work.
Here is where I am at currently:
Dim objNS As...
I have created an networked Access application that allow users to view data coming from another Access database via linked tables. The users do not add any data to either database in the process, all data is read only. The data in the "data" database (where the data files are...
I have a main form where users can select a variety of selections via checkboxes, comboboxes, etc. The results of these selections are then collected into a single SQL statement, the database is queried, and results are displayed in a subform via setting the .RecordSource = strSQL. Right now...
Let's say I have a spreadsheet called "Excelfile.xls" and an Access DB form with a single textbox and a submit button. How can I copy the textbox entry to cell A1 of the spreadsheet when the submit button is clicked?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.