Search results for query: *

Folks, I've been looking at this for a while now and I appear to be going round in circles, so any help would be greatly received. I'm looking to print records from a data table. My VB6 code is: Public Sub PrintRecord() Dim strMySQL As String Dim dbTest As Database Dim rsTest As Recordset...

Found a posting you made 2nd Dec 2004 regarding splash screens and some code for displaying the splash screen and then the main form..... Sub Main() Dim fs As New FormSplash() fs.Show() : Application.DoEvents() Threading.Thread.Sleep(3000) fs.Close() Dim...

The organisation I work for has rolled out XP in place of it's existing NT platform. As part of the "build" users have been given MS Access 2003 Runtime only (version 11.0.5614.0). Previously all users had the full version of MS Access 97 as standard. As a consequence we've had to...

The organisation I work for will shortly be upgrading from NT4 to XP, including an Office 97 to Office 2003 migration. I have a number of Outlook 98 forms that incorporate a fair amount of VB script and, not having a test bed available to me, I am unable to confirm whether these forms will...

Morning folks, I have an Access report that consists of 56,079 pages. My users like to know which page they are looking at so I placed the obligatory text field at the bottom containing = "Page " & [Page] & " of " & [Pages] "Perfect", I thought, until I ran the report. The report shows the...

I'm currently "playing" with VB.NET, being a VB6 developer on an NT network, on an XP standalone. In VB it's easy to create a keyboard shortcut on a menu by placing an "&" before the letter that you wish to be the shortcut key. Doing the same thing in .NET doesn't appear to have any affect...

I have 3 backend databases on a server, a live database, archive database and a database that holds some security information. On each of the 95 users workstations is a local database that links to each of the 3 backends. This morning none of the users could access the local application. I...

I am creating a sql string.... MySQL = "SELECT * FROM tblRemissions WHERE CustomerName LIKE '*" & strVariable & "*'" & " ORDER BY RemissionID" strVariable is as it suggests, is a string variable. If I use a sql string where the whole name is known.... MySQL =...

We have installed some software on a number of NT4.0 workstations that runs in the background after a user has logged on. Unfortunately an icon is displayed in the System Tray, from which the software can be closed down. I would like to hide/remove this icon from the system tray, does anyone...

Does anybody out there know the maximum number of fields that can be created on a custom Outlook form ? Thanks.

I have an Excel workbook on a server containing numerous sheets. I'd like to make one of the sheets available to everyone within the office but not have the others visible. Is it possible to create a desktop shortcut that links to only a single Excel sheet within a workbook ? Thanks.

We, myself and two other developers, have been advised to stop developing using VB6.0 and move to VB.Net. The rumour mill is in overdrive and has us believe that our organisation is moving away from the current Microsoft platform of NT4.0. To what it will move to we have no idea yet, Linux and...

I have an ADODC data object on a form, connecting to a backend Access97 database, within a VB6.0 application. My problem is with the SQL string. The following string works.... strMySQL = "SELECT * FROM tblBankGiro WHERE Name = " & "'" & strNameSearch & "'&quot...

Folks, I have a VB6.0 app which opens an Access97 database to produce reports - I don't have Crystal unfortunately. Anybody have any idea of the code to open the Access database maximized ? I'm not talking about the Report window within the Access window, I'm talking about the Access window...

Morning Folks, I have a database (Remissions.mdb) on a server. I have another database (Reports.mdb) on the same server with linked tables to Remissions.mdb. In a VB6.0 application I have a procedure, shown below, that opens Reports.mdb, asks for some information from the user and generates a...

I have a ListView box on a form called lvwPostings. On opening the form, code is executed that creates an Adodc recordset. The records contained within the recordset then need to be displayed within the ListView box. I am, however, having problems displaying the records. The code so far...

I have a custom form that, amongst other fields, has two combo boxes on it. The first combo box is populated from a table within an Access 97 database. The code for which resides within the Item_CustomPropertyChange(Value) procedure. This code, based on a SQL string, works fine. The second...

I have a VB 6.0 front end linking to an Access97 back end. I'm able to create a simple report in VB 6.0 based on a particular table. I can "hard code" a value to pull out specific data but I cannot work out how to pass a variable to the "query" to pull out specific data from...

This question relates more to VB Script than VB5 or 6 but hopefully someone out there can help me. To delete a known Word document within VB I normally use the Kill command. However, within Outlook VB Script the Kill command generates an error - Type Mismatch. The script help within Outlook is...

I have written a VB6 app that opens a Word97 template and automatically feeds data into it from an Access database. Relevant sections of the code are below.... Set wdMyApp = New Word.Application Set wdMyDoc = wdMyApp.Documents.Add([pathway to template here]) wdMyApp.Documents([filename...