I have an Access app with ULS applied.  It has a main form and a subform
with a 1:M relationship.  My client wants some of his users to be able to
edit 3 fields in the subform but read-only the rest.  What's the "preferred"
solution to this?

Hi, i have found out as i have developed the database i've ended up
with a number of tables that have the same attributes.
For instance, my suppliers and customers have the same fields for the
address. Would it make more sense to create an additonal table and to

I have database, which contains the list of laptop companies and some
information about them.
Some laptop models, have series, sub series, family's and so on.
for example. Acer Aspire 5102WLMi.

I need some help getting unique records from our database! I work for
a small non-profit homeless shelter. We keep track of guest
information as well as what services we have offered for statistical
purposes.

I would like to compact on close only if the database size goes over a
certain amount, rather than each time. Thus, I'd like to check the file size
and then perform the compact through code as the mdb's closing. Is that
possible?

In:
http://groups.google.com/group/comp.databases.ms-access/msg/f06bd4c45037ef29
Lyle wrote:

Hey everyone,
Using Access 2003 and SQL Server 8.0
I have a stored procdure on SQL Server that is launched from  my
access database where I send the parms.

Say I've got a graphic on a report's detail section. Say it's
a bound object frame linked to an image spec in a bound
table field named [Pic].
How might it be possible to approximate the CanShrink /

I have this query which updates a field based on the result of an IIF
statement. The table is on SQLServer and I'm linked to it and it has
many records and will take Access a very long time to run so I'm
thinking I can make this query a pass-thru query and I hope someone

I'm trying to find a good program to use for editing memo fields in Access
2003. I'd love to use Notepad or Wordpad, but the only option I'm really
finding is a program called Total Access Memo.
All I'm looking to do is have a field for notes, and be able to add/edit the

I was having problems connecting to an ODBC data source in A2003.  I
would click on File/GetExternalData/Link and select "ODBC Databases()"
from the "file of type" dropdown.  This would simply quit on me and not
present the "Select Datasource" window.  It was driving me nuts.

Anyone have any idea why
   SendMessage ctl.hwnd, WM_PASTE, 0, 0
isn't working from a regular Access text box (form is opened normally, not
in dialog more)? I realize I can just use docmd.RunCommand acCmdPaste. But I

Cut this little FN out-a-Access 97 HELP. It makes mention
of the new record being made the current record. Is it the
Update method responsible for that - or the Bookmark method?
Which one?

I'm new at this and don't understand what's happening or how to fix
it!
I have 4 tables: Student (6 fields), Charges (3 fields), Payments,
(3fileds), and Address (4 fields).

I have been asked to build a simple database that will operate and
track a liquid dispensing device.  The machine is run in a multi-bus
drop (coin operated basis) but I need to make it run on a barcode
scanner basis.  I have no idea if this is even possible (or if there