Does anybody Know anything about creating Deployment Disks?? 
Author Message
 Does anybody Know anything about creating Deployment Disks??

Does anybody Know anything about creating Deployment Disks??

Can anybody tell me what's wrong with this code?
When I install my program via Deployment Disks created
with the StartUp Wizard on my PC, to a PC without VB installed,
I get an error message stating that my database can not
be found.  The path displayed with this error is the path
where the program was designed on my PC, not the target PC.

I've tried everything I can think of, but can't get this to
work.  I'd appreciate some help on understanding what I'm
doing wrong.

This is in my Module1.bas
-------------------------
Option Explicit

Global dbName As String
Global rsName As String
Global db As Database
Global mrstSW113 As Recordset

Sub main()

     Open_Database
     gblnSound = False
     frmMainMenu.Show

End Sub

Public Sub Open_Database()

     dbName = App.Path & "\dbSouthWing113.mdb"
     Set db = OpenDatabase(dbName)
     rsName = "tblMstr"
     Set mrstSW113 = db.OpenRecordset(rsName, dbOpenTable)

     gblnSound = False

End Sub

This is in my frmMainMenu.frm
-----------------------------

Private Sub Form_Load()

    ' ' Notes: Path was set in the Sub Main of Module1.bas.
    Data1.DatabaseName = dbName
    Data1.RecordSource = rsName

    Data1.Refresh

    ' ' Note: Select the starting order of records
    Data1.RecordSource = "Select * from tblMstr ORDER BY ID"

End Sub

This is in my frmAppend.frm
---------------------------
Private Sub Form_Load()

     ' ' Notes: Path was set in the Sub Main of Module1.bas.
    Data1.DatabaseName = dbName
    Data1.RecordSource = rsName

    Data1.Refresh

    Clear_WS
    Disable_Buttons
    Command1(0).Enabled = True
    Command1(3).Enabled = True

End Sub

The error is displayed when I select the following
from the frmMainMenu.frm.

Select Case index
           Case 0
              Me.Hide
              frmAppend.Show

                        Thanks for your help,

                                   Magic



Sat, 29 Sep 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Does anybody know anything about creating Deployment Disks??

2. Does anybody know anything about creating Deployment Disks??

3. Does anybody Know anything about creating Deployment Disks??

4. Doe's anybody knows how to...

5. Does anybody know how to create ADD-INS?

6. Does anybody know how to create ADD-INS?

7. Does anybody know how to create an Audit Trail in Access

8. Assistant not doing anything because system is busy?

9. anything special that needs to be done for Terminal Server

10. Has anyone done anything adventurous in VB.Net??

11. ShellExecute - can anything be done with task ID?

12. CGI Help...Anyone Know Anything?

 

 
Powered by phpBB® Forum Software