|
 |
access thread: Max Record Size
Message #1 by "enz@u... on Thu, 29 Nov 2001 00:01:34 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_000D_01C17869.01E2E230
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
What's the maximum number record size Access can handle? I have this
2.7G of datafile but I have tried only 770,000 records and its record
size is 1912. is this still possible to query???
Thanks,
Enzo
----- Original Message -----
From: Rand E. Gerald
To: Access
Sent: Wednesday, November 28, 2001 3:45 PM
Subject: [access] RE: vbYesNo in Access?
> Or you can do it this way
>
> If MsgBox("Have you changed the Print margins to .5?", vbYesNo,
"Print
> Margins")=3DvbNo then
>
> Exit Sub
> Else
> DoCmd.PrintOut acPrintAll
> Endif
>
> John Ruff - The Eternal Optimist :-)
>
>
>
> -----Original Message-----
> From: Joseph N. Stackhouse [mailto:joe@s...]
> Sent: Monday, November 26, 2001 10:32 AM
> To: Access
> Subject: [access] RE: vbYesNo in Access?
>
>
> Do it this way,
>
> Dim YesNo
> YesNo =3D MsgBox("Have you changed the Print margins to .5?",
vbYesNo,
> "Print Margins")
> If YesNo =3D VbNo Then
> Exit Sub
> Else
> DoCmd.PrintOut acPrintAll
>
> -Joe
>
> -----Original Message-----
> From: Ryan Lockhart [mailto:rlockhart@p...]
> Sent: Monday, November 26, 2001 6:32 PM
> To: Access
> Subject: [access] vbYesNo in Access?
>
>
> I am trying to use the MsgBox function to return True/False, which I
> have
> done before in Visual Basic. Is this possible with VBA? Here is my
> code
>
> Dim yesNo As Boolean
> yesNo =3D MsgBox("Have you changed the Print margins to .5?",_
vbYesNo,
> "Print Margins")
> If yesNo =3D False Then
> Exit Sub
> Else: DoCmd.PrintOut acPrintAll
> ---
> You are currently subscribed to access as: joe@s... To
> unsubscribe send a blank email to $subst('Email.Unsub')
>
>
>
> ---
> You are currently subscribed to access as: papparuff@c... To
> unsubscribe send a blank email to $subst('Email.Unsub')
>
>
>
>
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=3D2181&sourceid=3D38934667&cat
egoryid=3Drn_ebooks
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #2 by "John Ruff" <papparuff@c...> on Wed, 28 Nov 2001 08:33:58 -0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_001D_01C177E7.6CFD60E0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
It's not the size of each record but the size of the entire database.
Access97 can be no bigger than 2gb and Access2K/XP can be 4gb.
John Ruff - The Eternal Optimist :-)
-----Original Message-----
From: enz@u... c",) [mailto:enzaux@y...]
Sent: Wednesday, November 28, 2001 8:02 AM
To: Access
Subject: [access] Max Record Size
What's the maximum number record size Access can handle? I have this
2.7G of datafile but I have tried only 770,000 records and its record
size is 1912. is this still possible to query???
Thanks,
Enzo
----- Original Message -----
From: Rand E. <mailto:rgerald@u...> Gerald
To: Access <mailto:access@p...>
Sent: Wednesday, November 28, 2001 3:45 PM
Subject: [access] RE: vbYesNo in Access?
> Or you can do it this way
>
> If MsgBox("Have you changed the Print margins to .5?", vbYesNo, "Print
> Margins")=vbNo then
>
> Exit Sub
> Else
> DoCmd.PrintOut acPrintAll
> Endif
>
> John Ruff - The Eternal Optimist :-)
>
>
>
> -----Original Message-----
> From: Joseph N. Stackhouse [mailto:joe@s...]
> Sent: Monday, November 26, 2001 10:32 AM
> To: Access
> Subject: [access] RE: vbYesNo in Access?
>
>
> Do it this way,
>
> Dim YesNo
> YesNo = MsgBox("Have you changed the Print margins to .5?", vbYesNo,
> "Print Margins")
> If YesNo = VbNo Then
> Exit Sub
> Else
> DoCmd.PrintOut acPrintAll
>
> -Joe
>
> -----Original Message-----
> From: Ryan Lockhart [mailto:rlockhart@p...]
> Sent: Monday, November 26, 2001 6:32 PM
> To: Access
> Subject: [access] vbYesNo in Access?
>
>
> I am trying to use the MsgBox function to return True/False, which I
> have
> done before in Visual Basic. Is this possible with VBA? Here is my
> code
>
> Dim yesNo As Boolean
> yesNo = MsgBox("Have you changed the Print margins to .5?",_
vbYesNo,
> "Print Margins")
> If yesNo = False Then
> Exit Sub
> Else: DoCmd.PrintOut acPrintAll
> ---
> You are currently subscribed to access as: joe@s... To
> unsubscribe send a blank email to $subst('Email.Unsub')
<mailto:$subst('Email.Unsub')>
>
>
>
> ---
> You are currently subscribed to access as: papparuff@c... To
> unsubscribe send a blank email to $subst('Email.Unsub')
<mailto:$subst('Email.Unsub')>
>
>
>
>
<mailto:$subst('Email.Unsub')>
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181
<http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categ
oryid=rn_ebooks> &sourceid=38934667&categoryid=rn_ebooks
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&catego
ryid=rn_ebooks
|
|
|
View Cart
