Printing a workbook one row at a time filling in a form with the d
I have a workbook with about 20,000 rows of data. I want to design a form
and have the information from one row inserted into the form and be printed
out. The form would also have empty places for the sales people to write
additional information on the paper after they make the sales call.
The information is name, phone number, address and several other customer
related information cells. I am using Excell 2000.
IF possible I would like to print these 2 up on a standard piece of paper
8.5 by 11 inches. This means I would print two forms on one page with a
seperate record/row fi...xp/vista incompatability?
I created several pub files using office 2007. I pasted in multiple Word docs
created with two computers, one using XP, the other using Vista. The files
using docs from both computers will not open ("publisher cannot open this
file" error). I ran a test with 6 Word docs created on XP pasted into a
publisher file, opened closed it with Vista computer, no problem. Pasted 1
Word doc created on Vista into the same file then closed and tried to reopen
document but got the aformentioned error message. I tried the registry fixes
Mary Sauer suggested but no results. Thumbnails of...Form Wizard Unable to create form
After navigating through create form wizard I get message saying wizard
unable to create form.
Can anyone help me with this .
I am using Vista Home Premium and Office 2003 Profesional.
What EXACTLY does the error message say? How many fields are in the form's
Record Source? The usual message is that Access can't create a form because
there are too many fields, which means just that. The forms wizard is
intended to help the casual user create a simple form. Complicated form with
bunches and bunches of fields doesn't fall under this heading. These forms
have to be created using ...Locking Form and Subform-What am I doing wrong?
Okay, I have a form that includes a checkbox "Closed_Check", when this box is
checked I need to lock that specific record in the form and subform.
Currently I've tried:
If Closed_Check = True Then
Me.AllowEdits = False
Me.AllowDeletions = False
Me.AllowEdits = True
Me.AllowDeletions = True
and placed this in the On Current event field for both the form and subform.
It works, problem is it locks the following records that are not closed.
What am I missing?
Lori A. Pong
With continuous forms, it...Installation of Office XP SP3 issue...
I am using the Outlook 2002 client. Since I have installed Office XP
"Service Pack 3", I have noticed that each time a mail message arrives in my
mailbox, a window pop's up stating that ...
A program is trying to access email addresss you have stored in Outlook. Do
you want to allow this? etc...
This is really annoying. How do I turn this off??
Sue Mosher, Outlook MVP
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outl...After XP sp2 upgrade, Outlook 2003 crashes every time a Contact is saved or links to other contacts added to it
The subject line says it all. On my Toshiba Tablet PC, "After XP sp2
upgrade, Outlook 2003 crashes every time a Contact is saved or links
to other contacts added to it" (via the Contact's "Contacts..." link
button). The error signature is always the same:
AppName: outlook.exe AppVer: 11.0.6353.0 AppStamp:408f2937
ModName: mso.dll ModVer: 11.0.6360.0 ModStamp:40d147de
fDebug: 0 Offset: 0001f0e3d
And I always send a report to Microsoft (about 115K each), but there
is no response giving a fix as there sometimes is.
With www.Microsoft.com -> Windows Update, I ha...How do I tie a web Form to an excel database
...Office XP transfer of files to new PC
I am transfering files from my old PC to a new one and I
want to take my Office XP just as it is on the old one to
the new one; settings and all. Anyone know how to do this?
First, you must reinstall Office.
Then you can configure Outlook to use the same Outlook Data File (PST file)
you were using before instead of the new blank one it created when you
- Go to Tools > Options > Mail Setup > Data Files > Add...
- Add the PST you'd like as your new default, then Close > OK to exit the
- Go to Tools > E-mail Accounts > View or chan...Detecting Shift key when form is opened
What is the best way to tell if the Shift key is held down when a form is
opened? The form is being opened from a toolbar. I don't want to react to
the Shift key's being pressed after the form is opened. I only want to react
if the Shift key was being held down when the toolbar option was clicked.
Also, is there a way to do this for reports?
Thanks in advance.
...How to add DHCP mgmt console to XP
Is there a way I can manage DHCP running on SBS2003, or at least look
into the current lease list from an XP client?
How can I run the dhcpmgmt.msc from an XP client?
Maybe RDC into the SBS from the XP client?
-Please post the resolution to your issue so others may benefit.
-Get Your SBS Health Check at www.sbsbpa.com
> Is there a way I can manage DHCP running on SBS2003, or at least look
> into the current lease list from an XP client?
> How can I run the dhcpmgmt.msc from an XP client?
Tha...Microsoft Office XP excel 2003
When I open Excel 2003 the splash screen hangs for 30 seconds to about a
minute and then excel opens and behaves normally.
All other office programs such as Word etc open quickly and behave normally.
If Excel is opened in safe mode , the program opens rapidly without any
splash screen at all.
Any explanations and indeed a cure for this behaviour ?
When you open excel in safe mode, you're not opening the addins or stuff in your
XLStart folder or your customized toolbar.
If you don't have lots of addins turned on and don't have lots of stuff in your
XLS...Export from a form
I know there are several ways to programatically export, like
docmd.transferspreadsheet, but I want to export data from a form. I however
do not want the file button available to my users. I thought this might work
DoCmd.DoMenuItem , acfilemenu, acExport, , acMenuVer70
but it did not. Basically all I want to do is have a command button act
like what happens when you click file, export. I want the user to click the
button, and then select the location and the format to export to. Am I on
the correct track with the DoMenuItem?
Nevermind, I figured it out. I guess it helps to keep rea...Publisher 2002 photo and graphic problems on xp
Microsoft Publisher 2002 works well on my old computer with Windows 98.
However, I installed Pub. 2002 in my new computer with Windows XP and have
many problems with photos and graphics just showing outline or no image at
all. Is 2002 compatable with Windows XP?
Yes, Publisher 2002 is compatible with Windows XP, it should work better than it did
View, pictures, detailed display.
If this isn't the solution....
Even though your computer is new, it doesn't necessarily mean your video driver is up
Slide the acceleration down on your adapter, control panel,...Money 2001 and xp #2
I've been using money for some time but just recently I
keep on getting this message " this opperation cannot be
preformed " and each time I go from one account to onther
this box keeps poping up and then the other box opens
asking do I want to send this report to Microsoft can you
suggest for me what to do i CAN'T SEEM TO GET ONTO
MICROSOFT TO HELP ME OUT
Robert (Australia )
In microsoft.public.money, Robert Herod wrote:
>I've been using money for some time but just recently I
>keep on getting this message " this opperation cannot be
&g...Folder sharing in XP Home vs. XP Pro?
Why is it that I can mount shared folders coming from my desktop running
XP Pro onto my laptop running XP Home, but not vice-versa? I don't think
I've done anything different between the two machines when sharing out
"Yousuf Khan" <email@example.com> wrote in message
> Why is it that I can mount shared folders coming from my desktop running
> XP Pro onto my laptop running XP Home, but not vice-versa? I don't think
> I've done anything different between the two machines when shar...Outlook Task request form
I am hoping that someone out there knows the answer to my
guestion! I am creating a customized task request form
that eventually will sit on every users desktop in the
school district where I work. My goal is to have the
users enter a request for technical assistance that
generates an email to each of the 4 technology members
here. The e-mail will generate a task item when accepted
and send a reply to the "owner" (staff member initiating
the request). The problem I'm encountering is when I
customize the form and turn off the display of the
default task page, m...Filter by form search field showing non-distinct values in pull do
I'm using Filter-by-Form for searching. For each field, when in FBF, the
pull down shows a list of distinct values for that column.
One field on my form, though, is showing a list of non-distinct values, so
the list has over 200,000 entries, many of them duplicates (in this case,
NULL or zero length string).
What's going on? This particular field was fine earlier in development, and
the other search fields are still fine - showing only distinct values.
Any suggestions on where to look/what to do???
Just a guess here, but since...XP Pro desktop Search updates
Need to know the numbers of updates to XP desktop search. Particularly the
one that lost me the dog (Search Companion) and gave me Desktop Search. The
latest update is 4 and I have not installed that.
> Need to know the numbers of updates to XP desktop search. Particularly the
> one that lost me the dog (Search Companion) and gave me Desktop Search.
> latest update is 4 and I have...Can't Send Messages Using Outlook Web Access & XP
Our users with Windows XP cannot send messages using OWA. I've read a few KB
articles about some incompatabilities between XP and OWA, but none of the
proposed fixes (using the "basic" rather than "premium" client, or changing
the security settings in IE) seem to solve this last problem. When they
click on "send", it generates an unspecified "error on page". The problem
occurs using IE and Firefox, but just on XP machines. My Windows 2000
machine works fine using IE and even my Macintosh using Safari (gasp!) works.
...AfxDaoInit fails on Win XP SP2
after deinstalling some test applications and then installing the Win XP SP2
a call to AfxDaoInit() fails with a CDaoException. This usually means that
the Jet is missing.
Windows however reports that the Jet is now part of the system so its not
possible to install the latest Microsoft Jet 4.0 SP as well.
Any idea how to check the presence of the Jet and solve the issue?
Thank you for your time and help.
...Data input form
I have 20 cells values that must be input to a row 128 times within about a
half hour to 45 minutes. I need to do this once each month. In Excel 97
there was a 'data input' form that could be used. I cannot find that in
Any advice would be appreciated since I think it would really help speed
Are you looking for....
Select your data range, including col headings.
From the Excel main menu:
Does that help?
> I have 20 cells values that must be input to a ...Otlook forms
MS Outlook 2000.
In my MS Outlook 2000 I have created some custom forms for contacs. Every of
the form has some additional fields, which I use during a contact with the
person in question. Unfortunately, I had a comp crash. But I have a backup,
made before the crash happend.
When I have recreated the environment at a new machine, and imported there
the contact list in question, I have quickly found out that the additional
information entered via my custom forms into a contact has been imported
along with normal data, and is is great.
But what worries me is how to migrate the forms the...Outlook XP and VPN
My sales force can not use Outlook when they VPN to our network. Everything
seems fine on the mail server. When they open Outlook, they see their mail,
but can not do anything with it. Any suggestions?
"=?Utf-8?B?UGVycnk=?=" <Perry@discussions.microsoft.com> wrote in
> My sales force can not use Outlook when they VPN to our network.
> Everything seems fine on the mail server. When they open Outlook, they
> see their mail, but can not do anything with it. Any suggestions?
What do you mean by "can't ...UPGRADE XP HOME to XP PRO SP2
I have Windows XP Home, SP3 with latest updates.
I purchased Retail Windows PRO with SP2
How do I upgrade my XP home to XP PRO?
Either uninstall SP3 from Home Edition or slipstream SP3 into your XP Pro
installation media and create a new installation CD.
"LURKER" <firstname.lastname@example.org> wrote in message
>I have Windows XP Home, SP3 with latest updates.
> I purchased Retail Windows PRO with SP2
> How do I upgrade my XP home to XP PRO?
there is very little difference between
...2000 Deluxe & Windows XP looks for disk at start up.
Installing 2000 Deluxe on XP Pro system works for awhile then spontaneously
starts to look for a disk on startup. The msgbox caption is "No Disk" and
the message is something like "Msmoney.exe Put disk in drive D:" The
program will open after Ignoring, Retrying or Canceling the prompt. Its
I'm wondering if anyone knows of a command line switch that might fix the
In microsoft.public.money, Lemo wrote:
>Installing 2000 Deluxe on XP Pro system works for awhile then spontaneously
>starts to look for a disk on startup. The m...