A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Dialog box



 
 
Thread Tools Display Modes
  #11  
Old October 19th, 2004, 05:36 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like

to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no

results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I specify

start
date of 1/1 and end date of 12/12 in the form, the queries do not

work.
But,
if I individually type the same info when I run the query by itself,

it
works. The fields in the form are formatted to short date. What

should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters "startdate"

and
"enddate". I then run a macro which has about 15 update queries

depending
on
the dates. =[form]![specify dates]![startdate] and

=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate

and
enddate.
2. Some of the queries remain open. I would like the user to

only
see
the
end result which is a report.

Thanks for your help









  #12  
Old October 19th, 2004, 06:39 PM
ria
external usenet poster
 
Posts: n/a
Default

yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like

to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no

results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I specify

start
date of 1/1 and end date of 12/12 in the form, the queries do not

work.
But,
if I individually type the same info when I run the query by itself,

it
works. The fields in the form are formatted to short date. What

should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters "startdate"

and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. =[form]![specify dates]![startdate] and

=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate

and
enddate.
2. Some of the queries remain open. I would like the user to

only
see
the
end result which is a report.

Thanks for your help










  #13  
Old October 19th, 2004, 06:39 PM
ria
external usenet poster
 
Posts: n/a
Default

yes the macro is opening some 15 queries, some are updating tables that are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other form
did not work. I am using the same macro with the same queries. But, the
problem I have now is that all the queries I run are open. I would like

to
close all the queries and only show the end result, the report. How do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no

results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I specify

start
date of 1/1 and end date of 12/12 in the form, the queries do not

work.
But,
if I individually type the same info when I run the query by itself,

it
works. The fields in the form are formatted to short date. What

should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters "startdate"

and
"enddate". I then run a macro which has about 15 update queries
depending
on
the dates. =[form]![specify dates]![startdate] and

=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify dates.startdate

and
enddate.
2. Some of the queries remain open. I would like the user to

only
see
the
end result which is a report.

Thanks for your help










  #14  
Old October 19th, 2004, 08:43 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no

results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not

work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What

should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and

=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to

only
see
the
end result which is a report.

Thanks for your help












  #15  
Old October 19th, 2004, 08:43 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no

results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not

work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What

should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and

=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to

only
see
the
end result which is a report.

Thanks for your help












  #16  
Old October 20th, 2004, 01:55 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

The macro has about 15 queries which update different fields in a table.
Some also make a table. THe last one uses data from these and other tables
and queries to give the end result. The queries that remain open are the
select queries that are used later for Dlookup to populate a field in the
tablle. The rest make table and update queries do not remian open.

Thanks for your patience and advice. I greatly appreciate it.

"Lynn Trapp" wrote:

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and
=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help













  #17  
Old October 20th, 2004, 01:55 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

The macro has about 15 queries which update different fields in a table.
Some also make a table. THe last one uses data from these and other tables
and queries to give the end result. The queries that remain open are the
select queries that are used later for Dlookup to populate a field in the
tablle. The rest make table and update queries do not remian open.

Thanks for your patience and advice. I greatly appreciate it.

"Lynn Trapp" wrote:

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and
=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help













  #18  
Old October 20th, 2004, 01:55 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

The macro has about 15 queries which update different fields in a table.
Some also make a table. THe last one uses data from these and other tables
and queries to give the end result. The queries that remain open are the
select queries that are used later for Dlookup to populate a field in the
tablle. The rest make table and update queries do not remian open.

Thanks for your patience and advice. I greatly appreciate it.

"Lynn Trapp" wrote:

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and
=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help













  #19  
Old October 20th, 2004, 01:55 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

The macro has about 15 queries which update different fields in a table.
Some also make a table. THe last one uses data from these and other tables
and queries to give the end result. The queries that remain open are the
select queries that are used later for Dlookup to populate a field in the
tablle. The rest make table and update queries do not remian open.

Thanks for your patience and advice. I greatly appreciate it.

"Lynn Trapp" wrote:

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and
=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help













  #20  
Old October 20th, 2004, 02:01 PM
ria
external usenet poster
 
Posts: n/a
Default

Lynn

I figured out a way... I tracked the queries that remain open and closed
them later in the macro using the close command.

"Lynn Trapp" wrote:

It's pretty difficult, since I can't look over your shoulder, to see exactly
what you are doing. Could you describe what your macro does in a bit more
detail?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
yes the macro is opening some 15 queries, some are updating tables that

are
later used by the main macro.

"Lynn Trapp" wrote:

Is your Macro opening those queries? Are you using multiple queries in

your
final query that the form is calling?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

I created another form and now it works. I am not sure why the other

form
did not work. I am using the same macro with the same queries. But,

the
problem I have now is that all the queries I run are open. I would

like
to
close all the queries and only show the end result, the report. How

do I
close the queries?

Thanks

"Lynn Trapp" wrote:

when you say it doesn't work, what do you mean? Are you getting no
results?
Are you getting unexpected or "wrong" results?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
Lynn

Thanks...it works. But now, I have another problem. When I

specify
start
date of 1/1 and end date of 12/12 in the form, the queries do not
work.
But,
if I individually type the same info when I run the query by

itself,
it
works. The fields in the form are formatted to short date. What
should i
be
doing?

Thanks

"Lynn Trapp" wrote:

Change [form] to [forms]

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"ria" wrote in message
...
I have a form "specify dates" in which a user enters

"startdate"
and
"enddate". I then run a macro which has about 15 update

queries
depending
on
the dates. =[form]![specify dates]![startdate] and
=[form]![specify
dates]![enddate]. This is where I am running into problems

1. I am still being asked for the form.specify

dates.startdate
and
enddate.
2. Some of the queries remain open. I would like the user to
only
see
the
end result which is a report.

Thanks for your help













 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Network Path/Excel Open Dialog Problem Nny :\) General Discussion 3 August 16th, 2004 08:57 PM
Access 2000: No events when hiding & reopening dialog box-a glitch in attempt to speed up app Matt Jaffey Using Forms 11 June 11th, 2004 09:09 PM
Access 2000 OLE Insert Object Dialog box Roger C. Bledsoe Database Design 0 May 28th, 2004 03:56 AM
How can I programatically supress "Select Table" dialog? RHNewbie Mailmerge 4 May 3rd, 2004 09:26 PM


All times are GMT +1. The time now is 01:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.