Search results for query: *

Hi All, I would like to use the frame as an object. I'd like to create an instance of it. Something like : Public FRM1 As New Frame Public FRM2 As New Frame FRM1.Visible = True FRM2.Visible = True Can someone help me with this? Thanx!! Linux IS userfriendly. It's only very selective...

Hi All, I've got a problem which I hope you can help me out with. I'm trying to create an application that can open a frame that i've designed multiple times at once. (So there will be like three of the same frame with different content) (How) Is this possible? Thanx in advance! Eric Linux...

Hi guys, I've got a small problem and I'm hoping you can help me out with it. I want to put comment into a specific cell. Inserting the comment into the cell isn't the problem. Making the comment partly BOLD and COLORING is though. Does anyone have a VBA script for me that fills a cell with...

Hey guys, I've got a problem withe the WHERE clausule of my query. In my database records are stored and all have a field Start_Timestamp and Stop_Timestamp (both Date/Time format) When I execute a query like : SELECT * FROM table WHERE number = 1000 AND Start_Timestamp > '1-3-2005...

Hi All, I've got a relatively small problem to which I can't seem to find an answer. In a production process employees can enter a time which they spent on a production. The start time is entered in the system and stored in the database in a date format. I would like to calculate the estimated...

Hi All, I've searched my @$$ of for sites that give me information about this subject and I hope some of you can help me out here. I've got a table in ACCESS with a records that I put in a recordset using ADODB. Cursortype = adOpenForwardOnly LockType = adLockPessimistic Now I'd like to lock...

Hi there, Is there a way to "escape" certain reserved characters when they're put into a string which I want to insert in a database field? The problem I have now is that VB6 gives me an error when i'm using a quote in the text field. Thanx for your replies! Eric Linux IS userfriendly. It's...

Hi All, I'm trying to change the type of contents of one cell in Excel 2000. Can't seem to find the command for it though. Can anyone tell me how to do this and... Does anyone know a online source where I can retrieve more information about connecting VB6 to Excel and also creating charts...

Can anybody tell me how i can insert a Image into an Excel document using VB6? t4yr! Linux IS userfriendly. It's only very selective about who it's friends are.

Hi All, I was wondering if you could help me out with this one. I'm aware of the fact that you can merge cells by using a command like : SELECT ...., (Time & " on " & Date) As TimeDate From TableName What I would like for an output is a variable that contains a check wether a field is NULL...

Hi guy's, I've got a small question and I hope you can help me with it. What is the difference between an IS and = operator in a SQL query. For instance : SELECT .... WHERE Date = NULL gives NO RESULTS at all SELECT .... WHERE Date IS NULL gives all the records that have an empty field...

Hi guy's, Is it possible to fill one column with multiple variables? I want the column to display three fields from the same database table in one column. As for now I can only enter one Datafield in the Property pages. The entire field isn't editable. Linux IS userfriendly. It's only very...

Hi all, At the moment I made myself a little config file where I've declared the path to the database file I'm using. My application reads out this information an put's in in an variable. I can use this variable with any recordset i'd like now. I've got only one problem. How do i get this...

Hi all, I'm having some trouble inserting data from a recordset in a variable. De default method like Label1.Caption = RS!Number always worked for mee. But.... Now i've combined two tables (Path and Recipe) in which both tables have a Primary Key called "Number" Logically i entered the...

Hi all, I was wondering if it's possible to disable the Close button (Cross in the right-top) of a form. I mean not by setting the BorderStyle to none for this results in a unmovable Form. Thnx 4 your replies!! Eric Linux IS userfriendly. It's only very selective about who it's friends are.

Hi All, I've got a problem with a listbox and it's connection to a field in a database. I've got al listbox that contains of the "Description" of multiple Components. The list of descriptions is retrieved from a database Table called Component. The primairy key of this table is a NUMBER. In a...

Hi Guys, I've got a problem that has kept me busy for quite some time now (like four days!!). I'm not very fimiliar with Access and a bit fimiliar with Visual Basic 6 I've got a database that holds three tables. 1. Recipe 2. Component (A recipe consists of components) 3. TT_Recipe_Component...

Hi Guys, I've got a problem that has kept me busy for quite some time now. I'm not very fimiliar with Access and a bit fimiliar with Visual Basic 6 I've got a database that holds three tables. 1. Recipe 2. Component (A recipe consists of components) 3. TT_Recipe_Component (This table holds...

Hey guys, I've got a nice one for you this time. I'm programming a recipe application at the moment to create recipes for factory product. My database is in short like this : - table "Recipe" that holds the recipe number(autonumber), code ("PC123") and name ("Pancake") - table...

Hi there, I'm quite new in using VB6 but very fimiliar with SQL databases and many other programming languages. At the moment i'm filling a Datagrid using a pre defined Data Environment command. This works very nice but.. I would like to get a listing of a Recordset that i declared in the form...