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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  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

    ...we need? 4 sState = GetDomicileState(lngCK) 5 If sState = "CA" Then blnCA = True 6 sExistingFile = DoesFileExist(strPolicy, "xls*", WSPath) GetWSForState: 7 If sExistingFile <> "" Then 8 Set oWB = oExcel.Workbooks.Open(sExistingFile) '<-- Error 1004: Select...
  14. VBAPrincess

    form footer total not working

    ...Buildings.OperationClass, Buildings.Coverage, Buildings.Value, Buildings.Deductible, Buildings.DeductibleFactor, Buildings.Rate, [DeductibleFactor]*[Rate] AS NetRate, Buildings.Premium, Buildings.BuildingArea, Buildings.BuildingRoofConstruction, Buildings.BuildingYearConstructed...
  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...
  16. VBAPrincess

    form footer total not working

    I have an Access subform which has totals in the footer. The calculated field should display the total premium for the displayed account. The subform has worked just fine until we moved to 2010. However, I have two employees using Citrix to access the database. When they view the form the...
  17. VBAPrincess

    Excel 2010 InStr function problem

    PHV: I tested in the immediate window like so -- ?strCheck and ?cell.value, then I tried ?Instr(actual values returned in window for strCheck and cell.value) Thanks for the suggestion and I'll have my colleague try your suggestion. vbajock: We'll have to try it in reverse and see what happens...
  18. VBAPrincess

    Excel 2010 InStr function problem

    I was helping someone add the final touches to a long process and ran into a strange problem with InStr. The long process included a macro which is filtering data raw data by client and copying the data to a new worksheet. On the new worksheet, a pivot table of the pasted raw data is created...
  19. VBAPrincess

    Excel data connection refreshes but data is not updated

    Skip: yes, all are coming from the same database. Geoff: I was hoping for #3, even though you said it was a long shot because I'm quite certain I'm pointing to the right database (there's only one I can point to with this information) and the name of the query is correct. I've even gone so far...
  20. VBAPrincess

    Excel data connection refreshes but data is not updated

    Really? ... Well that is exactly what I've been doing OVER and OVER but the data is NOT refreshing, hence my post in this forum. By "adding the data connection back in" I meant that I started over from scratch. I deleted the data table in Excel which had a connection to Access. I answered YES...

Part and Inventory Search

Back
Top