Trying to create a similar database

On Thu, 22 Feb 2007 11:44:35 -0800, Betty
wrote:

They mention S_GUID in the "help" area under making a replicated database a
regular database.

I saw the S_GUID notations SOMEWHERE when I was digging around in the
database. Unfortunately, I cannot find them at the moment.

As Bruce and gls858 said, the S_GUID field is created as part of the
Replication process. if you don't intend your database to be
replicated, just leave them out of the new version; if you DO want to
replicate it, let the Replication Wizard created them, don't try to do
so yourself!

John W. Vinson [MVP]

Beautiful! You are all a big help.

I'm finding that my functionality suffers in great part due to the macros
that were entered from the locked bid log I began with. I copied those
macros without really knowing what they were for, so now I'm digging in there.

Any general tips you'd like to offer regarding creating efficient macros?


"John W. Vinson" wrote:

On Thu, 22 Feb 2007 11:44:35 -0800, Betty
wrote:

They mention S_GUID in the "help" area under making a replicated database a
regular database.

I saw the S_GUID notations SOMEWHERE when I was digging around in the
database. Unfortunately, I cannot find them at the moment.

As Bruce and gls858 said, the S_GUID field is created as part of the
Replication process. if you don't intend your database to be
replicated, just leave them out of the new version; if you DO want to
replicate it, let the Replication Wizard created them, don't try to do
so yourself!

John W. Vinson [MVP]

On Fri, 23 Feb 2007 09:42:10 -0800, Betty
wrote:

Any general tips you'd like to offer regarding creating efficient macros?

Yes:

Don't.

Macros are inflexible, inefficient, hard to write, hard to document,
don't allow errors to be trapped, and are hard to maintain.

VBA code is better on every single count.

Abandon macros and go to VBA code. For anything beyond the simplest of
tasks, it's *easier* to write and to understand.

John W. Vinson [MVP]

WOW. I see what you've posted, but what I'm hearing is "...be afraid. Be
very afraid."

And it all translates into: maybe you're in over your head here, girl.

If I can't figure out a feasible solution within a couple days, I'm going to
have to look into maybe a free template to just rename tables etc.

As much as I need to learn this office tool, I'm in need of something quickly.



"John W. Vinson" wrote:

On Fri, 23 Feb 2007 09:42:10 -0800, Betty
wrote:

Any general tips you'd like to offer regarding creating efficient macros?

Yes:

Don't.

Macros are inflexible, inefficient, hard to write, hard to document,
don't allow errors to be trapped, and are hard to maintain.

VBA code is better on every single count.

Abandon macros and go to VBA code. For anything beyond the simplest of
tasks, it's *easier* to write and to understand.

John W. Vinson [MVP]

Ok. I'm taking an Access class in March. If I still have trouble after
that, I'll be back. It's silly for me to continue posting, when you are all
speaking Greek.

We have so many organizational issues with tracking our bids and jobs and
assigning numbers to them all and tracking success by estimator and
more.....it's silly to not have SOMEONE here who can use Access.

Thanks for trying, but it was all just too new for me. They're flipping for
the class, so I may as well take it!

"Betty" wrote:

WOW. I see what you've posted, but what I'm hearing is "...be afraid. Be
very afraid."

And it all translates into: maybe you're in over your head here, girl.

If I can't figure out a feasible solution within a couple days, I'm going to
have to look into maybe a free template to just rename tables etc.

As much as I need to learn this office tool, I'm in need of something quickly.



"John W. Vinson" wrote:

On Fri, 23 Feb 2007 09:42:10 -0800, Betty
wrote:

Any general tips you'd like to offer regarding creating efficient macros?

Yes:

Don't.

Macros are inflexible, inefficient, hard to write, hard to document,
don't allow errors to be trapped, and are hard to maintain.

VBA code is better on every single count.

Abandon macros and go to VBA code. For anything beyond the simplest of
tasks, it's *easier* to write and to understand.

John W. Vinson [MVP]

Betty wrote:
Ok. I'm taking an Access class in March. If I still have trouble after
that, I'll be back. It's silly for me to continue posting, when you are all
speaking Greek.

We have so many organizational issues with tracking our bids and jobs and
assigning numbers to them all and tracking success by estimator and
more.....it's silly to not have SOMEONE here who can use Access.

Thanks for trying, but it was all just too new for me. They're flipping for
the class, so I may as well take it!

"Betty" wrote:

WOW. I see what you've posted, but what I'm hearing is "...be afraid. Be
very afraid."

And it all translates into: maybe you're in over your head here, girl.

If I can't figure out a feasible solution within a couple days, I'm going to
have to look into maybe a free template to just rename tables etc.

As much as I need to learn this office tool, I'm in need of something quickly.



"John W. Vinson" wrote:

On Fri, 23 Feb 2007 09:42:10 -0800, Betty
wrote:

Any general tips you'd like to offer regarding creating efficient macros?
Yes:

Don't.

Macros are inflexible, inefficient, hard to write, hard to document,
don't allow errors to be trapped, and are hard to maintain.

VBA code is better on every single count.

Abandon macros and go to VBA code. For anything beyond the simplest of
tasks, it's *easier* to write and to understand.

John W. Vinson [MVP]


It may be that someone who knows Access well could do what you need in
a very short time. Check locally but I know that some people here do
contract work also. They're not allowed to advertise it here but many
have a valid e-mail and can be contacted directly. I've never used
anyone from the group but there are a few here that I wouldn't hesitate
to work with if the need were to arise. Those few are pretty obvious if
you just spend a little time reading through some posts.

Sometimes it just cheaper to pay somebody.

gls858

On Fri, 23 Feb 2007 09:42:10 -0800, Betty
wrote:

I'm finding that my functionality suffers in great part due to the macros
that were entered from the locked bid log I began with. I copied those
macros without really knowing what they were for, so now I'm digging in there.

Any general tips you'd like to offer regarding creating efficient macros?

Well, as I say - I'd not really recommend macros in the first place.
But unless we have some idea what the macros are intended to
accomplish, what they're doing (or not doing), and what specific
errors you're getting it's awfully hard to say what might need to be
done!

As gls858 says, there are several folks here who do contract work (I
do, but I'm pretty much booked up at present). If you wish you can
post a *INTENTIONALLY INVALID* but fixable email address, e.g.

Somebody at Some Domain dot com

for in order to prevent spammers from
harvesting your address. Many of the regulars here have such addresses
in their .sig or reply-to addresses if you want to contact someone.

John W. Vinson [MVP]

The company/developer of this original database has obviously taken trouble
to protect it! Am I the only one here who sees this whole thing as an attempt
to try to duplicate another company's intellectual property, without their
permission?

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/200702/1