Search results for query: *

OK, I bascially got this to work by removing "Application." My next question... I have navigated down to the appropriate subfolder in Public Folders, and within that subfolder I have a single Excel file that I now want to open. Something like: Set openwb = Workbooks.Open(Filename:=vPath &...

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...

OK, not too elegant a solution, but what I figured I could do here is simply create a saved query that would return distinct Cust ID's and pass parameters from the form to it. Then, in my code, I could create my recordset directly from this query, and tally the counts from there. Problem now...

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?