Search results

Thanks, was not intended as a critique, it was a post on a forum to try to fully grasp something. Yes it was a great solution & I am grateful; I have been studying it since you posted it trying to grasp what's going on. Modal - Only if the form is unopen it wall cause cessation of executed...

Thanks @MajP, not really what I spec'd in the uncryptic 1st post :ROFLMAO:. Don't worry about any more examples; I'm trying to learn all the ways to obtain a value. I was Moreso trying to implement your previous example (attached) but simplified. Not wanting to offend - I think you may be...

Thanks @MajP, too complicated for me to grasp that demo & our previous topic I don't want to have to filter selections from the source each time. I'll have the SourceFrm open each time at the area I want. I select the item I want from the Sourcefrm & it puts it to the NewHomefrm. A variable...

Off a previous topic which I thought I understood but don't - how can I grab a record from the sourcefrm & put it in the newHomefrm? I want to use a buffer variable & feed the ID to the newHomefrm without opening the form & using openingArguments. The sourcefrm will already be open. I want to...

Obviously, just expressing gratitude for other help from CJ. Lost count the amount of times I've thanked @MajP

CJ_London's helped me alot in the past too & on other site, I'm most grateful.

Thank you very much, learnt an awful lot from you here.

Thankyou, grasp it all I think now; but still not the below. I understand you are error handling. I would understand if your below said OpenArgs = "", I don't understand how the OpenArgs concatenates a blank returned string, a not operator and another blank string. I am stumped as to why there...

Thanks, I have learnt so much here. Pop-up forms is originally what I wanted. What are the benefits of not binding the subforms? I was not even aware of the datasheet form type. 1 - frmResourceSelector > Event Form_Load. (a) Is the below function itself not superfluous. We jump here...

Thanks MajP , trying to figure it out. Anyone have any tutorials on this? What's with the Nz & 0 in the opening argument. MSN does not have e.g's like this. Is Nz a local variable not requiring declaration, & lost for what the ,0 is for. Nz(Me.ReLibID_FK, 0) Would there not be a lot of error...

Thankyou all so much. I'm sorry I did not post all because I thought too much info deters people's interest & I think it's too big a topic for single post. Usually & people rarely understand me so I tried to simplify in OP. Looks like MajP has explained it for me which I'm going to read as soon...

New to db design & really struggling with it. Watched countless tutorials; implementing seems far harder. Been told to avoid composite keys in Access as it makes hard work, which seems to cause violations but I really don't understand normalization. ResTypesT - Labour/ Plant/ Material/...

Well you were completely right on a very badly explained problem so many thanks.

Thank you all for your help & input. On creating a fresh db & importing the objects on execution it then did what it should have in the old db & jumped to: Below in a certain form; which I don't think there is anything wrong with & was not Publicly scoped. There was another combobox with the...

Thanks was on, that's what I think has happened. Though the object has been renamed correctly in the Object Browser it is referring to an old outdated object name behind the scenes somewhere. I tried switching off, restarting, switching on again in the hope it would force a rebuild; which it did...

Managed to fix it an hour ago but trying to drill down so I can see exactly what the issue is. I previously fixed it with a naming conflict where the engine has failed to update a name, sharing an identical name with a different object type... or identically named events (despite being scoped to...

Something very, very wrong. In trying to compile it throws the same error; but does not bring me to where the issue is. In decompiling, then rebuidling in safe mode (important to hold down shift when opening), it says it needs to delete my entire VBA Project. Decompiling Links For Others -...

Thanks, strangely I restarted & in the problematic the References are available now. I thought it may have detached a vital .dll but you're right I have no issues in the References Library which I am able to access now strangely.

Don't worry about it mate. Concentrate on posting comments which have value. Josef references are greyed out. Pretty sure you're right. Obviously repairing the application would not benefit this in any way.

Thanks, sounds more like the solution. No it's not compiling at all, gives me titled error on first instance of trying to compile. Looking into decompiling now.