Type: Posts; User: gibra
Search took 0.04 seconds.
Do not need to know it, you'll just use the Replace() function.
See the help file about it.
But, the best way is: use a Command with Parameters.
Why? What your need to discovery?
Explain your goal...
Nothing to do with your question.
your query return to me 4four record
What's your problem?
What result you want to achieve?
CAST is not supported by Access.
You may use:
ORDER BY CLng(Student_ID)
Caution: is there a record wich Student_ID is empty or NULL then you get a error.
However, keep the Student_ID...
First of all:
The correct way to open a recordset is:
Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset
10 ADO best practices - TechRepublic...
In table: change field type from STRING to NUMERIC.
VB Helper: HowTo: Give an MDIForm a resizing background picture
If you want center image, replace this line:
You can use the KeyPress events:
Private Sub Text1_KeyPress(KeyAscii As Integer)
If KeyAscii = vbKeyReturn Then
KeyAscii = 0 ' avoid the beep when Enter key is pressed
In your project, are you referenced ADO 6.x or ADO 2.x ?
Your Windows 7 include SP1 ?
First of all, the instruction:
If Printer.DeviceName <> strNewPrinterName Then
return always True, because strNewPrinterName variable is always on upper case, while Printer.DeviceName not.
Also, you can use Styles:
...and CursorLocation is ???
Are you sure that Excel and/or Word are availbles for any/all users ?
this is the correct way:
Public cnOracle As ADODB.Connection
Set cnOracle = New ADODB.Connection
Windows already auto connect automatically to internet.
why do you want to reinvent it?
10 ADO best practices - TechRepublic
Check your connection string here:
SQL Server connection strings - ConnectionStrings.com
also, your declares are worng:
This help you?
SELECT Count(*) AS Lot, Sold
GROUP BY Sold
Will return the below result:
But not so for all ADO DataType constants:
i.e. doesn't exists a VbVarTypevalue for large fields as: adLongVarChar , adLongVarWChar , adLongVarBinary, ...
Sorry for you, but vbString is a member of VBA VbVarType enum; isn't a member of ADODB DataType enum, so use it is totally wrong.
When you use ADODB, you must use a ADODB DataType, as indicates in...
Append Method (ADO)
Sorry, but you are not clear (to me at least) ...
Your code is working. ;)
I've tried with:
AppWFM = "Google - Internet Explorer"
and IE will activated correctly.
How do you see this confirms what I said in my previous post about the...
Not always the window title inlcude Windows Internet Explorer, on my pc shows Internet Explorer only.
What functions you uses to read and activate the window using the hwnd?
Sort require a Range object, in this line:
oSheet.Sort.SetRange Range(Temp) ' This is the instruction that causes the 1004 error
Range object could not be created implicitly.
Error in vb when using IWshRuntimeLibrary.WshNetwork-VBForums
LOGIN form is better than InputBox
source code here:...
What's your problem about INNER JOIN ?
Yuo can use the MonthView, wich is exactly equal the MsCal.ocx
Simply, from Project -> Components... add the:
Microsoft Windows Common Controls 2-6.0 (SP6)
From Project menu ADD new Form, choose the already Options window template
This form will help you to understand how TabStrip work. ;)
And the query is ????????
You should use Click event (not MouseDown event)
To understand better how to use TabStrip:
- create a new project
- menu Project -> add Form
- choose Options window
this create a sample...
Dim sPath As String
Dim sFileName As String
Dim sExtension As String
Dim sFolder As String
sPath = "D:\Common\Tools\vb\Unsupprt\MCIWinDx\mciwindx.doc"
In Command1_Click() event, after :
Picture1.AutoRedraw = True
Picture1.Width = Screen.Width
In Design Mode you can use MZTools 3.0 (free) or CodeSMART 2013 (not free) add-in.
Both have the appropriate commands:
- Copy control with code
- Paste control with code
all events are...
My code is working good but is the Windows 8.x system that work differently:
This appear on my Windows 8.1 (Italian language)
To show the OpenWith system dialog:
Shell "Rundll32.exe shell32.dll, OpenAs_RunDLL " & sPath, vbNormalFocus
where sPath contains the complete path of the file you want change
Click Here to Expand Forum to Full Width
Survey posted by VBForums.