Using AutoKeys Macro Group To Assign Shortcut Keys (2002) XP
Nov 9, 2006
Hope someone can help,
Just learning Access so may have missed something really basic!
I am trying to add some shortcut keys to existing toolbar functions such as FileGet External DataImport (&Import). My issue is that when I try to use the shortcut key I get a message saying:
"A macro can call itself a maximum of 20 times. Your macro contains a RunMacro action that calls the same macro more than 20 times. Use a condition to stop the macro after it has been run 20 times, or call another macro with the RunMacro action."
I have added the shortcut key "CTRL+I" to the button by going ViewToolbarsCustomise then right clicking on the button and under PropertiesShortcut Text adding "CTRL+I".
I have added the Macro Group "Autokeys", and within Autokeys added "^I" to the column named Macro Name, "RunMacro" under the column called Action, and "AutoKeys.^I" under Macro Name (at the bottom).
Both the Repeat Count and Repeat Expression fields at the bottom have been left blank.
SOLVED: Hows it goin?I need to assign a second primary key to a table involving three fields (Student Number, Subject Code and Average). I have to make Student Number and Subject code the primary keys. Any help would be appriciated.
I have built an access application that contains a set of buttons along the top of every form that serve as navigation.* These buttons each perform the same function on every form they are on. (menu opens the main menu, etc) I have database macros to assign each button the same function but I still have to go through each form and manually assign them. I was wondering if it was possible to define a public function that on db open will look for all buttons with a certain name and assign them the macro. (so all buttons called cmdmainmenu will have the OpenMainMenu macro assigned and so on).Before you go there, I have already tried the navigation form and set all forms as subforms.
I am trying to write a more complex macro that will start another macro at a preset time, however I am getting stopped at the first hurdle - getting a macro to run another macro.
Here is the code i am using at the moment, all I want to do currently is click the first button, then get the second macro to execute. But no luck, getting error 2157 "cannot find the procedure"
Is there a way to have an expression in the control source of a text box in a report, that re-starts or is exclusive for every group within the report?
I have a database (split) I developed using Access 2000 (Office Professional). I installed it in a lap top that has Office Prosessional 2002 and am encountering several problems: 1) The shift-key bypass does not work; 2) My application uses an access wizzard switchboard. With the lap top, when I open a form from the switch board and subsequently close it, Access closes; 3) When I just open Access in the lap top, I get none of the standard tool bars. (I don't know if I caused this). This has to be something obvious that I just cannot see. Thanks in advance for your help.
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
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)
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 ....
I need to develop an application that works in 2002. I tried to take a 2002 mdb, convert in 2002 to 2000 and try it on my machine at home. It didn't work and I couldn't find the missing reference. I then took an mdb that was originally a 2000 format, converted it to 2002 and it worked fine. So what I want to do is develop the app in 2000 and just convert it over to 2002. This allows me to work on it from home which is pretty important since my deadline is creeping closer. Am I ok doing this or am I courting disaster? Or is there another way of doing this?
I have created a database using Access 2003. If I leave the database in the MDB format, it will run perfectly on my computer at work that has Access 2002. However, if I use Access 2003 and convert the database to an MDE file, and try to run it at work using Access 2002, I get an error that states "The Visual Basic for Applications project in the database is corrupt."
I know it is not corrupt because the same MDE file runs fine on my machine with Access 2003.
I would like to share the database with some fellow staff members, but I would like it in MDE form.
I'm looking to purchase Access 2002 because that is the version we use at work. The problem is, when I search the net for deals, it is more economical to purchase Office XP 2003 OEM instead of Access 2002.
Is Office XP - version 2002 unless it says Office XP 2003?
Or should I just purchase Office XP 2003 and just convert before I take my database to work? I hear the difference between 2002 and 2003 is mostly the VB coding functionality.
BTW I am looking at the following deal..Hope its not a scam http://www.pricegrabber.com/search_getprod.php/masterid=991291
I have an application which I did in Access 2003 and it uses "Microsoft Access 11.0 Object Library" and also "Microsoft Outlook 11.0 Object Library".
I have converted it to 2002 format from database utilities where it says (2002-2003).
Now when this application is opened in Access 2002 the refrences are "Microsoft Access 10.0 Object Library" and "Microsoft Outlook 10.0 Object Library", now the code starts throwing various errors.
Now what is the way out to avoid these errors? Should I copy the 11.0 libraries and add those in refrences on the machines where access 2002 is available.
I did some initial searching but I am not sure what to search for. I have inherited an access application for maintenance. I am a C# developer by trade so developing code and ui inside the db is kind of weird to me not slamming it, just a little confused with the paradigm. Anyway, I had successfully added functionality to the code base as the per requirements. I made the changes using 2003. No database conversion dialog ever showed so I figured everything was cool. However the client is using 2002 and when they launch it the MDI parent shows the correct title but the form that is opened by default never shows up.
I have no problems creating an MDE file from a newly created database but the system hangs when I try to do the same with a former Access 2000 database that I converted.
My Access program crashes frequently. I tried the 'Repair Office' function, but that has made no difference. On checking, I see that it's Access 2002, not 2003. Can I still get Access 2003? Should I upgrade to that? I don't want to buy the new Office 2007 suite.
I am creating an access database and I want to know the following limitations;
1. Maximum number of users who can log into the database at a time
2. Maximum size of the database. Here I understand that it is 2GB, but I am confused as to whether it is for .MDB file or for each table in the database.
I have an existing database using access 2002 which has been split. In the part containing the data (back end I think its called) there are 3 existing tables which are clearly linked from the front end (forms queries etc.). If I now try to add another table in the back end it is not shown in the list when trying to create a link from the front end.
I'm running Access 2002 at work and trying to import a form that was created in Acrobat 7.0 and saved as a xml file. The structure and data option is selected, yet only the structure imports, no data.
In Access 2003 (which is what I have at home) I can get both structure and data. Does anyone know away around this in trying to import the file into Access 2002 or why I might be having that problem with one version and not the other?
I am trying to build a database for my share trading and am having trouble doing some calculations in a Report.
In the Detail section of the Report I do this calculation: =IIf([LVR]="0","0",((([Units]-([Margin Amount]/[Unit Price (o)]))*[Close Price (c)])/(1-[LVR]))+(([Margin Amount]/[Unit Price (o)])*([Close Price (c)]-[Unit Price (o)])/(1-[LVR])))
This calc is done on all my open trades and it returns the answer i want which looks like:
Margin Calculations
Open Trades
ASXCodeCurrent ValueMargin Available
FLT$5,500.00$18,333.33
SGN$3,700.00$3,200.00
AXN$13,200.00$33,000.00
CPU$9,250.00$17,821.67
AUN$15,600.000
Total Margin Available:$5.00
Inthe report footer i attempt to sum the answers this calculation returns using the Expresion: =Sum([Margin]) to get Total Margin Available.
Margin is the name of the field that contains the above calculation and when I try to veiw the report it prompts me to enter a parameter for Margin? I would have thought no parameter is required as all I am asking it to do is sum the numbers the calculation is churning out, however if i enter a value ie 1 Total Margin Available totals the number of records and multiplies it by the value i entered as you can see in the above example ($5.00).
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?
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
