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

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

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

Another group in our company has an Access database set up. All 10 of the users have rights to the folder this database resides in. All the tables are local except for one that is a linked table to a folder that only 3 of the 10 users have rights to. Even though they are not using this table...

I have a drop down in Excel on a sheet named Level 2 Support Team Member. Based on the value of a prior dropdown results for this are in Cell H8 I need the Input Range to change dynamically Example If H8 =1 the Input range should be Sheet1!$B$2:$B$10 If H8=2 the the Input range should be...

I have a spreadsheet that is in effect the finished product of a crosstab. The first column is date which would stay fixed and it contains records from rows A2:A367. Then we have coulmn headings from Column B to Column CU which should in effect become field values. I need to pivot this data...

I have a function that will return a complete file path with file name to a hyperlink field on my form. What I need is to just return the path to the folder and have that folder displayed in the hyperlink field on my form. Example instead of storing L:\MyDocs\Documentation\Word1.doc I need to...

I have an AUTOEXEC Macro that opens up a main switchboard form, and then some buttons that run macros to open other forms. I know in Excel I can use Application.ScreenUpdating = False to prevent the blinking screen during updates, and I was wondering how I could do the same thing in Access? Thanks