Recent content by MacChris

Hi I hope it will answer your Question. regards Chris 'Datebase Connection to a MS Access mdb file ' with the current Username on my current Application path Public Sub InitAppDB() g_strAppDB = App.Path & "\" & GetCurrentUserName & ".mdb" If Dir(g_strAppDB) = "" Then If...

Hi plesa check in the Access DB the Query for defined Parameter like TheParam1 type Text an on the SQL criteria the [TheParam1] and not "TheParam1" Chris

MS Asscess DB with 3 Tables tbl_Customer: with ID, CustomerNr, Name, Surname, Street, Country tbl_Video: with ID, VideoNr, VideoTitle, VideoAuthor, VideoYear tbl_lend: with ID, CustomerNr, VideoNr tbl_Customer:NameID = tbl_lend:CustomerNr tbl_Video:VideoID = tbl_lend:VideoNr qry_Overview: SELECT...

Dear all Now I know why this App-def Obj-def error i got. Wrong path in the Application! First solution is include the mdb File into the Package & Deployment Wizard thanks Sheco for help. Secound I found that my Software is looking in the WinPath like C:\Windows\System32 and there is something...

Hi It's maybe a dummy question but i need help to have something like a subform in my Data Report Form. Situation: I've got a DB with a Table Name and a Table with Video The Table Name contents - NameID -Surname -Name -Street The Table Video contents - VideoID -Title -Author Now I like to have...

Yes, it's appear when die Data Source can not be located. It's define manually the Path and Username ... the new ConnectionString. Or thake the Source above and it will not longer appears. Chris

Private Sub Form_Initialize() DataEnvironment.Connection.Close DataEnvironment.Connection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & " /Datenbank.mdb;Persist Security Info=False" DataEnvironment.Connection.Open End Sub Thanks Sheco for your Help

Dear Sheco One small step for man one giant step for mankind Like it was just a small thing for you and somthing unknowing staff for me. It's working but i have to enter in this ' Geben Sie bitte MS JET OLE-DB-Initialisierungsinformationen ein. ' Windows the Datasource Username Password ...

no let me do that, thx Sheco Chris

yes i'm using Package & Deployment Wizard and it's still not working like i used it from begin. The installation will be done with the created Setup.exe and .cab file. and even wenn i create this directories and copy all files into its not working. Chris

It's a good thing do check it. thx because i'm not so fam. with this Package & ... so i us allways the standard wizard to Package the SW and standard Installation on other PC's. this will take a few time (PC are at home and i be on working yet) Thanks at this time regards Christian

Thanks for this quick replay. No the 'other' PC's are a standard Windows XP PC. for test hier the full source: http://mypage.bluewin.ch/LehnerChris/Downloads/DataReport.mdb http://mypage.bluewin.ch/LehnerChris/Downloads/DataReportView.vbp...

Hi I'm using VB 6 and MS Access 2000 I like to have a Data Report to display and print data. so far so good it working fine aslong i'm running the .exe file on my dev. Maschine. on all other PC's it say allways this App / Obj Error and Invalid Data Source for this DataReport Object Source are...