STOPS at prs_FormName = "frm_ydl"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There,

I've a quite strange problem in my small program which developed in Access
2002, now using in Switzerland (the Access version of users is Access 2000
built 9.0.2812).

There are two identical client computers using the program without any
problem until one user computer reinstalled. After the reinstallation the
program stops at the line 'prs_FormName = "frm_ydl"' of a public function
which I use it to switch between two main datasheet.

I asked them to compare the Access version, it's exactly the same.

What can be the possible reason? Would be appreciate if someone can give any
hint to crack this problem.

Thanks advanced for any feedback.

Public Function fub_MyShowForm(prs_FormName As String, _
Optional pri_View As Integer = acNormal, _
Optional pri_Mode As Integer =
acWindowNormal, _
Optional pri_DataMode As Integer =
acFormPropertySettings, _
Optional prv_OpenArgs As Variant =
vbNullString) As Boolean

' On Error GoTo LBL_ERROR_fub_CommonShowForm

Dim vls_Bar As String
Dim obj As CommandBarControl

If prs_FormName = "frm_ydl" Then <---- program stops here
CommandBars("OSSS ToolBar").Visible = False
CommandBars("YDL ToolBar").Visible = True
....
 
Open the Immediate Window (Ctrl-G), type

?AccessError(5)

and hit enter. You should get "Invalid procedure call or argument".
 
I'm not sure about this, but you may want to check your Library References.
If one computer got reinstalled, it is possible a library needed did not get
reinstalled or was installed in a different folder.

In your VB Editor, Tools->References
Then look for a reference that says "Missing". If this is the case, then
you will need to either reinstall it or if it is in a different location,
copy it to the location where it is expected.
If no checked references say "Missing", then compare the list of references
between the two computers to see if there are differences.
 
Hi Klatuu,

Thanks for your replys!
We compared the library reference in both computers and it's identical. Is
there any other possible reasons?
All the best
 
This is a puzzelment. What error are you getting? Are both computers on the
same OS version and service pack level?
 
Hi Klatuu,

Problem solved, the Swtizerland user visit China office with her laptop and
I remotely worked on her laptop. The problem solved by import everything into
a new database file. I also tested to just compress and repair and it works,
what a pity I missed this so simple method!!

Thanks for all your reply and help!

All the best
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Runtime error - #5 2
on exit macro 2
Remove Command Bar when excel file closes 1
Do Until ?? 8
Run time error 1004 - unable to get the chartObjects property of the worksheet class 1
Control Word Document/ Current Instance from within Access 9
Toolbar Reactivation 2
VBA - Disappearing custom menu and custom toolbar 2

Back
Top