From: softy on
Guy's and Gal's

I have a database that is based on MS access that I am having trouble
with. I actually paid someone to create this for me but they refuse help
as they have gone out of business! (wonder why-)

First, before I show that I am a complete idiot and describe the fault,
** am I in the right group for that type of help ** ??

Softy
From: softy on
BTW... the database is for Pest Control



On 30/01/2010 9:29 AM, softy wrote:
> Guy's and Gal's
>
> I have a database that is based on MS access that I am having trouble
> with. I actually paid someone to create this for me but they refuse help
> as they have gone out of business! (wonder why-)
>
> First, before I show that I am a complete idiot and describe the fault,
> ** am I in the right group for that type of help ** ??
>
> Softy

From: oldblindpew on
Softy,
There is considerable expense and effort in developing a full-blown
custom-made application. What makes things affordable is spreading the cost
among many end users. Since you paid someone to develop your application,
you may be a small company with maybe just one location. I think your
choices are to either spend a very long time acquiring the knowledge it takes
to do Access yourself, or, find and pay another consultant to continue
developing your application.

There are some very knowledgable and helpful people on this forum, but there
are practical limits to what can be accomplished here. Vague questions
cannot be answered clearly in any case, and extremely broad and complex
questions tend to get bogged down in details. The best results come when a
knowledgeable developer asks a very specific and narrowly focussed question.

I would suggest you try picking out one thing you are having trouble with in
your application, learn as much as you can about it by "getting under the
hood" and figuring out specifcally which parts are not working, and then ask
your question accordingly.

Best of luck,
OldBlindPew


"softy" wrote:

> Guy's and Gal's
>
> I have a database that is based on MS access that I am having trouble
> with. I actually paid someone to create this for me but they refuse help
> as they have gone out of business! (wonder why-)
>
> First, before I show that I am a complete idiot and describe the fault,
> ** am I in the right group for that type of help ** ??
>
> Softy
> .
>
From: softy on
Sorry for the "vague" original question but I am that way about this and
what its doing...and also, I was not sure if I were in the right NG

First, the DB belongs to the other 1/2 and I have never really used it.
Just looked at what she told me and tried a few things. My knowledge of
MS Access is very limited.

As best I can....
The database seemed to have run out of job numbers for 2009. All job
numbers start with the year prefix i.e 08xxx or 09xxx.
We gave up using it around August 09 as new jobs entered were gone next
day...and when logging in, a message popped up saying

QUOTE
"The job ID is not using the current year as count prefix, do you wish
to update it to the current year"

If we change the date of the computer to 2009.... and start the database
so the DB thinks its 2009... the same above error pops up. Closing and
changing back to 2010, the error is gone.

How here today, gone tomorrow was happening I have no idea

Now playing with it in 2010, it seems to be working again but obviously
not fixed

We did take it down to the local computer shop. He said he fixed it by
"adding more numbers"?? Anyway, whatever they did, did not fix it. But
again, that was last year. This year 2010 the other 1/2 has been playing
with it and entering a few jobs and ....seems to be working again.

The last 2009 job number was 091010 and that's where it seemed to go
weird.... but 2008 had more jobs and nil issues...

I don't trust it enough to sit there and enter all the jobs that have
not been yet put in

Any assistance appreciated

Softy

