Recent content by not_rich_yet

Hi, Yeah, I've done it in a very similar way! Not ideal but it works which is all that counts! Thanks for the help, nry

Dapple, in all of these posts, I don't think any of us know what you are actually trying to create! Any chance of you posting what you are trying to do, with a list of what tables(and their fields and field types) you currently have (and maybe any relationships you have between tables?)... I...

Stupid OutlookXP won't let me open the DB as it is 'potentially unsafe' ! I've posted elsewhere to see if I can force it to let me open it! nry

Hell yeah, why not! not_rich_yet@btinternet.com nry

Simply, Access won't let you create a Many-Many relationship, only a many to one or a one to one....you said that you have a many to many within Access but I don't know how: "Actually the tables are normalized. There is a **many-to-many relationship** between the three tables, but four isn't...

Open the form in design view. Right click on the the topmost right square of the form and choose the properties option: you may be able to get the form properties via a menu when the form is open in design view. One of the properties you can set is 'Shortcut Menu'. Set this to 'No' and users...

Hmm, to what normal form level are they normalised? Currently, every device you have in the system can appear possibly infinite times in the device table, as a seperate record of each device is required every time a device is loaned: this is not an ideal situation and I'd guess it may make...

Hmm, let me get this right: A participant goes to an event At an event, a participant may be given one or more devices. In which case, I'd hazard a guess that your DB isn't normalised correctly. I think you still have some many-many type relationships in there, and addition of one or more...

Hmm, no, according to Access VBA Help, Forms() can be used with the form index, form name or a string representing the form name.... ActiveForm won't work because I have hmm, around 12 forms open at once! nry

I think I originally misunderstood what you meant! I think the use of Forms("FormName") may be the neater way to do this, but for the life of me i can't work it out... I've just tried you're suggestion and had no hassles so for now guess which way I'm gonna use! Ta, nry

Not much help really, as it doesn't cover what I want to do: I open a subform via a button from one of many main forms. I then wish to have the subform update a value on the mainform, but this mainform is one of many so the subform needs to know which main form to update, hence cannot use the...

Hi all, I have a subform which can be opened via a button from numerous main forms. I need to access the main form from the subform to update a value on the main form based on what the user has done with the subform. I created a textbox on the subform, which gets it's text value set when the...

Presumably then, I can then use the value from the textbox to refer back to the form FormB was opened from? I can't suss the syntax to do this though, any ideas? nry

If that makes sense? Say I have numerous forms, all of which can open FormB. These numerous forms can all open FormB via a button click. I create a value on FormB which I would like added to a value on the form which FormB was opened from. Beyond creating a seperate FormB for each of the...

Try using the expression builder as this cannot get the names wrong...all those !!! and [][][] get me confused with nested nested stuff! nry