Recent content by jason246day

PHV, how do I do that?

I've already tried that. It finds the duplicates on the whole table, then filters. I am wanting to filter first, then find the duplicates.

I have having trouble running my duplicate finder query. The table I am running off, Orders, contains hundreds of thousands of rows. One of the colums in this table is Customer ID, which contains a company id that signifies which of our clients this order came from. I am wanting to find...

that worked, thank you.

I've already tried that. It gives me all the results from both queries. I am looking for the results that are common to both.

I have 2 queries that are independent of each other, qryTemp1 and qryTemp2. Both of them return a list of policy numbers, but both have different criteria that they are searching for. I am trying to find a way to return the policy numbers that are found in the results of both of these queries...

MS Access uses parts of the ms photo editor to display tifs, and in office 2k3, they replaced photo editor with picture editor. So I had to use an old version of office, mine was 2k, to install photo editor. Its a stand alone app, so you can install it without installing anything else from the...

Problem solved, no help needed.

I am creating reports using tif files, but they won't show up in access. I get an error saying that they aren't supported, or the file is too large. I know that it will work, because it works on other computers. Is there a setting that I don't know of that will allow tif files to show up...

Yes I can, I have it working. I just need to figure out the lengths of the cells, Len(Cells(row, col)), at which I want it to wrap. Because of the indentions, not all of the cells are the same width. Do you know if there is a standard length for a defualt sized cell. I tried 10, and then...

I've already done that, the problem with AutoFit is that it expands the width. I am creating a printer friendly version of my data. If the columns are all set to default, then my text cannot go past than column I, or it won't print on a single page. So I merge the cells to I on each row...

Could you explain a little more, I am a programmer, but I just don't know the vba calls, and am having a hard time locating them on the web.

I am trying to find out how many times a text entry in a cell word wraps. I need to know that so I can automatically adjust the cell height to compensate. I could do it by counting characters, but some of the cells are indented. Is there a way to count how many times a sentence wraps around?

The application is now working correctly!! :)

I am trying to achieve a utility that will allow the user of the script to arrange the data entries any way they feel possible, through the browser. Imagine a table containing data. Each line in the table contains all the data stored for that entry. I want to have arrows off to the right side...