Search results for query: *

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

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

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

I need to be able to read a Word document from within Access using VBA. How could I read one line of text to populate an Access Variable? Thank you