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 John Tel 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 DianeA

  1. DianeA

    macros in webpages

    Not familiar with languages other then the html at this point but i'll have to look into it more and other options. thanks for your assistance. diane
  2. DianeA

    macros in webpages

    how about html or xhtml? can you give me an example of what how the code would look like? thanks
  3. DianeA

    macros in webpages

    Can a button be used on a webpage which executes a macro when pressed? I want to be able to be able to push information into an access database based on the specific button which is pressed. diane
  4. DianeA

    SELECT * from problem

    I finally got it.. thanks for your help diane
  5. DianeA

    SELECT * from problem

    This worked great... i did forget to add the year though and obviously i am also having a problem with it. This was my best guess... sorry.. pretty lame StrQstr = "SELECT * from qryCSMCbyHourTTLS WHERE qryCSMCbyHourTTLS.qrymonth =" & PullMonth And "qryCSMCbyHourTTLS.qryyear =" & PullYear...
  6. DianeA

    SELECT * from problem

    Pretty green to coding but i have a simular macro running in excel which does the same thing except the WHERE stmt compares the field to a date variable. In this case I'm trying to filter out records from an ACCESS query with a particular month found in a specific cell in excel. Once found it...
  7. DianeA

    Missing: MS ActiveX Data Objects (multi-dim) 6.0 Library

    And / Where how do I change this? Diane
  8. DianeA

    Missing: MS ActiveX Data Objects (multi-dim) 6.0 Library

    I have an excel 2003 SP3 spreadsheet which has a script that dumps data into Access 2003. This has been working great until the other day and now we get an error which when I go to references I see "Missing: MS ActiveX Data Objects (Multi-Diminentional) 6.0 Library" . I uncheck this and...
  9. DianeA

    creating temporary tables

    I need some guidance as how to best approach my form. I have two tables (example only)... Table1 has a record for each hour of the day (Date, Hour,Factor)*Note: there is a factor for every hour Table2 has random records which need to be matched with Table1 and calculations made (Date,Hour,Qty)...
  10. DianeA

    Storing numbers until next record

    sorry... got it working.. thanks again
  11. DianeA

    Storing numbers until next record

    The function is working wonderfully.. thanks. Now... can I use that textbox in a calculation? I've named the textbox "Last" and used it to multiple with another field but I get #Name?
  12. DianeA

    Storing numbers until next record

    I've got a report which is generated from a query. For each record in the query I calculate Qty * dollars. But there are records which will have 0 in the qty so I need to use the last known qty for the next records until the qty is no longer 0. The total dollars are summarized. Not sure how...
  13. DianeA

    Excel Addins disabled

    Yes... i am using xla but for some reason I need to Uncheck (with false) and then Check (True) in order for this to work. Any thoughts? Diane
  14. DianeA

    Excel Addins disabled

    I was not initially able to get your stmt to work. I checked the Addin module to see what it was showing me and all applicable addins were checked already but not loaded. To resolve this I added the following: oApp.Application.AddIns("PI-DataLink").Installed = False...
  15. DianeA

    Excel Addins disabled

    How do you determine the name to use for the addin? Would this be like the executable name? I'm assuming i substitute my addin name for "Test".
See more

Part and Inventory Search

Back
Top