Search results for query: *

Thanks all, I haven't tried your suggestions yet but will in short order. I just want to clarify. When I said that the quit statement was the problem statement I meant that it wasn't getting rid of the process in task mgr (memory leak). When the code runs for the subsequent XLS files to be...

I have a routine that opens an Excel 2003 workbook, retrieve some custom properties and loades to memory for use, then closes the Excel workbook. When there is only one workbook to check there is not a problem because when the access appliation is closed it kills the specific Excel process...

PHV, Thanks for your comments, actually the first thing the application does is run the routine that defines the errors, so that the constant (vbobjecterror) has all the errors already added to it. The conditional is in the raising of the error, when an appropriate Status is not detected the...

Greetings, I have an application that I am trying to create some error handlign. I raise an error 513 when the status in the properties of a particular file is invalid. And a nother error is raised (613) when the version of the template (xls) file isn't the same as the access database version...

I have a template that does some checks to make sure the user has the right version and that they are running it from the right directory. It needs to be in the correct directory because it must work with the right databse. The code in my template checks the properties to get the current path...

Not sure why it would matter, but in column AB & AC is a range called Ccd In column AB is a list of the codes: AE00 AE01 AE02 ... In column AC is a list of their values or descriptions Small Hand tools Hand tools over 1000.00 value Hand Held Power Tools the combo boxes populate just fine that...

The comboboxes are added to the spread sheet from the Control toobox toobar. I right click on the combobox and select Properties from the pop up menu. Properties dialog opens and in the property titled "Listfillrange" Identified the range name of in the spreadsheet that has the fill data for...

sorry skipVought, I meant to replace that with, "It doesn't have prefilled formulas in unused rows, but it does have data in hidden columns that fill in down thrugh unused rows. they are used to populate the combo boxes". S J E If I am not learning, then I am coasting, if I am coasting I must...

it does I figured it out. it was reading the hidden columns used to populate my combo boxes. I got it to work using some of what you gave me plus some of my own logic. see below: 'Initialize variables blnkrow = 1 rowcnt = 0 lastrow = 0 'Find the last row of data Do...

SkipVaught, Thank you for your input, I actuall just figured that out about Set myRange = Worksheets("CTRL m TO PROCESS").Range("B1:B15") lastrow = Application.WorksheetFunction.CountA(myRange) I understand your point, column B is required, but if they meant to use row 10 for example...

SkipVought, See the code in my post for LastRow# = ... in the comment it is "Method 3" and "Method 4". Both methods returns only a 1 even though I have data from rows 1 - 7 of column B. Yooneek, Thanks for the sugestion, but it didn't work. The spread sheet has 100 rows where there are combo...

I have a spread sheet that I need to run some data validations for. I am checking to see if a particular column is blank or not. First tried using countA for the column but it always returns a 1 even if I add several rows of data. then switch to counting rows and trying to iterate through...

Used the property and specified the range to read from. the combo boxes work for loading the data into the cell, I am just trying to automate setting the column size properties. Wanted to write a utility so when I have a lot of controls like this I can automate it. I actually ended up doing...

This is a Combobox from the controls toolbox S J E If I am not learning, then I am coasting, if I am coasting I must be going down hill.

Skip, Perhaps I should have been more clear, the error I am getting says Run-time error 438 Object doesn't support this property or method. I get the same error with your code. I even tried this for a test to see if I could get it to work... * ActiveSheet.OLEObjects("combobox31").ColumnWidths...

I have an Excel spread sheet which serves as a template for users to request stock codes be created. There are several combo boxes tied to some ranges which provide them the ability to select what they want in that cell. I need to write a utility that will allow me to modify the properties for...

Sometimes when a file is exported to Excel where there is a "D1" at the end of the data it is being replaced with 00 or 0. Data accessed by Access shows some stock codes as 37244D1 but when they export it comes out 372440. Numerical portion "37244" varies. Numerical value after the D varies...

MajP, I created it as a single mdb and then use the database splitter utility. How do you make multiple user interfaces, simply copy the original to various users? S J E If I am not learning, then I am coasting, if I am coasting I must be going down hill.

I have a large database that is used by many different users at the same time. It doesn't happen all the time but is sporadic in nature. folks will exit the database but then when they try to go back into it they get an error saying that the database needs to be repaired or it is not an access...

Mufasa, Thank you for your response. I have not yet had a chance to do this but the information you provided in prelude to the code you given is extemely helpful. I will let you know how it turns out. Thanks Again!!!