473,287 Members | 1,399 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

How to change the RowSource in a SubReport

Dear reader,

The syntax for the VBA code to change the RowSource of a Master Report is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon
Oct 7 '07 #1
11 7409
I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master Report is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon


Oct 7 '07 #2
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master Report is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon
Reports!MasterReportName.SubReportName.Report.RowS ource ="TableOrQueryName"

Notice the addition of the word Report. This instructs Access to refer to
the report itself, not the subreport control that 'hosts' it.


Oct 7 '07 #3
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the property
Form/Report.

And I have checked the names of the master en sub for report several times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon


Oct 7 '07 #4
The syntax is correct, but Access won't let you change the subreport's
recordsource after it's opened in the main report (was thinking of changing
other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource property from
within its own OnOpen event, rather than the parent report's OnOpen event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the property
Form/Report.

And I have checked the names of the master en sub for report several times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
>I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Rep ort.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport
control,
>and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master Report
is:
>
Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon




Oct 7 '07 #5
If I do so, change the subreport's recordsource in his own subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after printing
has started."

And in case I change the query name to a not existing one the following
message pop's up:
"The record source "NotExistingQuery" specified on this form or report does
not exist."
So that means that the sytax is running.

But still a can't change the recordsource of the subreport.

"Neil" <no****@nospam.netschreef in bericht
news:fC*****************@newssvr19.news.prodigy.ne t...
The syntax is correct, but Access won't let you change the subreport's
recordsource after it's opened in the main report (was thinking of
changing
other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource property
from
within its own OnOpen event, rather than the parent report's OnOpen event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the property
Form/Report.

And I have checked the names of the master en sub for report several
times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master
Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon





Oct 8 '07 #6
On Oct 8, 1:00 am, "Simon" <SvanBee...@Versatel.nlwrote:
If I do so, change the subreport's recordsource in his own subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after printing
has started."
You might try setting the sub-report's RecordSource in its module to a
Public Function as:
*****************
Private Sub Report_Open(Cancel As Integer)
Me.RecordSource = ShippersRecordSource()
End Sub
*****************

To open specify the Sub_Reports RecordSource while opening the Parent
Report you could use code in a Standard Module such as:
*****************
Dim mShippersRecordSource$

Public Sub OpenShippersParentReport(ByVal vRecordSource$)
mShippersRecordSource = vRecordSource
DoCmd.OpenReport "ShippersParentReport", acViewPreview
End Sub

Public Function ShippersRecordSource$()
ShippersRecordSource = mShippersRecordSource
End Function
*****************

You could then call the code with
*****************
Public Sub TestOpenShippersParentReport()
OpenShippersParentReport "SELECT * FROM Shippers WHERE CompanyName
LIKE 'S*'"
End Sub
*****************

Oct 8 '07 #7
I don't experience that. I'm using Access 2000, and, changing the
recordsource in the subreport's OnOpen event with the syntax:

Me.Recordsource = "TableOrQueryName"

changes it to that table or query and doesn't produce an error.

What version of Access are you in?
"Simon" <Sv********@Versatel.nlwrote in message
news:47**********************@news.tele2.nl...
If I do so, change the subreport's recordsource in his own subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after
printing
has started."

And in case I change the query name to a not existing one the following
message pop's up:
"The record source "NotExistingQuery" specified on this form or report
does
not exist."
So that means that the sytax is running.

But still a can't change the recordsource of the subreport.

"Neil" <no****@nospam.netschreef in bericht
news:fC*****************@newssvr19.news.prodigy.ne t...
>The syntax is correct, but Access won't let you change the subreport's
recordsource after it's opened in the main report (was thinking of
changing
>other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource property
from
>within its own OnOpen event, rather than the parent report's OnOpen
event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the property
Form/Report.

And I have checked the names of the master en sub for report several
times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Rep ort.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master
Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon




Oct 8 '07 #8
My version of Access is 2003 (11.6566.6568) SP2

"Neil" <no****@nospam.netschreef in bericht
news:o3******************@newssvr13.news.prodigy.n et...
I don't experience that. I'm using Access 2000, and, changing the
recordsource in the subreport's OnOpen event with the syntax:

Me.Recordsource = "TableOrQueryName"

changes it to that table or query and doesn't produce an error.

What version of Access are you in?
"Simon" <Sv********@Versatel.nlwrote in message
news:47**********************@news.tele2.nl...
If I do so, change the subreport's recordsource in his own subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after
printing
has started."

And in case I change the query name to a not existing one the following
message pop's up:
"The record source "NotExistingQuery" specified on this form or report
does
not exist."
So that means that the sytax is running.

But still a can't change the recordsource of the subreport.

"Neil" <no****@nospam.netschreef in bericht
news:fC*****************@newssvr19.news.prodigy.ne t...
The syntax is correct, but Access won't let you change the subreport's
recordsource after it's opened in the main report (was thinking of
changing
other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource property
from
within its own OnOpen event, rather than the parent report's OnOpen
event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the
property
Form/Report.

