Re: Setting up an automatic but customized ID

CodeGunnerLev1 wrote:
wow... I need time to digest that.. I guess.

I sort of get it first go, but I need to read it again. What I meant
by distributed database is more like the application is located in
multiple locations but all share the same data.

Do they run separately (iow on a PC not connected to the network or not on a wan or whatever)? You might have to think about replication then but I really don't know what your current situation is yet.

Replication would be for something like going out into the field and collecting data on a laptop and then updating the database with changed data when you get back to the office. (Look at the mvps.org link and click on the search button for Replication of that is needed.)

So do you need replication or am I not understanding how the data will be updated or shared...since they share the same data...whatever same data is.

The ID numbers act as an identifier is like a membership number. It
doesn't necessarily need to have s or alpha's. It can be all numbers
only. I was thinking of using a code to generate the number in a form.
Would that work? And what sort of language do I need to know to make
that? :P VB or Macro?

Yes, that would work. Macro would be worthless. You need to understand VBA. Fortunately for you, there's not many commands you'd need to learn. Left, Right, Mid, Trim, String functions are a few.


Thank you for your reply.

.

Loading