Search results

Hi Doc Man The reasons I made the relations"1 to 1" between the primary table "Member" and the secondary "Addresses" table were that: 1. I failed to make to an intermediate linking file work, ie to break the 1 to 1 relation ship . 2. The number of records in the life of the database was small...

Hi Catalina What you suggest must be happening. In the past I just typed data into my multi page form, saved and all was well. Now I get these warnings and " #Error " shown in each address control in the child table "Addresses". From what you say the a new record is not being created when I...

My form inserts data directly into Tables directly Rural Guy , as far as I know. That has worked fine until now. I use queries to extract data for reports. Les

Many thanks for your kind reply RuralGuy. I do not know how to show you the underlying code. Perhaps you could give a steer. I forgot to tell that this is Access 2010 and that the addresses, held in an Addresses table, of all existing members can be read. The problem only occurs when I try to...

Hi all My membership database has worked fine until recently. Now I cannot save inserted data. On attempted saving "Update or CancelUpdate without AddNew or Edit" appears. The problem. relates to 2 tables Member and Addresses. PK in the parent table Member is ID. In the Addresses Table...

This issue can be closed I found the problem. In Form Properies I had inadvertantly, somehow, switched "Data Entry" from no to yes. Restoring "no" and saving brought data back on screen. Phew. Many thanks Jeanette and Banana.;)

Many thanks for your help Jeanette and Banana. I will study the help at both links. I have the idea now that each form control has lost its respective record source as result of my actions. All the table level data and relationsships are fine. All the best Les

Somehow my quite complex multipage form cannot show data from the underlying multiple table data. This database was working fine until I saved a form with new data. The table data remains fine. Do I have have to go to each form object and reconnect with its respective table or can I reset...

Here is the problem File VBA with some data. I still have to do some normalisation and form design. Many thanks for your kindness in offering to help me out of the chasm. Les

On my way to a meeting now VBA. Will upload database file, as is, later this evening. All the best Les

Uncertain about that VBA. I created a blank form then added a 5 Tabs form straightaway. Then added field controls. I would not of considered this a subform; but may be wrong. Thanks for your interest and reply. Les BTW I created an auto form that worked correctly before striking out on my...

Hi All I have created a tabbed main form in Access 2007. Fifty records are already in Datasheet view but only the First record can be read in the Form. I have no filters set. The record selector shows 1 of 1 with a data fully visable correct first record. If scrolled right records 2 of 2...

You are are right on the nail with that advice Doc Man and I really appreciate that steer. I had thought about simpler approaches but I wanted to climb the overhang with the big boys to see if I could do it. I did seek a universal solution to push my boundaries. I think I will go back to one...

I'm a trial and error man Kryst. Ripped it up a will start again works sometimes. Can usually spot the obvious but not in this case;yet. Again many thanks for your Help. By the way my great grandfather made it to Fort Griffin TX near Albany just after the Civil War. He fought on the Union side...

Sorry for the delay Kryst. I have deleted the whole Form. Will write a new Form tomorrow then I'll tab through as you suggest. Do you consider the underlying tables and relationships are sound? If so, then I can eliminate that. All the best Les

Many thanks for your very quick reply Kryst. When I put in dummy address, say an address with "Home" selected thats OK fine. But when I select Work or Next of kin the Home address remains. I want the address field to clear so that I can input a new address. I am travelling without lights on...

Hi all. A newbie here. I have been working on a membership database in Access 2007 for our gliding club and am seeking to avoid repeating addresss. I cannot get this to work either in tables or in Forms. This is what I have done so far: 4 tables: Member ID field autonumber Primary Key-...