Sendmessage With Shortcut

Jan 17, 2005

I'm looking for a way to send an email from access that contains either a shortcut to this database(Product Change Database-CURRENT.mdb) or a hyperlink to it. I've tried using this sendmessage code, but it seems to only work for actual files and not shortcuts.

If I replace "C:TEMPREADME.TXT" with "C:TEMPShortcut to Product Change Database-CURRENT.mdb" it gives me a message "The system cannot find the file specified."

It would also be nice if it showed email to the sender(like in Sendobject) and let the user edit the email.... currently it immediately sends it.
Maybe there is another way to do this, any help would be great.



Code:Private Sub cmdEmailPCR_Click() Dim objOutlook As Outlook.ApplicationDim objOutlookMsg As Outlook.MailItemDim objOutlookRecip As Outlook.RecipientDim objOutlookAttach As Outlook.Attachment ' Create the Outlook session.Set objOutlook = CreateObject("Outlook.Application") ' Create the message.Set objOutlookMsg = objOutlook.CreateItem(olMailItem) With objOutlookMsg ' Add the To recipient(s) to the message. Set objOutlookRecip = .Recipients.Add(johndoe@test.com) objOutlookRecip.Type = olTo ' Set the Subject, Body, and Importance of the message. .Subject = "New PCR" .Body = "Please review this new product change request. Thank you." & vbCrLf & vbCrLf ' Add attachments to the message. If Not IsMissing(AttachmentPath) Then Set objOutlookAttach = .Attachments.Add("C:TEMPREADME.TXT") End If ' Resolve each Recipient's name. For Each objOutlookRecip In .Recipients objOutlookRecip.Resolve If Not objOutlookRecip.Resolve Then objOutlookMsg.Display End If Next .Send End WithSet objOutlookMsg = NothingSet objOutlook = Nothing End Sub

View Replies


ADVERTISEMENT

Run A Shortcut ?

May 25, 2005

hello,
Here is my problem: i need from access or vb to run a non-window application,this application (in buisness basic) is generally run with an Icon on desktop, and needs to be associated with a text file wich contains path and other parameters to be executed, i tried with shell command but it does'nt work.
In the shortcut (right click on icon appli) properties there is the target information and an other info to select path start application (called 'demarrer en' in french ,see image ), but i don't know how it is called in english, and i think this info is missing in my shell command, so the question is :
How to give this info in shell command ?
Or is it possible to run directly shortcut (lnk file) with VB ?
Sorry for my english.
Thanks in advance for help.
VINCENT

View 2 Replies View Related

Shortcut

Oct 25, 2005

I'm making a shortcut to a report in my database. I'd like to place the shortcut to the report onto my desktop.

The problem is I'm running both access2000 and access97. Even tho I've told the computer to open all access programs in access97, when I go to open that shortcut to the report it opens in access2000.

How do I go about getting the report shortcut to open with access97 as well?

(I do need to keep access2000 for some rare files)

Thanks for any suggestions

View 6 Replies View Related

DB Shortcut

Mar 19, 2008

I have created a desktop shortcut to access the network DB - but it does not work. Even finding the target database on the Network Places and double clicking to invoike Access does not work. The only way I can open the DB at present is to open Access first/ then select the DB file from the File/Open menu ....

View 5 Replies View Related

Creating Shortcut

Aug 1, 2006

I created a shortcut icon on my computer to access an Access dB that's located on the company server. The Access db opened, but immediately froze and wasn't able to do anything (not responding). Any suggestions as to why this happened and how to fix it?

View 2 Replies View Related

Access Shortcut Key

May 9, 2014

I remember there is shortcut keys for input field name when creating a queries. For example, when we try to create a query to combine field [firstname] and field [lastname] from customer table and we use: fullname:[firstname]+" "+[lastname]; instead of input this expression {fullname:[firstname]+" "+[lastname]} key by key, is there shortcut key that can input [firstname] into expression?

View 1 Replies View Related

Shortcut For Command Button

Jun 4, 2005

hi to all,

does anyone know how to create a shortcut for a command button? For eg, the caption of my command button is SAVE. how do i create a short cut (CTRL + S) for it? thanx

View 1 Replies View Related

Shortcut Target Not Valid

Dec 3, 2005

Trying to make a shortcut to join the workgroup and open a Db.

I made a shortcut for a Db, the shortcut defalt target was:
X:RC-OfficeRC_OFFICdatabaseProjects.mdb

I edited the target line to:
/wrkgrp ”X:RC-OfficeRC_OFFICdatabaseMS Access Workgroup.mdw” “X:RC-OfficeRC_OFFICdatabaseProjects.mdb”

