This is a multi-part message in MIME format.



------=_NextPart_000_00B8_01C17964.B2F0CAA0

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



MessageI have created a query in Access, how can I be able to edit and 

update from the results I got from the query? right now I can't make 

updates or anyting on my form which is recordsource is the query results



Thanks





Enzo

  ----- Original Message -----

  From: John Ruff

  To: Access

  Sent: Thursday, November 29, 2001 12:33 AM

  Subject: [access] RE: Max Record Size





  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 J



    -----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. 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')

      >

      >

      >



To

      > unsubscribe send a blank email to 

$subst('Email.Unsub')

      >

      >

      >

      >






$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




$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




  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