Auto-Select Button on "Lot # Selection" screen in Manufacturing
I have a test company and a live company, the test company has the
"Auto-Select Button" active in the "Lot # Selection" screen, and I can enter
quantities in the quantity lines available to insert into the document.
In the Live company I cannot do this. And the "Auto-Complete Button" is
disabled, and I cannot type in the quantities of the Lot/Bin for the document
How do I make this feature active?
I tried turning on "AutoAssign Lot Numbers" in SOP setup, no luck...this is
not selected in either DB.
...synchiing two computers?
Is there a way to synch Outlook on two computers?
I end up with some email on my laptop and some on my desktop - it would be
nice if the two could be synched so that I could have all of my email on
Take a look here, it may help:
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Bill Andersen asked:
| Is there a way to synch Outlook on two computers?
| I end up with some...QUESTION ABOUT DISABLING A BUTTON ON A FORM
I have 2 checkbox on a form and a button. The button is disabled when the
form is loaded and enabled when either of the checkboxes is checked. What I
want to do is set things up such that when the checkboxes are both unchecked,
the button is disabled. I tried the On Current event of the form, see below,
but that didn't work.
Private Sub Form_Current()
If Me.chkFilterBy.Value = False And Me.chkTimeRange.Value = False Then
Me.cmdFilter.Enabled = True
Me.cmdFilter.Enabled = False
Private Sub Form_Load()
M...Compare two cells in two different files and return answer
I am attempting to compare two text cells and if they both exist, I want to
bring in a "yes" answer. If they don't, bring in a "no" answer. Here's an
example of text.
Col A Col B
Col A Col B
So, what I want to do is say in File 1 take cells A1 and B1 compare them to
File 2 and search Col A and Col B and if there is an exact mat...Mouse event question
Does anybody know if is there an event triggered in the CWnd class when a
mouse "enters" that class, I mean, for example, when the mouse moves out
from a view, or returns to a mainframe from the desktop? So far, the only
workaround I've found is to use the OnSetCursor event to signal the position
of the mouse, but this is not the optimal, since is triggered each time the
mouse moves, making the application slow, and, as I said, I only need a
signal that tells me when the mouse leaves one window and enter to another.
Thanks a lot for your attention.
OnMouseMove is what you nee...Pivot table for two different data variables
I have the following table
Name type Cost overhead
amy C1 23 12
bob C2 129 17
cat C2 36 45
doo C2 100 32
I owuld like to create a pivot table that looks similar to:
the standard pivot table. (Please ignore type for now.)
name Data Total
amy Sum of overhead 200
Sum of cost 12
bob Sum of overhead 130
Sum of cost 23
cat Sum of overhead 90
Sum of cost 19
doo Sum of overhead 87
Sum of cost 34
Total Sum of overhead 507
Total Sum of cost 88
But with overall total (overhead + cost) for ...COUNTIF (?) on two criteria
I have a spreadsheet that logs work activities and records team
members' completion of project units.
Column B records team member names. Column C has project unit status -
'pending', 'beta' or 'completed'.
It's easy to set up a formula to count how many units are allocated to
each team member - =COUNTIF(B1:B1000,"Joe"). But what I need to do is
set up formulas to count how many units Joe has completed, or has
pending or at beta, and this means assessing data in both columns -
which COUNTIF won't do.
This doesn't strike me as an especially...Lost send mail button
Suddenly the send button is missing from the toolbar and
the help database doesn't give information on how to
restore it. The button is on the general bar but not on
the message itself, so that I can put it in the outbox,
but it won't go out because it hasn't been "sent". Very
frustrating, and my manual doesn't cover it.
Thanks for help. Urgento!
...Two IF Statements with two answers
In cell J9 I need a formula that would do the following:
If G9="Yes" then F9, If G9="No" then -f9
Note: G9 has a drop down list with Yes, No answers.
If there are no other alternatives that yes and no
> In cell J9 I need a formula that would do the following:
> If G9="Yes" then F9, If G9="No" then -f9
> Note: G9 has a drop down list with Yes, No answers.
Positioning the Vertical axes:
I have a chart where there are two axes. The first implementation produced
the two scales on the right side, one inside, the other outside the chart
area. Unusual, but luckily it fits well the chart.
I tried to duplicate the feat with another dataset (similar in structure)
and did not even get the second scale to show right, left or center (data
plotted with two different scales allright).
Where is the info to control these functionalities?
On Wed, 29 Oct 2003 17:48:13 +0100, pl.carry <email@example.com> wrote=
> Positioning the Vertic...Custom POS button for blind closeout
Is anyone aware of an internal command which can be used for a custom POS
button to perform a blind closeout?
Many thanks, Nick
The Bottle Bank
2 Tidemill House, Discovery Quay
Falmouth, TR11 3XP
Tel: 01326 218 319
I don't know the internal command, but we did it a different way.
I think that "F5" brings up the blind close window. On our machines we just
made a macro to do this and assigned a button to it. You still have to
select it, but it helps our cashiers.
Hopefully this helps.
&g...plot two groups of numbers on one series of xy coordinates.
how to create a plot from separate x and y values. i.e. y values do not
correspond to the same set of x values. example x1= 5, y1=10; x2= 8, y2=15
I can read your question 2 ways;
A) you data looks like this
Select the data and make an XY chart
B) you have two sets of data
Make an XY chart of the first data series
Select all the data (including headers) for second set, and use Copy
Click the chart to activate it
Use Edit | Paste Special .... indicate New Ser...two variables
I have a query that asks for collcode, collcode2 and booth. On any given day
an employee may be collcode or collcode2. I would like to know how many
times a certain emp has been paired with another employee. So how do I ask
if an employee has been collcode/collcode2 and who the other person was? I
hope this question makes sense.
Thanks for any help
SELECT CollCode, CollCode2, Booth
SELECT CollCode2, CollCode, Booth
SELECT CollCode, CollCode2, Count(CollCode) AS TIMESPAIRED
GROUP BY CollCode, CollCode2
IF y...Find two PCI instance but load Init() one time
I'm developing a stream interface driver for my PCI device under WinCE 6.0
and this driver works very well currently. Now, I got a problem when testing
two the same PCI devices with my stream driver.
The registry can find two PCI instances (i.e. PCI\Instance\mydrv1, PCI\
Instance\mydrv2) but system only call my XXX_init() one time. Does anyone
know what the problem is?
The following information is my registry setting:
"Dll"="myd...Comparing two lists for matches
I am trying to do the following:
There are two sets of supplier lists - A List and B List. I need to
compare the two lists. Source A is my master. Source B is a subset of
that but has contact information for all the suppliers. Hence, my goal
is to retrieve the contact information from Source B and match it to
the suppliers of Source A.
The above can be easliy achieved using a vlookup funtion. But the
problem is that some of the supplier names in the two lists are not
exact matches. Hence, vlookup does not catch it. For instance, a
supplier is listed as ABC Inc. in A list and as ABC, inc....Compare two lists of names
Can you compare two lists of names where one list is last name first and the
other is first name last?
try this formual:
=RIGHT(TRIM(E2),LEN(E2)-FIND(" ",E2))&" "&TRIM(LEFT(TRIM(E2),FIND(" ",E2)))
it will convert First name last name to last name, first name or Visa versa.
then you can compare your lists.
> Can you compare two lists of names where one list is last name first and the
> other is first name last?
It happened all of a sudden:
when I type something in a cell and move to another cell, the undo button
greys and the undo function is therefore disabled.
It never happened before, and I have no recollection of having modified
settings. in this regard I could not find any setting to enable/disable the
can please somebody help/
Have you got some macro running?
> It happened all of a sudden:
> when I type something in a cell and move to another cell, the undo button
> greys and the undo function is therefore disabled.
> It never hap...Compatible driver f. writemaster
I'm having a problem with installing win98.
No compatable driver is on the start diskette for
my DVD/WriteMaster optical drive. I downloaded a
driver from samsung. This one fills more than can be
contained on the disk. Does anyone know how this
problem can be tackled ?.
The 40GB fat32 formated harddisk intended for win98
is mounted as a secand drive on a Vista machine. Any
problem with this too ?.
Get a old PC and put put win98 it on it>>>. you can get one for $25 with 10
gb hard disk
Then Copy to that 40GB fat32 formated hard disk @ Drive D:\
and ...Modify columns on Account view from Regarding button on email
I have added a custom field, Alias, to the Account entity. When users
write a new email and click on the Regarding button to track it in
CRM, they get an Account view to select the account.
I would like to modify the columns to display the new field I have
added because users need it to tell accounts apart.
They cannot send emails from within that account in CRM because those
emails do not go out.
I have tried modifying the existing Account views but none of them
seems to be used by the Regarding button. Do I have to use the SDK?
If i understood your requirment correct...Two copies of all Mailboxes
Using my sbs2003 srver with exchange 2003 installed - I notice two copies of
all users mail box in the list of mailboxes using outlook 2003 on the same
server. When I try to close these I get an error syaing mail boxes in use. I
cn not remove them. Can you tell me how to remove these so I have just on
mail box visible per user?
I need some help with a form. What I am trying to do is, to place a button
on a form in MS Access so that when you click on it, in another field it
will display a number one. If you click on the same button again it will
change the one to a two and so on.
Private Sub YourCommandButton_Click()
YourTextBox = YourTextBox + 1
There's ALWAYS more than one way to skin a cat!
Answers/posts based on Access 2000
Message posted via AccessMonster.com
"Wes Derhak" <firstname.lastname@example.org&...Photo Shop Compatible to XP/SP3
I've been using 'Microsoft Digital Image 2006' since 2007 or earlier. It's
been a terrific program, particularly 'Photo Shop' when in needing to
enhance images and etc. However, on XP/SP3, MDI 2006 is VERY sluggish and
often it's hard to load photoes.
My question is;
What or which Photo-Shop/program is more compatible to XP/SP3?
Thanks for your help in advance.
> I've been using 'Microsoft Digital Image 2006' since 2007 or earlier. It's
> been a terrific program, particularly 'Photo Sh...How do I create a chart on two axes with two lines and a bar
I am trying to compare two final stock prices to the average volume.
So, teh left axes would have the numbers for the stock prices, and the
right axes would have the volume. The two stock prices would be lines
using the left, and the volume a bar using the right. I can do one line
and one bar, but I can't figure out two lines.
Can anyone help?
Forget the built in custom types. It's better to build your own. Create your
chart using all the data, to produce a chart with three line series all on
the primary axis. Select the Volume series, and on the Chart menu, use Chart
Type to ch...Option Button protection on spreadsheet
I have (thanks to this newsgroup) successfully set up a
user form leading to a spreadsheet which has options Yes
or No - these answers 1 or 2 are in turn fed into another
sheet with If statements to show text.
Eg: If the user clicks the Yes Option then 1 appears and
in the final sheet =if(A21=1,"Please let us quote
you","Customer already has insurance")
So, everything is working but what I do not want to happen
is that the user clicks on the group box and drags the
position of the option buttons - I have tried to protect
the sheet - contents but then I cannot cl...how do I display last two digits of a SSN in a separate column
I am trying to create a formula to take an existing list of 8 or 9 digit
numbers and display the last two numbers in a separate column. Is this
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> I am trying to create a formula to take an existing list of 8 or 9 digit
> numbers and display the last two numbers in a separate column. Is this
Use a formula