Date format issue when submitting from a userform to a spreadsheet
I have a userform that I've generated which routes dates onto a spreadsheet
based on the users input. I am having a bit of a frustrating time with the
dates, it would appear that in the process of moving the date from the
userform to the spreadsheet some dates are switched/transposed. I'll give an
example. If someone enters 09/02/2004 on the userform excel seems to look at
09 and assume it is a month and transposes the dates to 02/09/2004(this does
not appear to be a US/UK format issues as I have already gone down that
road). However, if the date 13/09/2004 is entered i...Form for table
Here's the problem:
Access 2003, XP Pro-
I have three tables that are related by primary keys. I have a
table[Table QC] that has the field [EmployeeID], the data type is
number--that field is linked to the autonumber primary key of the
Employees Table. So far so good. I am trying to make a form that has a
combo box that looks to the Employee Table to get me the drop down of
the employees (Last Name, First Name). The SQL statement builds out
okay, and I get the correct name config., but because the data type is
a number it won't accept the data. I looked at the Northwind example
and i...How to get XML data out of an XML file
I am trying to retrieve the Parameters first or second (0, 1 ,2) node from
the following XML file:
<?xml version="1.0" encoding="utf-8" ?>
There will be more data than just a name for each Parameters node. Here is
Dim node As XmlNode = xmlDocument.SelectSingleNode("/P...Baseball Stats question: How can I get the RBI's?
I have a data table that looks like this:
STR-S SNK-S STR-K STR-F SNK-S STR-3 STR-2 STR-F SNK-S SNK-4 SNK-S STR-3 SNK-F STR-4 STR-O
"STR", etc at the beginning are pitch types, SNK is Sinker for example
The end character is the result of the pitch, a 4 would be a home run,
3 a triple, and so forth. O is out, F is foul, S is strike --- you ge
How can I figure the amount of RBI's? I know that it's 5, but I can'
think of any automated way to calculate this, anyone got any ideas?
THANK YOU!! :confused
AVER...Get at messages in queue
Is it possible to get at the undeliverable messages that are held in a queue
(eg to check the message body or redirect undeliverable messages). I would
like to be able to selectively forward them to an alternate email address or
to archive them to a PST etc rather than just deleting them?
...chart label reference based on the column number
In a worksheet with an embedded chart, I have a cell, S4, where I enter the
number of the column I want to chart (these numbers are listed as labels in
I can't figure out how to translate the number in S4 into the corresponding
column letter. For example, if S4 contains "3", the chart title should be
I think working with absolute references, R1C1, might be easier here, but
somehow what I've tried, didn't work (the entire spreadsheet is based on
relative addresses (A1).
in a cell (Z100) put
Change G2 to whatev...How to get paper size from dmPaperSize returned from GetDevMode?
For example, dmPaperSize returns 1 which is DMPAPER_LETTER, how do I
calculate the paper size like in this case 8.5"x11"?
There are so many paper sizes, is there any function call to calculate
based on the return value of dmPaperSize or mapping between the value
of dmPapersize and actual size?
The reason I asked the question was because dmPaperLength and
dmPaperWidth are 0 for some printers.
Also, my HP laserjet returns as a color printer (dmColor = 2) from
GetDevMode call. Anyone knows why?
...does vista installed on virtual machine 2007 get wsus updates ?
It is searching for updates but it is not finding anything and saying
that Windows is up to date. I have set the updates to install from the
wsus server and assigned the updates to the same Vista virtual machine
aconti's Profile: http://forums.techarena.in/members/73272.htm
View this thread: http://forums.techarena.in/active-directory/1290161.htm
If the machine is getting the correct GPO for the WSUS settings, check with
rsop...Count unique values
I've some problems to count unique items (Invoice #) in a pivot table. There
is the default solution "Add-a-new-calculated-column" as mentioned on
http://contextures.com/xlPivot07.html#Unique, but in my case, it doesn't
My problem is, that these values aren't in a Excel worksheet; it's a
external data source - a SQL-Select via DAO/ADO. Because of that, I don't
have the possibility to add a new column. Another reason is, that the pivot
table should always be dynamic: Group over this field, group over another
field - and always show the number of unique...NDR Report
We get this NDR error when someone sends to a particular address:
550 Only 1 recipients accepted with null sender address
Again, the emails are sent using Outlook to a listing in our GAL for the
Custom Recipient. I have checked the outgoing messages and they do contain
a sender address.
Have you contacted the recipient's admin folk on this?
> We get this NDR error when someone sends to a particular address:
> 550 Only 1 recipients accepted with null sender address
> Again, the emails are sent using Out...Custom Item Movement Report
Anyone out there have a custom item movement report and item movement
history report that includes extended description that they would be willing
That was a pretty tricky request but I was able to make the change.
Download the reports here:
If you cannot download from there shoort me an email and I will send
over. Check out our RMS add-ons website in exchange..
New West Technologies
Can you do one with "Transferred To"...Keyboard shortcut for current date and time
Ctrl+ ; inserts current date and Ctrl+Shift+; inserts current ti me
Ctrl+Shift+; inserts the current time with the date serial as 0 and
not the current date's date serial.
Presently I am adding the two (ie current date and time) to get the
current date and time. Is there a keyboard shortcut that does this?
Thanks in advance.
CTRL+; then SPACE then CTRL+SHIFT+;
Portland, Oregon USA
wrote in message
Ctrl+ ; inserts current dat...Z Report shows zeros for an entire shift
How do I correct the problem described above? All receipts are printed
correctly, and all transactions seem to be successful. However, the Z report
that is run at the end of the shift prints all zeros? Any ideas???
I am having the same problem. All the transactions are successfull and I can
see the sale amounts and etc at crstal reports but all the z, zz and x
reports print "$0.00" amount. Does anyone know how to solve this problem?
> How do I correct the problem described above? All receipts are printed
> correctly, and all transactions seem t...Comparing first and last names in two lists
I have two data sources that each contain about 8000 names in seperate
fields for first and last name. I can put them on seperate worksheets
or append one to the other. I need to make them match and find out
where they don't. Messed with consolidate but not sure if that will
work for more than one column at a time. FYI data set one is from a
school transportation database and data set two is from the main
student database from the same school district.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages dir...Two mailboxes for one user account after mailbox moved to a new server
After moving a user's mailbox from a Exchange 2003 to a new Exchange
2003 server, Outlook has listed two mailboxes with same name in the
"All Mail Folders"area. The Outlook profile only has the user mailbox
and no other mailboxes added to it. The user can send and recieve email
just fine. The mailboxes seem to be clones of each other. New mail show
up in the mailboxes at the sametime.
How can I get Outlook to only show one mailbox?
Any help would be appreciated,
...Pulsar Women's Crystal Accented Dress Two-Tone Stainless Steel Watch #PEGA16
Best deal: http://bestdeallocator.info/index.php?id=B001L1RZ8C
This ladies' two tone, Pulsar fashion watch features a white dial CrystallizedTM with 22 Swarovski crystals. Watch is water resistant up to 30 meters.
This stylish timepiece features a two-tone bracelet and case. The mother-of-pearl dial is accentuated by gold-tone hands and markers. 22 Swarovski® crystals sparkle on this classic watch. 30M water resistant.
Pulsar Women's Crystal Accented Dress Two-Tone Stainless Steel W...gp10 change clients pointing to different server
In version GP 10 I have clients pointed to a test server. When production
server is ready what do i do to point the clients to the production server
Would I change the odbc connection?
Rerun the client installs?
Any help is appriciated.
As long as your production server has THE SAME level service pack as your
clients and THE SAME third party products all you need to do is repoint your
ODBC to the production server.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
"2020" wro...List Running Horizontally-Pivot Table Possible?
I just had a customer ask this one and I'm not so sure
1) The customer has setup a list of information that is
running horizontally instead of the typical list running
2) I just taught him how to do pivot tables and he wants
to generate a pivot table with his "horizontal" list.
3) I know he can copy and paste special and use the
Transpose feature to change the list from horizontally
oriented to vertically oriented.
4) the question is: can he leave the table in its original
orientation and still generate Pivot tables? I can't seem
to make it work ...How do I break URL address over two lines?
I am trying to enter website addresses into footnotes and Word automatically
forces the footnote onto a separate line. I need to conform to certain
aditing requirements and want the url to start right after the citation and
continue on to however many lines are necessary, but not leave a gap because
it starts the url on a separate line in the footnote. Help please.
In the edit hyperlink dialog, put the URI in both the Address and Text-to-
display boxes. That way you can use a space or linebreak to wrap the display
text to the next line without affecting the hyperlink ability. Hyp...How to view the same email message at the different PC users
My husband & I use the same PC(Windows XP) but have an
individual user accounts. We have several email addresses
for individual usages and shared usages and all enable to
receive and view by Outlook 2000 inbox. We have noticed
that the emails came in while I'm on Outlook (or
minimized at the bottom) can not view when my husband
goes to his Window user and open the Outlook. And vise
versa. We want to be able to look at all emails that came
into the Outlook inbox at both Window user's Outlook
inboxes. How can we do that?
...Getting Cell Value from the Concatenate formula
I built a concatenate formula that returns the following result: =Jul!
I am looking for the cell contents of Sheet: July Column D Row 27.
I tried to use offset, but I am stumped. Can I add something to the
front of the concatenate to not only build the reference to the cell,
but also return the value instead of the =Jul!$D27 ?
Don't include the equal sign in your formula. And match the name correctly (Jul
Depending on the name of the worksheet, you may need to have a string that looks
=indirec...using dates Part 2
Karl was great in helping me get to this point with dates, now I'm wondering
if we can take it 1 step further?
For Activity Dates prior to 2/1/2007 they are using a normal reporting year
and the formulas below take care of Activity dates >2/1/2007?
So for example prior to 2/1/2007
1/1/2006 would have a B_Qtr of 2006-1
1) B_Qtr - 2011-1 --- Format(DateAdd("m",11,[ActivityDate]), "yyyy - q")
2) Year - 2011 ---- Year(DateAdd("m",11,[ActivityDate]))
3) Qtr - Q1 ---- Format(DateAdd("m",11,[ActivityDate]), "q")
I am trying to compare 2 columns of numbers so that I can identify and
delete numbers no longer required. Can anyone help me find a formula for
Check your earlier post.
Dave T wrote:
> I am trying to compare 2 columns of numbers so that I can identify and
> delete numbers no longer required. Can anyone help me find a formula for
> this please?
> Many thanks
...Hyper link one column to another
I would like to have my columns hyper link one another.
For example: Click on B2 would take you to N2, and vice-versa. Click
on C2 would take you to O2... and so on through column j linked to V.
Is this possible without having to make the link for each cell?
This is a timesheet template and the columns b though J are the hours
and N through V are the text comments for those hours. When I copy the
template to a
new sheet, there will be no data in any column. I would like to be
able to enter an amount or formula (=end-start) for time spent and then
be able to click on that cell and hyperlin...Compare 2 different workbooks with the result in a 3rd
I have two workbooks (2005 Sales, 2004 Sales), which track daily results in
half hour intervals. I want to be able to show the increase in 2005 in a 3rd
workbooks. The first two workbooks are identically formatted. How can I do
this? Many thanks to all in the forum who have helped in the past.
If the data is in exactly the same position in the two worksheets you could
copy/paste one's data to a new worksheet and then copy the second's, doing
an Edit, Paste Special, Subtract on top of the first's data. This is
admittedly crude but it is easy to do.