Access 2003 Single Record Report

  • Thread starter Thread starter Nadihaha
  • Start date Start date
N

Nadihaha

Ok I have a database that I have built (with much help from ppl here) That
allows me to produce a report listing each employee and what software they
have/require.

Is there a way that I can create a search function that will allow to bring
up the above report for just one employee?

E.g We have an employee who get's a new computer or requires a rebuild and
we need to know what software needs to go back onto that machine, so I run a
report for them that lists what software they need and where to find it
(that's on my table too)

I can get it for all employees, but that's not very time effective when you
need it in a hurry.

Many Thanks in advance
 
On Wed, 22 Jul 2009 19:28:01 -0700, Nadihaha

Absolutely. On that line of code that currently says:
DoCmd.OpenReport "myReport"
add something for the WhereClause argument. e.g.
"EmployeeID = 5"

Of course rather than 5 you may want to offer a dropdown from which to
select employees, and the WhereClause argument becomes:
"EmployeeID = " & Me.myEmployeesDropdown

-Tom.
Microsoft Access MVP
 
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, print report, edit
existing data etc.
 
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?
 
Apparently the wording I was looking for wasn't main menu, it was
switchboard. And I have figured out how to master that :)

Now for the add a button thingo
 
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
 
Hi Gina,

What I mean is I add a button (I think i should be adding the command
button?) and I open the properties and click on the event tab and it's blank.
 
Nadihaha,

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.

--
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?
 
Hi Gina,

I don't mean the Event Procedure is blank. I mean the tab is blank i.e I
don't have the On Click or anything. It doesn't allow me to type anything.

Am I doing something wrong?

I press on the command option on the toolbar, draw my little square. then
right click to get the properties menu, then click on the even't tab and
there is nothing there. I know what it's supposed to look like with all of
the options to add an event procedure and then I would select on Click and
then put what I need in there. But I can't get to that bit!!
 
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
 
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
 
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,

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.
Click to expand...

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,

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

Gina Whipp said:
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.
Click to expand...

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

Nadihaha said:
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!!
Click to expand...
Click to expand...
 
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

Gina Whipp said:
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.
Click to expand...

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

Nadihaha said:
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

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

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, print
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
to
the
events
tab, delete what's in the On Click event then add a new
event.

Put the following code in the click event of the new button:

DoCmd.OpenReport "myReport",,"EmployeeID = " &
Me.NameOfYourCombobox

regarding setting up a main menu type thing.........
It depends on the version of Access you aare using.
Access2003
and
earlier
use a menu at the top. Access2007 uses a ribbon.

Steve
(e-mail address removed)


message
Hi Thanks heaps for your help. But I don't really
understand.

Where/ How do I add a where clause?

I don't have any buttons at the moment, how do I add
buttons?

Also do you have any idea where I would get information
regarding
setting
up
a main menu type thing?

e.g press this button to enter info of new software, press
this
button
to
get a report.

Cheers

:

To add to Tom's suggestion, keep the button you cirrently
have
to
open
the
report for all employees. Add a second button and put
Tom's
code
in
the
click event of the second button. You will then be able to
open
Click to expand...
Click to expand...
Click to expand...
 
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

Gina Whipp said:
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,
print
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
to
the
events
tab, delete what's in the On Click event then add a new
event.

Put the following code in the click event of the new
button:

DoCmd.OpenReport "myReport",,"EmployeeID = " &
Me.NameOfYourCombobox

regarding setting up a main menu type thing.........
It depends on the version of Access you aare using.
Access2003
and
earlier
use a menu at the top. Access2007 uses a ribbon.

Steve
(e-mail address removed)


message
Hi Thanks heaps for your help. But I don't really
understand.

Where/ How do I add a where clause?

I don't have any buttons at the moment, how do I add
buttons?

Also do you have any idea where I would get
information
regarding
setting
up
a main menu type thing?

e.g press this button to enter info of new software,
press
this
button
to
get a report.

Cheers

:

To add to Tom's suggestion, keep the button you
cirrently
have
to
open
the
report for all employees. Add a second button and put
Tom's
code
in
the
click event of the second button. You will then be
able to
open
Click to expand...
Click to expand...
Click to expand...
 
Back
Top