Is there a way to relabel the label colors on the Appointment form?
Do you mean to modify them or what? Modifying the label names is very easy.
Right click on an appointment->Label->Edit Label. I presume you are using
Outlook 2002 or 2003, correct?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Cindy MIkeworth
| Is there a way to relabel the label col...Blank forms 01-06-10
Hi, I recently took over our Access 2003 Database from our guy that got laid
off and I am a newbie++. I am having a problem with a form. I have a form
then I have a subform embedded within that. When I log in with the developer
account, I can see the form, but the area where the sub form is is greyed out.
When I log in as a user and try to open the form, I have a completely blank
When I am looged in as developer and look at the form in Design view can I
can see all of the fields in the subform that are supposed to be there, but
in Form view it magically becomes grey.
I ha...How to print priority mail label in excel
I will like tosetup and print address on the pre printed "Priority Mail"
blank lable supplied by the post office.
Use Excel as the datasource, setting up the mailmerge in Word
Microsoft MVP - Excel
"TROJAN" <TROJAN@discussions.microsoft.com> wrote in message
>I will like tosetup and print address on the pre printed "Priority Mail"
> blank lable supplied by the post office.
...Unable to print shades of gray
Hello everyone.... I'm trying to print out calendars that have certain days
grayed in, (the cell for that day is filled with a shade of gray). My printer
is working and will print black and white... with gray but won't in publisher
or word. I have Office Professional 2003 with the latest upgrades. My OS is
MS XP Pro... with SP2. Any help is appreciated, thanks
This will be a printer issue, do you have the latest driver for your printer?
Mary Sauer MS MVP
"Kristinmerri" <kr...Email printed mystery
I am totally confused how this happened, if anyone can clue me in i would
really appreciate it.
AD 2k3 mixed
I have a user, we will call him Mike, who was working at home via Outlook
Web Access. At one point Mike's cat jumps up on the keyboard and lays down
and a sensative company email from "Sally" to "Kate" and "Mindy" prints on
his printer at home. Mike says he never had this email in his mailbox and
never had it as an attachment either, nor on his desktop. Mike has never
seen this email that just printed.
I ran message tracking to...All my 1099's aren't printing
I have printed my 1099's and now have vendors calling me that they never
recieved one. The hard copy does not show that one was printed for these
vendors, but the system does show me that one should have printed. Any
...Report that print quotes closed or quote status
How can I print a report that display the quotes status?
I mean all quotes open (no invoices done) or quotes closed (quotes converted
You can edit the quote summary report and add
FieldName = "[Order].Closed"
DrillDownFieldName = ""
DrillDownReportName = ""
Title = "Closed"
VBDataType = vbBoolean
Formula = ""
ColHidden = False
ColNotDisplayable = False
FilterDisabled = False
ColWidth = 1005
GroupMethod = groupmethodNone
ColFormat = ""
ColAlignment = flexAlignCenterCente...Fill-In Form Problem
I have a number of fill-in forms I created with Word 2000. Many have
dropdown boxes that contain a number of responses as well as a "blank"
option (created using blank spaces) to allow us to 'clear' the field if
nothing has to be filled in. We recently switched to Word 2007 and we have
been unable to select the "blank" entry in the dropdowns, therefore, we can
no longer clear a field if no entry is required. Am I overlooking something?
If you use the legacy dropdown fields in a protected form then Word 2007
will certainly allow a blank entry consi...Creating a form / card
Was hoping someone could help, been trying for ages. All I want to do
is remove all the excess cells and space from my work-sheet so that I
get a nice tidy form / card.
Thanks so much.
dhunter84's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33373
View this thread: http://www.excelforum.com/showthread.php?threadid=531997
Dan, you can't remove them but you can hide them, select the rows you want
to hide and format rows hide, do the same for the columns...adding specific "Lead Source" contact or account to Lead form?
The Lead form has a "Lead Source." When the lead source is "External
Referral" we'd like to track the actual Contact (or Account) so we can
them a thank you or special offer.
How can we create a "Lookup" attribute (relationship?) from the Lead to
Contact and put it on the Lead form for the user to select a lead
contact from the search Contacts form?
Would using the Referral field help?
Larry Lentz [CRM MVP]
MCSE+I, MCSE W2K, MCDBA, MCSA Messaging
Lentz Computer Services
Microsoft Small Business Specialist
San Antonio, Texas
Larry@LentzCo...how to print reference label name in excel for comments?
I have chosen to print comments at the bottom of my spreadsheet the problems
is it only gives the cell reference number. If I am looking at a printed
version I would not know what cell it is refering to. I then labeled
(reference) each cell but it still does not print out the name of the cell.
How can I print out the label name oppose to $b$3$?
Go to Print, Page Setup, Sheet, and select (under print), row and column
headings. This will print out the headings just as you see them on your
> I have chosen to print comments at the ...access 2007 form sql subform
When i use a database with linked table on sql 2005, each time i open a form
with subform, access load all the record before showing the form. If the
table has many records, it's taking a long time (30 seconds) before loading
the form (a table with 30000 records and 100 fields).
With access 2, 95, 97, 2000, 2003, it worked fine. Only a few pages of data
Instead of binding the entire recordset (table) to the form, and the entire
recordset (table) to the subform, consider using something, say, like an
unbound combobox in the header of the main form to allow selection ...Form Coding
Do I not have this correct?
In VB for a form, I want to call a particular field from the query the form
uses. The query has multiple tables attached to or in it. Affiliates is one
of the table names. Email is the name of the field in Affiliates.
So, shouldn't the code be if I want to reference that box?
It isn't work...
Nevermind, realized I didn't have a box on my main form calling or dislpaying
that field, the code I was using was in an event for a button...
> Do I not have this correct?
> In VB for a form, I want to c...how do I generate a bill from an order form?
It depends... In what format is the order form? Hard copy? If so, then
you would have to type in the data from the order form.
If the order form is in some type of soft copy, then you would want to open
that file with Excel. The Help file will tell you how to do this.
If the order form exists as a record in a database, then you would need to
coax Excel to query the database to get the data. The Help file will (sort
of) tell you how to do this.
Once you have the data in Excel, then you can manipulate it as you wish.
That is about all I can say without greater detail regarding the cha...Excluding worksheets from printing
I currently embed an Excel macro in my spreadsheets which will print
the entire workbook (40+ sheets) should the user request it:
Private Sub CommandButton2_Click()
Dim Sheet As Worksheet
Dim lAnswer As Long
lAnswer = MsgBox("This report contains " & Sheets.Count & " sheets - Do
you want to print them all?", vbYesNo, "Print?")
If lAnswer = vbNo Then
However, I have now incorporated several workings sheets that a...Print Titles
Hi, I need some help please.
I have a sheet with lists of peoples names and other specific data. I'm
able to sort these and sub-total them into groups of the same name and print
these on separate pages. I've set up a header so it prints at the top of
every page through "print titles". This is fine and I'm happy with this.
What I'm trying to do is to have the name of the person in the "header" that
appears at the top every page. But how?
Are all these groups on the same worksheet?
If so, you are allowed only one &qu...Can Publisher print divided page ranges?
With Ms-Word, you can specify several ranges of pages, using commas as
delimiters, such as:
This doesn't seem possible with Ms-Publisher 2003, but maybe I'm
missing something. It only seems possible to indicate one range, such
Is there a way to have just certain pages print out such that several
ranges are involved?
I'm trying to accomplish the equivalent of Ms-Word's "MasterDocument"
by having a 40 page master, from which I can specify a 12 page
version, a 28 page version, etc. The twelve page version might be
1-3,8-9,10,14,36-4...Lease agreement forms
Is there any template forms I can get for leasing an apartment?
I am looking for a roommate, and I need a form for potential roommates to
sign and have some sort of lease agreement. I am renting out an extra room
in my house.
Try this here:
And more specifically this one:
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.bta...Printing Problems #4
i group some spreadsheets but when i press the print
function on the spooling it breaks the pages by 1, 12, 2, 3
so its group have differrent printing preferences..
It is excel XP
Can anyone help me with that?
...Bar Code Printing
I am looking for advice regarding bar code label printing with Access. My
non-profit organization receives donated items that are sold in our store.
I want to track this inventory by attaching a bar code label to the
merchandise when it is received so the donor will receive proper credit when
the item is sold. Ideally, the barcode will contain the donor's information
as it is entered into the database. Then, it would be nice if scanning the
barcode on the item would bring up the donor's record from the database
(sort of a two-way operation). Can anyone give me a few tip...2003 Publishing my print smears on back of business card. Any idea
Using a ink jet HP printer, when I place text on back of busness card it
smears. Does anyone know to correct or prevent this? Thanks. HCGordon
On Mon, 1 Nov 2004 09:26:04 -0800, "HCGordon"
>Using a ink jet HP printer, when I place text on back of busness card it
>smears. Does anyone know to correct or prevent this? Thanks. HCGordon
More info, please. What kind of paper are you using? Are you using any
graphics on the cards?
Blessed be, for sure...
Jim-I'm using Avery Business Card 8879-Extra Sturdy, photo quality ...after apply filter show blank form.How to detect 0 records??
I Have a form , and the user goes to filter by form and then
apply filter. When no rows are returned a blank form is displayed
how do I detect this and display a message 'no rows found'?
I would like to say add a piece of line to your code...
DCount("SomeField","SomeTable") < 0 Then MsgBox Esle run your filter but you
didn't post any code. Perhaps that little tidbit I posted is enough to get
2010 Microsoft MVP (Access)
"I feel I have been denied critical, need to know, information!&quo...Create Table Record on Current of Form
I have a table called LastVisitedRecord. There is but one field in
that table called "lvCompanyID". I'd like to use the OnCurrent event
of my record form to insert the record id (CompanyID) into a new
record in the LastVisitedRecord table.
After that, I'd like to use a query I've created qLastVisitedRecord
which only shows the top 1 record of the LastVisitedRecord table to
query my contact form by default, showing all records, but skipping to
the record whose CompanyID field matches the sole record in the query
Anybody got an idea on how to do this? ...automate printing
We have an excell file that has different sheets that need to be emaile
to different departements within our organization. We are trying t
automate the system so that it will print the sheets that go to eac
Example: 1 sheet to dept a
the next sheet will go to dept b
we tried using print to file but it does not give us a usable file tha
can be emailed. Can someone help us with this
Message posted from http://www.ExcelForum.com
Look at Ron de Bruin's web site for different approaches to emailing
workbooks, worksheets and so on.
R...Images on Forms
Does anyone know if an image can be added to a form? For example, we'd like
to put an image of our 3-party supplier items on their records in the product
I'm currently going down the path of the IFRAME and linking to the supplier
website, but I'd like something cleaner.
I'm on 3.0 currently but will be upgrading to 4.0 soon, so if it can be in
4.0 I can wait.
My suggestion would be to add you image as a note from the related record and
retrieve it at-runtime using client side script (web service call) or any
custom aspx page from a menu entry...