I get wrkgrp not vaid target. I put the mdb file path first, I get not vaid target for the path to the Db.
I would rather not put in the whole MS Access program file. This is on a server that I don't know much about. Not sure I would get the program file right.
Help?

View 3 Replies View Related

Is There A Way To Protect Shortcut On Desktop ?

Dec 6, 2005

Hello,I need to know is there any way to protect a shortcut on desktop ?Bcz someone is deleting (I dont know by mistake or intentionally) shortcut of database shortcut. I thinking about its protection from deletion only unless you have to supply a password or code something like that.Any idea..?With kind regards,Ashfaque

View 1 Replies View Related

Customising A Form Shortcut??

Mar 14, 2006

Hi there, this maybe very simple but I can't seem to sort it out... I have a created a shortcut to my form database on my desktop but I want to know if there is a way in which I can make it so whenever I use the shortcut my database will open as a maximized screen as opposed to opening in a small window which it keeps doing, meaning I always have to maxmise (it may seem like something small but it gets quite annoying after a while) Can this be done? Or even better can I make it so that JUST the form opens and not the whole access program, as the other people using the database don't need to see and use anything else but the form. Any help would be much appreciated. Thanks

View 1 Replies View Related

Shortcut To MDW Security File

Apr 4, 2007

Hello all:

using Access 2000.

I'm using the mdw file to secure a db and I have installed it on a few computers and it works fine. The shortcut is

"C:Program FilesMICROS~2OfficeMSACCESS.EXE" "C:Vero InventoryVERO INVENTORY_fe.mde" /WRKGRP "C:Vero InventorySecured.mdw"

There is a local folder on each workstation holding the front end and I've given full access to this user and made sure the permissions propagated to the actual mde file itself.

There's one computer that tells me it can't find the db when I run the shortcut. It has the same setup as all others....


Any ideas?


thanks

View 3 Replies View Related

Specifying A Workgroup File To Use From A Shortcut

Jan 9, 2008

Hey all,

I was wondering if any of you guys know how to specify a custom workgroup file in a shortcut to my database.

This is what I've got in my shortcut:

C:TESTTEST.mdb /w "C:TESTSECURITYFILE.MDW"

Basically I want access's system.mdw to remain the default mdw for access but want my mdb to use a different mdw.

Many thanks!

View 5 Replies View Related

Shortcut Icon Lost Its Way....

Mar 7, 2008

A problem I have seen a couple times has come up again... Wondering if anyone knows why this happens?
This is always with a split DB.... Using "Remote Access"..... The user signs on, a shortcut to the Frontend of the application is there...... But when clicked... nothing.
I personally did not load this one onto the clients server, but I believe the administrator has done this to use a bit of group security abilities. I think he has put the Frontend in their "Documents" folder and then puts a shortcut to the frontend on their remote desktop (Server)....... But time after time it loses the path to the frontend....or maybe doesn't recognize that it is an mdb file....Not sure. Anyone had this come up before??

View 6 Replies View Related

Shortcut To SQL Query (View)?

Mar 14, 2008

Is there a keyboard shortcut to open a new query in SQL view?

I find myself encouraging carpal tunnel by:
> going to "queries"
> "new query"
> "design view"
> closing the "show table" dialog box
> right clicking the new query
> finally selecting "SQL view".


There has GOT to be an easier way that this 6-step process to ~run a query~ in a _database_ ... but I haven't run across it yet though. Any help here? My wrist thanks you ; )

View 14 Replies View Related

Shortcut For Command Button

Jun 4, 2005

hi to all,

does anyone know how to create a shortcut for a command button? For eg, the caption of my command button is SAVE. how do i create a short cut (CTRL + S) for it? thanx



i'm using access 2003.

View 2 Replies View Related

ALT+ Shortcut For Custom MenuBar

Jan 31, 2006

I have created custom menus for forms. The menus come up and go away as needed when the form is open. No problems there. The problem is that the ALT shortcuts aren't working when the form has the focus. If I leave the database main window open and give it the focus (form is popup) the ALT+ works fine, but when the database is complete I will be hiding the database window. I have experimented with that already and still get the same results. I have tried making the form modal and popup, popup only, modal only, and neither. No matter the configuration:eek: , the ALT+ does not seem to work. In case it isn't clear, ALT+C if the menu is &Control, etc...And I have removed the built-in menus so there is no conflict that I'm aware of with the ALT+ commands.

I'd appreciate any help you can give on this problem.

View 7 Replies View Related

Shortcut Problems On Network

Mar 26, 2006

