timesheet revisited

[bobc721]

Hi ya'll...

I am dire need of some clear thinking. Here is the situation....

I am running split databases... the timesheets are entities that are
controlled by the employee. I have control of the project information. I need
to allow the employee to view the project number, project name, client name,
and project manager from my database. That information will need to be
appended to the timesheet so they don't have to retype the information (has
to do with errors in the final summary). At the same time, they will need to
input date, hours, task code, and work description for that job. (the reason
for split databases is due to the frequency of travel and having to port
their timesheet database via laptop to the jobsite.)

So currently I have two databases

1 Corporate_Jobs > (table) Proj_Info > (fields) Job Number, Job Name, Client
Name, Project Manager, Job Status, etc...

2. Timesheet > (table) Time > (fields) Job Number, Job Name, Client Name,
Project Manager, Date, Hours, Task code, Work Description.

Now, what I am trying to do is parse information from the Corporate Jobs
database and insert it into the Timesheet database (yeah, I have already
tried to explain this a couple of times, but the boss says he wants the
information separate, period). I have created a form that has the Job Number,
Job Name, Client Name, and PM - I am able to scroll through the information,
but not having any luck taking the information from the form and adding it to
the time table. I would also like to have the capability to have a complete
entry form that will allow me to have a command button that will append the
information to the time table.

If I am way out of line here, I'd sure like to have some suggestions on how
to rethink what I am trying to accomplish. a simple timesheet that has a job
lookup and ability to drop the correct information into the time table.

 

[Allan Murphy]

Bob

Any reason why you cannot link the table proj_info table to the timesheet
database front end then use a query
to deliver the required information for your time sheets?

 

[bobc721]

Hi Allan, thanks for responding so quickly, I do have the project_info file
linked. I just realized this morning that I should be using a query instead
of having the form linked directly.

Now what I have run into is that I have the project_info listed, but when I
try to do the timesheet part, I am getting a subform... I want to be able to
have one form that will allow the user to select the job (4 fields) and input
the rest of the timesheet information (4 fields) as I build the form, the
timesheet part becomes a subform. How do I get to the one form and then get
it to append the information to my time table? Do I need to build it via
vbasic or am I just drop kicking myself and not seeing what is right in front
of me?

I am leaving for the day and will look for a reply first thing tomorrow. I
think I need a fresh set of eyes to continue this journey. I do really
appreciate all the help that has been given...

--
bob

Bob

Any reason why you cannot link the table proj_info table to the timesheet
database front end then use a query
to deliver the required information for your time sheets?

 

[Allan Murphy]

Bob

Have a look at Service Call Management and Time and Billing templates in
access this may give you some ideas.

In the meantime I will look at your problem later today.

--
Allan Murphy
Email: (e-mail address removed)

Hi Allan, thanks for responding so quickly, I do have the project_info file
linked. I just realized this morning that I should be using a query instead
of having the form linked directly.

Now what I have run into is that I have the project_info listed, but when I
try to do the timesheet part, I am getting a subform... I want to be able to
have one form that will allow the user to select the job (4 fields) and input
the rest of the timesheet information (4 fields) as I build the form, the
timesheet part becomes a subform. How do I get to the one form and then get
it to append the information to my time table? Do I need to build it via
vbasic or am I just drop kicking myself and not seeing what is right in front
of me?

I am leaving for the day and will look for a reply first thing tomorrow. I
think I need a fresh set of eyes to continue this journey. I do really
appreciate all the help that has been given...

 

[bobc721]

Allan,

Both databases (Service Call and Time & Billing) are using subforms to
capture data. This is great up to a point, but neither will allow me to do
what I am trying to do: Move information from the split database, into an
individual table.. I need the information from the (linked) proj_info table
that has been selected, which is currently attached as subform and place it
into the Timesheet database into the time table.

I know this is not the best solution, but it's the one that will work for
the exercise.

tia

 

[Allan Murphy]

Bob

Replay to me off list as I may have a solution