Out of curiosity, I tried to check the help file for the property 'Fetch
Defaults' to see what it is for. No surprise, it is not mentioned. F1 on the
property give nothing. A search of MS knowledge base is equally unhelpful.
Can anyone explain what this new property in 2003 is for?
Jeff
7  22249 
it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I can
think of some other reasons too.
"Jeff" <je************ @asken.com.au> wrote in message
news:ld******** ***********@new s.optus.net.au. .. Out of curiosity, I tried to check the help file for the property 'Fetch
Defaults' to see what it is for. No surprise, it is not mentioned. F1 on
the property give nothing. A search of MS knowledge base is equally unhelpful.
Can anyone explain what this new property in 2003 is for?
Jeff
---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system ( http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
What defaults? The default settings for a control? Wouldn't that mean that
any settings made, such as colors etc would be lost if it reset everything
on the form to default settings? Why would you use this?
And why isn't such as basic property in the help file?
A lot of questions but I am interested in why such a powerful property is
not documented?
Jeff
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:xO******** ***********@new s.xtra.co.nz... it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I can
think of some other reasons too.
"Jeff" <je************ @asken.com.au> wrote in message
news:ld******** ***********@new s.optus.net.au. .. Out of curiosity, I tried to check the help file for the property 'Fetch
Defaults' to see what it is for. No surprise, it is not mentioned. F1 on the property give nothing. A search of MS knowledge base is equally
unhelpful.
Can anyone explain what this new property in 2003 is for?
Jeff
---
Please immediately let us know (by phone or return email) if (a) this
email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
I believe (could be wrong) that it is used to get the properties for a bound
field and apply them to the control.
I suppose, if you changed a field's properties after creating a form, you
could use this to update the control?
--
Joan Wild
Microsoft Access MVP
"Jeff" <je************ @asken.com.au> wrote in message
news:lz******** ***********@new s.optus.net.au. .. What defaults? The default settings for a control? Wouldn't that mean that
any settings made, such as colors etc would be lost if it reset everything
on the form to default settings? Why would you use this?
And why isn't such as basic property in the help file?
A lot of questions but I am interested in why such a powerful property is
not documented?
Jeff
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:xO******** ***********@new s.xtra.co.nz... it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I
can think of some other reasons too.
"Jeff" <je************ @asken.com.au> wrote in message
news:ld******** ***********@new s.optus.net.au. .. Out of curiosity, I tried to check the help file for the property
'Fetch Defaults' to see what it is for. No surprise, it is not mentioned. F1
on the property give nothing. A search of MS knowledge base is equally
unhelpful.
Can anyone explain what this new property in 2003 is for?
Jeff
---
Please immediately let us know (by phone or return email) if (a) this
email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
From the help file:
Returns or sets a Boolean indicating whether Microsoft Access shows default
values for new rows on the specified form before the row is saved. True if
Access shows the default values for new rows on the specified form.
Read/write.
I believe this means that when you go to a new record, the default values
for the fields (if any) will be shown, otherwise they are applied when the
field is saved if you've left the field blank.
--
Wayne Morgan
Microsoft Access MVP
"Joan Wild" <jw***@nospamty enet.com> wrote in message
news:10******** *****@corp.supe rnews.com... I believe (could be wrong) that it is used to get the properties for a
bound field and apply them to the control.
I suppose, if you changed a field's properties after creating a form, you
could use this to update the control?
--
Joan Wild
Microsoft Access MVP
"Jeff" <je************ @asken.com.au> wrote in message
news:lz******** ***********@new s.optus.net.au. .. What defaults? The default settings for a control? Wouldn't that mean
that any settings made, such as colors etc would be lost if it reset
everything on the form to default settings? Why would you use this?
And why isn't such as basic property in the help file?
A lot of questions but I am interested in why such a powerful property
is not documented?
Jeff
"WindAndWav es" <ac****@ngaru.c om> wrote in message
news:xO******** ***********@new s.xtra.co.nz... it will find the defaults when you open a form. If the defaults for a
control are rather complex then it may pay to set this to false and I can think of some other reasons too.
"Jeff" <je************ @asken.com.au> wrote in message
news:ld******** ***********@new s.optus.net.au. ..
> Out of curiosity, I tried to check the help file for the property 'Fetch > Defaults' to see what it is for. No surprise, it is not mentioned.
F1 on the
> property give nothing. A search of MS knowledge base is equally
unhelpful. >
> Can anyone explain what this new property in 2003 is for?
>
> Jeff
>
>
---
Please immediately let us know (by phone or return email) if (a) this
email contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.688 / Virus Database: 449 - Release Date: 18/05/2004
"Wayne Morgan" <co************ *************** @hotmail.com> wrote in message
news:nn******** *****@newssvr19 .news.prodigy.c om... From the help file:
Returns or sets a Boolean indicating whether Microsoft Access shows
default values for new rows on the specified form before the row is saved. True if
Access shows the default values for new rows on the specified form.
Read/write.
I believe this means that when you go to a new record, the default values
for the fields (if any) will be shown, otherwise they are applied when the
field is saved if you've left the field blank.
Thanks Wayne, that makes more sense. Jeff said he couldn't find it in help
--
Joan Wild
Microsoft Access MVP
Thanks everyone.
After Wayne's comment I went back to the help file. Nothing comes up looking
for FetchDefaults, but if you lookup the form object and then it's
properties (don't ask me why I didn't try this slant before) you will get
some help, though a little vague.
Jeff
"Joan Wild" <jw***@nospamty enet.com> wrote in message
news:10******** *****@corp.supe rnews.com... "Wayne Morgan" <co************ *************** @hotmail.com> wrote in
message news:nn******** *****@newssvr19 .news.prodigy.c om... From the help file:
Returns or sets a Boolean indicating whether Microsoft Access shows default values for new rows on the specified form before the row is saved. True
if Access shows the default values for new rows on the specified form.
Read/write.
I believe this means that when you go to a new record, the default
values for the fields (if any) will be shown, otherwise they are applied when
the field is saved if you've left the field blank.
Thanks Wayne, that makes more sense. Jeff said he couldn't find it in
help
--
Joan Wild
Microsoft Access MVP
Hi Jeff,
It's in the VBA help. If you open the VBA window and then search on
FetchDefaults (no space between the words) it should show up.
--
Wayne Morgan
Microsoft Access MVP
"Jeff" <je************ @asken.com.au> wrote in message
news:b%******** ***********@new s.optus.net.au. .. Thanks everyone.
After Wayne's comment I went back to the help file. Nothing comes up
looking for FetchDefaults, but if you lookup the form object and then it's
properties (don't ask me why I didn't try this slant before) you will get
some help, though a little vague. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Max M |
last post by:
I am using the fetch command from the imaplib to fetch messages. I get a
result, but I am a bit uncertain as to how I should interpret it.
The result is described at http://pydoc.org/2.3/imaplib.html as::
(typ, ) = <instance>.fetch(message_set, message_parts)
In RFC 2060 it says: "The data items to be fetched can be either a
single atom or a parenthesized list."
|
by: serge |
last post by:
I am doing a little research on Google about this topic and I ran into
this thread:
http://groups.google.com/group/microsoft.public.sqlserver.programming/browse_thread/thread/63cce060ff152dcc/1dc13d4ee6758966?lnk=st&q=difference+constraint+sql+defaults&rnum=14#1dc13d4ee6758966
I read SQL Server MVP Louis Davidson's post saying:
"Actually they are more likely to drop the concept of bound defaults.
Constraints are the standard way to do...
|
by: Evan Smith |
last post by:
During a routine performance check using an event monitor, I
discovered a class of query whose performance has me baffled.
The monitor captured:
SELECT * FROM EWM_CASE fetch first 1 rows only
It took 14 seconds of CPU time to execute. After looking up the
documentation on the FETCH FIRST notation I find "Limiting the result
table to the first integer rows can improve performance. The database
|
by: William Ryan |
last post by:
I just picked up a copy of John Robbins' debugging book and started to look
at disassembled code. Anyway, I hate optional Parameters in VB, but I was
checking them out to see what IL is created. I've done this before with
Modules, and saw that <gasp> they behave just like sealed classes with only
static members.
Anyway, it looks like Optional Parameters are nothing but a way to tell the
compiler to write some overloads for you. So, in...
|
by: **Developer** |
last post by:
I know this is not the correct NG but I've been trying to get this answered
for a while and can't find someone really knowledgeable about printers.
(Actually it does relate to something I'm programming.)
I'm not suggesting you do what I've outlined below - just read the steps I
did.
It has to do with printer parameters. Using Window XP printer parameters can
be changed as follows:
| | |
by: stefan |
last post by:
Hi,
for a school project I'm trying to analyze some python modules. I just
struggeld over a little detail I cannot solve:
shortened example of walking trough an AST with my own visitor:
class MyVisitor:
def visitFunction(self, t):
# Here I do not know know how to associate the default values
|
by: scoonie999 |
last post by:
I'm having a problem that I can't seem to find any solution for online.
I'm using a cursor in a cobol program to fetch some data. I know for a
fact that the select should return 2 rows. The fetch works as I would
expect it to on the 2 rows, but then when I do my next fetch, the
program ends abnormally.
My next step is to check for sqlcode 100, as I would expect it to be,
but my program never even gets to this step.
|
by: antonyliu2002 |
last post by:
I know that this has been asked and answered thousands of times. As a
matter of fact, I know that I need to say
If Not Page.IsPostBack Then
'Do something
End If
for things that needs to be processed by the web server. I am still
struggling to understand this postback logic, and hope that some kind
gurus out there could help me clarify the confusion I have.
|
by: Frank Swarbrick |
last post by:
Is there a way to do a multi-row fetch in to a COBOL table with DB2/LUW?
Apparently the following is supported in z/OS, but not LUW (or at least I
couldn't get it to work):
WORKING-STORAGE SECTION.
EXEC SQL
INCLUDE SQLCA
END-EXEC
EXEC SQL
BEGIN DECLARE SECTION
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