I am having problems with a database that is on a network. When I update it, the computers that have a shortcut on their computer to this database does not get the updates. How can I make sure that my updates are also on the computers with the shortcuts.
Thanks

View 2 Replies View Related

Forms :: Add Parameters To MAF Shortcut

Jul 10, 2015

Is there any way to add parameters to a .maf shortcut?

I'm thinking, I may be able to email the link to a form to someone, with the correct ID. But I'm assuming this isn't an easy thing to do?

View 9 Replies View Related

2 Mins Of Your Time! Shortcut Menu

Mar 13, 2007

Hello,

I am going crazy! I have managed to do this in a previous database and now I can't remember how I did it.

I want to create a shortcut menu for a report that when I right click the mouse button it gives me the option to print. When I select print on this shortcut menu it goes straight to the printer instead of giving me the printer dialogue box.

Please help!

Thanks

View 4 Replies View Related

How Do You Undo Lost Shortcut Menus?

Jan 7, 2008

Hi everyone! Well, I goofed... I was trying to figure out how cause access to launch a switchboard I made and NOT launch the regular shortcut bars or database window. Well, fortunately the help file told me I could change that in tools...startup options...

I found it, and it worked great, except I can't get back into my regular shortcut menu features, including the startup options themselves to reverse it. I did figure out I could reclaim the database window by pushing f11, but sadly have been unable to figure out how to get to my shortcut menus and back into startup options. Anyone know how I can get back in?

Next time I'll have to make a copy before doing that...

View 1 Replies View Related

Shortcut Button To Report Wizard

Jan 21, 2005

I know there is a Access Guru out there that could do this in a milisecond, but, this one has been kickin my backside all week...

I need to know how to create a shortcut button in a form to bring up the "Report Wizard" feature. Then after that button is created, I would like to be able to hide the structure of my database so that all the users can see is the switchboard. PLEASE give me some insight here if you can, the first correct reply gets free fries with thier next order...

View 13 Replies View Related

Is There A Shortcut To Copy The Text From Cell Above?

Dec 7, 2007

Hello! I need some serious help! After 25+ years of using Paradox where I work, we are going to Microsoft Office and Access is stumping me on one thing!!! In paradox you could hit Ctrl+D and it would enter the same information as in the cell directly above. I can't find anything that shows that Access has a feature like this. I have our inventory database and I will enter maybe 25 of the same items, but they have different property numbers and locations only. How do I get it to repeat what is in the cell/row above?

View 6 Replies View Related

Putting The Line Under A Letter On Button As Shortcut Key

Sep 5, 2006

Hi All

How do you assign a shortcut key to a command button.

I want to close a form with the command button - the button would have the words "Close Form" on it with an underline under the C.

If the user does the action eg: Ctrl E - the form will close.

Tee

View 2 Replies View Related

Modules & VBA :: Creating A Custom Shortcut Menu

Jun 5, 2014

I'm working to put together a shortcut menu for a form that will be viewed as a datasheet. I'm trying to put together the vba to create the menu. I'd like a lot of the standard options i.e. sort a-z, filter toggle etc. I'd also like to add the menu option that is displayed in the default menu called "Text Filters". I've been unable to find the id code for that option, and since it, when chosen opens another menu, I'm not real sure how to code it. Here is what I have so far:

Sub CreateWIPShortcutMenu()
Dim cmbRightClick As Office.CommandBar
Dim cmbControl As Office.CommandBarControl
' Create the shortcut menu.
Set cmbRightClick = CommandBars.Add("cmdWIP", msoBarPopup, False, True)

[code]....

View 2 Replies View Related

General :: Shortcut Key To Select Current Record

Jun 2, 2014

I cannot remember (or find) a simple thing like the shortcut key for selecting the current record I am editing.

I have a form (or sub-form, or table even) set as a continuous form. I want to delete a record. I select the "record selector" on the LHS by left clicking on the grey box. I press [Delete]. No problemo.

I do not want my users to see the "record selector" grey box on LHS of my continuous form. I switch off record selectors. Now I am in edit mode, editing data in a field of my record. I decide I want to delete that record by using the [Delete] button. What is the shortcut key for selecting the record so that I can then press [Delete] do this, given that there is no "grey box record selector" to click on?

Same could apply in direct table view. No clicking on grey record selector box allowed.

View 1 Replies View Related

General :: How To Add Keyboard Shortcut To Button Command

May 8, 2013

I am using access 2010 and I created couple of buttons on my forms that do some stuff in vba, but beside triger them with mouse I would also like my users to be able to have shortcuts on keyboard so for example I have btnClose an I widh when user press ALT + that btnClose do the same thing as it is doing when you press mouse on it.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved