Type: Posts; User: gibra
Search took 0.03 seconds.
The Button property only display a small button with arrow.
Any other action should be done by code on ButtonClick event, where ColIndex parameter get the column on clicked button.
Set tab stops, auto search, add/remove items from listboxes
For me its work good. Example:
Period is a Integer data type, change it to text:
ALTER TABLE Analisis ALTER COLUMN Period Varchar(20) NULL
After, reset to Integer:
Form Resources Explore:
- right click over yout .MTF
- choose Open With... command
- select your program .exe
values of :
- cmbpayperiod.text ?
- CmbPp.Text ?
date, string, number or letters?
Value type for columns table?
Dim CN As ADODB.Connection
Set CN = New ADODB.Connection
.Mode = adModeShareExclusive
.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sPathMDB & ";;Jet OLEDB:Database...
In your query spaces are missing:
I suggest you don't use & _ , use strings concatenation as below:
sql = "SELECT STUDREC.stid, tblmem.dte_valid, STUDREC.Lname, tblacnt.role"
sql = sql...
Search on forum:export recordset to excel
Use RowColChange event, instead of Click.
Issues of points of view, but it is generally known that the DataEnvironment is much more limited ADODB, has problems in itself (bugs):
VB Toolkit: ADO or the Data Environment? | Business...
Data Environment isn't necessary.
Use ADODB library : Connection, Recordset, ... is more flexible, powerful and easy.
If you use DAO35 then may be the problem, because isn't more supported:
Support Statement for Visual Basic 6.0 on Windows Vista and Windows Server 2008...
I forgot the last zero :D
Use a Timer, Set the Interval property to 100, then use this code
Private Sub Timer1_Timer()
lblTime.Caption = Format(Now, "hh:nn:ss AM/PM")
Dim m_iCount As Integer
Private Sub cmdLogin_Click()
If m_iCount = 0 Then m_iCount = 1
If txtPassword.Text = "training" Then
Use DataGrid2_RowColChange() event, instead of Click event.
PictureClip and Winsock are external OCX controls. You can't simply copy this files.
You must create a SETUP to deploy them, including all files your app is need to work.
I use API Viewer 2004 on all my PCs/Notebooks on Windows 7 64bit SP1 with no problems.
VB project: NO.
Exe program: YES (if use only intrinsic controls!)
My VS6.0 Installer tool, made with VB6, use only intrinsic controls + API, it work on any pc that does not have VB installed.
Before to add Item in lv2, check is already exists: see FindItem method
This is not what you wrote here:
You can share any files/folders with any user you want
You have to set shared files/folder only from your DropBox account (DropBox web...
ACC2000: How to Change the Database Password Through ADO
Then you have :
- 3 PCs with DropBox installed and running.
- all PCs are connected to same DropBox account
- all PCs have username (DON-Win7)
From your DropBox web site account you...
Yes (see below)
Yes, but doesn't need.
Really, the files you share on the cloud are local pc.
When you install a cloud programm service like DropBox, OnDrive, GoogleDrive, ... a shared folder...
Into Access database, set the table fields as Required = Yes, then intercept and manage the error on update action.
You can load your database on cloud (DropBox, OnDrive, ...) then access to it from anywere.
Of course, you can't use this technique on a multi-users scenario, it's only for single user connected,...
See Codice Fiscale project in this page
My favorite function is the system SHFileOperation:
here a vb6 sample:...
On my Windows XP SP3 (virtual machine) start correctly :
Check permissions of F:\0_Archive\INSTALLS\Visual Studio 6\ folder...
VS6 Installer has been updated to version 2.1.
Download and try it.
If doesn't work contact me on my forum (VBCorner web site).
Then you should ask to the CodeJock forum:
ActiveX COM - Codejock Developer Community
Doesn't exists a 'database control'.
Copy only if cell [N17] is empty
Using VBA, you can try to copy the .Text property of the cell (not the .Value property).
Then, as I said, you have to use only intrinsic VB6 controls.
Even with just these controls, you can achieve a good application.
For example, my VS6 installer (see my signature) is a truly...
If your problem is solved, mark the topic [RESOLVED] (see Thread Tools link)
Not always a 'desktop' application is a 'portable' application (app is another thing...)
Given that the library 'virtual machine' VB6 is already present in the Windows o.s. from version 2000 and...
Click Here to Expand Forum to Full Width