[mso] Re: Access 2000: More than one form allowable per database ?

  • From: "Jim Pettit" <jimpettit@xxxxxxxxx>
  • To: <mso@xxxxxxxxxxxxx>
  • Date: Tue, 17 May 2005 05:13:12 -0700

Robert--

Certainly you can have more than one form in an Access database -- hundreds
of them, even. (Search Access help for 'database specifications' for an
interesting rundown on the maximum number of most things Access. You'll see
that 
32,768 individual objects are allowed, and that 1000 modules can exist (and
that number includes forms and reports with the HasModule property set to
True).

What happens when you try to save the "Damage List" form? Is there any error
message? It's possible the database, small though it is, suffers from some
sort of corruption; were I you, I'd create a new database, then import the
good table and forms from the 'broken' one and see of that helps.

--Jim
 

-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
Of Robert Carneal
Sent: Tuesday, May 17, 2005 3:35 AM
To: mso@xxxxxxxxxxxxx
Subject: [mso] Access 2000: More than one form allowable per database ?

I have a database in Access 2000 that I have made an entry form for. I will
call it "Stones" (Cemetery Headstones).

For some reason, my attempts at making a second form to use the same data
base will not "save." I feel real stupid asking this question- Access 2000
can and does allow more than one form per database, right? In the first
form, I have address, stone ID, plot ID, Longitude, Latitude. In my second
form, I wanted to be able to select a cemetery, and print a list of damaged
stones according to severity of damage. I call this form "Damage List." But
this won't save! Is there a setting I am unaware of that will allow more
than one form per database? I hope this is not a rookie question! McAfee
says I am clean, and SpyBot says I am clean.

Thank you.

Robert

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx
with the word "unsubscribe" (without the quotes) in the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also
allow you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation
with instructions.  Once you are a member of the files group, you can go
here to upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: