Search results for query: *

Hi - i have a data entry form in Access with multiple combo boxes. The combo boxes include code to automatically drop-down any time they receive focus. It seems that Access is automatically refreshing the forms on a periodic basis which causes the combo box to automatically close at undesirable...

Hi, I have a custom VBA function to constrain values to a user-specified minimum and maximum. The syntax is BAND(Value, Min, Max). If Value < Min, BAND returns Min. If Value > Max, BAND returns Max. If Value is between Min and Max, BAND returns Value. The function code is provided further...

Skip - i can post the code tomorrow, but it's long and ugly with many calls to separate sub procedures. Again - the problem exists with the simple code above. With each iteration, the Mem Usage grows... Sub MakeExcelBloat() Dim wkb As Workbook Do Until 1 = 2 Set wkb =...

Thanks vbdbcoder - i have tried "Set wkb = Nothing" inside of the loop and it doesn't seem to resolve the issue. One thing to note - when the VBA editor is open, i can see a new VBAProject open each time a new workbook is opened. When the workbook closes, the VBAProject does not dissapear from...

Thanks Skip - great question. I'm i'm hooking into Adobe's PDFMaker API to print the Excel workbooks in PDF format. Unfortunately, as part of the printing process, PDFMaker closes the workbook and then reopens it - destroying the object variable associated with the workbook. I then have to...

I have a sub routine that opens and closes another Excel workbook as part of a loop - for say 100 iterations. I'm running into a problem with "bloat" in the Excel application. Closing the workbook doesn't seem to free-up the memory - i monitor it on the "process" tab of the Windows Task...

I don't know what happened or what changed, but the file now seems to be processing just as quickly when the form is modeless. Thank you both for your posts. - Cory

Hi, I have an Excel workbook that allows a user to requery an Access databse, based on thier selection from a combo box on a UserForm. If the UserForm's ShowModal property is set to True, the requery/update macro is blazing fast. If the UserForm's ShowModal property is set to False, the macro...

I saved the file under a different name and the error stopped occuring. I deleted the original file and changed the renamed file back to it's original name and the error started occuring again. So, the solution is to rename the file to something different than the original name, and don't...

I double clicked the axis, went to the scale tab, and unchecked the "Logarithmic scale" check box. Is there another way to do it? Thanks! Cory

Hi All, I had a workbook with a log-chart in it and received an error message that said negative and zero values cannot be plotted on a log chart. I don't need the chart to display a log scale on the y-axis so I removed the log scaling. The error message still appeared every time i saved the...

That worked! Thanks so much! Cory

I'll try it out this evening and let you know how it works. Thanks Skip. Cory

Primarily number 1. Do I have to choose between 1 or 2? Can i get them both? Thanks Skip. Cory

Hi, I have an Access db that I would like to open each time i open an Excel workbook. As soon as I select "Open" on the "Unsafe Expressions Are Not Blocked" dialoge, the database opens and then instantly closes. Why does it keep closing on me? The code is below. Any help would be greatly...

Hi, I am printing an Access report to a PDF file and I would like to insert bookmarks into the PDF file programatically based on the value of a control in the report/recordset during report runtime. I'm using the Adobe Distiller to print the reports. I know Crystal reports has a print option...

Brilliant! That worked. Thanks!

Hi, I would like to create a simple report with a bar chart to show sales by team, by employee. The report is based on a simple table (T_Sales_By_Team). T_Sales_By_Team has the following fields: TeamName EmployeeName Sales I have created a report that groups on the TeamName field. I have...

Thanks! That worked!

Thanks! I think this will get me there. However, there is one complicating factor I didn't mention above which I'm having a little trouble with. Each of the 60 Excel tables have slightly different field names. They are in a crosstab format by year. For example, "T_Sales" has the following...