G
Guest
First of all, I want to thank all the people who take time to answer
questions in this newsgroup. By following Rick B.'s advice on searching for
specific wordage, I've found so many answers to problems I've been having
with a database I'm trying to create. Being given hints on words to do
searches on helped quite a bit and gave me ideas for how to design the
database to work the way I want it to.
Basically, I have a database that will be used to help accrue for unbilled
month-end costs associated with some consultants. I have one form that will
allow them to enter their timesheet data, any expenses and mileage that we
will reimburse them for. This form has three subforms based on the header
entry of consultant name and week ending date. Right now, the form and
subform's record source is set to the individual tables. I've tested the
form to see that the data in the individual tables are updated the way I want
them to and it works as expected.
I plan on setting up user security after I get everything working correctly.
I'm still tackling the Security FAQ before I do that, though. I will follow
the advice given in other posts to lock the records so that a consultant will
only be able to view/edit/add data related to him or her, i.e. CurrentUser( ).
From my research I know that I need to base this timesheet form on a query
to get it to work the way I want (locking records). However, when I base it
on a select query, the form is blank as there is no data in the tables. When
I put in dummy data in the tables involved, the form has the fields showing.
Is this the type of query I need to use to lock the records and let the
consultants only use data pertaining to them? If so, what settings do I need
to use to avoid having a blank page?
It's been a while since I've had programming classes, but I'm slowly getting
reacquainted with VBA code. Thank you in advance for any help you can
provide.
Suzann
questions in this newsgroup. By following Rick B.'s advice on searching for
specific wordage, I've found so many answers to problems I've been having
with a database I'm trying to create. Being given hints on words to do
searches on helped quite a bit and gave me ideas for how to design the
database to work the way I want it to.
Basically, I have a database that will be used to help accrue for unbilled
month-end costs associated with some consultants. I have one form that will
allow them to enter their timesheet data, any expenses and mileage that we
will reimburse them for. This form has three subforms based on the header
entry of consultant name and week ending date. Right now, the form and
subform's record source is set to the individual tables. I've tested the
form to see that the data in the individual tables are updated the way I want
them to and it works as expected.
I plan on setting up user security after I get everything working correctly.
I'm still tackling the Security FAQ before I do that, though. I will follow
the advice given in other posts to lock the records so that a consultant will
only be able to view/edit/add data related to him or her, i.e. CurrentUser( ).
From my research I know that I need to base this timesheet form on a query
to get it to work the way I want (locking records). However, when I base it
on a select query, the form is blank as there is no data in the tables. When
I put in dummy data in the tables involved, the form has the fields showing.
Is this the type of query I need to use to lock the records and let the
consultants only use data pertaining to them? If so, what settings do I need
to use to avoid having a blank page?
It's been a while since I've had programming classes, but I'm slowly getting
reacquainted with VBA code. Thank you in advance for any help you can
provide.
Suzann