They are wanting to use word to print out some cards 4 to a page
preformatted stuff from an access database.
the problem with this is they don't want to do the same card twice.
How can setup a variable in the table for printed and update it from
word when I do a merge?
I thought about macros in word but at my work they have macros turned
off on all systems.
any help or ideas are greatly appreciated
Jerry
Nov 13 '05
15  2078 
"David W. Fenton" <dX********@bwa y.net.invalid> schreef in bericht news:Xn******** *************** ***********@216 .196.97.142... Arno, do you want to land in everyone's killfile? If you insist on
responding to someone in CDMA based on posts they've made somewhere
else (I don't read any other Access newsgroups), then *you're* the
one who is annoying the hell out of me, and ^you're* the one whose
posts will be ignored by increasingly large numbers of CDMA readers.
OK, I get the message, thanks.
I was a bit 'carried away' I guess, by someone who indeed is annoying the hell out of me.
Arno R
Arno R wrote: OK, I get the message, thanks.
I was a bit 'carried away' I guess, by someone who indeed is annoying the hell out of me.
Lighten up, dude. Life 's too short.
One more question on this if I may.
I called them and told them that I needed a word template so I could
set this up.
Their response.....te mplate?
yea how its going to print and what.
I got the same thing I have been dealing with for over a year.
DAMN Access!!!!
If they would have gone foxpro like I told them we wouldn't have these
damn problems!!!!!!! !!!!!!!!!
huh?
anyway it is now my job to set up a template for something I know
nothing about and give them the info that they don't know what it is
in a format that is,what. With variables that I don't know what they
want.
WTF
because foxpro could do it. Seems that some B that works in the head
office has a husband that works somewhere that uses foxpro and
anything that is mentioned about data or databases well foxpro can do
that.
I also program sas so I guess foxpro is better at data analysis as
well.
anyway is there a place to dl preformatted templates?
thanks big time
soon to be unemployed
Jerry
On Tue, 20 Sep 2005 20:41:51 GMT, sparks <js******@swbel l.net> wrote: They are wanting to use word to print out some cards 4 to a page
preformatted stuff from an access database.
the problem with this is they don't want to do the same card twice.
How can setup a variable in the table for printed and update it from
word when I do a merge?
I thought about macros in word but at my work they have macros turned
off on all systems.
any help or ideas are greatly appreciated
Jerry
"Arno R" <ar***********@ tiscali.nl> wrote in
news:43******** ************@dr eader2.news.tis cali.nl:
"David W. Fenton" <dX********@bwa y.net.invalid> schreef in bericht
news:Xn******** *************** ***********@216 .196.97.142...
Arno, do you want to land in everyone's killfile? If you insist
on responding to someone in CDMA based on posts they've made
somewhere else (I don't read any other Access newsgroups), then
*you're* the one who is annoying the hell out of me, and ^you're*
the one whose posts will be ignored by increasingly large numbers
of CDMA readers.
OK, I get the message, thanks.
I was a bit 'carried away' I guess, by someone who indeed is
annoying the hell out of me.
You can't tell me anything about being annoyed by someone else's
posts, as you should well remember.
The way to deal with people who annoy you is to killfile them and
ignore them. It will keep the newsgroup cleaner and lower your blood
pressure.
And I've Been There and Done That, so I think I have a right to give
this advice to you.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
sparks <js******@swbel l.net> wrote in
news:ih******** *************** *********@4ax.c om: anyway is there a place to dl preformatted templates?
If you need a template for a mail merge, it seems to me that a
preformatted template won't do the job.
Don't use word "template" -- just ask them for an example of how
they want the results to look. That would include document text,
which they *must* provide for you (unless they are like the website
clients who think the web developer should write all the content on
the website).
In cases where the client tells me some other product can do it I
will just tell them "Fine -- use that other product. But I guarantee
that you'll find it's not as simple as you think and you'll come
back to me to finish it in Access."
If they don't like that, well, there's not much point in *wanting*
to continue the project.
Sometimes the developer should FIRE the client.
--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
David's on the right track for this!
All I do is ask them to "Mock-up" document in Word of what they want
the end result to look like. I then take that document and turn it
into a document template. If they don't like the results....
Make sure you also say something like "Including whatever graphics
(logos or whatever) or legal wording that needs to be on the
document." If there _is_ any legal wording required, that will get
the proper people involved. (It's something that clients often
forget.)
On Thu, 22 Sep 2005 11:54:01 GMT, sparks <js******@swbel l.net> wrote: One more question on this if I may.
I called them and told them that I needed a word template so I could
set this up.
Their response.....te mplate?
yea how its going to print and what.
I got the same thing I have been dealing with for over a year.
DAMN Access!!!!
If they would have gone foxpro like I told them we wouldn't have these
damn problems!!!!!!! !!!!!!!!!
huh?
anyway it is now my job to set up a template for something I know
nothing about and give them the info that they don't know what it is
in a format that is,what. With variables that I don't know what they
want.
WTF
because foxpro could do it. Seems that some B that works in the head
office has a husband that works somewhere that uses foxpro and
anything that is mentioned about data or databases well foxpro can do
that.
I also program sas so I guess foxpro is better at data analysis as
well.
anyway is there a place to dl preformatted templates?
thanks big time
soon to be unemployed
Jerry
On Tue, 20 Sep 2005 20:41:51 GMT, sparks <js******@swbel l.net> wrote:
They are wanting to use word to print out some cards 4 to a page
preformatte d stuff from an access database.
the problem with this is they don't want to do the same card twice.
How can setup a variable in the table for printed and update it from
word when I do a merge?
I thought about macros in word but at my work they have macros turned
off on all systems.
any help or ideas are greatly appreciated
Jerry
--
Drive C: Error. (A)bort (R)etry (S)mack The Darned Thing This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Squirrel |
last post by:
Hi everyone,
I've created a mail merge Word doc. (using Office XP) , the data source is
an Access query.
Functionality I'm attempting to set up is:
User sets a boolean field to true for each person for whom a mail
merge letter is desired.
The query reads address info from the table for each record where is
true.
|
by: Neil Ginsberg |
last post by:
I have a strange situation using Access to automate a Word mail merge. Using
Access 2000 and Word 2000, the code opens Word, opens the document in Word,
sets a table
in the calling Access application as the data source, and then performs a
merge. Everything works fine.
However, when a user uses it in Access 2002 and Word 2002, an extra instance
of the Access application is opened and remains open at the end. Sometimes
it remains open
|
by: Andy Davis |
last post by:
I have set up a mail merge document in Word 2003 which gets its data from my
Access 2000 database. I want to set up a button on a form that:
1. runs the query to provide the dat for the merge document in Word;
2. opens the document and runs the merge process for the new data.
I have managed to write the code to perform step 1 ok, but I'm having
trouble with step 2. It opens the word document fine but does not perform
the mail merge of...
|
by: Linda Cacina |
last post by:
Hello all you fine folks,
Here is some code I am using to merge data from a single record Access
2K3 table into a NEW word document based on a pre-defined Word merge
template doc. All I want to happen is as follows:
User defines a storage path and name for the new Word document then
clicks a "Create" button on a form. From that point on I use the
following code:
|
by: pmhaupt2 |
last post by:
I developed an Access 2003 program that will allow the user to produce
a group of Word letters that merge with data records from an Access
database.
I created a mail merge Word document and associated it with a specific
query in my Access database.
My problem is that when I run my "create letters" button from an Access
form, the program opens up Word correctly with the proper letter.
However, the MailMerge toolbar in Word appears...
| | |
by: lesperancer |
last post by:
I have 3 tables (office97)
tblQuote
quoteNbr
tblDetails ( quote : 1 <-> M: quoteDetails)
quoteNbr
detailLine
product
value
|
by: ckirby |
last post by:
I've inherited an application for creating mail merges from an Access
2003 ADP that needs an overhaul.
To generate the mail merge , the app uses a shell command:
result = Shell(str, vbHide)
where str = "C:\Program Files\Microsoft Office\Office\Winword.exe " &
letter & " /mmergeletter"
|
by: Ron B |
last post by:
Help!!!
What am I doing wrong? I am working with Office 2003 and am trying to create a command button on an Access form that will create a mail merge in Word from an Access table.
I want to make the mail merge seamless to the user so all they have to do is click on the command button and the letters are generated.
For the button I created an event procedure with the following code:
Private Sub RunLetters_Click()
|
by: crealesmith |
last post by:
Firstly, I have no problem with mail merging to Word, VB code for that
works perfectly.
On one mail merge I need to merge 15 fields of data that are from 3
seperate records.
The 3 records are all in the same table. If I use a control source that
is selecting the 3 records, all of the data is shown but spread over 3
pages in the mail merge, but needs to be listed together in one
paragraph.
Is there anyway of looping through the 3...
|
by: Esther Lane |
last post by:
Hello!
First off, many many thanks to Albert who wrote the Mail Merge code for MS Access I am using. It has been working beautifully for a few years. However, my client just (without notice!) upgraded from Access 2000 to Access 2007. Now that component is failing.
The merge is building the data source file fine (text file named merge.888).
I am providing an absolute path reference to the word file being used for the mail merge. ...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
| | |
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
