Search results

im using access 2010

the three fields that dont have a control source are working fine, however the supplierID field has a control source, it isnt working as intended, if i take the control source off it still doesnt work ive tried doing this many times, many people have told me however the same error message...

Basicaly ive been working on my database for quite sometime and ive had a problem with the whole form/subform relationship, i have tried my best to get it to work, but if i try fix one thing another two errors creep up from behind, it is really really annoying and ive fried my brain googling...

or did you mean the whole Forms!frmSupplier![sfrmPerson].Form.MasterUpdated business

really?? so i delete all the vba code within my frmSupplier?

http://images.access-programmers.co.uk/forums/images/smilies/banginghead.gif http://images.access-programmers.co.uk/forums/images/smilies/banginghead.gif thank you very much for that database example you took time out to create for me, I have three questions.. 1. how come there is like one line...

im not 100% sure as i lifted the code, lol and i dont want to make any assumptions as to what it may be in fear of making myself look more stupid than i already am :(. maybe something that links the two forms together?

here is the stripped version of my database, its the suppliers form and suppliers vba code that i am currently having trouble with, but if you could make any other amendments that would be splendid, can you point out the bits that i have missed or made the mistake on because i have been playing...

which smells like

yup i step through my code and i press the compiledatabase9, i also start by placing a breakpoint on the open form sub and i run down through the code, if its possible i can send you my database through email or something, dont want to put it here and you could explain my mistakes or just merely...

im not really sure about this, ive tried using 'link master fields' and 'link child fields' keep getting an error saying 'can build a link between unbound forms' secondly, what would my 'foreign key field' in the main form be and how do i get to it, lol i know this might be the stupidest...

ive got a form that i am building atm, i may have also posted this elsewhere, however if you see the screenshot i have took.. the main form is working fine, its the subform that is being a pain i cant get it to connect with the main form, it should be fetching the data from another table for...

Ive been having this problem for a few hours now, i cant seem to figure out what the problem or where the problem is for that matter. after the error comes up the form automatically opens up and access takes me out of the VBA section, its really frustrating and i would really apreciate it if...

Hi, thank you very much again, i completely scrapped this idea and thought of a different approach to it which is below in doc file(im the type of person to test new waters). How it works is that when i switch records i.e. click first record, last record etc the main form will show what it has...

thank you so so much for everything and i deeply thank you from the bottom of my heart for the long replies and the time you are taking out for somebody you dont even know :), ive been going through everything you said and have been amending my table the past 45mins, ive come to a slight...

here is the database im working on

have you got an email address i can post it to? because it exceeds the limit? thaaaanks

is it possible that i send you the whole database and i run ou through what i want, you dont necessarily need to do it for me, that way you know what i need, what im missing, and you as the expert can point out my mistakes? :)

Attached: screenshots of customer, supplier, employee and persons table. its not many fields just a few

thanks very much for your time and effort with this long reply, just to let you know lol i read your paragraph about 5-6 times trying to understand what you meant because of your jargon, i think i get what you are saying my relationships with foreign key and primary key are all set and robust...