Please Help! :(

[zol3x]

hello everyone. I'm having headaches, trying to solve this problem of my application so I really appreciate your help.
I have windows 7 64bit and ruining it on my HP laptop. I've designed and made an application in access 2010 32bit with some forms, queries, reports, some VBA codes, and packaged it with Microsoft access developer. everything works fine on my computer, but when I install it on other computers (access run time installs during the process of installing my application), access run-time crashes and I have this error message
"the application can't continue and will be shut down"
after I changed the default form from login page to switchboard, at first I get these messages...
"Your (application) database or project contains a missing or broken reference to the file 'QTOControl.dll' version 1.0."

and
"Your (application) database or project contains a missing or broken reference to the file 'mscomct2.ocx' version 2.0."

and
"Your (application) database or project contains a missing or broken reference to the file 'HPDeviceDetection2.dll' version 1.0."

and then crashes with the first error mesage.

please help me. I've put my life through this application and I really don't wanna loose it!
BTW it doesn't have any network or share point.

 

[Trevor G]

You have to look at the VBA references to see what is missing and adjust it to what is available or change the coding to use Objects.

So in the VBA Screen (Use Alt + F11) then go to the Tools Menu and References you will find you have MISSING and what is missing, if you deselect them then save and close then reopen that might resolve your issues.

 

[smig]

please read this:
Tips on Posting Questions & Searching for Answers

 

[zol3x]

Thanks Trevor. I used Alt+F11 in VBA but nothing happend. I've put date() function in my vb and am not sure if there should be a specific reference for that. what should I do?

 

[Trevor G]

When you used Alt + F11 did you go to the Tools Menu and look at the References

Date() in VBA is just Date no brackets.

 

[zol3x]

yes sorry, date without brackets, yes I checked and there were some references ticked. should it notify me what to check or what not to? BTW I've changed the database name(it was Database4 and I've changed it to Spring Management Suite) and copied it somewhere else then I developed the second database. and in the references it shows the references with the name of "Database4"

 

[Trevor G]

Within your first thread you state it gives you a message stating things are missing so in the VBA screen under the Tools menu and References it would tell you what was missing there is your clue, either remove the ticks from what is missing and search down for the version if available for the software or remove and keep them removed.

 

[smig]

You can put date with brackets or not VBA will remove them
Not sure why but now() do require the brackets

 

[zol3x]

Thanks smig, it was as Trevor said. it is fixed by removing some references and now everything works well. thank you so much for the big help Trevor

 

[Trevor G]

Your welcome and thank you for letting us know you have this resolved.