Access Development Freelance

[Cy]

Hi all,

I wanted to start a thread that might help many of us. I worked for a
company for 12 years, until this past Christmas when they let me go.
Getting rid of the higher dollar guys, in favor of more profit, was the
reasoning. Oh well.

Anyhow. I built this companies network from the ground up. Then about
8 years ago, I developed a MS Access 2.0 database. This database, much
like others, was supposed to just tiny bits. Over the course of time,
we converted to 97, then to 2000, then this past summer to 2003. The
database now runs almost every aspect of the company, from contract
management to payroll (outsourced) to contact management to sales to
production measurement and budgeting tools, except the Accounting end,
yet it interfaces and pulls data out for custom report in Access.
Towards the end of my tenor, say the past 3 years, I had 2 guys doing
the hardware/break fix, while I spent most of the time developing. The
company is about $50 million in size, with about 80 users access this
database daily. The back end is SQL, front end Access.

Ok, enough of the history lesson. What I would like to figure out,
since I feel I have become pretty good at creating, modifying/making
databases, is any suggestions on how to get into consulting/freelance
Access work. I know, that I have read other threads, that state there
aren't a number of truly qualified Access developers out there. I've
tried finding free lance sites, but that seems like a fruitless effort.

Any help for a guy in Cincinnati who is trying to make it in life,
would be appreciated. Would be good to hear everyone else's take on
this.

Thanks for looking and commenting.

[Tim Marshall]

PC Datasheet wrote:

I provide help for a very reasonable price. Here are a few comments I have
gotten

Oh Jesus Christ, will you just fuck off.

What about for providing advice on pk/fk that betrays a total lack of
knowledge about that most basic of relational database techniques,
implementing table level constraints (aka relations in Jet) for data
integrity? The construction of an interface that allows creation of
orphaned records and relies on form level code to avoid such? And
giving such advice trying to pass yourself off as an authority on such?
OMG, give me a break.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "What's UP, Dittoooooo?" - Ditto

[StopThisAdvertising]

"PC Datasheet" <no****@nospam. spam> schreef in bericht news:ss******** *********@newsr ead2.news.atl.e arthlink.net...

<snipped all te crap here>

And if there is any doubt, look back five posts previous to this one, "What
is the syntax for displaying ....."
Yep Thats the syntax
Thanks a bunch
Jerry
You are a real champion here Steve! Indeed a good answer! Chapeau!
---
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
re******@pcdata sheet.com

--
To Steve:
Over 300 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R

[Rob Oldfield]

I just find it a bit strange that there are these hordes of people reading
this, all of whom seem to adore Steve, and none of them have ever made the
effort to post a supportive message.

[Danny J. Lesandrini]

NASA?!

Lyle, do you know if the moon landings were faked?
Or should we consult with Kyle on this question in
order to get the truth?
--
Danny J. Lesandrini
"Lyle Fairfield" <ly***********@ aim.com> wrote ...

I graduated from College just before Sputnik. I started to work at NASA
using Clipper and a 286 XT. I developed all their database software ...

[Lyle Fairfield]

I'm not sure.

Just when Sheppard set his foot on the moon, my partner was having a
big orgasm. I'm pretty sure it was faked bacause she faked everything
else.
Now if we apply that principle to western media, what do we get?

Regardless, all the noise, thrashing and clenching prevented me from
observing carefully.
I don't know what Kyle was doing at the time ... probably something
wild, so he's unlikely to know either.

[David W. Fenton]

"John Marshall, MVP" <la******@stone henge.ca> wrote in
news:nq******** ************@ma gma.ca:

"PC Datasheet" <no****@nospam. spam> wrote in message
news:Ep******** *********@newsr ead3.news.atl.e arthlink.net...

I have gotten 6 to 10 requests for help

How many knew that there was a price attached to your "help".
These newsgroups are for free help, not for soliciting.

Just for reference, I get a lot of Access questions via email, and I
refuse to anwwer the questions there. I direct them to post here,
and usually if someone has beaten me to it, I then answer the
question in the newsgroup.

Theoretically, I could charge people for answering their questions,
but I'd much rather contribute to the Access community, which has
provided me with so much.

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

[David W. Fenton]

"Rob Oldfield" <bl**@blah.co m> wrote in
news:43******** **************@ news.zen.co.uk:

I just find it a bit strange that there are these hordes of people
reading this, all of whom seem to adore Steve, and none of them
have ever made the effort to post a supportive message.

Er, don't give him any ideas.

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

[Lyle Fairfield]

I never get any Access questions via email, but I answer them right
away and free-of-charge.

[Marshall Barton]

Cy wrote:

I wanted to start a thread that might help many of us. I worked for a
company for 12 years, until this past Christmas when they let me go.
Getting rid of the higher dollar guys, in favor of more profit, was the
reasoning. Oh well.

Anyhow. I built this companies network from the ground up. Then about
8 years ago, I developed a MS Access 2.0 database. This database, much
like others, was supposed to just tiny bits. Over the course of time,
we converted to 97, then to 2000, then this past summer to 2003. The
database now runs almost every aspect of the company, from contract
management to payroll (outsourced) to contact management to sales to
production measurement and budgeting tools, except the Accounting end,
yet it interfaces and pulls data out for custom report in Access.
Towards the end of my tenor, say the past 3 years, I had 2 guys doing
the hardware/break fix, while I spent most of the time developing. The
company is about $50 million in size, with about 80 users access this
database daily. The back end is SQL, front end Access.

