Tailspin Toys Loyalty Program source code?
Is the full source code available for the "Loyalty Program For Tailspin Toys"
mentioned in the RMS Customization guide? Where can I get it?
This is a multi-part message in MIME format.
It didn't work and they pulled it.
Check Point Software
=3D=3...filter form on value from linked table
Is it possible to filter a form (based on table A) on a value in a table B
where the tables are linked?
I would like to filter the form records (Table A) by using as input the
company name (or part of it) from a textbox.
Message posted via AccessMonster.com
Sorry for this but I forgot
I would like to use like
as I already use it to filter the form based on values from another txtbox on
Message poste...Remote Access to Web Client???
Are there any options for Remote Access to the Web Client? other than
...link Access workbook to Excel workbook
Can I link information from an Excel worksheet to an Access worksheet?
In Access, clic on File menu, External data, link tables and follow each step.
You'll have to define first row as heading label and that's it.
> Can I link information from an Excel worksheet to an Access worksheet?
...Importing Data into Existing Pivot Tables ?
Can anyone tell me if it is possible to *import data into an existin
pivot table *(possibly from a excel spreadsheet(refresh) or with
query to a Access database table) **I need to do this daily with
pivot table if possible ! Thanks in advance !
jman559's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2945
View this thread: http://www.excelforum.com/showthread.php?threadid=49157
...Query: Link data between worksheets?
I'm trying to find a shortcut to save me some time.
This is the problem:
I'm setting up a master worksheet, and 30 to 40 "slave" worksheets tha
need to run off it (all within the same workbook). The slave worksheet
all retrieve data from the master. The data is setup to run across i
rows (i.e. Row 1 contains 1 record). Each record has an individua
identification number entered in column A.
Is there a way that I can tell the slave sheets to copy an entire row
based purely on the identification number entered in column A?
Thanks in advance if anyone can help, as this could ...Data Validation
I want to set data validation on a cell so that it will accept the following
(and only the following) text strings:
(1) "BR" (literally)
(2) "NT" (literally)
(3) "nA" where n is any positive integral numerical value including zero and
A may take any of the values "L", "P", "T", "V" or "Y"
(4) "An" where n is any positive integral numerical value including zero and
A may take either of the values "K" or "D".
Is this possible, please, and if so how? thanks
Return e...Forms: can a cell itself be clickable?
Hi! I'm trying to create a form for my boss. I'm using the forms toolbar,
but what it does is throw in a check box for instance, but if I change the
cell in any way, the "picture" of the click box stays where it's at. Any way
to change this?
In other words, I don't want to the click box to be a picture, I want it to
be an integral part of the cell, so I can modify it as needed (ie. place it
centrered horizontally or vertically etc.
Am I dreaming in colour?
I've seen a macro that will insert a checkmark when you select the cell, but
I...Excel 2000 #15
We have a situation where all of the text keyed into a
cell does not appear when viewing or printing the
spreadsheet. If the user merged a row into columns from J
through W, it all appeared. If we inserted hard returns
into the entry into the cell, it also displayed. Has
anyone had similar a experience? If so how did you
Specs for Excel states that 32,767 characters can be placed in a cell.
1024 will be visible or can be printed.
Using ALT + ENTER to get hard returns will increase this limit.
Gord Dibben Excel MVP
On Wed, 14 Apr 2004 07:20:58 -07...Outlook client 2002 and 2000 are hang when restart DCs
We have Windows 2000 one forest one domain with six sites setup, each site
has atleast one DCs with GC role, The head office have two DCs (DC1 and DC2)
and both are GC as well. There is only one exchange 2000 in Head office on MS
cluster which hosting around 4000 users, All Windows 2000 servers has SP4 and
upto datae critical patches including MS clsuters, Exchange 2000 has SP4.
Now when ever we restart any one DC either 1 or 2, our outlook clients seem
to be hang, we cannot open global address list, and following evnts get in
application log of exchange node, these two DCs are appea...Tables in Outlook 2000
A user copied a table from Word 2000 to an Outlook email
message and sent the email to a Macintosh user. The Mac
user cannot read the email with the table in it. The
message shows up as an OLE attachment. I asked the user
to send it as a regular attachment to the Mac user instead
of sending the table within the email. Is there a known
issue like this between Mac and PC?
...Filtering data on subforms
How can I filter data in a subform?
The subform is a datasheet linked to a parent form (field)
On Fri, 8 Jun 2007 22:37:14 -0500, "Alberto Rios" <email@example.com>
>How can I filter data in a subform?
>The subform is a datasheet linked to a parent form (field)
Base the subform on a Query selecting the records you want to see.
John W. Vinson [MVP]
...Combo Box on Forms
I am using a combo box on a form that has several items w/ one being
Other. If the user selects other I want them to be able to input what
they want so that it will go into the table instead of just the
"Other". I just am not really sure on how to do that. Can you help?
In design view click on VIEW - Properties and the the combo. Then change
Limit To List to No.
Build a little - Test a little
> I am using a combo box on a form that has several items w/ one being
> Other. If the use...Outlook 2000 boots for a few seconds, then shuts down
My Outlook 2000 (running under XP) has started booting, but only for a few
seconds, then it shuts down by itself. I cannot access new or stored
messages, manage the personal folders, etc. I get a popup Microsoft Outlook
message that says:
AppName: outlook.exe AppVer: 18.104.22.16804 ModName: emailscanner.dll
ModVer: 22.214.171.124 Offset: 00040df3
To view technical information about the error report, click here.
I have re-installed Microsoft Office 2000 (including Outlook 2000), but the
problem remains. Outlook still boots and then disappears in seconds...How to print 2000+ characters seen in formula bar? #2
Formula bar shows +1024 characters, screen only shows 1024. Printer only
prints 1024. How can I print all?
Add some alt-enters to force new lines within the cell.
Use a smaller font.
Widen the column width
lengthen the row height.
> Formula bar shows +1024 characters, screen only shows 1024. Printer only
> prints 1024. How can I print all?
Thanks, but none of your suggestions work. I'm using Excel 2003 by the way.
"Dave Peterson" wrote:
> Add some alt-enters to force new lines within the cell.
&g...How to access a category name and code from vbscript
I am modifying the lineitem.html for the status bar in Store operation. I
want to ask how can i access the category name and code for each item, i only
can find a categoryid function, which is in the
TransactionEntry.Item.CategoryID, but can not access the name and code for
You will need to retrieve the name and code via SQL using the ID:
resultSet=QSRules.OpenRecordset("SELECT Name, Code FROM Category WHERE
ID=" & TransactionEntry.Item.CategoryID, true)
New West Technologies
> I am modifying the lineitem.html for t...Pagination on a Continuous Form
I would like to have one continuous form hold a list of 30 records per page,
and be able to see the page numbers (and use them) at the top and/or bottom
of the form, such that a total of a couple hundred records (or more) can be
displayed in groups of 30 at the request of clicking the page number (similar
to that of a webpage, but only an MS Access Form).
On Fri, 5 Mar 2010 11:23:01 -0800, VWP1
You'll have to do all the work yourself, because such interface is not
natively supported. Would be an interesting project though.
-To...OWA Access Is Denied for Win2k Users on internet
Dear kind MVPs,
Sorry for cross posting and the length.. but i am desperate for the
Heres the setup.
one Win2k Server (DC) ,
One Win2k3 Server (DC+Exchange2k3),
One server with Reverse-Proxy configured to direct all HTTP requests to the
Exchange Server (working OK ).
Assume my exchange server name is MyServer and Proxy Server is MyProxyServer
and domain is MyDomain - names assumed for clarity otherwise valid IPs are
I am able to login using
http://MyServer/exchange interanlly ( XP + Win2k )
http://MyProxyServer/exchange from XP clients from internet
but not from http://My...Problems with Mail Merge from Word 2000 to Outlook 2000 in Win98
I've been successful at trouble shooting my employees many mail merge
problems, but this one is stumping me:
Mail merge from a Word doc, no errors in the merge data, but the
messages never show up in the Outlook outbox.
Possible issues: computer also has Outlook Express 6 on it and Eudora.
But shouldn't matter, becase neither of those have mail merge
capabilities from Word.
It sure could matter. Outlook must be your default mail program.
<firstname.lastname@example.org>...Need access advise regarind linked versus imported tables
I have designed an application that uses a linked csv file as the main table.
The reason for this is because another user creates this file and jsut puts
it into a designated folder on their computer.
Here is the issue.
The csv file contains approximately 20K records. I cannot create any type of
index on a linked file. Am I better off importing the file into access (or
reading the linked table and inserting them into another table with an
index)? Is there an easy way to perform something like this? Will this
I am pretty new to access and am looking for any and all...get data form cells sequentially
I have a spreadsheet i am creating which is giving me some amount o
hassle!!! I'm sure it is possible to do this but i just cant figure ou
I have one worksheet which has many copies of the same table, eac
table is consistantly ontop of the other i.e. first table uses cells A
- G10 (a rectangle of cells).
The dates i am trying to use are in a pattern of a nine row seperatio
i.e. first date is in cell G2, next one is G11, next one G20, and s
I need to find out how i can make a formula which i could copy whic
would grab the date out of these cells in sequence for pl...Dividing a cell in Excel 2000
I am embarrassed to ask, but here goes. About a year ago
some of you on this forum explained how I can divide a cell
without creating a whole new row. I can't remember how I
did it. With a diagonal line? A horizontal line? A vertical
line? Doesn't really matter; I just want to enter a number on
each side of the divide.
You can always find previous posts in the archives. Just enter your name
or email address in the author field at
to see your posts and any replies.
You might take ...How do i print an excel file in the form of a booklet?
I have a list of phone numbers and addresse that I need to print in the form
of a small booklet that I can carry in my purse. How do I print it? What
program and how to set it up? Also I want ohotos on the left and data on the
right side pages.
I'm not sure excel is the best application for this kind of thing.
I'm sure you could do it (after a few hours/days/months of frustration!), but
maybe you could find a better application by searching google.
Or even put the data into MSWord and use that for all the nice formatting.
> I have a list of p...What can stop a PC from displaying Access 2000/2003 text & background colours?
Can anyone suggest a reason why a specific Dell Inspiron 9300 laptop should
be unable to display any of the text or background colours on an utterly
basic test form with only a couple of text boxes and no VBA code on an
otherwise empty test database?
The problem also happens with an application of mine using Access 2003
runtime - but only on this PC. It runs fine on several other PCs.
I have applied every available Windows XP Home update and every available
Office 2000 update to no effect. The laptop (set to 32-bit colour) can
display digital colour photographs without any problem and ...Merge & Sort Dynamic Lists w/ Data Validation
First off, let me say thanks to the Excel Usenet community that has
helped me over and over through these newsgroups. You are phenomenal.
Question 1: I need to create a BOTH box that will dynamically pull
names from both the "Chicago Office" & "Seattle Office" columns in my
sheet. It is extremely preferable to do this without VB Script if
possible to avoid the security warnings on opening the sheet. (Our IT
department will not budge on this..)
I have two lists of employees. Column A lists the Chicago Office
employees. Column B lists the Seattle Office employee...