Search results for query: *

We have a sensitive workbook we send to many users in our organization. Certain users should always be able to open it. It prompts for a password on open. What I wanted to do was to store a macro in these specific users Personal XLA that any time a workbook opens with a Password Prompt it...

Skip, Thanks for your response. This is VERY close. It seems to be rounding down in the lookup rather than rounding up. example A3 with 106 is giving me 1 PART when I thought it should give me 2 PART because it is closer to that value. But is that the way INDEX Match evaluates values...

I have a little table in Excel in cells A1:F5. In cell E9 to the right of my Formula Label I need a formula to evaluate the value in E7 (in this case A3) and evaluate the value in E8 (in this case 115) and read through the column headings to return a result of 3 PART. How can I write a VLOOKUP...

I have code at the end of a sub to close an active workbook save changes no. Is there any code I can use right after this to exit out if Excel altogether? Application.Quit does not seem to work. Thanks Here is code at the end of my sub ActiveWorkbook.Close savechanges:=False

I noticed on my left side Tasksbar that in addition to Objects is Groups. When I set up a group and place a query inside it, it is putting a shortcut to the actual query in Groups. Is there any way to place the entire query in groups without the shortcut so it does not appear twice? Thanks

We have a View named vwSubLogCounts_Post2005 which we want to use in SQL Server to update records in a SQL Table named GAIG_History_Producer_Codes When I run the SQL below in my Access update Query it runs fine. But when I attempt to run in the SQL Server Query Analyzer I get an error incorrect...

I wanted to set my Access database when it opens to a default profile named SHS Profile, and then when it closes back to Default. How can I do that?

We have an Access database usimg contacts in a special mailbox named SHS. How can i change a users Outlook Profile so that when they open the database it changes to the Profile for SHS and when they close the database it changes back to their user ID ie tsmith Thanks

We have the following code on a button click below. User clicks the button cmdSelectFolder to invoke this function to browse and select a contacts folder which is then set here to Me![txtFolderName].Value = pfld.Name. When we try and set a default value for Me![txtFolderName].Value to...

I have code I am using in a SendObject event using MS Access. I needed to know if there was a way to chnge the From Address to a default disional e-mail folder instead of my personal e-mail address so that if people reply to the e-mail it goes to the divisional mailbox, not my own. Code in...

I have a button on my form to invoke an Outlook E-Mail and Populate the To and Bcc fields. This works great. I also want to use an HTML Template as the basis for the wallpaper in the e-mail. I have the full path of the HTML file typed out in my code yet it never picks up this HTML Template. How...

I have an Access table with full name and email address that I want to import into my Outlook Contacts folder. I have successfully completed this by manually going to File, Import from Outlook after setting the dsn. What I need to be able to do is write some code to attach to a button on the...

Ken, I agree with you about moving the sheet but I am not sure how to do it in the code above. If as the code show we set a placeholder for wb as a temporary workbook how do I move the Activesheet to wb? Then I could get rid of the code below and break the links like you were saying. With...

Glenn If I move the sheet how can I have it be part of an e-mail in the event above

Ken, the send sheet method in his download gives the same problems as before it is truncating all data > 255 characters

I have an application used by 55 users. In the final step they are asked to e-mail the sheet they are on to an individual. What happens during the execution of this code is that it sends one sheet of just values to a user, stripping away all named ranges except the Print rane and removing all...

I have a fairly simple SQL Statement. I need the Most recent 5 records in descending date order by Agency_Diary_Date_of_Contact for each Producer_code to display. Problem I am having when I use Top 5 in the select statement is that it only shows the most recent 5 for the first producer in the...

I've created a form in Word using the Text Form Field for input. After protecting the document for use, the Spell check capability is not available and even if I "unprotect" the form, the form text field data is not included in the spell check evaluation. Is there any way around this?

I have a data type in Access that is Hyperlink. I did not see that data type for SQL Server. How can I ensure that my hyperlinks still work when I upsize this table from Access to SQL Server? What data type should I change it to for SQL Server? Thanks

Check out stephen Lebans web site of Access tips. His code is the best I've seen and I have it in one of our large production databases.