Form Design Question 07-05-07
I am new to Access and working on developing a new request tracking database
for our customer service team. The following two fields are required at the
table level when inputting a new request:
Field Name: SOURCE
ddl selections include: Call, email, web, fax
Field Name: REQUEST TYPE
ddl selections include: New, Edit, Dispute
Here's what I would like to do...If the user selects a REQUEST TYPE = to
"Dispute", make another group of required fields appear on the form to be
populated before saving the record. I know this can be done, just not sure
of the best wasy to appro...Designing Reports for MsCRM 3.0
What is needed to design or modify reports for CRM 3.0 running on SQL 2000?
Specifically what versions and components of Visual Studio are required?
I have an article on this on my blog:
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of any included script or code samples are subject to the terms
"Gill" <gill@nospam_opsis.com.au> wrote in message
news:8FB42B2A-94C3-4184-B8E4-DC...How do I design a label template?
I need to design a template in Publisher for round labels. I have downloaded
the template from a web site in Word, but would like to use it in Publisher.
The setup for 2.5 labels are
Side margin .25, top margin .5, Horizontal gap .25, vertical gap zero
This will result in 3 columns and 4 rows
Mary Sauer MSFT MVP
"PegGall" <PegGall@discussions.microsoft.com> wrote in message
>I need to design a template in P...How do you universally change watermarks in a 'Seasonal design'
I would like to use Publisher's Seasonal newsletter design but I am hoping to
find a way to change the seasonal watermarks each season without manually
That would be nice but I'm afraid that if you don't do it, no one else will.
(And when you do, send me a copy. <g, d, & r>)
MVP Microsoft [Publisher]
"Gary" <Gary@discussions.microsoft.com> wrote in message
>I would like to use Publisher's Seasonal newsletter design but I am hoping
> find ...Macro recording the design of a report using report wizard
Can I record the steps/procedures when creating a MS Access report using the
Report Wizard? Reason for this, I have a dynamite query for the report and
the field names in the query is different each time when executed. I acn not
put the statis column name in teh report.
Some of the other Access apps can record macros, but Access does not do
There are times when the field names change - particularly with crosstabs.
But it might be possible to alias the fields in the query, or design it so
that the names don't constantly change. If that is not possible, you may
have to save...2 Designers
how would you handle having two persons who work on
creating/designing/editing a DB?
FYI I'm not in this situation but just in case.
Simultaneously or consecutively?
If simultaneously, one approach might be to allow both to open the same
file, but the first one on an object will 'lock' it from the other.
If consecutively, you'd need a way to ensure that PersonB doesn't start
until PersonA is done ... that's a matter of communication.
There are tools that help with the communication ...
Microsoft Access MVP
I must either have bad software or I'm not doing something.
When I try to save a created page in documents, assistant
scrathes the screen gives mw a ballon which simply says -
miccrosoft Publisher and an OK button.
How do I save either page by page or whole publication to
work on later?
Try a "find files" search for the name of one of the files
you have tried to save...they especially like to hide in
the "Temporary Internet" folders (even if you are sure you
specified the "My Documents" folder!)
>I must either...using HTML to design an email
I wondered, in Outlook Express you can edit your source
directly in an email (by using the Edit tab at the
bottom).. Why is this feature not available in Outlook?
Or is it, but actually hidden? If so could someone tell
me how i should proceed?
Thx in advance
Anyone? Now i need to design my email in Dreamweaver and
then copy the code to my Outlook Express. Then i need to
send that email to my Outlook account and then i can use
it by forwarding. There has to be a easier way, don't you
think? Thx in advance..
>I wondered, in Outlook Express you can...make all outgoing emails leave through designated Exchange server
I have 2 exchange servers, and they are in different locations. The
exchange servers are part of the same domain, and the same, initial, routing
Internet email can be sent from accounts hosted on the first exchange box,
but all internet mail sent from mailboxes hosted on the second exchange box
The error seems to indicated that the ISP that the second exchange box
connects to is blocking smtp traffic, or is failing a reverse lookup.
email accounts on both exchange boxes use the same domain name.
Is there a way to configure the exchange on the second box to route all
Is there any way to change the UI / Bckground color of MSCRM 4.0.
...sending publisher designed e-mails for everyone to see
I sent a publisher designed newsletter via e-mail once and the recipient
wasn't able to read it because they didn't have a Publisher or they didn't
have the proper document viewer.
So my concern in designing an e-mail via Publisher 2003 is will the
recipient be able to see the design even if they don't have publsher as well?
I know how to design one via publisher but I want eveyone to enjoy your
software and my labor :-)
Coolbreeze <Coolbreeze@discussions.microsoft.com> was very recently
heard to utter:
> I sent a publisher designed newsletter via e-mail ...SRS Report Designer .NET requirements
Since the full version of Visual Studio .NET 2003 is not required to install
the Report Designer, I'd like to know if there are any drawbacks to using one
of the stand alone programs such as MS Visual Basic, Visual C#, Vistual C++,
or Visual J# (the programs listed in the What's New guide).
If anything, use Visual Basic.Net as SRS uses VB.net as it's programming
MVP - Microsoft CRM
"Sarah Montgomery" <SarahMontgomery@discussions.microsoft.com> wrote in
Since...filter graph design
I want to create an application that makes it very easy for a user to
change the order of applied operations.
-> �flow chart with black boxes� or "building a filter graph"
I will illustrate this problem with a simplified example : some kind of
Suppose we have 2 edit boxes displayed in a CScrollView : 1 at the front
(in which we insert the starting value), and 1 at the end (this box will
display the resulting value).
In between those 2 boxes, the user must be able to insert an arbitrary
number of �operation� boxes, and those boxes must be connected so that
at...Money Template Designer? HELP!!!
I recently made a leap of faith, and purchased MS Money
Small Business 2004 over QuickBooks SB. Now I have an
issue, that mus be resolved, and I am sure, this is
I have a portrait style 8x5 invoice sheet, with static
text on the top(which can be the coimpany setup info),
but i need to add custom fields for both the company, and
for clients, and pull those fields into the template.
What am I missing? I tried the help, with no luck,
browsed the newsgroup, nothing. Basically, I need it to
look like the statement printout, but customized.
Thank you, to whoever, for your time!
Is there anyway to stop the Design Checker from checking a whole article on
opening? We have a project that is 86 pages and we don't want the whole
article checked everytime we open it up. We do want to check certain pages
that are being worked on. Thanks.
I use design checker often. I just ignore the pages that are still in
progress but I've yet to have a Pub file that large. I don't know of a way
to tell it not to check certain pages tho. Sorry.
MVP Microsoft [Publisher]
"DSmith" <Donna@NOTSPAMres-xraynews.com> wrote in message
news...Looking for Exchange architecture designers
I am not a recruiter, but a consultant looking for experienced people to
work on a large Exchange project (+700 Ad and Exchange servers).
The project is located in Europe/Prag (Tchek Republic).
If you want any details, please send me a mail at
Thanks in advance.
...XML Schema Design
I am trying to design the schema for an XML file.
The approach that I am planning to follow is to have 2 XSD files, each
containing some relevant information about the elements in the instance
document and then
planning to automatically generate the XML file from these 2 schema files
using the XMLSpy tool.
My doubt is - What is the best way to generate the xml file ? Are there any
best practices ? Any example would be of great help.
It will not be a dummy XML file, the xml file generated will contain the
mandatory elements and it can be refined and used ...Designate which addresses get e-mail attachment
When creating a single message in Outlook, is there a way
to designate which recipients should receive the
attachment? For example, I am creating a message to two
people and intend to "cc" another three people. Only one
of the action recipients (and none of the "cc"
recipientss) needs the attachment; and I don't want to
burden the other four folks with the attachment. Can I
accomplish this with just one e-mail?
"Richard" <firstname.lastname@example.org> wrote in message
> When creating a single ...Access 2003 Query design
I lost my query design grid-it is not showing up. I can only see the
selected tables and relationships in the upper part of the design screen -
any idea how I can make the grid display?
Maximize the window. So the grid has room to be displayed
Drag the bottom of the window down
Drag the bottom of the upper part up so there is room for the grid to show.
If none of those work, you can switch to SQL view, copy the SQL, create a
new query, paste the SQL in SQL View and then switch back to Design (Grid)
Access MVP 2002-2005, 2007
Center for Health Program Deve...your TLS experience??
Your experience using TLS with Exchange 2003 SP2?
2 Exchange 2003SP2 front-end servers which facilitate OWA (SSL and
2 back-end Exchange 2003SP2 clusters
Our SMTP connector routes all outbound messages via our FE (bridgehead
servers) to FrontBridge (spam & queuing service - which claims to support
incoming messages are routed via FrontBridge (as in the MX value)
My predecessor installed a certificate on the front-end servers which
allegedly supports SSL and *TLS
1. is an x.509 cert required?
2. what happens to a TLS-enabled...Designing outlook forms
Trying to create a form with several rows of radio buttons
or checkboxes, don't mind which, however, do not know how
to make it possible to select a button or box on every
line. It must be possible but we can't get it to work have
tried the properties value and groupname and grouping and
naming the same etc etc. Can anyone help. Checkbox makes
it so that if you have three boxes you can select all
three whereas the radio button allows you to select one
which is what we want, but when you get down to the next
row and select one, then the previous row deselects - I
hope you get ...db design to calculate overlap in group membership in time
I am a biologist studying the social structure of birds. I am currently
brainstorming ideas for constructing a database that will allow me to easily
calculate the number of seconds that one bird is in the same group as another
bird. Because group membership changes frequently with birds arriving and
departing at different times, and often arriving, departing, and re-arriving
on the scale of seconds, I will have many thousands of records. I am trying
to determine how to best set up this database before entering all the data. I
have 2 goals with this database:
1) I need to f...How do I get design view back?
In Access 2007 I have disabled design view and the navigation bar and
everything else the options page allowed. I thought my database was finished.
Now I have found one small flaw with my database and would quite like to
change it, but i can't even get back to the options menu.
Have you tried opening the db while holding shift? That should enable you to
get to the navbar and options. Only works if you didn't use the bypass module.
> In Access 2007 I have disabled design view and the navigation bar and
> everything else the ...Question about Call Tracking design of form
I am working on a call tracking module. I’ve seen Microsoft’s temp and it
does not help.
I have the following tables:
tblCustomer 1 record per customer
tblCall 1 record per customer per call “subject’. May take
actual calls to resolve issue.
Multiple calls per customer.
CallCloseDt - If field is null, call is open, otherwise it
is closed...Report design in Access
How do I hide/ supress items with negative counts in a report?
Thanks for your help.
What are 'negative counts'? I have never seen a count return a negative.
Microsoft Access MVP
> How do I hide/ supress items with negative counts in a report?
> Thanks for your help.