And I have checked the names of the master en sub for report several
times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master
Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon







Oct 8 '07 #9
I really don't understand then. Thought perhaps you had an older version of
Access.

Do you have anything else going on in the Open events in the main report or
subreport? If so, then please post that code.

Other than that, I'm not sure why it would be doing that.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
My version of Access is 2003 (11.6566.6568) SP2

"Neil" <no****@nospam.netschreef in bericht
news:o3******************@newssvr13.news.prodigy.n et...
>I don't experience that. I'm using Access 2000, and, changing the
recordsource in the subreport's OnOpen event with the syntax:

Me.Recordsource = "TableOrQueryName"

changes it to that table or query and doesn't produce an error.

What version of Access are you in?
"Simon" <Sv********@Versatel.nlwrote in message
news:47**********************@news.tele2.nl...
If I do so, change the subreport's recordsource in his own subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after
printing
has started."

And in case I change the query name to a not existing one the following
message pop's up:
"The record source "NotExistingQuery" specified on this form or report
does
not exist."
So that means that the sytax is running.

But still a can't change the recordsource of the subreport.

"Neil" <no****@nospam.netschreef in bericht
news:fC*****************@newssvr19.news.prodigy.ne t...
The syntax is correct, but Access won't let you change the subreport's
recordsource after it's opened in the main report (was thinking of
changing
other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource property
from
within its own OnOpen event, rather than the parent report's OnOpen
event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource =
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the
property
Form/Report.

And I have checked the names of the master en sub for report several
times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would be:

Reports!MasterReportName!SubReportControlName.Rep ort.Recordsource =
"asdfadsf"

You're actually referring to the "Report" property of the subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master
Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon






Oct 9 '07 #10
I had no other code in the main and sub report as the

Me.RecourdSource = "QueryX" in OnOpen event of the MainReport

And

Me.RecourdSource = "QueryY" in OnOpen event of the SubReport

My coal was to avoid the situation that I need for each filter (query with
selection criteria) a different report.

So I have to change the RecordSource of the main and SubReport by checking
which query has to be filled out as RecordSource. But before I write this
code in the OnOpen of the MainReport I did a test of it works to change the
RecordSource in the MainReport and SubReport. And it came out that it works
in the Main Report and it dos not work in the SubReport. And because of this
I have now 6 the same reports with different selection queries as
RecordSource.

"Neil" <no****@nospam.netschreef in bericht
news:3w*******************@newssvr29.news.prodigy. net...
I really don't understand then. Thought perhaps you had an older version
of
Access.

Do you have anything else going on in the Open events in the main report
or
subreport? If so, then please post that code.

Other than that, I'm not sure why it would be doing that.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
My version of Access is 2003 (11.6566.6568) SP2

"Neil" <no****@nospam.netschreef in bericht
news:o3******************@newssvr13.news.prodigy.n et...
I don't experience that. I'm using Access 2000, and, changing the
recordsource in the subreport's OnOpen event with the syntax:

Me.Recordsource = "TableOrQueryName"

changes it to that table or query and doesn't produce an error.

What version of Access are you in?
"Simon" <Sv********@Versatel.nlwrote in message
news:47**********************@news.tele2.nl...
If I do so, change the subreport's recordsource in his own
subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after
printing
has started."

And in case I change the query name to a not existing one the
following
message pop's up:
"The record source "NotExistingQuery" specified on this form or
report
does
not exist."
So that means that the sytax is running.

But still a can't change the recordsource of the subreport.

"Neil" <no****@nospam.netschreef in bericht
news:fC*****************@newssvr19.news.prodigy.ne t...
The syntax is correct, but Access won't let you change the
subreport's
recordsource after it's opened in the main report (was thinking of
changing
other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource
property
from
within its own OnOpen event, rather than the parent report's OnOpen
event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource
=
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the
property
Form/Report.

And I have checked the names of the master en sub for report
several
times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would
be:
>
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource
=
"asdfadsf"

You're actually referring to the "Report" property of the
subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a Master
Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon









Oct 9 '07 #11
OK, let's back up a second. You say that you're just trying to apply query
with selection criteria to your report? You should be able to do that
without changing the recordsource. Just place criteria in your query which
refers to the form that you are using for your selection criteria.

Post a description of the form you're using for selection criteria, along
with the form name and the names of the controls on the form, and I'll show
you how to set that up. You shouldn't have to change the recordsource at
all.

But...... if you did want to change the recordsource, and it's not working
in the On Open event, you could always open the report in Design mode,
change the recordsource, and then open in Preview mode. But I don't think
that's the best way to go. Better is just to apply your criteria on the fly.

So, post the above info, and we'll go from there.

"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
>I had no other code in the main and sub report as the

Me.RecourdSource = "QueryX" in OnOpen event of the
MainReport

And

Me.RecourdSource = "QueryY" in OnOpen event of the SubReport

