My boss is asking for a bi-weekly schedule that allows him to see two weeks
of work at a time as to what is due and when. He also wants the weeks to be
numbered (X/52). I also need to have room in each dated block to enter the
types of projects due that day.
I doubt it. Im finding it hard to find what I want even simple things
when I look online and Im also going to bookstores skimming through
the books at borders etc and I dont like the books all that much. Sure
Id love to buy ALL of them cause they all have bits and pieces of this
and that but I dont feel like spending $400 in books at the moment. Id
buy one or two if I really felt comfortable with them. That may change
when I get look over them more closely.
You can try to create your own input / lookup screen.
Create the database/table obviously And then use the wizard to create
a continuous form which is an option in the properties box when you
create the form. Im doing that now and coincidentally need about two
weeks of time cards shown. In the headerscreen part Im making an
input for the soc sec number and date so that it looks up two weeks of
time card entries for a particular person. You can create all that by
dragging and dropping fields from a field list etc
It should be easy but I cant find clear examples. Anyway the next part
obviously are the lookups, restricting the lookup between so and so
and so and so dates - one obvious way is you got 5 records per week so
obviously limit it to 10. How to do this? I dont know . Im looking
now. It should be in a dummies book frankly. These are basics. But
wading through all that stuff from objects, to events, to VBA to the
drag and drop automated features is driving me nuts.
Also you have all that validation code and any calcs you want to
display and other fancier stuff. I keep skimming the books and theyll
have a bit here and there thats driving me crazy. Like they have a
thing on forms but how do you set all the values when you open the
form? Ive been looking at the event starup etc Ill have to experiment
with that but Im not sure I have the right one.
Lots of simple things having trouble getting a clear view on which
should be simple as pie. It might be my fault though. I like to get
the total picture and hate learning a tiny bit by tiny bit.
