Stdregprov decimal return codes?
I'm getting a decimal return code of 161 attempting to getstringvalue from a
registry key that works on somes PC's (ret=0) and not others.
I've seen the return codes for stdregprov such as 0x80041071 in hex format
which I can't easily translate into decimal. Does anyone has a decimal
return value table? I can convert hex & decimal but we see these are
different scales? Are the return code dword values?
This is running in WSH/VBS 5.7 on WinXP Pro SP3.
On Oct 1, 9:24=A0am, Rick E <Ri...@discussions.microsoft.com> wrote:
> I'm getting a decima...multiple value choices for If range().value = "xxx"
The macro below runs on worksheet change and works properly.
However, I have 5 values to examine in column H. The values are: Split,
Payday 1, Payday 2, Payday 3, and Payday 4. Any of these choices should
result in unlocking and clearing the cells in that row (first part of if
statement). Otherwise, the range 'pasterage' is copied to that row and it is
locked again. I can't find the proper syntax (if there is any) to say
something like is possible in SQL (if ...value in ("Split","Payday 1",...))
Please advise on the best way to go about this.
...Why am I getting #VALUE! when working with a TIMEVALUE formula?
This formula is working on other pages within the same workbook, yet it does
not work on a newly inserted worksheet. NOTE: this orginial workbook was
created in an early version of Excel (95 or 98), now using 2000.
what is your exact formula and what is in the referenced cells?
TIMEVALUE ERROR wrote:
> This formula is working on other pages within the same workbook, yet
> it does not work on a newly inserted worksheet. NOTE: this orginial
> workbook was created in an early version of Excel (95 or 98), now
> using 2000.
The for...How can I number rows based on unique values in another column?
I need to create a number in column A based on the data in column B. Here's
an example of the result that I want:
Number Product Code
I'm really looking to get either a 1 or 2 based on the first or 2nd entry of
the product code.
Try the below formula in cell A2 and copy down as required
> I need to create a number in column A based on the data in column B. Here's
>...Counting Consecutive Numbers in a List
Is there a function in Excel that will count how many sets of 2 or 3
consecutive numbers appear in a list of 20 numbers?
Sorry if this post is redundant, but I cannot see it go through...
Can you post some sample data and let us know what result you expect?
Microsoft Excel MVP
"Wiseguy91" <Wiseguy91@discussions.microsoft.com> wrote in message
> Is there a function in Excel that will count how many sets of 2 or 3
> consecutive numbers appear in a list of 20 numbers...SOP Return
How best should a situation like this be dealt with;
Customer returns an item, payment method was cash.
Customer returns the item and takes something of greater value.
Customer said he will pay the difference of the second item.
You could enter a sales invoice in SOP. Enter a negative quantity for the
item being returned and a positive quantity for the new item. The difference
between the two should be the amount the customer owes.
Charles Allen, MVP
> How best should a situation like this be dealt with;
> Customer returns an item, payment method...returning two values
I have a function in which two indexes are calculated. I would like to
return them both. Is this possible?
"Steve Russell" <firstname.lastname@example.org> wrote in message
> I have a function in which two indexes are calculated. I would like to
> return them both. Is this possible?
If they will fit, you could use something like MAKELONG. Otherwise you could
use OUT params.
Jeff Partch [VC++ MVP]
"Jeff Partch [MVP]" <email@example.com> wrote in message
news:%23a2ShLKwFHA.2348@TK2MSFTNGP15.phx.gb...Reminder list view
Is there a way to change the view for reminders in Outlook XP. Our new XP
users are asking for reminders to pop-up individually like in Outlook98, not
as a list in one window. Registry hacks are welcome.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"London Canada" <London Canada@discussions.microsoft.com> wrote in message
news:1...Value Minus Value = ???
Can't work this function out...
I want a box to minus another and give the total of whats left.
In the box i've put.. "=SUM(M2-F2)" and that just comes up and shows m
Whats do I need here?
Also, 1 last function that I can't figure out..
Is it possible in a value to do..
I mean, box 1 + 20p + 3.4% = my total etc
Any idea's guys?
Emzicle's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...Subquery returned more than 1 value
When I run this query:
update a set a.[UPC] = b.[IDSCE], a.[AltDescription] = b.[IDESC],
[Weight] = b.[IMNNWU],
from [ProductVariant] a inner join [IIMWEB] b on a.
I receive an error:
The statement has been terminated.
Msg 512, Level 16, State 1, Procedure trig_NotificationProduct, Line
Subquery returned more than 1 value. This is not permitted when the
subquery follows =, !=, <, <= , >, >= or when the subquery is used as
How do i go about fixing this issue.
"Mary Phelps" <firstname.lastname@example.org>...Print return quantities on packing slip and pick ticket
GP will allow a negative quantity on an invoice. Staff has been taught to use
this feature for change orders. They will enter an invoice, whatever (if
anything) is being returned is entered as a line item on the invoice with a
negative quantity. Then they will go to the next line and invoice what they
are buying. This may or may result in a credit balance. But that doesn’t
matter. The problem is when the shipping docs print (packing slip and picking
ticket) the negative quantity does not print. That is logical but customer
needs the negative quantity to print so the warehouse knows what...Lists depending on ID
I have a spreadsheet (a supply list), what I want to do is have a list
populated in the spreadsheet depending on the ID number selected.
Client 123 can only order Item A, Item B, and Item C.
Client 456 can only order Item A, and Item C.
I know I can do dependant lists, but all I want is for the cells to
populate with the list of items available.
You need to furnish a bit more information for someone to give you some
meaningful help with this. Specifically, what is the layout of your data?
By this I mean:
What is in Column A?
What is in Column B?
I gather that one ...Format of Email-List/Email Display
I actually did this once before myself but cannot remember what I did nor can
find the option for it now: Instead of emails appearing to the right of the
email list, I'd like them to appear on the bottom of the list. What do I do?
On 3/7/2010 3:34 PM, Shaan wrote:
> I actually did this once before myself but cannot remember what I did nor can
> find the option for it now: Instead of emails appearing to the right of the
> email list, I'd like them to appear on the bottom of the list. What do I do?
You are talking about the reading pane layout.
View -> Readin...Return Materials
I want to set up a database to track all my return materials from start to
end. any suggestions?
Ummm, we're going to need a wee bit more information. Like, is this your
first database? How are you tracking that information now? What version of
Access? What kind of materials? Well, you get the idea...
"I feel I have been denied critical, need to know, information!" - Tremors
"Jay" <Jay@discussions.microsoft.com> wrote in message
news:351CAC5C-0B9A-4840-BC6E...Text Function: Store Value instead of Reference
I apologize if this is a newbie question but I can't seem to find th
I am trying to clean up some data and have a column that contains 1
character ID numbers.
I only need the last 5 characters so I setup another column to get the
Now that I have the last 5, I don't need the original column and wan
to delete it and retain my new column. I can't though since the ne
column has a reference to the original.
How can I store the value returned from the RIGHT function instead o
Or, is there a better way to do this such as running so...how to set list control scroll bar position?
When more item added to list control, the HScroll bar appeared. How to
make VScroll bar appeared instead of HScroll bar ?
...Reversing cell values
how do I reverse the values of a cell (eg. 1234 becomes 4321)???
"ac512" <email@example.com> wrote in message
> how do I reverse the values of a cell (eg. 1234 becomes 4321)???
Try this UDF (from John Walkenbach's site) in a plain VBA module:
Function Reverse(InString) As String
'UDF to reverse string - John W
Dim i As Integer
Dim StringLength As Integer
Reverse = ""
StringLength = Len(InString)
For i = StringLength To 1 Step -1
Reverse = Reverse &a...Return to same cell
Hi, I enter data in a cell, if the data is wrong, how can I make the
cursor to go back to the same cell, thank you.
Totoguzzo's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25288
View this thread: http://www.excelforum.com/showthread.php?threadid=528893
How do you know that the data is wrong? Do you want to compare it with
data in another cell? If that is the case, then why not set the value
of the first cell equal to the second?
...Return last value in column
Probably a really silly question, but is there a formula i can use to return
the last entered value at the bottom of a column?
If say if my data went from A10 to A1000, and A1000 was 12, how do i get A1
to = 12?
Next week A1 would then = A1001 and so on,
Is there a =end of A:A ?
Put this in A1:
will return the last used value in the range A2:A2000.
Hope this helps.
On Jan 23, 11:42=A0am, "Jack Rabbitt" <a...@b.com> wrote:
> Hi All,
> Probably a really silly question, but...How to return to current worksheet in a macro
I'm trying to make a macro that copies a few lines from worksheet1 into the
current worksheet2. The problem is that the name of worksheet2 can change so
I can't use
to return the focus before doing a paste.
How do I do this please?
normally no need at all for select / activate.
use something like
"CWatters" <colin.watters@pandoraBOX.be> sch...Returning to 'factory' defaults
Operating System: Mac OS X 10.6 (Snow Leopard)
This form of Word is nothing like the ones that I have used in the years that I had a PC. Bought the Mac in Feb this year. <br>
I have a load of questions but will start with this primary one and if that can be fixed I will drip feed the others! :o) <br>
I don't know what I have done but in a scramble with the programme I now find that I cannot open the normal Word window (with the option of going to full screen or print by clicking on the 'spots' at the bottom of the page. <br>
...Return Authorization in Great Plains
Does anybody have an idea about a Return Authorizations process with GP 7.5
or 8 as we will be going to 8 soon. It seems like in SOP there should be a
document similar to SOP order or backorder to keep pending returns seperate
from actual returned items..and generate a RA number that could be given to a
Any ideas or creative ideas appreciated!
GP does have returns document but for what you want you probably need
"Kelly Jensen" <KellyJensen@discussions.microsoft.com> wrote in message
news:24448D92-F0A6-4888-B9DD-4028A3294541@microsoft...Look up tables vs. value fields via combo box on form
I have tables such as t_WeatherData in which I have fields such as
Temperature, WindSpeed, WindDirection. The WindSpeed and WindDirection
fields each have a lookup table with an ID (primary key/autonumber) and a
field that holds a category ("N", "NE", "NW", "W", etc., or "< 5 mph", "5-10
mph", etc.). As I have it, the look up tables merely serve to populate a
combo box on the data entry form...
OR, is creating a combo box with a value list sufficient?
What should be the factors in my decision on when to use a look...Incorrect Account Appearing on General Transaction Edit List
If I go into my General Ledger and view a certain entry, on the input screen,
it lists the correct accounts. However, if I print the edit list, one of the
accounts is incorrect. In fact, it is an account that doesn't exist in our
As shown in transaction entry screen:
51-6021-3500 Disability Insurance
12-1296-0000 Intercompany Rec/Pay -
As printed on edit list:
51-6021-1000 Disability Insurance
$478.24...Is it possible to get text values in a pivot table?
ROW COL VAL
A HD1 X
B HD2 Y
B HD1 Z
C HD3 J
A HD3 Z
B HD3 R
C HD1 S
Var of VAL COL
ROW HD1 HD2 HD3
A X Z
B Z Y R
C S J
(If 2 rows go to same cell, would need to get maximum or first).
Not with Pivot Table
Let you A, B C data be A1:A7, the HDn data in B1:B7 and the other data in
In some convenient place (I use A11) enter =A1&B1 and copy down the column
(you could put this in another sheet or in a hidden column)
Make the heading HD1, HD2 - I did this in F1:H1 and the row ...