Recent content by DarrellW

You will need to dimension two tabledef variables, you can't get away with using the variable name on items such as forms, tables etc without defining the type first as follows: - Dim tdf_orig As TableDef Dim tdf_create as TableDef You can then assign a table name to temporary variable as...

You cannot open an access database in the same way as a desktop pc from the web. However, if you wish view, add,delete, and modify record you should look into Active Server Pages/Perl etc in order to do this

See the following article, this checks nearly everything, so you can remove the code you do not require. I would place the whole lot inside a module and then you can re-use it when ever you wish. http://www.devx.com/vb2themax/Tip/19403

Zalmey you can save images into DLL files and use these within your VB application. Try and use JPG or PNG files as these offer compression. Also bear in mind that the DLL will need to be shipped with your application. The DLL file can be created using the built in resource editor within VB6...

Ndaa in order to pass values from VB to Cyrstal you can use the .SelectionFormula in your code. For example: - RptPrint.SelectionFormula="{Trans_MatRecei.Comp_code} = " & Trim(Aft_extract_id(cmbCompany.Text)) & " AND {Trans_MatRecei.Doc_NO} = " & Trim(txtNumber.Text) I find it easier to...

Hello Evie, does your report contain any subreports ? I have had this problem too, but in the Visual Basic environment. I created a report using Crystal and then used the ActiveX control to run it from withing my VB app. The report ran fine in the Crystal Designer environment but when I...

Hello EarlGray, The subreports were created seperately and then I used the Insert Sub-report option and pointed to the existing reports I created, then I specified that the sub-reports were linked to main report by a field called 'locid'. Both the main report and sub-report look at the same...

I am using VB5, CR6, and I have a report which has a subreport within it. When I run the report in the crystal report designer everything is fine. I use the Crystal OCX control within my VB app, and when I try and run the same report it reports a runtime error 20599 Cannot find SQL server. If...

I have an access database which obtains data from a word document. My table consists of a memo field to contain the imported text data. This word document contains a table and the text in each cell contains bullet points as well as the usual carriage return/line feed. I create an instance of...

Thanks for your help, It's a real pleasure to know that someone else is aware of the problem and has a solution. Rgds Darrell