Search results

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.

Thanks, can't upload the db as I'm developing my own application to which there is limited supply. Seems like taking a bazooka to swat a fly atm, though search results only have relations to bad data types being passed as arguments; which we know that is clearly not the issue here at all.

Creating the most basic new blank form & putting a button with an event just to display a msgbox results in the error in title; nothing wrong with call-name or passing any arguments data types... It is much more sinister than that Code which worked fine is no longer working VBA Editor no longer...