Recent content by HLEE1167

I do have many Excel Workbooks with many worksheets that contains Embedded object. We can not link them to their source (or we do not know how to do it). The important thing is that we need to take this objects out of the worksheets and extract them into a folder. How could we accomplish...

Do anyone know of free Add-On objects libraries that I can use with Access? Thank you

Thank you for the reply. I am using similar code but I still get several cells with ###### instead of the real content. Do anyone know Why this happend and how it could be solved. Thank you

I do want to make a table exclusive in such a way that if anybody is using it and any user try to use it (including update queries, or even LINKING it) Access may not allow other users to use the table. Could any one Tell me how could you do this? Thank you

I do have a query that joins several tables. It works fine but there are two tables that are join by fields that have a different name. One table contains a field called Emp_Number and the other table (It is a link table from another department, used in many places therefore is not feasable to...

I need to be sure that all my cells expands and that I do not have any ##### because of a number being too big for its cell. Do you have an idea of how to do this? I had tried changing the font to Times New Roman Programatically but it do not solve the problem Thank you

I need to write a piece of code that may determine how many empty lines and how many empty columns I do have from a given cell. Any idea on how to accomplish this? Thank you

Thank you for your answers. I did not had chance to answer before since I was on vacation but as always your answers are just impressive. I was able to solve the problem with this piece of code: lc_lastarea = ActiveCell.SpecialCells(xlLastCell).address lc_printarea =...

Do you know if there is a way to determine if there are cells with any value that had not been included in the selected print range? Thank you

Do you know if there is a way to determine if there are cells with any value that had not been included in the selected print range? Thank you

I am running a program that I had run docens of times in different machines with different operating systems. In one of the machines I am getting a Windows error like this: I am using Windows NT with Access 2000 running a program who uses DAO with a large query (with calculated fields) as my...

We have thousands of workbooks that need to be printed. One of the problems that we have is that we need to determine if there is data left out from print ranges in any given worksheet. Do you know how I could code this? Thank you

I would like to have a list object with checkboxes on it. VB Net have this functionality but Access do not. Could you tell me how could I do this? Do you know of any good free object library that I can use on my projects? Thank you

It is possible to process records in a data collection eficiently using T-SQL? Why is necessary to use and intermediate thread sometimes(like FoxPro or VB) when using SQL Server? Thank you

We are a very intensive Access production shop. We are going to develop and implement a SQL Server solution. Basically what we do is that we have hundreeds of Access databases in hundreeds of machines and then we have people who run queries, programs and reports on those databases. The SQL...