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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Opening a form and subform to a specific record



 
 
Thread Tools Display Modes
  #1  
Old March 4th, 2008, 08:50 PM posted to microsoft.public.access.forms
LT AREA[_2_]
external usenet poster
 
Posts: 3
Default Opening a form and subform to a specific record

I am using the time and billing database and I would like to be able to open
an employee timesheet data form only for a specific person. I would like for
an employee to only be able to view their time card and not others how can I
do that.
  #2  
Old March 4th, 2008, 09:45 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default Opening a form and subform to a specific record

Use the WhereCondition argument of the OpenForm command. What Time and
Billing db?

LT AREA wrote:
I am using the time and billing database and I would like to be able to open
an employee timesheet data form only for a specific person. I would like for
an employee to only be able to view their time card and not others how can I
do that.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1

  #3  
Old March 5th, 2008, 05:47 PM posted to microsoft.public.access.forms
LT AREA[_2_]
external usenet poster
 
Posts: 3
Default Opening a form and subform to a specific record

the time and billing database that is apart of the emplates available with
the program.

"ruralguy via AccessMonster.com" wrote:

Use the WhereCondition argument of the OpenForm command. What Time and
Billing db?

LT AREA wrote:
I am using the time and billing database and I would like to be able to open
an employee timesheet data form only for a specific person. I would like for
an employee to only be able to view their time card and not others how can I
do that.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1


  #4  
Old March 5th, 2008, 06:34 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default Opening a form and subform to a specific record

What version of Access are you using?

LT AREA wrote:
the time and billing database that is apart of the emplates available with
the program.

Use the WhereCondition argument of the OpenForm command. What Time and
Billing db?

[quoted text clipped - 3 lines]
an employee to only be able to view their time card and not others how can I
do that.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com

  #5  
Old March 5th, 2008, 06:46 PM posted to microsoft.public.access.forms
LT AREA[_2_]
external usenet poster
 
Posts: 3
Default Opening a form and subform to a specific record

2003

"ruralguy via AccessMonster.com" wrote:

What version of Access are you using?

LT AREA wrote:
the time and billing database that is apart of the emplates available with
the program.

Use the WhereCondition argument of the OpenForm command. What Time and
Billing db?

[quoted text clipped - 3 lines]
an employee to only be able to view their time card and not others how can I
do that.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via http://www.accessmonster.com


  #6  
Old March 5th, 2008, 07:34 PM posted to microsoft.public.access.forms
ruralguy via AccessMonster.com
external usenet poster
 
Posts: 1,172
Default Opening a form and subform to a specific record

The templates that come with Access are designed to get a new user started
with some examples. Your request is too general in nature for this Forum. I
could answer you by just saying "impliment User Security" which would
probably not make a lot of sense at this stage of development. It sounds
like you have a learning curve ahead of you. It is a pleasant journey IMHO.
If you have a specific question then by all means ask it. If you need some
help implimenting User Security then there are people here that have done
that hundreds on times. Good luck.

LT AREA wrote:
2003

What version of Access are you using?

[quoted text clipped - 6 lines]
an employee to only be able to view their time card and not others how can I
do that.


--
RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro
Please post back to this forum so all may benefit.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200803/1

 




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


All times are GMT +1. The time now is 04:53 AM.


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