|
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 Mon, 9 Nov 2009 09:21:02 -0800, Sarah at DaVita <sarah.petterson@davita.com.(donotspam)
I have a form with numerous subforms. Within the subform I am using a
function to hightlight the field the user currently is in. This highlight on
and...
Started by Sarah at DaVita on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
I suppose it could simply be that, as you....
On Mon, 9 Nov 2009 12:34:47 -0500, "Dirk Goldgar" <dg@NOdataSPAMgnostics.com.invalid
"Sarah at DaVita" <sarah.petterson@davita.com.(donotspam)news:81520450-BDAB-4149-BD51-6E0BF12A4E4C@microsoft.com.. .
|
|
On Mon, 9 Nov 2009 05:59:01 -0800, Syb H <SybH@discussions.microsoft.com
We started a document with the hyphenation box clicked and now we don't want
any hyphenation. I went under tools and unchecked hyphenation, but it is only
unhyphenating that...
Started by Syb H on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
--
Arvin Meyer, MCP, MVP
http://www.datastrat....
This
newsgroup answers questions on the Microsoft Access database product .
On Mon, 9 Nov 2009 09:51:02 -0500, "Arvin Meyer" <a@m.com
You'll find an answer in a Word newsgroup, but not likely in this one .
|
Ask your Facebook Friends
|
On Mon, 9 Nov 2009 11:30:03 -0800, Noel <Noel@discussions.microsoft.com
MS ACCESS ERROR ON OPENING A SUBFORM
1. For some records, when I click on a button to open a subform, I get an
error. It appears to happen when 1 of 3 different fields for...
Started by Noel on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
On Mon, 9 Nov 2009 15:38:11 -0500, "Dirk Goldgar" <dg@NOdataSPAMgnostics... .
On Tue, 10 Nov 2009 05:22:20 +0900, "Suenaga" <ks_eternity@ybb.ne.jp
"Noel" <Noel@discussions.microsoft.comnews:BA08DCDA-D806-4598-B2B3-C1AB71186A8E@microsoft.com.. .
|
|
On Mon, 9 Nov 2009 15:37:39 -0600, "SAC" <sac@somewhere.com
Access 2003.
When I reference a control value from a subform which is on the main form, I
get japanese looking characters.
The Main for has a control whose data source is:
=DateDiff...
Started by SAC on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
--
Gina Whipp
"I feel I have been denied critical, need to ... .
On Mon, 9 Nov 2009 17:20:55 -0500, "Gina Whipp" <NotInterested@InViruses.com
SAC,
Perhaps posting how you are referencing the value from the subform will
yeild some useful replies .
|
|
On Mon, 9 Nov 2009 13:02:40 -0800 (PST), Simon <S.Dickson@shos.co.uk
I have a stock/ ordering systesm
i have a tblProducts and then i have a tblProductPurchasePRice
tblProductPurchasePRice hold the price and the date i bought new
stock. This ...
Started by Simon on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
(BTW, you need....
Include ProductID, Price and Date.
Start by creating a select query based on tblProductPurchasePRice.
On Mon, 9 Nov 2009 18:45:48 -0500, "Steve" <notmyemail@address.com
Create a Totals query based on tblProductPurchasePRice .
|
|
On Mon, 9 Nov 2009 12:38:47 -0500, "kc-mass" <connearney_AT_comcast_DOT_net
Hi
I have a continuous form which has a combobox on each line.
I want to change the datasource for the combobox depending on what type of
data is in the other fields ...
Started by kc-mass on
, 5 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
You can download the column
(and sample database....
Steele" <NOSPAM_djsteele@NOSPAM_gmail.com
See whether my February, 2006 "Access Answers" column in Pinnacle
Publication's "Smart Access" magazine helps .
On Mon, 9 Nov 2009 12:46:38 -0500, "Douglas J .
|
|
On Mon, 9 Nov 2009 11:27:01 -0800, aubrey <aubrey@discussions.microsoft.com
Hi,
I've tried every combination I can think of to get all results from a query
where a selected field is more than zero; this is the expression that I used:
Amount In...
Started by aubrey on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Here's one way:
Amount_In_Count: Sum(IIf([Amount ....
On Mon, 9 Nov 2009 14:32:23 -0500, "Dirk Goldgar" <dg@NOdataSPAMgnostics.com.invalid
"aubrey" <aubrey@discussions.microsoft.comnews:944397FB-9794-4BBD-A185-A17AEDF9A19A@microsoft.com.. .
|
|
On Mon, 9 Nov 2009 01:08:01 -0800, Jackie <Jackie@discussions.microsoft.com
Hi
i need to convert a function in an excel spreasheet into access using a
query.
NETWORKDAYS is the function. Does anyone know the equivelent in Access.
Thanks in advance...
Started by Jackie on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
"Workdays....
You can then use it
like a built in
function.
On Mon, 9 Nov 2009 07:31:12 -0500, "kc-mass" <connearney_AT_comcast_DOT_net
Look here: http://www.mvps.org/access/datetime/date0006.htm
Save one of these function in a new module in your db .
|
|
On Mon, 09 Nov 2009 09:59:07 -0500, John Spencer <spencer@chpdm.edu
I did not test for a password protected database.
I don't know if it is possible (I am speculating), but it should be possible
to include the password in the specification. Hopefully...
Started by John Spencer on
, 6 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
On Mon, 09 Nov 2009 10:23:36 -0500, John Spencer <spencer@chpdm.edu
Ok, try this
Clear the Source Database property and
set the Source Connect Str of the source queries to something like the following:
MS Access;PWD=spencer;DATABASE=C:\Center ... .
|
