Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by getrighteous

  1. getrighteous

    Accesing Exchange Public Folders via Excel VBA Script

    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 &...
  2. getrighteous

    Accesing Exchange Public Folders via Excel VBA Script

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

    locking application during update

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

    updating values in a subform

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

    updating values in a subform

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

    exporting an Access textbox value to a cell in existing Excel file

    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?
See more

Part and Inventory Search

Back
Top