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 ; )
I'm looking for a keyboard shortcut to expand the columns in "design view" of a query.
What I mean by this is rather than selecting all of the columns and double clicking to see the entire text, I'd like to be able to a shortcut.
The entire process as I see it involves 3 steps so I will need thesolution to the 3rd step.
(1) [ctrl+spacebar] to select initial column
(2) [shift+arrows] to select all of the columns I need
(3) [keyboard shortcut] will expand all of the columns "field" names to the size of the column heading
Alternatively, if you know of a shortcut that will expand the columns without having to select them first I'll take it!!
How I can close a parameter query without having to close the entire database and reopen again? [Alt] [f5] ??
View 1 Replies View Relatedhello,
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
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
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 RelatedIn some cases I create pass-through queries and use these in an Append or Make-table query to bring data locally.
All is well and fine until source data changes and the pass-through query runs too long and times out.
If needed, I can extend the timeout value in the Parameters of the pass-through query no problem, but when I try to open the Append or Make-table query in Design view to do the same, the pass-through query is first triggered and then throws the timeout, and I cannot access the Design view of the Append or Make-table
Is there a way to open an Append or Make-table query in Design view without invoking the source query?
I have a Form which I have linked correctly to a subform. The Text boxes are showing in the Design view but are not when one switches to the Form View. Labels for Fields are visible in the Form View. Have even created a new subform and that will also not display the Text Boxes.
View 1 Replies View RelatedWhy the ability to view the properties of an object within a form is not available when you double click on it in design view?
I was happily working away double clicking on a command button to edit some code when for some reason the next time I tried to edit it did not open up for me.
I was unable to access it even by right clicking on the object & selecting properties as that also appears to be disabled, not greyed out or anything but just does nothing when selected.
Have I inadvertently changed a setting somewhere that prevents the properties from being displayed?
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 RelatedI'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
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 RelatedSee title :)
I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to formview.
Maybe someone can help me with this, probably very simple(?), question?
Anybody ever heard of this before? I open a form, and it is empty, just a blank window. I open the same form in Design View, all appears well. :mad:
View 2 Replies View Relatedhi 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
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?
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 RelatedHi 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 RelatedHello 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
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!
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??
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.
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.
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
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?
I have a table called NewTransactions_tbl that I have been using for some time. I am trying to add a new field called CustomerProjectNumber. It's not being displayed when I look at the table view. I've attached an image showing the settings for the field. I am probably missing something obvious.
Any ideas why it is not showing?
I am using Access 2000.