Ok, enough of the history lesson. What I would like to figure out,
since I feel I have become pretty good at creating, modifying/making
databases, is any suggestions on how to get into consulting/freelance
Access work. I know, that I have read other threads, that state there
aren't a number of truly qualified Access developers out there. I've
tried finding free lance sites, but that seems like a fruitless effort.

I can't suggest much in the what to do department beyond
checking the want ads, especially those from consulting
firms. Even if you don't want to work for someone else, it
might keep you going until you can find some contacts of
your own.

Given your description of the db you developed for your
previous employer, sooner or later, I fully expect them to
call you looking for help with another enhancement. If they
do, be sure to charge them the going rate in your area. You
don't owe them anything "for old times sake" and are in a
fairly strong position compared to folks that are unfamiliar
with the company and the db.

--
Marsh

[Lyle Fairfield]

After people read this previous post from Cy I'm sure he'll have
thousands of offers. You'll probably want to hire him to spruce up some
of your code!

**********
1. Cy
Jan 26, 7:18 pm show options
Newsgroups: comp.databases. ms-access
From: "Cy" <googlej...@com putunity.com> - Find messages by this author
Date: 26 Jan 2006 16:18:49 -0800
Local: Thurs, Jan 26 2006 7:18 pm
Subject: Method Not Found, Access 97/2000 Conversion
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse

Hello Fellow New Group Folks,

Here's today's problem. I was called in to help convert an Access 97
database to Access 2000. 99% of all my Access Dev. work has occurred
in 2000, so I know very little about 97, however, from everything I
read, it sounded like a conversion from 97 to 2000 should go smoothly.
Boy was I wrong.

Here's what we got. There is a form, that lists a group of employees.
There is a command button, that when pressed, is supposed to go out and
see if there are any "results" for this particular employee. If there
isn't any results, it is supposed to prompt the user to see if they'd
like to add a result at that time. Works great in 97. Gives a method
not found. I looked at the code, with no avail. Here is the code.

*************** *************** *************** *************** *************** *************** *************** **
Private Sub Results_Click()
On Error GoTo results_err
Dim a, mers As Recordset, f As Form
Dim mydb As Database, resrs As Recordset
If Me.Dirty Then DoCmd.DoMenuIte m 0, 0, 4
Select Case Me!stype
Case 2:
Set mers = Me.RecordsetClo ne
mers.Bookmark = Me.Bookmark
If IsNull(mers.[res_no]) Or mers.[res_no] = 0 Then
a = MsgBox("There are no results yet for this appointment. Do
you wish to add some?", 36, "No results yet")
If a = 6 Then
Set mydb = CurrentDb
Set resrs = mydb.OpenRecord set("result-alcohol")
resrs.AddNew
resrs.date_rept rcv = date
mers.Edit
mers.[res_no] = resrs.result_no
mers.Update
resrs.Update
DoCmd.OpenForm "results-alcohol", , , "[result_no] = " &
CStr(mers.[res_no]), , acDialog
Me!Positive = alcres("results-alcohol")
DoCmd.Close acForm, "results-alcohol"
End If
Else
DoCmd.OpenForm "results-alcohol", , , "[result_no] = " &
CStr(mers.[res_no]), , acDialog
If Forms.[results-alcohol].cpos Then Me!Positive = 1 Else
Me!Positive = 2
DoCmd.Close acForm, "results-alcohol"
End If
Case 3:
Set mers = Me.RecordsetClo ne
mers.Bookmark = Me.Bookmark
If IsNull(mers.[res_no]) Or mers.[res_no] = 0 Then
a = MsgBox("There are no results yet for this appointment. Do
you wish to add some?", 36, "No results yet")
If a = 6 Then
Set mydb = CurrentDb
Set resrs = mydb.OpenRecord set("result-drug")
resrs.AddNew
resrs.date_rept rcv = date
mers.Edit
mers.[res_no] = resrs.result_no
mers.Update
resrs.Update
DoCmd.OpenForm "drug result", , , "[result_no] = " &
CStr(mers.[res_no]), , acDialog
mers.Edit
If Pos("drug result") Then mers.Positive = 1 Else mers.Positive
= 2
If susp("drug result") Or (mers.Positive = 1) Then mers.mro =
False Else mers.mro = True
mers.Update
DoCmd.Close acForm, "drug result"
End If
Else
DoCmd.OpenForm "drug result", , , "[result_no] = " &
CStr(mers.[res_no]), , acDialog
mers.Edit
If mers.Positive < 3 And Pos("drug result") Then mers.Positive =
1 Else If mers.Positive < 3 Then mers.Positive = 2
If susp("drug result") Or (mers.Positive = 1) Then mers.mro =
False Else mers.mro = True
mers.Update
DoCmd.Close acForm, "drug result"
End If

End Select

Me.Refresh
results_cont:
DoCmd.SetWarnin gs True: DoCmd.Hourglass False
Exit Sub
results_err:
If Err = 3260 Then
MsgBox "This data is currently locked out. Hit Enter to try again"
DoEvents
Resume
End If

msgdisp
GoTo results_cont
End Sub
*************** *************** *************** *************** *************** *************** ***************

It fails on this line, so far.
If IsNull(mers.[res_no]) Or mers.[res_no] = 0 Then
What I don't understand is what "method" in 97 is res_no? I was
thinking that the brackets would indicate that it is a field, but there
is no object in the database with that name.

I also know that it fails on this lines as well:
resrs.date_rept rcv = date
and what is date_reptrcv

Any help would be appreciated. If anyone has a utility or something
that helps sift thru this code and made recommendations for changes,
that is helpful also.

No matter what, this group has always been good to help out. Any help
is appreciated.
********