assign a shortcut key in access
I want to assign a shortcut key in a form
like when a user presses CTRL+S a code should run like
Go To Control combo1 and me.combo1.dropdwon
any way to do this?
You need to yous the AutoKeys macro. Here's a very good explanation of how to
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
Message posted via AccessMonster.com
missinglinq via AccessMonster.com wrote:
> You need to yous the AutoKeys macro. Here&...How do I show formulas (in values) for the calculation?
when i'm doing caluclations in excel, i want to "show my work". I dont
mean just showing the formula (eg. =A10 + B20, you can do this if you
copy/paste the function in the cell). But instead, say if the value in
A10 is 1 and B20 is 2, i want it to show "=1+2" in the cell.
I understand if I type in the cell: '=A10& "+" B20, it'll show what i
want. but it'll be veyr troublesome. I need a more automated easier
way, almost as easy as say copy and pasting as a special option.
I need this so that show my work on the worksheet.
Is there possibly a...Access object pane out of place
The main switchboard on access is stuck towards the top of my display and I
can't click on the top bar to move the window around or maximize it. How do
I fix this?
> The main switchboard on access is stuck towards the top of my display and I
> can't click on the top bar to move the window around or maximize it. How do
> I fix this?
"gator" <firstname.lastname@example.org> a écrit dans le message de groupe
de discussion : B5CACF0D-C525-4EED-ABAF-68B6742FF1E1@microsoft.com...
> The main...Find records that belong to a combo box value
I added a combo box to an Excel wks. I need to find all the records on the
same worksheet where column B value=ComboBox value. Then I need to copy the
records and paste into another worksheet.
Is there a way of doing this in Excel?
I appreciate any help. Thank you.
If this is not what you are looking for, maybe you can adapt it to do what
you want. The code below goes into the Sheet code module for the sheet with
the combobox. To access the code module, right click the sheet tab and then
click View Code on the pop up menu. Copy the code below and paste it into
the code windo...Return a charactar from a cell value
How do I return a scharactar from a cell value in VB?
ANSWER = Left(Activecell.Value, 10)
....but for example I just want to return one charactar, the ninth,
from the cell value.
MsgBox Left(ActiveCell, 10)
Dim MyString as String
MyString = ActiveCell.Value
mvpearl omitthisword at verizon period net
"Marcus Ostman" <email@example.com> wrote in message
> Simple questi...See if cell value appears within a value range given by another cell.
In one column (b), have the figure of 470
In another column (a), a cell contains values containing a number, a
dash and another number: "425 - 490"
I need to check to determine if the number 470 is found within a range
defined by a cells contents. In this case, yes, it's equal to or
(The dash may or may not have spaces around it. ..could be 425-490,
or 425 - 490.)
The column (b) item can be the 425, or the 490 and any number in
Need to do a vlookup to find if the 470 is present in any of the
assorted ranges contained in column (a).
Thank...change pixel values in a CBitmap
I hava CBitmap object that i wish to iterate over and change the values
of certain pixel colors, how is this done?
thanks in advance
First, you will have to use GetBitmapBits() and then you'll have to use
Hope this helps.
> I hava CBitmap object that i wish to iterate over and change the values
> of certain pixel colors, how is this done?
> thanks in advance
Might I also mention that you may want to use GetBitmapDimension().
> First, you will ...WEEE value
how everyone handle WEEE in GP?
I don't handle WEEE in GP. I toddle off the the bathroom...
"hlv" <firstname.lastname@example.org> wrote in message
> how everyone handle WEEE in GP?
> many thanks
...Outlook Object Model Threading
after months of working in an addin for outlook using OOM, I found a big
problem which is that OOM is not multithreaded as discussed in:
Problems started with multithreaded as I described in an e...Set value of a field based on a value in a subform
I have a form to add a new record to a record set. I would like to create an
AfterUpdate procedure that will set the value of one of the fields in the
main form to the value of the related field in the sub form. The forms
are linked by the BrdSN field.
Private Sub BrdSN_AfterUpdate()
' set the value of the BGA# field in the main form
' to the value in the BGA# field in the sub form
Me![BGA#] = Me![MySubForm].Form![BGA#]
but nothing is updating.
Thanks for your help!
In which form's module is this co...Assigning values from a sheet to an array
Can anyone explain why I get a runtime error with the code below.MANY
Option Base 1
Dim Vt() As Double
Dim j As Long
Dim i As Long
ReDim Preserve Vt(1 To 40)
For i = 1 To 40
j = Int(Rnd() * 1100)
Vt(i) = Worksheets("data").Cells(1, j)
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Software!
Because j is greater than 256, the maximum number of columns in Excel.
Ann...No "Assign Macro"
In the Excel help files it indicates that you can execute a pre-recorded macro from a command button. It states to first record the macro, then create the button, then right click on the button to get the shortcut menu and choose Assign Macro. I have tried this in both Excel 97 and Excel 2002 and in both cases I do not have any such item as "Assign Macro". Am I missing something
If not by this elusive shortcut menu item, how can I assign the pre recorded macro through code?
It may be that your working with a command button from the "Control Toolbox" instead
of...Serial Numbers auto assigned
S/N are being auto assigned when the SOP Setup Options DO NOT have
"auto-assign serial numbers" marked.
We do NOT want to use a separate fulfillment process. Up until a few months
ago, everything was fine. Now, when a PO item, assigned to a sales line item
comes in, the s/n is autoassigned.
How can I get this to go back the way it was? Below is the way we have had
our SOP set up for eight years - why has it changed?
Allocate by: Doc/Batch
X Transfer Order to BO / Transfer Order to Invoice
X Allow repeating documents
_ Use Separate Fulfil...#VALUE! error: vlookup works in Excel 2000 but not 2003
My client has a spreadsheet which works fine in Excel 2000 but when opened
with Excel 2003 it populates the pages with #VALUE! and the best I can tell
is that the problem is with the following formulas.
Can anyone advise if they have seen this before. I am unable to post their
file but this is the code that I think is a bit suspect.
=IF(ISERROR(VLOOKUP(B14,'C:\Documents and Settings\User\My Documents\[Price
and Settings\User\My Documents\[Price List
040301.xls]Items'!$A:$M,11,FALSE...Is there a way to extract Dropdown List values from CRM?
I'm wondering if there is an easy way to extract all dropdown list values
from a customized CRM deployment. I want to put them in a document to use as
a baseline for a similar implementation.
You can export your customizations by going to Settings > Customization >
Export Customizations. You can export all your customized entities into an
XML file that you can re-import into your other deployment. You'll be able to
choose which entities to import. But you will get all the customizations on
the selected entities, not just the picklist values. However, you can also
use this...Change Date Values
I've created a pivot table that has dates along the top and quantities sumed
in the data field. The problem is that Excel is not combining the date like
I want. I want the date columns at the top to be distince my month-year, but
excel is distinct for full date. To give an example. I have columns for
January 2004 such as this:
01/01/04 01/02/04 01/03/04
I want a single column for January 2004 with quantities added together and
not seperated by the day. Please help. Thank you.
Select one of those headers and right click on it.
Choose Group and show d...No Assigned Licenses
We have a total of 5 licenses. However only three users can access the CRM
applications. If any other user tries to access the application we get an
error message stating No Assigned Licenses
You have to actually go assign the users licenses with the CRM, Log in
to CRM as administrator, Click Settings from the Left menu, Click
Business Unit Settings, Click users, Click the user you want to assign
a license to, then from the popup click license from the left menu,
Click Manage Licenses and add a license to that user. Just to warn you
do not remove the l...Look up in another sheet for values to return in 1st worksheet
I have a workbook with 2 worksheets, 1 sheet is a simple summary showing the
current months data and the ytd data (the month would be input by the user)
as below. The second sheet will have the month by month information and the
How do I get it to lookup according to month inputted and then pick up the
correct corresponding data
Enter Month "Apr"
Jan Feb Mar APr....... YTD
Maybe you can you use INDEX an...Assigned task
Hi, we are receiving emails from our bosses with
attachment of our schedule task which we manually enter
into our outlook task folder, is there a way or how can we
automatically accept assigned task to integrate to our
We are using outlook2000 under windows98 the outlook 2000
version is part of the office 2000 package install on out
Is your boss sending the tasks to you using Outlook Rich Text Format? If
not, have him start. Also, how is he assigning tasks? Using the Assign
Task feature or forwarding the task to you?
Milly Staples [MVP - Outlook]
...College Assignment Woes
I would GREATLY appreciate it if someone could guide me in some kind of
direction. I have been given the following data:
On a new sheet, named Salary Table, starting at cell A1, build the
My exact problem is that I must createa formula that can be used for
all to calculate the amount to each employee for the year 2004. The
increases take place on the first day of the month specified. This
means that if increase comes in July, the pay is six months at the old
rate and six months at the new rat...Assigning Records
When a Microsoft CRM Record is assigned from one Microsoft CRM User to
another, the Microsoft CRM User who assigned the record will maintain share
privileges on that record once it has been assigned. The ownership of that
record will be changed to the Microsoft CRM User the record was assigned to,
but the User who assigned the record (the previous owner) will still maintain
share privileges on that record. (KB861702)
We have a situation where we our system reassigns accounts to different
users quite often. We would not like the previous owner to have share
privileges on that record. It...Subtracting values in a query
I have a query with multiple repeating values, each value has a set of
readings assigned to it How do I subtract the max/min from the readings for
each value (looking for change over time)?
Value Reading over time
I would like Access to automatically subtract 3 - 0.5 for value 1; 4 - 1 for
value 2; and so on.
Is this possible? Thanks!
Replace 'z' with your [Value] and 'x' ...assign
How do I make every thin in a column that is not >4000 assigned the "0" and
every cell >4000 assigned the "1" (and ignoring the letters)?
column might look like
Message posted via http://www.officekb.com
Are there always just 2 letters (or none)?
On Tue, 07 Jun 2005 17:32:03 GMT, "jeremy via OfficeKB.com"
>How do I make every thin in a column that is not >4000 assigned the "0" and
>every cell >4000 assigned the "1" (and ignoring the letters)?
&g...Display Custom Market & Value
Maybe this is a simple chart example but I am not able to figure it
I have some data in the format below.
Date 1 Value
1 Jan 10
2 Jan 20
3 Jan 40
4 Jan 30
5 Jan 50
and so on (around 1000 entries)
Now I have some events that happen at certain values. Like at 30 there
is a positive event that has a value +10%. Lets say at 40 value, I
have a negative event has a value -10%.
I store this information in two columns. I can also concatenate it if
I want the Text "P 10%" along with a Marker at the value ...CRM 3.0
Is there any way to use work flow to automatically assign leads to varius
salesman as the leads come in.
With v3.0, you can write a .Net assembly that you can call from workflow.
This could be used to cycle through a list of reps and process the
MVP - Microsoft CRM
"Dave M." <Dave M.@discussions.microsoft.com> wrote in message
Is there any way to use work flow to automatically assign leads to varius
salesman as the leads come in.