TableA 1 to many> TableB 1 to many> TableC
Referential Integrity Enforced, Cascade Update/Delete
Form has two subfroms.  Print Record Command
button on form.  As long as first subform has

I want to assign a value to a field in a reoprt id a certain condition is
met.
Within my report's VBA module, I add the following lines:
   If d Then

i've created several reports. Can anyone please advice how make the reports
read only. Similar to Excel read only format.

All
I have developed a simple database to record volumes of material in
different parts of the business.  I have developed a query that draws a table
that lists Division and volume of material.  I have developed a report based

I wrote a VB program to take attendance for the school Library.  It scans a
syudents ID, looks up the ID in a database table to get student name etc.  
Writes this information to a different table.  After all ID's are scanned for
that period I have a button to post the list to our ...

In Access 2003, I'm printing subtotals in a group footer.  I want to keep
track of the values for later computation.  Is there any way to do that?  I
tried creating the subtotals in a separate query, but I just get an Error
message when I try to access them from the report.  ...

problem statement: when i open a report the margins i have set when i created
the report have not been saved.
how can i trobleshoot that? i would like to avoid resetting the page margins
and orientation (page setup) every time i open the report.

The Tools > Analyze > Documenter option on Access
produces a huge long report.  I need a documentation
report that is somewhat detailed (description of fields
in tables, forms and reports)

In MS Access how can we make a program that directly print to printer (like
at POS program that print every line after the operator key in one line
transaction)?  Any one can help me plz?
Tonny

I using the RTF2-Object from Lebans under Office XP with Access XP it
works correctly. if I use the Application under Office 2003 with Access
2003 it works on my Computer online correktly on an computer by my company
it comes the message ("Eigenschaft ist schreibgeschütz"/problem ...

I often need to copy MS Access reports (charts and graphs mostly) into
PowerPoint presentations and have not found a simple, and direct means of
copying and pasting the reports.  No need to link the reports, static
"picture" will meet our needs.

I have a form that calls up another filter that sets a glove variable from
the users selection.  It thens calls up a report that is filtered by this
global variable.  In this report I have a subreport.  When I try to put the
filter variable in the event proceedure on open  for ...

I want to set the recordsource in the on open event of my form.  I am having
trouble with the code,
Dim str_sql As String
    str_sql = "SELECT DateAdd("d",-Weekday([meetingdate]),[meetingdate])+1

I have a report that is printing out multiple lines of the
same data. The query it is based on has the multiple lines
in the table. How do I get only the first occurence of a
line to print and not all occurences?

I have a data base of group officers.  Some have appointed a representative
to a consortium, some have not.  I want to print a report that lists the
groups with their representative AND if no rep. has been appointed, print the
Vice-President of the group instead.