New job Access 97 help please

[justicerulesok]

Hello,

I've just started a new job where at interview I said my week point was
MS Access. I got the job & they've asked me to create a DB on Access
97 to log calls to the IT department & keep a record of the action
taken. I thought I was going quite well I have talbes for new call,
call details, caller, equipment, escalation routes, contact details for
escalation routes, I got all the relationships up & runing (I think) &
then did a nice form to fill in to log new calls using fields from a
number of the tables that should be filled out. Well b****r me if it
didn't work. one error i get is that I cant type stuff in due to
recordset properties (but I cant find a record set thinggie to edit) &
then when I can type stuff in one field it does two wiered things,
firsly it puts the same data in that field on every new record I create
(within the form) but that same data does not apear in the table!

Obviously I need help - can anyone give me some pointers or suggest a
good website for adivce (or does anyone know where I can download a
ready made one).

Any help or advice is very much apreciated.

Thank you,

Justice.

[ortaias]

At a minimum upgrade to Access2000 before starting anything.. I don't
know if the current release of Access adds anything of value.

Read "Access Database Design & Programming" by Steven Roman by O'Reilly
press.
You may also want to read "Programming Microsoft Access Version 2002"
by Rick Dobson by Microsoft Press. I would expect that these books
would be available on Amazon.com.

[justicerulesok]

thanks for the reply. The IT manager has no desire to upgrade. He had
an assistant for about a month who suggested that & got sacked - I'm
the replacement & don't intend to rock the boat. I'll bear the titles
in mind if they descide to keep me on (I'm on a temp contract - want to
make a good impression before I splash out - very poor been unemployed
since being knocked off my motorbike in March).

or*****@hotmail.com wrote:

At a minimum upgrade to Access2000 before starting anything.. I don't
know if the current release of Access adds anything of value.

Read "Access Database Design & Programming" by Steven Roman by O'Reilly
press.
You may also want to read "Programming Microsoft Access Version 2002"
by Rick Dobson by Microsoft Press. I would expect that these books
would be available on Amazon.com.

[Lyle Fairfield]

ju************@gmail.com wrote:

Hello,

I've just started a new job where at interview I said my week point was
MS Access. I got the job & they've asked me to create a DB on Access
97 to log calls to the IT department & keep a record of the action
taken. I thought I was going quite well I have talbes for new call,
call details, caller, equipment, escalation routes, contact details for
escalation routes, I got all the relationships up & runing (I think) &
then did a nice form to fill in to log new calls using fields from a
number of the tables that should be filled out. Well b****r me if it
didn't work. one error i get is that I cant type stuff in due to
recordset properties (but I cant find a record set thinggie to edit) &
then when I can type stuff in one field it does two wiered things,
firsly it puts the same data in that field on every new record I create
(within the form) but that same data does not apear in the table!

Obviously I need help - can anyone give me some pointers or suggest a
good website for adivce (or does anyone know where I can download a
ready made one).

Your description suggests you did a good job of database design; you,
at least, took into consideration normalization, relationships etc.

You indicate that you have a problem with a form. Before we can help
you with that we would have to know some more about the form. Is it a
bound form, that is does the form have a recordsource; if so what is
the recordsource? If it's a saved query then we will likely need to
know the sql string of the query. Does the form default to continuous
form display, or a single record at a time? Do each of your tables have
an indexed, probably primary key, identity field?

After that we could attack one problem at a time. You could choose the
simplest, perhaps, first. I think you should not despair. It sounds to
me as if you have done some good work. It may be that one simple
misunderstanding is causing your form to misfunction and that if we can
clear that one thing up, everything may work.

I am not a fan of Access 97 being used today, not because its bad, but
because its old. But IMO Access 2000 is unlikely to be helpful in this
case. There is no reason Access 2000 will work better than Access 97,
and in fact, because of its greater complexity and extremely poor state
on initial delivery (since repaired with Service Packs 1 through 7864)
it may not work as well.

[Tom van Stiphout]

On 30 Jun 2006 04:11:11 -0700, "ju************@gmail.com"
<ju************@gmail.com> wrote:

File > New > Database Wizard

-Tom.

Hello,

I've just started a new job where at interview I said my week point was
MS Access. I got the job & they've asked me to create a DB on Access
97 to log calls to the IT department & keep a record of the action
taken. I thought I was going quite well I have talbes for new call,
call details, caller, equipment, escalation routes, contact details for
escalation routes, I got all the relationships up & runing (I think) &
then did a nice form to fill in to log new calls using fields from a
number of the tables that should be filled out. Well b****r me if it
didn't work. one error i get is that I cant type stuff in due to
recordset properties (but I cant find a record set thinggie to edit) &
then when I can type stuff in one field it does two wiered things,
firsly it puts the same data in that field on every new record I create
(within the form) but that same data does not apear in the table!

Obviously I need help - can anyone give me some pointers or suggest a
good website for adivce (or does anyone know where I can download a
ready made one).

Any help or advice is very much apreciated.

Thank you,

Justice.

[Bob Quintal]

"ju************@gmail.com" <ju************@gmail.com> wrote in
news:11**********************@y41g2000cwy.googlegr oups.com:

thanks for the reply. The IT manager has no desire to
upgrade.

Smart man. We upgraded from '97 to 2K and had so many problems, we
went back.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[Bob Quintal]

"ju************@gmail.com" <ju************@gmail.com> wrote in
news:11**********************@y41g2000cwy.googlegr oups.com:

Hello,
one error i get is that I cant type stuff in due to recordset properties (but I cant find a
record set thinggie to edit) & then when I can type stuff in
one field it does two wiered things, firsly it puts the same
data in that field on every new record I create (within the
form) but that same data does not apear in the table!
The form or the control is not properly bound to the table.
You may need to break the form into a master and some separate
subforms, .

The recordset is defined as a property in form design view,
called .recordsource. this should be one of your tables or an
inner join between two or three tables max. Left joins sometimes
are read only for no apparent reason.

Your textbox that puts the data in all rows has no
..controlsource. that's why it puts what you type everywhere.
Check for spelling errors or that the name you used is not an
Access reserved word.
Any help or advice is very much apreciated.

Thank you,

Justice.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

[David W. Fenton]

"or*****@hotmail.com" <or*****@hotmail.com> wrote in
news:11**********************@y41g2000cwy.googlegr oups.com:

At a minimum upgrade to Access2000 before starting anything.

Oh, that's just ridiculous. There's nothing wrong with A97 as a
development platform.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[justicerulesok]

OK,

I've tried a few things, I was trying to use fields from 3-4 different
tables in one form, reading your posts I have figured out thats not
good. I've put most of the fields on one table (I had a table new job
which had job number, time of call & date of call, and a job details
table with nature of call & advice offered, job number, callers name,
then another caller details etc). I also don't have any queries yet so
maybe that causes a problem.

:-) Yes I tried the wizards & templates first - who wouldn't I couldn't
find one that did what I wanted :-)

I have a form for log new call but in the caller name box it gives me a
menu of names already used when I type a new name in it won't let me
save the record so I tried to put a command button in to add new user -
the idea was to open another form I created called add new user but for
the life of me can't remember anything about the VB unit I did at uni
in 2001 as a mature student & all my attempts to show, load or open
form when the button is clicked fail misurbly.

Fortunatly this is a mon-fri 9-5 job & I'm not expected to 'take it
home with me' I think they are quite happy as I've spend two days in
cupboards auditing old equipment to go down the dump (one of those jobs
that must be done but no-one actually gets around to)

Thanks all for your advice, I havn't given up yet!