|
On Thu, 12 Nov 2009 07:39:02 -0800, Wendymel <Wendymel@discussions.microsoft.com
Hello,
I submitted a question in June (6/24/2009) concerning formatting a percent
field. It was resolved and has worked ever since. Until last week, when we
upgraded...
Started by Wendymel on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
On Thu, 12 Nov 2009 16:52:01 GMT, "KenSheridan via AccessMonster.com" <u51882@uwe
It might be simpler to store the integer value entered by the user in the
field and just add the % sign as a label immediately to the right of the
control in the form... .
|
|
On Thu, 12 Nov 2009 06:56:02 -0800, dcornett63 <dcornett63@discussions.microsoft.com
Hello,
After a user inputs the data on a userform, they must print out a report
with that data for manager approval. To make it easier for the user, I have
placed...
Started by dcornett63 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Thu, 12 Nov 2009 07:25:02 -0800, Duane Hookom <duanehookom@NO_SPAMhotmail.com
You haven't give us much to go on such as:
Are both of the fields in the reports record source?
Are both values in the current form?
There is a possible solution at... .
|
|
On Thu, 12 Nov 2009 12:31:45 +0800, "Richard" <richardbee@hotmail.com
Hi
at runtime, how would I close a report and save it as another name?
I need to open a report in design view, add a few text boxes, close it and
save as another name, then ...
Started by Richard on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
On Wed, 11 Nov 2009 22:33:25 -0700, Tom van Stiphout <tom7744.no.spam@cox.net
On Thu, 12 Nov 2009 12:31:45 +0800, "Richard" <richardbee@hotmail.comwrote:
This is problematic in a Production environment, because you will
likely want to deploy... .
|
Ask your Facebook Friends
|
On Thu, 12 Nov 2009 08:49:25 +0100, "Lars Brownies" <Lars@Brownies.com
I have a crosstab query in which null values result in a column called <To make sure my report can be run, I've used the IN statement
(IN("<there is no null value.
Strange...
Started by Lars Brownies on
, 6 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Steele" <NOSPAM_djsteele@NOSPAM_gmail.com
I think it would depend on how the <
What's the rest of your SQL statement?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please... .
On Thu, 12 Nov 2009 09:01:14 -0500, "Douglas J .
|
|
On Thu, 12 Nov 2009 02:28:01 -0800, Wayne-I-M <WayneIM@discussions.microsoft.com
Hi
V strange problem.
I created a simple form to test if any external file existed.
I deleted the form.
Am now getting the error "module not found"
I have traced...
Started by Wayne-I-M on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
--
Allen Browne - Microsoft....
If the problem persists after that, create a new (blank) database, and
import everything .
On Thu, 12 Nov 2009 18:58:06 +0800, "Allen Browne" <AllenBrowne@SeeSig.Invalid
Compacting the database should get rid of it .
|
|
On Wed, 11 Nov 2009 20:47:28 -0800, "HankL" <hlaskin@bendbroadband.com
John,
I followed your very explicit instructions.
I setup a new query called Reset Print
It shows Field as PrintMe
Table as Restaurant
Update to ...
Started by HankL on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Name qryResetPrint)
Now, you just have to run the query when... .
*Back up your tables!!*
The Update query sounds good.. .
On Thu, 12 Nov 2009 09:09:42 -0500, "Al Campagna" <newsgroups@comcast.net
Hank,
Before going any further.. .
|
|
On Wed, 11 Nov 2009 11:10:01 -0800, LG <LG@discussions.microsoft.com
I would like to only store the CMS field and run a query to populate the
other information when printing the form. In the table the only thing that
needs to be stored is the...
Started by LG on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Did you try my sample file, to see how I did it?
If the CMS is your unique key field then use it, in your query... .
On Wed, 11 Nov 2009 15:47:27 -0500, "Al Campagna" <newsgroups@comcast.net
LG,
Well, that's what John and I are suggesting.. .
|
|
On Wed, 11 Nov 2009 06:17:38 -0800 (PST), "James A. Fortune" <MPAPoster@FortuneJames.com
On Nov 10, 2:34 pm, "KenSheridan via AccessMonster.com" <u51882@uwewrote:
That's positively brilliant. I mean that. Should the date format
ever have been...
Started by James A. Fortune on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Wed, 11 Nov 2009 17:47:42 GMT, "KenSheridan via AccessMonster.com" <u51882@uwe
Praise from someone for whom I have as much respect as I do for you is always
welcome James, but while the code is mine, the use of separate columns for
the year, ... .
|
|
On Wed, 11 Nov 2009 19:28:39 -0800 (PST), g_1 <g_1@mailinator.com
Thanks, for the query.
How do I know if I have the Excel Object Library or not?
I guess my code will fail if I don't have it as the references cannot
be
resolved? If I don't ...
Started by g_1 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
You should have at least one version....
Menu look for References...
Fortune" <MPAPoster@FortuneJames.com
On Nov 11, 10:28 pm, g_1 <g...@mailinator.com
In the VBA editor, if you have a Tools.. .
On Thu, 12 Nov 2009 06:35:25 -0800 (PST), "James A .
|
|
On Wed, 11 Nov 2009 21:00:02 -0800, Frank H <FrankH@discussions.microsoft.com
I've seen several posts stating not to use them.
What are the reasons not to use them?
--
Frank H
Rockford, IL
Started by Frank H on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
On Thu, 12 Nov 2009 00:53:45 -0500, "Gina Whipp" <NotInterested@InViruses.com
Frank,
http://www.mvps.org/access/lookupfields.htm
In the future, you'll want to put the whole question the big white space as
some newsreaders crop the subject line... .
|
