Re: Still New to Access DB

Evi
Yes everything else is working OK on the form. I have entered dummy entries
and it seems to work fine.

The tab order in the design view on the subform only is correct, however the
tabbing still does not work properly. It may have something to do with
tabbing from field to field on the form and it goes to the next row on the
first records subform then to the second record and then to the last field
on the subform. We can work on this issue later if you think it doesn't have
anything to do with anything else we are trying to do..

Now, when it comes to adding the combo box to the subform in design view,
the wizard will not allow me to look up the value I want in a table or
query. When I select the fields I want in the combo box it said the data
can not be retrieved from the source I have selected. I must select a
different table or query.
When I try - I will type in the value and I add the combo to the form and
type in the value I get it in 3 rows. Any thoughts???

Thanks to you and John using Outlook Express works like a charm.

Brent


"Evi" <evwool@xxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:pDfWj.506$ie5.372@xxxxxxxxxxxxxxxx
Hi Brent, you need to open the Subform by itself (not the main form) in
Design view to set the Tab order.

Open the subform in Design view, add a combo based on TblEvent to it, so
that you can choose which event the employee is attending. (it needs
EventID
and whatever fields you need to identify an event)
Is everything else working OK on the form - enter dummy data to your
tables
if you need to. Does it change records to show only records for that
Employee, can you add more than 1 record to it.

Can you add a new employee to it?

I access this ng using Outlook Express and Newsgroups. It works pretty
well.
If I want to search for a topic, then I go online.

By all means start a new thread - the more input you get, the better.
Include your db design, listing your tables, and if you have a problem,
state exactly what is happening

Evi





"Brent" <Brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:958E110D-3C0E-4326-9E3F-BCA279AA46D6@xxxxxxxxxxxxxxxx
Yes, this is happening. After the first record the tab order on the
subform
goes right to the last field but the Master and Child links on the
subform
are linked to the EmpID which is right.
We will need to get the event and funding tables in on this.

Should we stay on this post or start a new one? It takes me about 1/2
hour
to get here. Is there a faster way to get onto Microsoft? This is the
only
web site it takes so long to load.
--
Thanks Brent


"Evi" wrote:

Lets see if we can pinpoint what is going wrong. If you don't have any
data
in your db, add a dummy employee to TblEmployee.
Add a dummy event to TblEvent.

An AttEvent subform would list how many events that employee attended
so
you
could certainly start with that.

1. Click on TblEmployee then drag the (closed) TblAttEvent from the
db
window onto the newly created form in Design view.
2. The wizard ought to kick in. (if it doesn't, ensure that the Wizard
button is pressed down in the Form's design view (looks like a wand)

Is this bit happening?

Evi
"Brent" <Brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:75462D42-ACDC-4F02-81E1-8263F7D32CFD@xxxxxxxxxxxxxxxx
Your right Evi, I tried it again by building a new db and it still
didn't
work. What main form and subform would you suggest I start with?
I would like to start with the employee form as the employee name and
employee number seems like the natural place to start. Would the
AttEvent
subforms be OK?
I would need to figure out how to get the other fields on the
employee
form
ie. funding and event info.
Thanks for all your help


--
Brent


"Evi" wrote:

Don't forget it altogether, but there must be some reason why you
couldn't
get it to work, so just for now, see if it works OK to do a normal
main
form
and subform. If you can get that working OK, and everything works
as it
ought, then you can go onto doing the double sub.
Evi

"Brent" <Brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0389F89A-519F-4A86-BC08-99FAF5BD8FC8@xxxxxxxxxxxxxxxx
Hi Evi. Once again thank you for all your help. I have not had
time to
do
any
more work on th db over the last few days but will get on it
today. I
think
everything should work now.
Do you think my main form being the Employee form and the two
subforms
will
be ok or should I forget it and move forward? It would be great
if
I
could
get that to work.
That should be all for now and again thanks to all
--
Thanks Brent


"Evi" wrote:

Hi Brent. If you need to have a start date and end date for the
event
(is
that what is meant by ConfStartDate, ConfEndDate?) then it
would
go
in
the
table of events. The reason it might be necessary is if the
employee
doesn't
attend the whole event. It's looking fine as far as I can see.

If you are saying that Events are things that happen during a
Conference,
then you would need to add another level to your database,
though an
easy
one. You need a TblConference whose Primary Key field will be a
Foreign
Key
field in TblEvent.

You say:
'How much of each funding centre has been spent per employee
and
total
spent.' (This is a report the Manager wants to see as there
are
some
30
funding centres so wants to see the breakdown and totals on
reports)

