Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / March 2005

Tip: Looking for answers? Try searching our database.

Strange behavior of replicaset

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hermie - 11 Mar 2005 14:25 GMT
Hello

I have created  a replicaset of my database on  a laptop The replicaset
start with an startup form. The startupform has 3 tabs, 1 for dataentry, 1
for forms and 1 for reports.
On the reporttab there are some commandbuttons to open the report. When I
try to open a report Access report an error and quit the program. This not
happens on the designmaster.  The code of the commandbutton is:
Private Sub studsintarea_Click()
On Error GoTo Err_studsintarea_Click

   Dim stDocName As String

   stDocName = "Students sin tarea"
   DoCmd.OpenReport stDocName, acPreview

Exit_studsintarea_Click:
   Exit Sub

Err_studsintarea_Click:
   MsgBox Err.description
   Resume Exit_studsintarea_Click

End Sub

What can cause, that when try I to run the commandbutton that access close?

Herman
Cheval - 11 Mar 2005 21:25 GMT
Sounds like a case of the first mistake of replication. Only replicate
tables, not forms, queries, reports and modules.

Hello

I have created  a replicaset of my database on  a laptop The replicaset
start with an startup form. The startupform has 3 tabs, 1 for dataentry, 1
for forms and 1 for reports.
On the reporttab there are some commandbuttons to open the report. When I
try to open a report Access report an error and quit the program. This not
happens on the designmaster.  The code of the commandbutton is:
Private Sub studsintarea_Click()
On Error GoTo Err_studsintarea_Click

   Dim stDocName As String

   stDocName = "Students sin tarea"
   DoCmd.OpenReport stDocName, acPreview

Exit_studsintarea_Click:
   Exit Sub

Err_studsintarea_Click:
   MsgBox Err.description
   Resume Exit_studsintarea_Click

End Sub

What can cause, that when try I to run the commandbutton that access close?

Herman
Hermie - 14 Mar 2005 19:54 GMT
Cheval

This sounds very strange to me.  How to enter data? how to print reports?

Herman
> Sounds like a case of the first mistake of replication. Only replicate
> tables, not forms, queries, reports and modules.
[quoted text clipped - 27 lines]
>
> Herman
Cheval - 14 Mar 2005 20:44 GMT
You create what's called a front end application and replicate the back end.
The front end is a standard .mdb which holds queries, forms, reports, pages
and modules/classes. The tables are all linked to the replicated back end.
The backend holds only tables and is replicated.

Cheval

This sounds very strange to me.  How to enter data? how to print reports?

Herman
> Sounds like a case of the first mistake of replication. Only replicate
> tables, not forms, queries, reports and modules.
[quoted text clipped - 25 lines]
>
> What can cause, that when try I to run the commandbutton that access
close?

> Herman
Hermie - 14 Mar 2005 21:26 GMT
Cheval

In other words I need to split the database?
herman
> You create what's called a front end application and replicate the back end.
> The front end is a standard .mdb which holds queries, forms, reports, pages
[quoted text clipped - 38 lines]
> >
> > Herman
Cheval - 16 Mar 2005 22:04 GMT
Yes

Cheval

In other words I need to split the database?
herman
> You create what's called a front end application and replicate the back
end.
> The front end is a standard .mdb which holds queries, forms, reports,
pages
> and modules/classes. The tables are all linked to the replicated back end.
> The backend holds only tables and is replicated.
[quoted text clipped - 18 lines]
> > On the reporttab there are some commandbuttons to open the report. WhenI
> > try to open a report Access report an error and quit the program. This
not
> > happens on the designmaster.  The code of the commandbutton is:
> > Private Sub studsintarea_Click()
[quoted text clipped - 18 lines]
> >
> > Herman
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.