vba function cannot be found

[shutzy]

i have a major problem with my database. the database is live and i need help quick(if someone can)

the problem is easier to explain if you view it.

i have added the database. unfortunately it is in 2010 so my help will be limited.

on open if you type in s4ut21 into the password screen. frmClientMainScreen opens. then if you click on diary btn. when this has opened if you right click on an appointment(grey, green or blue) you are met with an error.

i didnt build this part so i am completely lost with what to do. i have contacted the designer and he is busy and cannot deal with it for 2 weeks.

the urgency is that clients are phoning up all the time and moving appointments and without it working correctly i do not have this function.

if anyone can help then please do.

thanks

 

[Mihail]

Save the database in a previous version of Access then upload again.

 

[shutzy]

sorry i was rushing and didnt want it to transfer over to mdb and it not work correctly. ive checked it and i still get the same result in mdb.

thanks

 

[Mihail]

Can you contact me via Yahoo Messenger ?
alt.mihai@yahoo.com

 

[shutzy]

why would i do that.

 

[Mihail]

First because you know your database so you can save me a lot of time until I understand it.
Any way.... try this password first:
chrysalis08

 

[Mihail]

And second, because is not an interesting thread from where can learn others.
And 3rd, because is YOU who ask for help.

but... forget that.
Good luck !

 

[jdraw]

I tried the chrysalis08 password suggested by Mihail, and the right click works to move appointments.
Seems the issue may be related to which password is being used.

Good work Mihail.

Good luck

 

[pr2-eugin]

Shutzy, what is the error message you are getting? I am not on my computer so I cannot look at the DB, but if you could explain at what scenario this happened I might be able to offer some help..

 

[shutzy]

sorry. who do i make a compliant to about attitudes. i have been on here for almost 2 years and that idiot is going to see the wrong side of me. how the hell does he know that others wont find it interesting. he has 75 posts. unless he has been by another name on here i would suggest he let other users decide if it not interesting to them.


get over yourself and dont respond to posts you have no intension of helping without payment!!!

 

[shutzy]

sorry about lads.

paul, the message i am getting is

Mouse Down Failed: invalid proceedure call or argument. (vbOK)
then on click of ok
cannot find the object 'cmdAppointmentRightClick'
if 'cmdAppointmentRightClick' is a new macro bla bla bla.....

the suggestion of typing the coded password works. any reason why this would be the case?

could it be with the sql for text box on frmClientMainScreen?

thanks

 

[jdraw]

So the password identified by Mihail works --so you're not dead in the water with your business system --is that correct?

Within the code it's possible that something is being set/valued when using that password and not being set when using a different password.

My first guess and it's only a guess because --
a) I haven't dealt with Application.CommandButtons
b) there aren't a lot of comments in the vba code
is that for some reason 'cmdAppointmentRightClick' does not appear to have been created. The system is telling you it can't find it (it doesn't exist). I can see code that Deletes that 'cmdAppointmentRightClick', but I don't see one, nor am I familiar with the code, that creates the command button.

There are lots of conditions and paths through the vba, it is quite possible that something is not invoking some code.

could it be with the sql for text box on frmClientMainScreen?

Sure, it could be a number of things, and none of us is familiar with the application or the code or the design methods used.

Did someone actually ask you to pay for help? Most of us here would NOT do that.
Its easier to debug code/issues/situation when you have access to someone who knows the business; who knows the background; who has been involved in design and testing and acceptance. To me it shows an interest in helping/collaboration -- not an attempt to only work for pay.

Most of us here are quite satisfied to help some poor soul whose business is at a stand still because of some database design/coding/testing issue or oversight-- for no compensation.

Good luck with your project.

 

[shutzy]

hi jd. i really do appreciate what users do for me on here. after all, 2 years ago i did not know a thing about access never mind vba. you have helped me aswell as paul. i made the comment about the other user as i was quite annoyed. why would he want me to go outside of the forum. the thread does not take up any room of his. i was astounded that someone would ask to go outside the forum unless it was to break forum rules.

after everything i have learnt through this forum i try and give as much back as my time allows. i suppose thats the way it is meant to be.

so a thank you to Mihail for the suggestion of Chrysalis08 but you should never ask users to go outside of forums for such a sinical reason.

Did someone actually ask you to pay for help? Most of us here would NOT do that.
Its easier to debug code/issues/situation when you have access to someone who knows the business; who knows the background; who has been involved in design and testing and acceptance. To me it shows an interest in helping/collaboration -- not an attempt to only work for pay.

i referenced before that you have helped me and you have helped me greatly in the past. but at no point did you ask me to email you personally. even when the thread reached 20 posts just between me and you. i may be wrong but i would rather be wrong on an occasion like this than someone to pressurise me into paying money out. i was desperate and he may/ may not have hung on to that.

i would love to share your optomism but quite frankly, the world is not, never has and nor will be like that.

thanks for your help guys.

 

[jdraw]

Shutzy,
With all respect, I think you jumped before recognizing/realizing what Mihail was offering. I have watched his posts and find his responses well written, clear and to the point. In my view Mihail saw someone in need, basically pleading for help -immediately if not sooner- because business appointments could not be processed. I believe he wanted to offer the best technical assistance he could - and that would be having Access to you and your knowledge of your business and your application. He was offering honest help, you had the immediate need, and yet you appeared to be challenging him for offering assistance.

I don't believe he ever mentioned money - and based on his posts and the info he has given - I don't think he would ask for compensation. Like most of us, a simple thank you is all that is required, if we have been helpful.

I really think he saw this as critical to business and was trying to reduce the "resolution time" by taking the issue -semi-offline -he could work with you on email, and still report/post back here as/when needed.

Sorry you don't share the optimism, but that's how I see Mihail's offer to help.

What did you have to lose? A bit of time? You have the database. All he has is a copy of a database that he knows very little about. From his own words, the issue involved does not seem to be one where there is a great learning experience --resolving an error. It isn't like developing a method to make Access database available on internet with some "magic code" or implementing a novel solution on new hardware/software.

Not everyone is in this for the money. If they were they wouldn't be spending their time on the forum. Most here find it relaxing and satisfying to help others.

Just my view of things.

 

[nanscombe]

If it helps in speeding up the diagnostic process for your designer, so he can fit it in earlier, the problem that I see is in the Form_Load event of frmClientMainScreen. I wouldn't necessarily try fixing it yourself unless you, and your designer, were happy to do so.

It looks like it could be a matter of copying one line of code.

With the s4**** password it is exiting the code before creating the appointment menu (commandbar).

With the Chy**** password it is bypassing some code and creating the menu (commandbar).


It does looks like you were actually being offered some live assistance via Yahoo messenger, rather than by e-mail, earlier.