Search results for query: *

I am using three data combo's attached to 3 separate ADO Data Controls. When the first combo box has one of it's list members selected, this is passed as a parameter to the SQL which populates the second combo. However, once I click the original combo, the first value has been replaced by the...

Is it possible to hide/supress a group header based on the value of a field in a higher level group?? Thanks in advance. Chris

Hi, I have some 40 controls that I need to call the same piece of code (a public sub created in a module) when each control loses focus. I was just wondering if there was a quick way to kind of do this once or do I just have to paste the sub's name into the LostFocus event of each of my 40 or...

Hi, Our company has a production database (sql2000) on a server in China. In the UK we run sql7.0. Is it possible for me to make a backup of the database in China and restore it to the SQL server in the UK, after transferring the backup file over a secure connection. If not, is there anyway...

Hi all, I have an application with some 30+ forms. Based upon a security table that I have set up determines which menu buttons are available to a user. However, upon logging in the user can see all of these forms having there various buttons enabled/disabled. Is there any method of hiding...

Is there an equivalent to the MS Access IIF function in SQL?? TIA Chris

Is there a quick way to determine whether a combination of three text boxes each have entries, i.e. 1&2 or 1&3 or 1,2&3 without using multiple IF statements??

Hi If I run a procedure on a text boxes contents when the text box loses focus, how can I return to that control if an error criteria has been met? TIA, Chris

In the past (probably in DAO) I have used the following; with rs .edit !field1="xxx" .update end with Is there a direct replacement for this in ADO? TIA, Chris

How can I avoid the change event firing if the change to the textbox is made programatically i.e. automatic. I only want the event to fire if the change is made by the user typing the changes. Any help is greatly appreciated. Cheers, Chris

Hi, I have a form which acts as a main menu for my application. However, I want to disable certain controls on this menu based upon some values that I have stored in an array (integers). Basically, if I encounter a zero in the array, I want to disable a specific button based upon the position...

When I try to write a transaction to my SQL database through my application I get the following error message: Run-time error '-2147417848 (80010108)'. Automation error The object invoked has disconnected from its clients.

I have a pretty major problem in which my application causes the P&D Wizard to bomb out as soon as it trys to create the setup.lst and cab files. Has anyone seen this before and if so know of a solution or workaround. TIA, Chris

Is it possible to manipulate the state of controls displayed on a form without actually loading the form? I have a number of forms with Chinese and English labels on them. If the user requests a change of language I need some controls to be visible and others to be invisible. Can anyone help...

I have a SQL7 database. I don't particularly want to store queries (views) in the database itself so I was wondering, is it possible to create two sub querys then join them together in order to get the correct result set in VB. The result I need cannot be done in one query (At least I think...

I have a query which pulls two quantity fields from different tables. If there is no related record in the second table then I cannot subtract one from the other cos the second value is null. Basically what I want to know is, is it possible if no related records are returned to return a zero...

Is it possible to create an ODBC datasource when installing a program that requires one, or do you have to do it manually afterwards?

Hi, I have a SQL Server database that contains both English and Simplified Chinese characters. However, no matter what I try I cannot get them to display on my report correctly, all I get are strings of question marks i.e. '???????'. Has anyone had any success with a report such as this? I...

Hi, I have a SQL 7 database which contains some unicode data which consists of Chinese characters. I need to display this data in a crystal report but this will not work unless the database client encoding is set to simplified chinese (GB2312). Does anyone know how I am supposed to go about...

Hi everyone, I have an application that uses and MDIForm and a number of child forms. Is it possible to prevent the controlbox on the MDI from working altogether or at least prevent it from working if a specific criteria is met i.e. a flag is set to true etc. This is because I would prefer...