My coal was to avoid the situation that I need for each filter (query with
selection criteria) a different report.

So I have to change the RecordSource of the main and SubReport by checking
which query has to be filled out as RecordSource. But before I write this
code in the OnOpen of the MainReport I did a test of it works to change
the
RecordSource in the MainReport and SubReport. And it came out that it
works
in the Main Report and it dos not work in the SubReport. And because of
this
I have now 6 the same reports with different selection queries as
RecordSource.

"Neil" <no****@nospam.netschreef in bericht
news:3w*******************@newssvr29.news.prodigy. net...
>I really don't understand then. Thought perhaps you had an older version
of
>Access.

Do you have anything else going on in the Open events in the main report
or
>subreport? If so, then please post that code.

Other than that, I'm not sure why it would be doing that.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
My version of Access is 2003 (11.6566.6568) SP2

"Neil" <no****@nospam.netschreef in bericht
news:o3******************@newssvr13.news.prodigy.n et...
I don't experience that. I'm using Access 2000, and, changing the
recordsource in the subreport's OnOpen event with the syntax:

Me.Recordsource = "TableOrQueryName"

changes it to that table or query and doesn't produce an error.

What version of Access are you in?
"Simon" <Sv********@Versatel.nlwrote in message
news:47**********************@news.tele2.nl...
If I do so, change the subreport's recordsource in his own
subreport's
recordsource in his own OnOpen event the next message pop's up:
"You can't set the record source property in print preview or after
printing
has started."

And in case I change the query name to a not existing one the
following
message pop's up:
"The record source "NotExistingQuery" specified on this form or
report
does
not exist."
So that means that the sytax is running.

But still a can't change the recordsource of the subreport.

"Neil" <no****@nospam.netschreef in bericht
news:fC*****************@newssvr19.news.prodigy.ne t...
The syntax is correct, but Access won't let you change the
subreport's
>recordsource after it's opened in the main report (was thinking of
changing
other properties of a subreport when I wrote that).

So what you need to do is change the subreport's recordsource
property
from
within its own OnOpen event, rather than the parent report's OnOpen
event.
You should be able to just go:

Me.Recordsource = "adfasdf"

in the subreport's OnOpen event.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
If I use the syntax:
Reports!MasterReportName!SubReportControlName.Repo rt.Recordsource
=
"asdfadsf"

I receive the Run-time error '2455'
You entered an expression that has an invalid reference to the
property
Form/Report.

And I have checked the names of the master en sub for report
several
times
and they are correct.
What can by wrong?
"Neil" <no****@nospam.netschreef in bericht
news:QW*****************@newssvr19.news.prodigy.ne t...
I assume you mean RecordSource, not RowSource. The syntax would
be:
>>
Reports!MasterReportName!SubReportControlName.Rep ort.Recordsource
=
>"asdfadsf"

You're actually referring to the "Report" property of the
subreport
control,
and then the RecordSource property of that report.
"Simon" <Sv********@Versatel.nlwrote in message
news:47***********************@news.tele2.nl...
Dear reader,

The syntax for the VBA code to change the RowSource of a
Master
Report
is:

Me.RowSource = "TableOrQueryName"

But now the syntax to change the RowSource of a SubReport:

I think it has to be something like this:

Reports.MasterReportName.SubReportName.RowSource =
"TableOrQueryName"

But this is not working.

Is there a working syntax for this?

Tanks for any help.

Kind regards,

Simon








Oct 10 '07 #12

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: dixie | last post by:
I have a report with a subreport. The source object for this subreport varies according to the value of a field in a table. I am trying to programmatically set the object source for the subreport...
7
by: Nicolae Fieraru | last post by:
Hi All, I am trying to change the rowsource of a combobox when I click on it. I played with many events, associated with the form and the combobox, but still haven't figured out what is the way...
8
by: bbdata | last post by:
ok i have a problem here and not much time to play round. have a form bound to a table. one of the combos is bound to a field Agents. i have active and retired agents. thing is, i want to be able...
3
by: lorirobn | last post by:
Hello, I have a report which uses a subreport. When I run the report, I get "Enter Parameter Value" error message for "tblGuestRoom". I click ok and the report seems to work fine. I...
8
by: | last post by:
hi, i have a form on which a user can choose specific criteria such as dates etc, in order to filter the report that is called from the form. i do this by using the Where section of the...
8
by: Maxi | last post by:
Hello, i'm sorry my bad english :( I have CR9 Webservice, how to change databadse name and User_name into Webservice method? (not Viewer Control) Tks!! -- --------------------------
8
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RowSource of a Form is: Forms!FormName..RowSource = "TableOrQueryName"
3
by: Simon | last post by:
Dear reader, The syntax for the VBA code to change the RecordSource of a Master Report is: Me.RecordSource = "TableOrQueryName"
3
by: Simon van Beek | last post by:
Dear reader, How to change the RecordSource for a subReport. For forms the syntaxes is:
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.