Search results

I have a database with 12 users with write access (though only 2 will be using it daily and the others approximately once a week) and 24 users with read only access. The database is stored on a server that everyone has access to. I have tried splitting this database and saving the front-end...

Please forgive the question. It was asked to me directly and I'm trying to formulate an answer. Google isn't being helpful in this. Does .snp format typically pass through spam filters? Apparently they went with sending Excel documents previously for that reason, but that's not a viable...

Excellent idea. Dim objOutlook Dim Message Dim olMail Item Set objOutlook = CreateObject("Outlook.Application") Set Message = objOutlook.CreateItem(olMailItem) With Message .To = "myemail@email.co"...

FYI I've managed to resolve this issue by using different automation code. Thank you.

Set Message = CreateObject("CDO.Message") Message.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2 Message.Configuration.Fields.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "Company Server Name"...

i have an Access program module that i wrote in (and which performs fine in) a Citrix connection. The module sends an email with an attachment. When run outside of Citrix, i receive the error in the subject. i presume this is not an Access error but rather an MS Outlook security issue which...

It works beautifully. Thanks again!

OK, thanks! Will try that.

This one is strange. i got my code to work for C:\Sample.XLS for the workbook Name1 (thanks to all who helped). i attempted to do the same formatting for workbook Name2, and the strangest thing happened (probably not strange to you, but strange to me). The code ran through to the Exit Sub...

What is the Job Number? You should group by Part Number (and also Job Number if applicable), but Sum everything else. Is that what you're already doing?

Do you have any Sum fields? You can add the Sum line and only group by like things, like part number, and sum everything else.

By George, i think i've got it! Now to apply it to the ACTUAL workbook that Access creates...

Actually i'm ultimately trying to set the first row to bold and set the back color to light gray, and also set all of the columns to autofit. i'm cutting corners to just try to get something (anything) to work so i can see where my problem lies, and add on from there. Meanwhile, i've had a...

i've tried at least a dozen permutations and computations and nothing seems to work. :confused: i was happy for a moment when it seemed to work, but it was just my computer freezing up. :mad:

It's a slight improvement. The highlighted error has moved down from the With objXL line and the next 2 lines to .Workbooks(strWkbkName) _ .Worksheets(strWkSt) _ .Rows("1:1").Font.Bold = True but I'm still getting a "Subscript Out of Range" error. Thanks!

I created a dummy Excel spreadsheet called Y:\Test.xls with a worksheet called It. I assigned each of them to a variable strWkBk and strWkSt. The code still creates the same error and follows: What am I doing wrong? Thanks!

Can someone help me with the "Subscript Out of Range" error at the line: With objXL.Application _ .Workbooks("C:\Sample.XLS") _ .Worksheets("Past Due - Name1") All those lines are highlighted with the arrow at the .Worksheets line. Thanks!

Banana, i'm sure that's a good idea, but the answer is because i'm blindly copying code from the internet in hopes it works. My new error is Runtime error 9 - subscript out of range on the same line as before.

Sorry to need more help, but i'm running into snags. The bold line in the code below creates the subject error. Can you help?

Thanks. Is there no way to do it within Access? (That is required for it to put the reports into production).