Tab Navigation Form

[wes9659]

Can someone explain to me how to connect my main project tables together so they work when using a navigation form? I originally had them set up in a flat table and it worked great. However, I am trying to put it into more standard naming convention and split tables so I have more room to expand later. Original flat table form had close to limit of fields. I created two forms to practice and a tabbed navigation form. My questions is how do I get all the tabbed forms associated within of the navigation form to use the same record for all the tabs in the forms? I have attached a copy of data base for all to look at. Is my structure in relationship correct? I would love it if someone could make changes I tend to have a better learning curve if I can visualize what has occurred on form. Thanks everyone I have learned so much here.

[Z1nkstar]

DLDB.zip
Here use my Database as a reference to see if you can find your problem.

[June7]

I've never used Navigation form, don't like it.

Your data structure is still not normalized - tblFamilyHistory has multiple similar name fields that are for the same data (Name1, Name2, Name3, ... Name21). This could cause issues for searching and filtering. Normalized would be a record for each relative (1-to-many relationship with tblClientData).

tblPrimaryContact and tblSecondaryContact could be one table with another field for designating priority (another 1-to-many relationship).

In tblClientData, field name for MaritalStatus is misspelled.

[wes9659]

I tried to download the database from Zinkstar to review project and it started adding files etc and searching my files. Not sure if something was wrong with it deleted it from system. I do appreciate those that have offered help.

[June7]

Because Z1nkstar has been a regular contributor to forum, I took a chance and downloaded and opened the db. No problems encountered.

[wes9659]

By no means was I implying his data was bad. I think after looking at it it is because I am using 64bit. I don't understand what triggered my malewarebytes

[June7]

I just ran Debug Compile and get errors 'Method or data member not found.' Very odd.

[wes9659]

Iam glad I am not crazy lol thought it was my system I think it may be just 64 bit issue

[ItsMe]

If the install of Access is 64bit then you will need to employ ptrsafe.

So something like
Declare PtrSafe Function.....

You can use an If Else statement to test for Access 64bit.

If VBA7 then
Declare PtrSafe Function.....
else
Declare Function.....
End if


http://msdn.microsoft.com/en-us/libr...ffice.14).aspx

[June7]

I don't use API just to get username. I use VBA Environ function. Then the version is irrelevant.

strUserName = Environ("USERNAME")