Front End / Back End

[Neil Greenough]

I originally had my DB in MS Access 2000 split into a frontend and backend.
I have now merged them so they are together. Nonetheless, some of the
setting and scripts I had no longer work. I keep on getting an error with
the following script when I try to run a report:-

"Private Sub Report_Open(Cancel As Integer)
Dim lngSource As Integer
Dim lngTarget As Integer
Dim strFilter As String
intLoop = 1
If IsLoaded("Translators") Then"

There is more to this script, however this is the part which gets
highlighted.

Any ideas?

[Larry Linson]

What is the error message? And, which specific line is highlighted? It is
difficult to debug remotely, but without all the information, impossible.

Larry Linson
Microsoft Access MVP

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@titan.btinternet.com...

I originally had my DB in MS Access 2000 split into a frontend and backend. I have now merged them so they are together. Nonetheless, some of the
setting and scripts I had no longer work. I keep on getting an error with
the following script when I try to run a report:-

"Private Sub Report_Open(Cancel As Integer)
Dim lngSource As Integer
Dim lngTarget As Integer
Dim strFilter As String
intLoop = 1
If IsLoaded("Translators") Then"

There is more to this script, however this is the part which gets
highlighted.

Any ideas?

[Neil Greenough]

Larry

Problem solved - many thanks anyway
"Larry Linson" <bo*****@localhost.not> wrote in message
news:S_19d.7547$r3.6078@trnddc05...

What is the error message? And, which specific line is highlighted? It is
difficult to debug remotely, but without all the information, impossible.

Larry Linson
Microsoft Access MVP

"Neil Greenough" <ne***********@btopenworld.com> wrote in message
news:ck**********@titan.btinternet.com...

I originally had my DB in MS Access 2000 split into a frontend and

backend.

I have now merged them so they are together. Nonetheless, some of the
setting and scripts I had no longer work. I keep on getting an error with the following script when I try to run a report:-

"Private Sub Report_Open(Cancel As Integer)
Dim lngSource As Integer
Dim lngTarget As Integer
Dim strFilter As String
intLoop = 1
If IsLoaded("Translators") Then"

There is more to this script, however this is the part which gets
highlighted.

Any ideas?

[Tony Toews]

"Neil Greenough" <ne***********@btopenworld.com> wrote:

I originally had my DB in MS Access 2000 split into a frontend and backend.
I have now merged them so they are together.

Why? What problems were you having with them split?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm