Search results

I have used priamry keys in my tables and these are set to auto numbers on the advise of fellow forumites. One question if at the end of every year I need to upload batches of data to my tables, this would mean I would need to go through each record and manually enter the foreign keys in the...

When you say with the control wizards enabled what do u mean, I am using the control wizard?

How should it be linked?

Can this be done I dont really need the scroll bar in one of my subforms, can I remove it and prevent users from using it?

Hi People, Another question, My database is looking good now, but I have one question, I dont want users to view it as I do, i.e with all the wizards etc, so how do I create an interface which does not allow the user to view the backend?

Thanks, add record works fine and so does delete record, BUT Undo records will not do anything, any ideas on this, I thought the purpose of this button was to remove data from the form if you decided to start again? Also with regards to save - How can you tell that it has saved? Is there...

How do I make the command buttons on my form actually do something, the only one that attempts to work is "DELETE RECORD" the others dont do anything at all

Thank you, it makes sence to me now. One question, Do I really need person_id in this data set, because it isnt used as a foreign key any where else, so why have it.

Hi Guys, thanks for all your help so far, I have created my database but I have a problem. My main form has details for the organisation and 2 sub forms for employment and person, Now if I have more than one person at an organistion I complete the main form as normal and then add more then...

Hi, I create a form using a wizard, then I go into my subforms and edit it to look more easy on the eye. I save the form and close it, when I re-open the form it looks fine except that the subform appears as a blank white space with Name Subform in top left corner of the sub form?? Whats going on

Thanks Rainman, this may be a wierd question but are you saying I can now start inputiing data and away I go?

Attached is my updated database, can someone help with the relationships.

Thanks guys, I have done as you asked, and included the auto number IDs. Now when trying to create the relationships between the tables I keep getting errors saying invalid definitions? Any Ideas?

Thats very clear, thank you guys. One question, in my old system when the user wanted to add an new contact they first entered the organisation, the system generated an organistaion ID. When the user then went to enter the person, he/she had to search for the organisation, note down the org_id...

so are you saing I need an auto number ID in both the organisation and people tables?

more than one can work at a certain place

but the user doesnt want additional fields. Is it ok to have a 1-many relationship when I dont want this type of rel. How do you edit the form to change things like the referential integrity can you edit using the wizard or do you have to do this manually. Also I am having to enter the url...

sory I was clicking the next button on the subform not the next button for the person details. Have a look at the relations ships it wont let me change them it automatically sets them to 1 to many but in my case 1 person has 1 employment why wont it let me change this. Also I am having to...

dont know, what do you think oof the attachement

I have created the forms and linked the tables Once I add one record through the form, it wont let me add any more records, why is this. I need to keep email and url as primary keys as the person leading this project doesnt want additional fields 'for fields sakes' When I click on the form it...