Print Form Page
I would like to have a button that prints just the page of the form that you
are viewing. Below is the basic. How can I change it to have it print only
one page? Thanks.
Private Sub PrintScreen_Click()
On Error GoTo Err_PrintScreen_Click
Dim stDocName As String
Dim MyForm As Form
stDocName = "Baylor_2008"
Set MyForm = Screen.ActiveForm
DoCmd.SelectObject acForm, stDocName, True
DoCmd.SelectObject acForm, MyForm.Name, False
Resume Exit_Prin...macro to print form to PDFCreator
We have a cost of quality database with 18,000 records and growing.
Customer service opens the claim form and finds the claim that they
are looking for. They need to be able to e-mail this to our credit
manager in pdf format so that she can issue the credit memo and so it
can be sent to our imaging software in pdf format. We have PDFCreator
installed on their PC but I want to create a button on the form to
automate this so that they don't accidentally print all 18,000 records
to a pdf file and they don't forget to change their printer to
PDFCreator. I think it will have to be accomp...Text Moves
I have a user using Publisher XP SP3.
When she opens a Previously Created Brochure - changes some text and selects
save, the text moves and then the document is saved with the incorrect
I cannot seem to correct this. At first I thought it might be a corrupt
graphic, but after testing I don't think so.
It could be a printer driver issue.
MVP Microsoft [Publisher]
"Gladys" <Gladys@discussions.microsoft.com> wrote in message
>I have a user using Publisher...Dis/En-able combo text box and resetting a form
Sorry for the long-windedness! I am a coding amateur.
I am having a few issues with a combo box and a "Reset" command button.
I have a combo box called "PrimaryIssue", and option 6 in the box is "Other".
I have been trying to set it up so that a text box is only enabled if the
user selects the "Other" option. I have been having limited success with the
following code (which I believe I found on this site somewhere):
Private Sub PrimaryIssue_AfterUpdate()
Dim varItm As Variant
For Each varItm In PrimaryIssue.ItemsSelected
If PrimaryIssu...how do i delete connected text boxes?
i need to delete a sperate section in a text box on Publisher. it's in the
vintage newsletter and the Inside this issue section
Unlink the text boxes, the text will stay in text box one. You will have to
delete the text by elongating the first text box.
"drjones168" <email@example.com> wrote in message
> i need to delete a sperate section in a text box on Publisher. it's in the
> vintage newsletter and the Inside this issue secti...Today Conditional Format
I have a column which calculated a date based on 3 working days from a date
input into a diff column. What I want to do I have the calculated date
appear bold if that date has passed based on the current date.
For example if I input 01/08/11 the next column calculates 04/08/11 (3
working days). I want the caluclated date to appear bold when I open the
spreadsheet on the 05/08/11 ro show the calculated date has passed.
I can use conditional formatting but can't get the syntax right
Win XP Pro
Andy Roberts presented the following explanation :
> I ha...Getting value from edit control?
How do I get the value from an edit control into its value CString variable?
Also, how do I convert from CString to char* ?
CString has an overload for LPCTSTR (which depends on whether you are
compiled for Unicode or MBCS) so you can pass it pretty easily. If you need
to access the buffer directly CString::GetBuffer() returns the pointer to
the buffer. Call ReleaseBuffer() when you are done using that point (if you
To assign and retrieve values with the edit control you should create a
variable for the control and use UpdateData(). Open the dialog and right
click on ...Two Condition Vlookup?
I am currently trying to create a function that searches through an
array for two exact column values which allows me to retrieve a third
column value. For example:
Type of Fruit Date Packaged Amount of Fruit
Apples June 100
Oranges June 50
Apples July 75
Grapes July 50
In this example, I would be looking to retrieve the Amount of Fruit
(Apples) that was packaged in July. I would be putt...Change case of text
I have Word 2007. In earlier versions of Word under the Format tab there was
a change case option that made it easy to change selected text to all upper,
I cannot fund this function in Word 2007. Where is it?
Thanks for your help - jjk98
Home tab, Font Group, Change Case "Aa" icon.
Also, does Shft+F3 toggle the text, from no caps - initial caps - all caps?
Hope this helps
> I have Word 2007. In earlier versions of Word under the Format tab there was
> a change case option that made it easy to change selected...Autoload a form
I might sound stupid but I have to face it. I would like to open a form
while opening a database instead of the database. That is i want a user to
get access to a form not the database as it is gives the user a choice to see
the table, queries etc. Just like VB when you create a form and load the
application it is the form that opens. More so am i suppose to do something
to make it an exe.
Could somebody help me please
Open the database (.mdb file) to the database window. Select Tools |
Startup, and set the name of the form you want to have be shown...Query condition by date range
I'm trying to create a query to base a report from. I need it to return
records within a date range that needs to be specified, as in specifying the
beginning date and having the current date as the end date. A field is
included in the query that has listed dates in the format mm/dd/yyyy. How
would I write the criteria? I have part of it ready - [Please enter starting
date:] . I know that's how you get the little question window.
On Tue, 4 Dec 2007 14:51:00 -0800, silva wrote:
> I'm trying to create a query to base a report from. I need it to return
> records within a...Need help with conditional formula (Excel 97)
Can anyone give me the correct syntax for the following formula:
if A1 is blank, and B1 is more than zero, then display B1, otherwise
display nothing (blank cell)
met vriendelijke groetjes
"Jake D" <JakeD@djhtend.com> schreef in bericht
> Can anyone give me the correct syntax for the following formula:
> if A1 is blank, and B1 is more than zero, then display B1, otherwise
> display nothing (blank cell)
> Thank you
> ...Inserting a text Watermark automatically moves all text down one l
In Word 2003, when I try and insert a text watermark from the
Format/Background menu, on pages with .3 or less margins, there is a flicker
and all the text automatically moves down one line. Clicking Undo (or the
blue back arrow) removes the watermark, but DOES NOT move the text back up.
I need the .3 margins and a ‘CONFIDENTIAL’ text watermark for this particular
document. I tried changing the ‘Auto’ size option, with no difference.
Is this an unnoticed and unfixable glitch in Word 2003? How can I insert
the watermark without the text being moved down? Also, what size text...Selecting Multiple Controls
I have about a hundred checkbox controls on a worksheet. I need to select
differing subsets of multiple controls in order to move or modify them. I
have entered 'Design Mode' on the 'Developer' tab and activated the 'Select
Objects' option from the 'Find and Replace' feature on the 'Home' tab. With
that combination I can drag over the controls, but this action does not
select the controls. What must we do in order to drag and select large
groups of controls?
You can select multiple controls by using control-click to add
addit...Conditional formatting if condition of an if statement is true and a string value is displayed
I got a nested 'IF'-Formula in an excel cell that returns nothing if
the condition is false.
I would like to conditionally format this cell with grey shading if
the condition is true and a string value is displayed.
How can this be achieved using excel conditional formating
Help is much appreciated. Thank you very much in advance.
Let's say your doing this conditional formatting in cell K17. In
conditional formatting (xl2003) choose the FormulaIs: option and enter:
choose your formatt...form customization 10-17-03
I have customized a totally new form for creating accounts
and saved it, but now when I want to create new accounts
the old form shows up and don't know how to access the new
form! do you know what the problem could be?
you need to publish your changes, goto Deployment Manager, and run "Publish"
on the object you changed (ie accounts, leads, opportunity, etc).
then restart IIS
"farshad" <firstname.lastname@example.org> wrote in message
> I have customized a totally new form ...Convert text to time value
I have a series of time values in a 'General' format. They are of the
Which is 18:45:25 or 6:45:25 pm.
A time which is am would be of the type:
Which is 1:23:45 am.
Is there a way to convert those 'General' values to an Excel serial so
that I can figure out the difference between two times? I've seen a
bunch of examples on the net, but none of those that I have found deal
with this format that I can tell.
"Andy" <email@example.com> schrieb...Conditional Field in Queries
Is there a way to make a field in a query conditional so that it only
displays the value if the value is equal to something specifically
> Is there a way to make a field in a query conditional so that it only
> displays the value if the value is equal to something specifically
> set? Thanks.
Explain "the value is equal to something specifically set".
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com
...How do i use Conditional formatting for 3+ conditions ?
I have a text box in a report which highlights in colour current members in
a list of past and present member names. I have six types of current members
that I want to highlight, but with conditional formatting I can only use 3
conditions in the members [Type] field. I have tried [Type]="Full member" Or
"Life member" but the "Or" doesn't work ! Is there a way to do this ?
thanks .. Roger
CF is limited to 3 contitions, but you can use OR in those expressions.
If you set Condition1 to Expression, you can use:
([Type] = "Full member") Or (...Help with Conditional formatting with Dates
I have a spreadsheet in which I have to monitor various dates which are in
different columns (i.e. (1) Date Tender Released, (2) Date Company Selected,
(3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...).
Would if be possible to Conditional Format and have diffirent ROWs
highlighted for each individual Contracts (I have 300 running contracts
running) every time a date is filled in these different columns:
Initial Step (1) = Yellow (Call for Tender released)
Step (2) = Blue (Company Selected)
Step (3) = Brown (Contract under Process)
Step (4) = Green (Contract Si...Conditional null value
Wondering if anyone can suggest a way to simplify the following code, which
I’m using in the OnFormat event of a report.
If Not IsNull(DLookup("[ICD2]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field192] = Replace(DLookup("[ICD2]", "EntryICDs", "[EntryNum] =
" & Me![PtAcct#]), ".", " ")
If Not IsNull(DLookup("[ICD3]", "EntryICDs", "[EntryNum] = " & Me!
Me![Field194] = Replace(DLookup("[ICD...Change "Text Numbers" to "Numbers"
Can you tell me how to (with a macro) change a range of
cells that have text numbers to real numbers so I can use
them in formulas and also have them show up as real
numbers if I save the file as a .prn file. The range of
cells begin in row 2 from column C through column AZ. I
would really appreciate your help. I have spent days on
this and I'm still lost.
try the following:
- set the format for these cells to a 'number' format'
- select an empty cell and copy this cell
- select your range of text numbers
- goto 'Edit - Paste Special...CFile and CStdioFile, text or binary, ANSI or Unicode, etc.
(CFile constructor) says:
> CFile::typeText Sets text mode with special processing for carriage
> return?linefeed pairs (used in derived classes only).
> CFile::typeBinary Sets binary mode (used in derived classes only).
OK, let's look at a derived class first.
> virtual LPTSTR ReadString(
> LPTSTR lpsz,
> UINT nMax
>...Great Plains 8.0 on a Domain Controller
Has anyone ever experienced any problems installing Great Plains 8.0
Standard on a Windows 2003 Server Domain Controller? The site has a
very low number of users (8) and they want to do this. Any issues with
GP support after the fact?
I have a GP MSSQL system running on SBS 2003, which is a domain controller,
with exchange, isa and other things.
Just make sure you have enough hardware and resources
> Has anyone ever experienced any problems installing Great Plains 8.0
> Standard on a Windows 2003 Server Domain Cont...Display ALL text contents in cell
I am having trouble displaying all the contents in the cell. It is som
lengthy information in the cell. I have made the row height as high a
it will go, but it still won't display all the information. I canno
make the column width any wider than I have it set, because then th
other columns will not fit on the page. Does anyone know how t
overcome this problem? :
Flipper1067's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2561
View this thread: http://www.excelforum.com/...