Displaying a stored image on a form
I created an OLE Object type field in a table and then I inserted an graphic
I then created a form on which I want to display my graphic file. I tried
to display the graphic in a bound object control but the contol only
displays the file name or an icon on the form. How can I get the actual
graphic to display?
I can display an image on a form but this is only a link to a graphic file
and if I move or delete the original graphic file the database connection is
lost. I want the image to be stored in the database so there is no linkage
to outside files.
Has anyone done th...Control of exit from a Form opened within a subroutine
A DoCmd.OpenForm statement occurs part way down my Access 2000
subroutine "Prcs". The opened form presents the user with some screen
info from which he/she must decide which of the two command buttons
"Continue" and "Quit" should be clicked. "Quit" sends execution
control elsewhere while "Continue" is designed to continue processing
tested vb code ' Includes evaluation of "strCrit"
DoCmd.OpenForm "frmShowinfo", , , strCrit
more tested vb code
I've not found a way to stop contr...Popup Form question
How can I set a pop-up form to only take one record?
I have a popup form (single form) to take some customer info however when if
they tab past the last field all the data disappears.
Anyway to prevent this?
Thanks in advance
"Dave" <firstname.lastname@example.org> wrote in
> How can I set a pop-up form to only take one record?
> I have a popup form (single form) to take some customer info
> however when if they tab past the last field all the data
> disappears. Anyway to prevent this?
> Thanks in ...help me set up a Event Macros
i am looking to use more than 3 colors in my spreadsheet
i can do the conditional formatting for 3 colors but need help
to use 5 colors.
I am new to this so please tell me how to do this
Message posted from http://www.ExcelForum.com
You could use a worksheet_change event:
rightclick on the worksheet tab that should have this behavior. Select View
code and paste this in the code window.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myColor As Long
If Target.Cells.Count > 1 Then Exit Sub
If Intersect(Target, Me.Range("a:a")) I...How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
File>Print Area>Set Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
...Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms,
modules, and logic) used to CRUD the data in the tables.
1) Is there any way to separate the database from the code into separate
files, eg. the db is mydata.mdb and the 'code is in a separate file, eg.
2) Say you have v1.0 of an app and the tables and attributes are populated
with data. You then go and build v2.0 of the app, adding tables and columns
to what already existed in v1.0, and perhaps moving some of the v1.0
attributes into different tables. What is the recommended way to
unload/reloa...I need a Macro that will open workbooks and run a different Macro.
Is there a way for a macro to open all workbooks in a folder and then run
I have the 'other macro' written already, I just need a macro that will open
200 spreadsheets - (they are not in the same folder but I can move them if
needed, they are in the same directory) - , one at a time, then run my
macro, then save each spreadsheet.
I've asked a similar question of this forum (specifically dealing with txt
files - thank you Jim Cone.) and I've tried to modify that Macro so it will
open *.xls files but I can get it to work.
Any help with this will...UCE content filter not working
We are running Exchange 2003 with SP2 and I'm trying to get the uce content
filter to work. Below is the xml file which I do save as unicode.
I can't get the Inside Elderhealth part to work. I restarted the SMPT server
in Exchange System Center and the SMTP service from Services.
<?xml version="1.0" encoding="UTF-16"?>
<CustomWeightEntry Type="Both" Change="9" Text="viagra"/>
<CustomWeightEntry Type="Both" Change=...Advanced Filtering
I've got a worksheet with four columns, one of which is a user name. I
would like to take all the user names that contain numbers (and their
respective data) and put it into a separate worksheet. So far, I
haven't had any luck doing this with any combination of wildcard
The format of the user names are two or three letters and then 4
numbers, or they are entirely text. So the list has data like abc1234,
ab1234 and abcdef. I want all the abc1234 and ab1234 entries in a
Thanks in advance.
Maybe you could use a helper column and filt...Form Locked !
Hi, I created a form using the wizard based on a query, everything looks ok
but i cannot enter data into the form as it appears to be locked ? what have
i done wrong, i been trying to solve this for 2 hours now - please can you
One common reason is the query used for the form.
Open the query and see if you can add a new record to the query.
If you can't, have a look here:
"blake7" <email@example.com> wrote in message
...Outlook Junk Filter is filtering good emails sometime
I have a co worker that sends me emails all the time, some time the
junk email filters it, and sometimes it does not. I would like it to
never filter emails from his address. Using outlook 2003 with
Can you add them to the Safe Senders list?
"WizardOnTheRun" <firstname.lastname@example.org> wrote in message
>I have a co worker that sends me emails all the time, some time the
> junk email filters it, and sometimes it does not. I would like it to
> never filter emails from his addre...How to 1. Jump to a specific page (in a massive document) based on a search then 2. Copy and paste an string of characters a few lines above it.
I am working from a very large word document, approximately 1000 pages
long. Each page has one 'article' on it.
I am currently doing something manually, which I would love to do
using a macro.
I am populating a table (which happens to be in an Excel spreadsheet)
One column is the Article number 'xxxxx'. One of the other columns is
a 'Topic' which is typically three alphanumeric characters (like AA1,
AD4, BB4 DO6 etc.)
This is what i have to do
Step 1 - Jump to the page with the article number. Achieved by
p...Default form in Public Calendar folder
I have a calendar in the public folders. Is there any way so that when the
user clicks on the "New" button in Outlook that the default form that opens
is a "Meeting Request" as opposed to an appointment?
Sylvia <email@example.com> wrote:
> I have a calendar in the public folders. Is there any way so that
> when the user clicks on the "New" button in Outlook that the default
> form that opens is a "Meeting Request" as opposed to an appointment?
I don't think so, but you can certainly click the down-arrow next to the New ...Print Preview using CPreviewDC
I have a problem trying to implement a print preview
function. Yet the printing itself is no problem.
I have this chart control with a method
which outputs the data to the CDC object.
Now I want to do Print Preview similarly using the
CPreviewDC class mentioned in the MSDN Documentation
instead of the CDC class.
How do I setup the CPreviewDC object without a print
And after I have printed the content into the CDC class
how do I display the print preview?
...Unwanted Code Being Added to Form
This is a multi-part message in MIME format.
Access 2007 sp2.
I thought I seen it all.
For some reason code was added to the OnClose of one of my forms that I =
DID NOT put there!
The code is a 1 liner using the NavigateTo command.(irrelevant I =
I recall testing using custom Navigation Panes about a year ago but =
abandoned it. I recall having
code in the OnClose of my form(s) that switched to a different Custom =
Nav Pan...Multiple combo boxes on a form
I have a form based on two tables. I would like a combo box for a field from
each table that will fill in various fields from the relevant table. Does
anyone have any suggestions?
On Fri, 17 Aug 2007 23:58:37 GMT, "Malt" <u36720@uwe> wrote:
>I have a form based on two tables. I would like a combo box for a field from
>each table that will fill in various fields from the relevant table. Does
>anyone have any suggestions?
Why would you want to do that?
It sounds like you're trying to store data from one table redundantly into a
second table. This is essentially ...forms not listed in database contents, yet can add data to them
Hi - there are no forms listed when I open up the database in design view.
All the tables, queries, and macros are there.
When I open up the database to add data, all the forms are there and can be
used. The data is stored. So, it seems that the forms are still there, but
just cannot be seen in design view.
The database, when I open it up in design view, says Access 2000 file object
even though I am using Access 2003 - could that be the problem?
You cannot open an entire database in Design View. Try opening it normally,
selecting a form, and choosing Design View from the V...Set Print Preview to always show color
It was easy enough to get Publisher 2003 to perform a print preview in black
and white using Tools, Commercial Printing Tools. I want to set it back to
print preview in color but it refuses to do so. I have jacked around with
all of the radio buttons for Any Color, Single color, Process Colors, etc.
but nothing seems to work.
If anyone can help me out, please do so.
How about the printer settings? Are they set to color? The Generic Color Postscript
for Commercial Printing has a color choice in the preferences. Paper/Quality tab.
Have you checked the printer pre...inserting text form field in a text box
I'm designing a form that has several text boxes I want to be able to insert
a text form field that I can type in different names in when needed, while
keeping the rest of the text constant. Every time I go to insert form field
from Legacy it is not available. Anybody have a solution.
Your subject line has the missing clue. There is no way to insert a
legacy form field (text or any other kind) in a text box, footnote,
endnote, or header/footer.
You can remove the text box and put the field into ordinary text, or
you can use a text content control in a text box or elsewhe...SFO
We have an issue at the moment and wanted to check to see if anyone else was
getting this before rasied a case with Microsoft directly.
Basically when using the CRM Email button in SFO to create an email, we
click on the Regarding button which brings up a search box where you can
search for accounts/users etc. If you have an account in your CRM called
Leeds & Birmingham (for example) we perform a search for 'Leeds & Birmingham'
and it comes back with no results.
If you search for 'Leeds' it finds the account and if you search for 'Leeds
&' i...Pivot table bottom ten filter with conditions
is it possible to have the bottom ten item of a pivot table but
excluding specific value(s)
eg I have a pivot table with the bottom 10 of cost
item 1 -200 $
item 2 -300$
item 3 -0$
I would like to exclude item that have a cost = 0$ and have only
items greater than 0.
Excel 2007 PivotTable
Bottom 10, no zeros.
thank you for the spreadsheet.
...Print Receivables Schedule Payments
How can I print the invoice (as in Transaction>>Sales>>TRansaction Entry) of
an individual Schedule Payment in Receivables Management?
I dont want to print the entire Schedule Invoice used, just a specific
invoice (Tools>>Routines>>Sales>>Posted Schedule"
Go to Inquiry>Sales>Transaction by Document or Transaction by
Customer. You'll find the invoices in this inquiry window. Highlight
the invoice you want print and click on the Document Number link to
open the Receivables Transaction. You can print the invoice from
Frank Hamelly...How to set form caption / text?
I use MFC Visual C++ 4.2.
I am developing an application with main window and a few childs window.
How to set each child window text / caption everytime I call DoModal? If I
set "Entry Form"
then the window I call will displayed with "Entry Form" caption.
You can use SetWindowText to set it. For a dialog, you should do it any time
after its created(IOW, not in constructor). OnInitDialog and after is fine.
"Landon" <Landon@discussions.microsoft.com> wrote in message
>I ...Not Print Zero values
I need to do one of two things:
1) My zero values are hidden but they span down 300 cloumns. Is there
away to hide these from printing?
2) The zero values above are a simple currency total between tw
fields. I have filled the incrementing formulas down about 300 rows. I
there a way to fill in the next incrementing formula [(b2)*(d2)] whe
the calulation is made? I want to keep from having 300 growin
formulas, I'd rather try to have them incrimentaly auto fill so m
print outs wont have 20 extra blank pages.
----------------------------------------------...Print areas #2
Is there any way of getting excel to determine print areas depending on
I have a spreadsheet whose print area needs to change for different
data entered and I want to be able to automatically set a print area so
the user doesn't need to fiddle with the print area manually.
Thanks in advance,
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
If you do not create a print_area then Excel will print the entire active
range. If that's not good e...