On 30/01/2010 11:11 AM, oldblindpew wrote:
> Softy,
> There is considerable expense and effort in developing a full-blown
> custom-made application. What makes things affordable is spreading the cost
> among many end users. Since you paid someone to develop your application,
> you may be a small company with maybe just one location. I think your
> choices are to either spend a very long time acquiring the knowledge it takes
> to do Access yourself, or, find and pay another consultant to continue
> developing your application.
>
> There are some very knowledgable and helpful people on this forum, but there
> are practical limits to what can be accomplished here. Vague questions
> cannot be answered clearly in any case, and extremely broad and complex
> questions tend to get bogged down in details. The best results come when a
> knowledgeable developer asks a very specific and narrowly focussed question.
>
> I would suggest you try picking out one thing you are having trouble with in
> your application, learn as much as you can about it by "getting under the
> hood" and figuring out specifcally which parts are not working, and then ask
> your question accordingly.
>
> Best of luck,
> OldBlindPew
>
>
> "softy" wrote:
>
>> Guy's and Gal's
>>
>> I have a database that is based on MS access that I am having trouble
>> with. I actually paid someone to create this for me but they refuse help
>> as they have gone out of business! (wonder why-)
>>
>> First, before I show that I am a complete idiot and describe the fault,
>> ** am I in the right group for that type of help ** ??
>>
>> Softy
>> .
>>
From: Gina Whipp on
Softy,

From your description it sounds like the database needs to be *reviewed* by
someone familiar with Access so the code can be reviewed and an assessment
of what needs to be done can be documented. Unless you are willing to
*learn* (and we volunteers will guide you along for FREE) then try checking
your local universities or colleges...

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"softy" <softus(a)XXXXgmail.com> wrote in message
news:IVL8n.4321$pv.3565(a)news-server.bigpond.net.au...
Sorry for the "vague" original question but I am that way about this and
what its doing...and also, I was not sure if I were in the right NG

First, the DB belongs to the other 1/2 and I have never really used it.
Just looked at what she told me and tried a few things. My knowledge of
MS Access is very limited.

As best I can....
The database seemed to have run out of job numbers for 2009. All job
numbers start with the year prefix i.e 08xxx or 09xxx.
We gave up using it around August 09 as new jobs entered were gone next
day...and when logging in, a message popped up saying

QUOTE
"The job ID is not using the current year as count prefix, do you wish
to update it to the current year"

If we change the date of the computer to 2009.... and start the database
so the DB thinks its 2009... the same above error pops up. Closing and
changing back to 2010, the error is gone.

How here today, gone tomorrow was happening I have no idea

Now playing with it in 2010, it seems to be working again but obviously
not fixed

We did take it down to the local computer shop. He said he fixed it by
"adding more numbers"?? Anyway, whatever they did, did not fix it. But
again, that was last year. This year 2010 the other 1/2 has been playing
with it and entering a few jobs and ....seems to be working again.

The last 2009 job number was 091010 and that's where it seemed to go
weird.... but 2008 had more jobs and nil issues...

I don't trust it enough to sit there and enter all the jobs that have
not been yet put in

Any assistance appreciated

Softy

On 30/01/2010 11:11 AM, oldblindpew wrote:
> Softy,
> There is considerable expense and effort in developing a full-blown
> custom-made application. What makes things affordable is spreading the
> cost
> among many end users. Since you paid someone to develop your application,
> you may be a small company with maybe just one location. I think your
> choices are to either spend a very long time acquiring the knowledge it
> takes
> to do Access yourself, or, find and pay another consultant to continue
> developing your application.
>
> There are some very knowledgable and helpful people on this forum, but
> there
> are practical limits to what can be accomplished here. Vague questions
> cannot be answered clearly in any case, and extremely broad and complex
> questions tend to get bogged down in details. The best results come when
> a
> knowledgeable developer asks a very specific and narrowly focussed
> question.
>
> I would suggest you try picking out one thing you are having trouble with
> in
> your application, learn as much as you can about it by "getting under the
> hood" and figuring out specifcally which parts are not working, and then
> ask
> your question accordingly.
>
> Best of luck,
> OldBlindPew
>
>
> "softy" wrote:
>
>> Guy's and Gal's
>>
>> I have a database that is based on MS access that I am having trouble
>> with. I actually paid someone to create this for me but they refuse help
>> as they have gone out of business! (wonder why-)
>>
>> First, before I show that I am a complete idiot and describe the fault,
>> ** am I in the right group for that type of help ** ??
>>
>> Softy
>> .
>>