N
Nadihaha
Hi Gina,
No I don't have a form at the moment, I currently open the report by
clicking a button on my switchboard, which just opens the report.
I shall now attempt to create a form to run the report, I'm assuming that
the button on the switchboard should the open the form not the report?
No I don't have a form at the moment, I currently open the report by
clicking a button on my switchboard, which just opens the report.
I shall now attempt to create a form to run the report, I'm assuming that
the button on the switchboard should the open the form not the report?
Gina Whipp said:Nadihaha,
I missed that you were trying to add this to a report. As AccessVandal says
command buttons go on reports especially if you want to filter the report.
How do you run your report now, do you have a form?
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" - Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Nadihaha said:Ok this is probably a stupid question but it's the only thing I can think
of.
Should I be putting the command button on my report? Or Creating a form to
run my report with the filter? (not that I'm sure on how to do that)
Nadihaha said:Hi Gina,
That's my problem I know where I should be putting it (not neccesarily
exactly what, but where I've got)
My Problem is on the Event Tab for this button I don't have the line that
says on click. The whole Tab is blank, there are no lines.
I think I must have done something wrong creating the button for that to
happen but I don't know what
:
Nadihaha,
Thank you for the description I now understand what you mean... Here's
what
you do, follow your steps...
When I go into the Event TAB on other objects in my database, there
is a
table listing all the different events.
1. In the EVENT tab go to the line that say 'On Click' and when you
click
on it an arrow will appear...
2. Select [Event Procedure] and once selected an Elipse button [...]
should
show...
3. Click that and copy/paste the code there.
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Hi Gina,
as far as I know I'm not using Tab controls. I'm pretty sure I'm
opening
the
porperties window for the button. I will do my best to describe what
I see
seeing as I can't do a screen dump
When I open the Porperties Window Across the Top of the Window it
says
Command Button: Command 43 (I haven't renamed the button yet)
Then there's a drop down box with all of the items in my report.
Below that are 5 tabs Format, Data, Event, Other, All.
When I go into the Event TAB on other objects in my database, there
is a
table listing all the different events.
When I do it with this button all that's on the event tab is white
space,
which I can't type in to enter an event procedure.
I assume that I've done something wrong creating the button but I've
tried
every way I can figure out how to.
Any Help is greatly appreciated!!
:
Nadihaha,
Are you opening the Properties Window for the button? And what do
you
mean
by tab, are you using tab controls? Remember no one here can see
your
screen, we have no idea what you're seeing!
--
Gina Whipp
"I feel I have been denied critical, need to know, information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Hi Gina,
Yes I did read your last post and replied. I'm talking about the
actual
tab,
where it supposed to come up with all the places you can add an
event
procedure, like before update, after update on click..none of them
are
there!! and it won't let me type there, so I can't enter what tom
suggested
to see if it works
:
Nadihaha,
Did you read my last post...
Yes, it should be blank until you type OR copy/paste something in
there,
like what Tom suggested...
DoCmd.OpenReport "myReport"
OR
Use the wizard to create you button and it will add the code for
you.
I think you benefit from the below links... Especially Crystal's
section
on
Form Design.
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
Ok I've added 2 command buttons. One to apply a filter and one
to
remove
the
filter. But when I select the event tab in the properties it's
blank,
is
there something I should be changing to make this tab populate?
:
Nadihaha,
Yes, you can add a button and you should be able to add an
event
function.
Please explain what you mean by you can't add an Event
Function...
We
can
give you line you will need but first you need to able to add
the
line.
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
message
Well I have a form which I presume I can adda button too.
But
when I
add a
button it doesn't allow me to add an event funtion. I think
I've
found
coding
that will allow me to do what I want, but I just can't
figure out
how
to
add
a command to a button. Do I need to write a vba code? or is
there
a
particular type of button I should be adding to allow me to
add
an
event
function?
:
Nadihaha,
Do you have a form to which you can add a button?
--
Gina Whipp
"I feel I have been denied critical, need to know,
information!" -
Tremors
II
http://www.regina-whipp.com/index_files/TipList.htm
message
Hi Steve,
What button are you talking about? I don't have a button.
In regards to the Menu thing, I'm using access 2003 as
per my
subject
line,
but I'm not talking about the standard menu. I want to
create
my
own,
so
that
it simplify's how to use it.
So what I want is when you open the database it
automatically
comes
up
with
a box with selections you can make eg. enter new data,
report,
edit
existing data etc.
:
Look again at Tom's response. Right now you have this
code in
the
click
event of your existing button:
DoCmd.OpenReport "ReportName"
To add a new button, copy and paste your existing
button.
Open
properties
and change the name of the button and change the
caption. Go
