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 VBAPrincess

  1. VBAPrincess

    Opening Excel template opens 22+ windows

    OMG this turned out to be the dumbest thing ever. I moved the oExcel.Visible = True to the beginning of the procedure rather than at the end (where it was so the user wouldn't have to watch the fields getting populated) and the 22 extra windows stopped appearing. WTH?! So, how did I figure it...
  2. VBAPrincess

    Opening Excel template opens 22+ windows

    Yes, when I manually open it I do not encounter errors. I can manually enter data -- the same data the Access code would enter -- and it works just fine. Love it when stuff stops working. Diana
  3. VBAPrincess

    Opening Excel template opens 22+ windows

    No events in the ThisWorkbook object either. I have another process in the database that populates an xlsx file with data and it works just fine. The only differences between the two processes are the type of Excel file -- xlsx vs xltm -- and one populates data from a recordset while the other...
  4. VBAPrincess

    Opening Excel template opens 22+ windows

    Skip, I've checked all of the worksheets and the only event code is on the Worksheet_Change event for a different worksheet called IM_Rater. Diana
  5. VBAPrincess

    Opening Excel template opens 22+ windows

    Andy, Thanks for the suggestion. I tried with a simple xlsx file (I just saved a blank copy of the template which also removed all of the macros from the template) and the same thing occurred. I was really hoping that would solve the issue. The template is not ours but rather it is one...
  6. VBAPrincess

    Opening Excel template opens 22+ windows

    Our company is upgrading all user computers to Windows 10 with Office 2016. I have an Access database (mdb) that has code to open an Excel template (xltm), populate data, and then allow the user to save the file. The code worked fine on Windows 7 with Office 2010. Now, when the code opens the...
  7. VBAPrincess

    Subform totals not working

    Thanks MajP! The totals are calculated controls -- each box has a formula like =SUM([PriorYrTotal]). I finally got it working! I tried using NZ to force a zero but it didn't seem to work. I then recreated each subform in 2010, and included the nz function, and then it worked on all but one...
  8. VBAPrincess

    Subform totals not working

    I have an Access 2003 mdb that I created for a client at least 10 years ago. They've asked for some updates and now I'm trying to make changes to the forms. After I began making changes, and saved those changes, the totals at the bottom of the subform (in the form footer) stopped working...
  9. VBAPrincess

    VBA to change Application Icon in MSAccess

    I don't use workgroup permissions so I can't test what I'm going to suggest to you. Your SetAppIcon sub uses Set db = CurrentDb. Change it to: Dim wks As DAO.Workspace Dim db As DAO.Database Dim prp As DAO.Property Set wks = DBEngine.CreateWorkspace("", "AdminUserName", "AdminPwd") Set db =...
  10. VBAPrincess

    ADD a TRUE FALSE Field via ALTER TABLE

    See if this works. ALTER TABLE BALBILL ADD DeleteRow YESNO Also, your YesNo field may not be formatted. This might not bother you, but if it does, you can use DAO to add a format. HTH Diana VBA Princess -- I'm hoping to grow up to be a Goddess!
  11. VBAPrincess

    form footer total not working

    Sorry it's taken a while to respond Duane. (I finally just wrote code to make the subform total the values in the textboxes each time something changes.) To answer your question, the field is a currency data type. To add more to this problem ... I have actually had this same thing happen in...
  12. VBAPrincess

    vba drops/aborts when underlying query/recordset joins an additional query

    Can you edit the data manually when you run the second set of queries? the ones with red in them? If not, there's your answer. The outer joins are not allowing you to edit the data and that's why your code aborts when you try to do the edit. HTH Diana VBA Princess -- I'm hoping to grow up to...
  13. VBAPrincess

    Error 1004 opening Excel file from Access

    Ok, I've got a really weird issue here... I have code in an Access 2010 database that looks to see if an Excel file for a particular account exists, and if it does, it opens the existing file. If a file does not exist, a new one is created from a macro-enabled template. The original...
  14. VBAPrincess

    form footer total not working

    Sorry Duane! I've been on vacation and didn't get this uploaded before I left. Here's the SQL behind the form: SELECT Buildings.CodeKey, IIf(IsNull([LocationNumber]),99999,[locationNumber]) AS Expr1, Locations.LocationNumber, Buildings.LocationID, Buildings.BuildingNumber...
  15. VBAPrincess

    form footer total not working

    Finally got the calculations to work but had to use DSUM instead of just SUM. I found another thread on another site where someone was able to get AVG to work but not SUM, but AVG didn't work for me either. =DSUM("Premium","qfrmBuildings","CodeKey=" & [CodeKey]) As a side note, on my main...
See more

Part and Inventory Search

Back
Top