Search results for query: *

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

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

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

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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

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