With the structure below, that should not be a problem. You
could
have a
query based mainly on TblAttendEvent. You would add (without
their
primary
keys) any details from the other tables which you required for
the
report
(so you wouldn't need the date field for instance or the
AtEventID
field
or
even the EventID because the statistics required don't concern
that
but
you
would want some of the Employee fields from TblEmployee and
some of
the
the
Funding Centre fields from TblFunding centre. You could turn
that
into a
totals query and base a report on that grouped first by funding
centre,
then
by employee.

Evi



"Brent" <Brent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E6ABFEE9-9E84-4D8F-899B-6356B8D90CA7@xxxxxxxxxxxxxxxx

Evi
I hope you can see my responses as I tried to make it as
clear
as
I
can. I
started a new db and removed all the spaces as you suggested
and
used
your
naming conventions. I tried to edit your post to help. All is
as
you
have
it
other than my notes in brackets.
eg
TblEmployee
EmpID (PK Autonumber)
EmpFirstName
EmpLastName
EmpNumber (a company number assigned each employee)

TblFunctionalCentre
PayID (PK
Account
Functional Centre
Org
Other Funding Source (is this meant to be a field in your
table?
what
is
this about? (A text field for notes if another funding source
will
pay
a
portion of the costs. Another program looks after this part
of
the
funding
if
it applies)

TblEvent
EventID (PK)
ConfName
Venue
Presenting
RefundDate (date by which refunds must be claimed)
(but no start and enddate for the event???) This table is
correct.
The
start
and end dates are in the TblAttendEvent table.( This is true)
(I
just
found
out I need a confStartDate and a ConfEndDate added, this was
a
request
from
another user. Where will these fields go?)


TblAttendEvent
AtEventID (PK)
EmpID (Linked from TblEmployee (Yes)
FundID (linked from TblFundingCenter (I called this field
PayedID)(Yes)
EventID (Linked from TblEvent) (Yes)
RegCost (how much it cost that employee to register for the
event)
TravelCost (How much it cost the employee to travel to/from
the
event)
AccomCost (How much the employee had to pay for accomodation
TravelDate (I have this field) (date employee traveled to
event)
ReturnDate (the date the employee returned from the event
DateBooked date Employee was booked to attend the event (I
need
this
field)
DateAttended (date Employee attended the event - or else just
use
a
yes/no
field) (I need the Date)
FundAmount (because you said that the centre funds an
individual
employee
rather than giving a lump sum to be divided among several
Employees (I
don't
have this field anywhere in the db and yes the centre funds
an
individual)

However, when you say that you need to know

'How much of each funding centre has been spent per employee
and
total
spent.' (This is a report the Manager wants to see as there
are
some
30
funding centres so wants to see the breakdown and totals on
reports)


A list like this, with explanations, will ensure the
structure
is
absolutely
correct before you go on to creating a coded, linked form.


When you say you checked the Tab order, did you go to View ,
Tab
order? (Yes in the form design view, it worked ok for the
first
record
then
would jump to the last field in each of the two subforms ???)

For your combo, (Lets forget this for now if it will make
things
easier)

Can I suggest, that until you've had a bit more experience
with
forms
and
subforms, that you put up with using seperate forms+subforms
to
add
your
data. So use simple forms without data to add your data to
your
'one'
tables
(TblEmployee, TblEvent TblFunding Centre in my example)
Then use one of these 'one' table as a main form and add the
links
via
a
combo with your single forms ready to add extra details (Not
sure
how
this
would work ?? but ok. I was just trying so hard not to give
up
on
the
subform
x 2 idea )

Once again thanks for taking the time to help. I started this
new
post
as
the first one was way down the list.


--
Thanks Brent


"Evi" wrote:

Hi Brent,
Could you check if I've listed your table structure
correctly. I
read
your
previous post where you began to do it but it got a bit
confusing as
to
which field was in which table or if the space between the
field
names
meant
that there were 2 fields or 1. You could just edit the
structure
below

eg
TblEmployee
EmpID (PK Autonumber)
EmpFirstName
EmpLastName

TblFunctionalCentre
PayID (PK
Account
Functional Centre
Org
Other Funding Source (is this meant to be a field in your
table?
what is
this about?

TblEvent
EventID (PK)
ConfName
Venue
Presenting
RefundDate (date by which refunds must be claimed)
(but no start and enddate for the event???)


TblAttendEvent
AtEventID (PK)
EmpID (Linked from TblEmployee
FundID (linked from TblFundingCenter
EventID (Linked from TblEvent)
RegCost (how much it cost that employee to register for
the




.