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 Replies
ADVERTISEMENT
Mar 10, 2014
If memory serves me right, I've seen code or maybe a shortcut somewhere for inputting a date value in a form along the following lines.
To input today's date, input "0"
Yesterday = "-1"
A week ago = "-7"
and so on.
View 6 Replies
View Related
Oct 21, 2013
I am running Access 2010. I have added the following to the "On Open" event on my main form:
Code:
Private Sub Form_Open(Cancel As Integer)
DoCmd.ShowToolbar "Ribbon", acToolbarNo
DoCmd.NavigateTo "acNavigationCategoryObjectType"
DoCmd.RunCommand acCmdWindowHide
Me.ShortcutMenu = False
End Sub
My main form (frmMain) is displayed when the database opens. As you can see, I am hiding the ribbon and the navigation pane from users. I also want to prevent users from right clicking on the form and opening it in Design view - trying to prevent any monkey business. However, the line:Me. ShortcutMenu = False
is not preventing users from right clicking on the form and getting the shortcut menu and going into Design view.If I go to Options and uncheck: "Allow Default Shortcut Menus" then I lose the ability to print reports because I have the ribbon hidden and this will not allow right click on reports.Converting to .accde is not an option at this time.
View 1 Replies
View Related
Nov 28, 2011
As the title says, ctrl-W works on all my other forms but not on the one which has Pop-up set to "Yes".
View 1 Replies
View Related
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
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
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
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
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 4 Replies
View Related
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
