Set all check boxes values on form
I have a table with 2 fields: Field1(Text box) and Fied2(Check box) in a form.
What i want is a command button to set all Field2 check box to YES, and a
command button to set all Field2 check box to NO
Could anyone help me please????
Sorry if my english isn''t correct, but I''m from Potugal ;)
Emanuel Violante Galeano
In the Click event procedure of the command button:
Dim strSql As String
If Me.Dirty Then Me.Dirty = False 'Save first
strSql = "UPDATE [Table1] SET [Field2] = TRUE WHERE [Field2] = FALSE;"
Hello, everybody !!!
Why this fragment of code shows : ac
Thanks All !!!
"Alex Dmitriev" <email@example.com> wrote in message
> Hello, everybody !!!
> Why this fragment of code shows : ac
'??/' is a '\' so you end up with "a\\\bc"
under print options: Number of copies___. It will only print out 1 copy. I
say 5 and it still prints out 1. I am a new user of 2007 Excel
I suspect the problem is with the printer.
Try getting the newest driver
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Val in Texas" <Val in Texas@discussions.microsoft.com> wrote in message
> under print options: Number of copies___. It will only print out 1 copy.
> say 5 and it still prints out 1. ...Login with pwd & Open the main form depends on pwd
We have three groups of user that will use our database. Administrator (my
boss & me), PowerUser (Manager / Supervisor) & NormalUser (clerk)
Now, my front-end .accde will open my designed form – (main menu1) without
What we are planning are :
1. Users should have input their password (user can change by themselves)
before they can login into the main menu.
2. Different class of user can open their own menu only (eg. Poweruser will
open Frm_MainMenu1 & NormalUser will open Frm_MainMenu2 …) that depend on
what password they input
Could you give...How do I print a list of the directory contents
I need to print the disk directory contents. In DOS this was possible. Is it
possible in WORD? Thanks
No - but you could use the freeware Printfolders utility you can download
from my web site that will produce a text listing that you can open in Word.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <...Form wont show records
I have an unbound form which has a unbound combox box called cmbmonth where
the user chooses a value from the list for which the record source is based
on this SQL statement
ORDER BY tblMonth.txtmonthlabela DESC;
txtmonthlabela is a date field - (I realise that the name is totally
misleading but that's how I it was when I got it!)
There is then a command button which should open a form which has a control
called txtmonth, a date field. However when I click on the form it doesn't
show any records. Here is the code behind the...Excel Object showing strange behavior
I have a sheet that I created that contains an Excel object (small
spreadsheet) that when double clicked, will open up and allow it to be
populated. After they populate it, and close it,...the data is
automatically reflected in the object on the original sheet.
This is shared with everyone and it's working great. BUT.....(always
Why have a few people sent the form back to me saying that when they
double click the object it opens up a "Format Object" dialogue box
rather than the editable sheet that it was supposed to do? They sent it
back to me and sure enough...Printing a Newsletter
I'm about to start printing a 6 page newsletter. I will use 1 sheet of 11" x
17" and 1 sheet 81/2 x 11". Pages 1 and 6 and 2 and 5 go on the 11 x 17 and
3 and 4 on 81/2 x 11. When try to set up I don't any mention of pages 5 and
You cannot set different page size in Publisher within one publication.
To do what you want you will need to use two different Publisher files.
I do a newsletter also and run into the same situation. All of my pages are
set up as 8�" x 11". My printer does whatever he has to do to get me my
double-sided 11" x 1...Unable to Print Timesheets in BP
We recently installed BP, PDK and Great Plains. We are experiencing
significant difficulty in printing the beautiful looking timesheet that
displays when hitting the "Print" button in Business Portal. The timesheet
data basically bleeds off of the right hand side of the page even on legal.
Has anyone experienced the same issue? We are required to submit timesheets
to our customers withour invoices.
I wish these were formated with the weeks in two one week rows rather than
one two week period all the way accross. And that it fit on letter sized
What we currently ...Exchange Permissions--Strange One
by default, domain admins (and ent. admins) are denied "receive as" and "send as" permissions to the mailbox store. additionally, by default, on the exchange advanced tab under the mailbox rights button, domain admins are DENIED Full Mailbox Access. However, if you look at the security tab for each user object, by default domain admins are allowed "send as" and "receive as" permissions. now i know that the "receive as" right is ignored on the ad user object, but i ran a small test. i logged on as a domain admin, opened up the domain admin...Print multiple mailing labels in Access 2003 or 2007
From: "Patrick Sewell" <firstname.lastname@example.org>
Subject: Print multiple mailing labels in Access 2003 or 2007
Date: Wednesday, November 28, 2007 3:45 PM
I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print. This
works pretty well.
However, I would like to include a field in my table for the number of
copies I want of each label. For example, if each record in my table
contains the information for a given label, one field in that record should
cont...Strange Email failure error
Can anyone help? Using Outlook 2002 and POP3 mail. I've always been able to
send emails to my wife's work email address until this week, when I get this
very strange failure notice.
"Connected to 126.96.36.199 but greeting failed.
Remote host said: 421 reppsrv01.repp.co.uk is not accepting new connections.
Please try later I'm not going to try again; this message has been in the
queue too long."
Does anyone know what the hell this means?
Google is your Friend
Email address deliberately false to avoid spam:
I have a Word 2007 document. In this I am using 3 different heading styles.
I want to use the feature 'Select Text with Similar Formatting' but it is
not working. I have 5 headings that are all Title Case, size 10, Times New
Roman, Left aligned and Bold there is exactly the same formatting applied to
all 5 headings - I even checked the paragraph spacing - all headings are 0pt
before and 12pt after. I checked show and hide - everything I repeat
everything is the same - can you tell me why oh why will this feature only
select 3 of my headings and not the 5????
...Re: Calendar Printing Assistant
IMI Attendees Print - http://www.imibo.com/imidev/Exchange/imiap.htm
you can fin it also at
| "JLinDC" <JLinDC@discussions.microsoft.com> wrote in message
|| Are there any CPA templates that print the Appointment Message/Body?
...Printing Problems in Entourage
I have no problem printing a monthly calendar, but if I print a weekly
format, the program crashes every time. Any one else having that
Any suggested solutions?
This is a known issue. To work around it, Try removing multi-day events
that cross the weekly boundary.
On 9/29/05 5:20 PM, in article
> I have no problem printing a monthly calendar, but if I print a weekly
> format, the program crashes every time. Any one else having that
> Any su...Footer printing
Operating System: Mac OS X 10.6 (Snow Leopard)
When I upgraded from Word 2004 to 2008 a portion of the footer that I've been using for years on business docs was now "outside the print area". The template is the same as it has always been with the bottom margin set at .7 inches and the footer at .3 inches -- this printed just fine in 2004. Some previously created docs print just fine but new docs will not print properly. I've tried to update the Normal template by opening one of the docs that do print as the default but to no avail....image prints 'double' in normal and best mode
I have an image - a portait-style, rectangular 'directions' map to help
customers find my location which I created in publisher with lines and text,
etc, then grouped and saved as a jpg - that I am now trying to use
(inserted>from file) in a quarter-page card layout to be printed and cut for
inclusion with mailers.
If I print in 'fast draft' mode, this map look fine. However, if I try to
print in normal or best mode, the image is messed up - the top half of the
rectangle is doubled; the bottom half is not printed.
the 'this is north' indicator, whic...Remove Group Box border lines (without using macro)?
Is there a non-macro solution to removing the Group Box border lines?
If not, a macro solution would also be appreciated, but as it is going
into a multi-user form, I don't want to scare the users with macro
I don't think you can do this except via a macro. But you could run the macro
to hide those borders and release the workbook with no macros.
In fact, you don't even need a macro--just just need the code.
Hit alt-f11 to get to the VBE
hit ctrl-G to see the immediate window
type this in and hit enter:
activesheet.groupboxes.visible = false
...Printing question in Outlook 9 SP3
I am using Windows 98 SE with Office Pro 2000 (9.0 SP3).
In my Outlook main panel (left with folder selection, right hand side is
message list) if I select a message to print, It's only appear "Memo Style"
and I can't select the text in Preview pane and print it. It only the way I
open these message then select the text to print.
The Print dialog box is difference in Preview pane and open the message.
How can I change it back to the same Print dialog box?
If you single click the message on the right side and choose File Print from
the men...Outlook not printing headers #2
Hi there, I posted here yesterday but today it is gone
but anyway here is my question again.
I would like to print hard copies of certain emails I am
sending out. When I try to print the email from Outlook
2002, all I see is the content and my signature. I
cannot see the from:, To:, or subject lines. I know that
this is an option somewhere but for the life of me I
can't seem to find it. Any ideas?
...Search Form Problems
I have a form that has two fields in it. The first field is for a ID
number, and the other is for the projects name. I am having a problem
with using the form for as a search tool.
Some of the values are duplicates in the drop down, I wanted to know
how to properly filter the combo box so that the values can only be
The Row Source is the name of the table that the fields are from,
however this only words for the ID combo box and not the project name
one. For some reason the values are from the ID column in the project
name's combo box as well. To counter this problem, I si...why this strange result with vlookup
hi i have this formula in a cell =VLOOKUP(A3,'LookUp Data'!A2:O740,2,FALSE)
but any time i pick a code from my list items in column A it gives #NA but
as soon as i change to a different code it gives the name.
any help why
My best guess would be a data type mismatch. Looking up text in a column of
numbers. When you change the value the type gets converted and the result is
Hard to say though based on yoru description. The ohter thig to look for
might be blank characters padded at the end of the input.
"Amin" wrot...DestroyWindow ASSERT problem....strange, strange!
I have derived a dialog-class in a DLL (shared MFC)
I can construct an object of this class in my app, and when overloading
DoModal() and adding an AFX_MANAGE_STATE(AfxGetStaticModuleState( ));
call, I can see the CMyDialog dialog.
But here is the issue, I have a timer set for a certain time, it posts
a message and the dialog has to be killed - so I use CDialog::OnCancel.
Then DoModal calls DestroyWindow() -
Here a copy of the m_hWnd is made in hWndOrig.
hWndOrig = m_hWnd;
Then m_hWnd gets set to Null by ::DestroyWndow (which calls
But later in Dest...Outlook prints in large font only
I'm using outlook 2007 with Hosted exchange. When ever I print a
schedule in my calendar, the font comes out larger then what
originally shows on the screen. For instance, I know the font size in
my calendar is 10 or 12pt but the font size on printouts is 2-3 times
bigger. Not sure what setting controls this but any help of guidance
would be much appreciated. Thank you all in advance for any help.
Under Help, do a search for the word font. Several responses come back with
changing font size.
"MikeG" <email@example.com...Printing reports
When I print my monthly and yearly statements it does not
print the bold headings and does not leave any spaces
between the budget categories. Is there a way that can
be changed so the reports look more professional and