Recent content by Jura

Also plz delete these treads: http://www.access-programmers.co.uk/forums/showthread.php?t=102222 http://www.access-programmers.co.uk/forums/showthread.php?t=102224 http://www.access-programmers.co.uk/forums/showthread.php?t=102225 http://www.access-programmers.co.uk/forums/showthread.php?t=102227

For table design: Table 1: Family UniqueID | FamilyName 1 | Simpson 2 | Duck 3 | .... Table 2: FamilyMembers UniqueID / FamilyRef / FamilyMember / Donation 1 | 1 | Bart | €1 2 | 1 | Homer | €1 3 | 1 | Marge | €1 4 | 2 | Donald | €1 5 | 2 | Huey | €1 6 | 2 | Dewey | €1 7 | 2 | Louie | €1...

That is the way continuous forms work. In continuous forms the controls (fields) on each row are multiple instances of the same control. Changing the visability (or any other setting) of a contol will change this setting for each instance of this control. Basicly you can not do this the way you...

Hi ejhatch, You can use the command dlookup to search in tables. Dim varX As Variant varX = DLookup("[Text]", "YourTableName", "[Name] = 'default file path' ") Becare full with using colom names like "Name" and "Text"

Hi Jeo, Add this to your routine which opens form2 DoCmd.Close That should do it.

Madrav72, Thx for your reply. What you say sounds about right. Can you give me any more detail on your solution. What kind of FE for network users (MDB / ADP) What kind of BE (MSSQL ??) What kind of local installation (for laptoppers) ? MDB? I'll have to dive into synchronising db's, any tips...

Hi all, I'm planning a new db. It's a kinda straight forward contacts/appointments management system for a small company (10 users) I've got a MSSQL server running there. Now here is the crux in my project. I want to have the users use the same data for obvious reasons, but i also want them...