Getting a GUID from a subform

[don97322]

Hello all,

I always try to find a solution before posting a new question, but... Your search - "guid" from Subform - did not match any documents.

So, I am trying to synchronize two subforms based on the guid in the first (continuous) subform and using that to select a record in the second subform. I am trying to use the technique of setting a textbox control source in the parent form (containing the two subforms) to the value of the first subform "={guid{MIX.Form!MIX_ELE_ID}}", but I get the following error: "The Replication ID you entered is invalid". I've tried it without the {guid{ }} and I just get garbage.

Thanks for the help,
- Don

 

[maxhugen]

Are the two subforms linked to the main form, or are you only trying to sync the 2 subforms together, with the main form nothing more than a 'container' for the subforms?

Max Hugen
Australia

 

[TheAceMan1]

How are ya don97322 . . .

Why are you using [blue]GUID[/blue] when there are much less troublesome schema available?

For all my experience I could never see the need for such an item . . . except to impress!

Example . . . how much difference would it make to [blue]index[/blue] a [blue]GUID[/blue] field?

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[maxhugen]

Maybe the db is replicated?

Max Hugen
Australia

 

[don97322]

Hi. Thanks for the feedback. I'm using the QUID becuase I wanted to use any Oracle type identifier, and when I did a search, I found the GUID. No more complicated than that.

I'm not sure who I would impress by using it.

The two subforms are not linked to the main form, but one of them could be I suppose. Each subform is a continuous form. Selecting a record from the first subform filters the selections available on the second subform.

In the future, and copies of the database will be loaded on individual machines and some method (that I have yet to create) will be used to sychronize them, so the GUID may help then (if that is what actually happens).

Thanks and have fun,
- Don

 

[maxhugen]

G'day Don

I'm not sure what you mean by an 'Oracle identifier'? And what does it have to do with an Access GUID?

AceMan's point is that using a GUID is a real pain in the a***! I know, having developed an Access replication system years ago. Aside from the GUID, if you do move in the future to Access replication, be forewarned that corruption while synchronising replicas happens easily and often!

I'd truly think long and hard about whether if you want a lot of grief (and users of course blaming you) and sleepless nights.

Apart from that GUID, what you're looking to do is not at all difficult...

One thing you could do, if you think you may have no option but replication down the track, is to use autonumber Primary Keys in the tables, but set them to Random, instead of Incremental.

HTH

Max Hugen
Australia

 

[TheAceMan1]

don97322 . . .

Good enough! Have a look here: faq702-5860

See Ya! . . . . . .

Be sure to see FAQ219-2884: