Search results

I have a MEMBERSHIP MASTER form which carries membership data, and this form has a subform called MEMBERSHIP SUBS which shows all the annual subscriptions the member has had over the years this is the linking : Parent Form MEMBERSHIP MASTER MemberNo...

Because I want to see if it can be done with code alone.

Hello folks I'm trying to populate a list which is an Access form that is Default View: Continuous forms. How do you get to bind to a continuous form's fields with VBA and DAO? I guessed that the form object was an array Here is my code: Private Sub PopulateForm() Dim njpn As DAO.Database...

That is useful information. I have been using lookup fields in my tables, i will now stop and just use them in my forms.

No problem. You did not break any rules, it was just a suggestion, but welcome anyway, I'm quite new here myself, but its a great forum, with lots of really experienced people, and you usually get an answer to your problem quickly. After i posted i realised you had only be here for two posts...

Maybe it slows down the indexing.

Thank you Gina for your help to both of us.

I think you will get the help you need in your question if you create a separate thread rather than post here as your question in not the same as mine. And I will not get the help i need as helpers will be diverted from my question as the helper GinaWhipp has been. Thanks.

Thanks, i'll work on that

My table key looks like this. Its a table that keeps a master record of conferences that occur during a calendar year ConfYear (Date/Time) primary key ConfNo (Byte) primary key As you see its a composite key. Now each time a new record is created i want the ConfNo to...

Sorry i don't know, i havent used it that much

I've had this , it drove me nuts. I think its a glitch. What worked in the end was: after deleting the relationships, which you've done, renaming the table with say an 'x' before its name for backup purposes, then copying and pasting it as a copy and giving it the original name.

this seems to work: http://www.microsoft.com/en-gb/download/details.aspx?id=42656

As a general answer i suggest you google "normalization" and read up. That should point you in the right direction.

Hello Uncle G, Thanks for your reply. Answers: 1. I put in an average of 9 hours per week. 2. Yes, definitely. Wouldn't have it otherwise. 3. Difficult to say, I took it on as an ongoing, but an end time could possibly be negotiated. 4. Yes, a fair bit. 5. Yes and no.. . There is an old system...

A Christian Charity based in UK needs a volunteer Access specialist of intermediate to advanced level, with good Access, VBA and database design and data migration skills. This is to take over the volunteer job i have been doing for the past six months. No pay but a huge opportunity to develop...

Thanks - i didn't see the Linked Table Manager before. That did the trick nice dog btw

Been developing this admin system for a charity. I've got the forms and queries in one .accdb file and my tables in a separate .accdb file. The forms file links to the tables in the tables file. The tables file resides in a folder called simply enough C:\acc_tables and thats where i browsed to...

Good point. I might build in another m to m relationship with a junction table to handle this situation.. m to m relationships are just such hard work, in this case in particular cos the table has a composite key... its not my design i'm rebuilding someone elses totally dodgy database with crazy...

I got this function which is supposed to find a record based on the primary key, and then give three fields a value if they should be empty. --------------------- Public Function DoesXrefExist(faPersonID As Long, faRoleCode As String, faDorpID As Long, faDorpCode As String) If...