Search results

Excel has 65,536 rows. I think it is a limit of the export.

I have too many rows (16,600+) rows in a table I am trying to export to Excel using the following code. Option Compare Database '------------------------------------------------------------ ' Autoexec ' '------------------------------------------------------------ Function Autoexec()...

I think that this will be excellent. According to the shirt website, what you see is what you get, and it looks good. Thanks a million guys.

Excellent work. Thank you. Now does anyone know how to resize and avoid the pixelization?

Wondering if anyone would be willing to take a look at this. I'm wanting to print this on a T-shirt at about 8"w X 5"t. Is there enough here to work with at that size or will it pixelate? If it can be worked with I also want to change Creamsicle to Dreamsicle. The text feel can either be...

GMAC MM offers 5+%. Take a look at bankrate.com to start off with of finding your best rates.

Thank You! Finally got it. Sorry I missed the bracket change. Thank you again for your help!

Syntax error in FROM clause same in post #4.

Not sure what you mean. The original query does work but I am trying to modify it to calculate the work days between two different fields than the first query. Still not able to get the modified one to work.

Of course you were right. Syntax error in JOIN operation. I need to bring tblECN, field DONOTPROCESS into the query so that records that <> Do Not Process are not included. Will I have to create a secondary query to do that or can I somehow do it in this one? Update -- I removed AND...

I'll give it a try on Monday. tblECN still exist and records that = DoNotProcess are not to be included in the results of the old and new query so hopefully it won't cause any problems. Thanks for your help,

Syntax error in FROM clause... ... FROM (tblECNDetail LEFT JOIN [SELECT Query4.[tblECNDetail].[ECNID] ,

Anyone? Did I mention it was tough?

I’m trying to modify an existing SQL query that calculates actual working days between start date in tblECN and end date in tblECNDetail to do the same between start date in tblECNDetail and end date in tblECNDetail (same table). Where I’ve gotten into a bind is with the joins of the two tables...

It is against the law in Kentucky to drive in the passing lane while not passing but I have yet to see or hear of anyone getting a ticket for it. They should though.

2nd vote for a Boxer. Very good around kids. Tough dog so that when Junior pulls on Fido's tail the dog just ignores them. I will warn you thogh that it is just like having another child when they are around kids. They love to play but if all is quiet so are they.

So no way to to call disable for the form for current user? That would solve all of my problems!

This field happens to be on a form which is tabbed to another and I don't want one user to have access to any of the fields on the form. Here is what I tried. Private Sub Form_Open(Cancel As Integer) Dim UserLoggedIn As String UserLoggedIn = CurrentUser() If UserLoggedIn = "username" Then...

A long time ago when I was first learning Access I named one of my fields "Part #". Now I need to refer to this field in a module but it doesn't like the # symbol a part of the name. This field is in numerous modules, reports and queries. Do I have any option that is good versus the one I think...

I have a combo box populated from a table containing names. Whomever processes the order selects their name from the combo box. Some entry persons have left the company but I cannot delete their names from the table as the orders are stored with their names and I want to maintain that history...