Hi,

Go to below link and download the AVG anti virus free addition. Its a greate antivirus, install it and it will catch some trojans that no other anti virus has even detected (name it macafee,...

Hi,

[code]xlApp.ActiveWorkbook.Close True, App.Path & "\gegevens.xls"
xlApp.Quit
Set xlApp = Nothing[/close]

Hi,

If IsNumeric(Me.txtInput.Text) And Me.txtInput.Text > 10 And Me.txtInput.Text < 100 Then

'you action

End If

Hi,

And if you are using access use "*" instead of "%" ex:
select ename from emp where ename like 'A*'

Hi,

I don't know what is generating the error as I tested my code and it worked correctly. Try to debug in order to find where the error is. A for Me. you can remove it where the "Me" word...

Hi,

EOF will be reading the cells or the sheets ??

Hi,

Check this:


Dim xl As Object
Dim xlsheet As Object
Dim xlwbook As Object

Set xl = CreateObject("Excel.Application")

Hi,

Ususally after cleaning any virous that strikes registry or system files it is advised to reinstall windows to avoid any similar cases.

Hi,

Sometimes some window files gets corrupted which slows down the startup of the computer. And sometimes a missing driver does that. So first of all try reinstalling all drivers, then go to run...

Hi,

It will look something like this:
Select tbluser.id, tblinfo.* from tbluser, tblinfo where tbluser.id=tblinfo.id

Hi,

Add the below code within your sub where xxx is the name of the button you want to click:
xxx.PerformClick()

Hi,
Just replace the wdFormatRTF with number 6 (this code is for VB6, if you are using different IDE please advise).

Dim Oword As Object
Dim Odoc As Object

Private Sub Command1_Click()
Set...

Hi,

Try this, I haven't been able to test it:

Dim Oword As Object
Dim Odoc As Object

Private Sub Command1_Click()
Set Oword = CreateObject("Word.Application")
Set Odoc =...

Hi,

Use the below code while changing just the file name:

Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal...

Hi,
What I ususaly do is call the below SQL through regular ADO "Select GetDate()" so the statment is implemented on the SQL server on our main server.

Hi,

I don't know if it is possible to remove windows without format, but I will till you how to control the boot list and how to skip the selection of OS.
Right click My computer and choose...

Hi,

Check this sample it may be a little complicated but you can isolate the code you need out of it.

Hi,
To disable the possibility of adding the same record twice I have amended the example a little.

Hi,

Check the attached example.

Hi,

What is the problem you are facing ... As syntax I don't see any mistake. If you are retriving wrong records try to format the value of the date picker.

Hi,

Most of the IE problems are resulted from the addons that most of the time you don't know that it is on your computer and some of them are really bad to your computer. In all cases go to tools...

Hi,

This not a virus. It is a normal office process that happens once after trying to open office applications for the first time, or over a new user. Mainly it is overcomed by leaving the office...

Hi,

Attached file shows an example of this.

Hi,

I can't check your code right now but below is a similar code I used once for a login form (no need for the module):

Option Explicit
Dim rs As Recordset
Dim db As Connection

Private...

Hi,
Just replace the 0 by 1 for the start index:
MsgBox Mid$(txtFirst.Text, 1, 2)

Hi,

If never messed with Java I advise you not to start now :)

Hi,

Your problem is in line 10 where you have seperated the If Then statment from their result without using End If. Just get line 11 to be directly after Then in line 10 (without going down to a...

Hi,

I think you are looking for:

Me.Combo1.AddItem " Select "
Me.Combo1.ListIndex = 0

Hi,
If you can unsertand some VBA (and it is very user friendly) you can simply use access or excel. Am sure as you start you can get very good suport.

Hi,

That depends on what you need to do. Please provide further information.

Hi,

For the extra spacing problem use the built in excel function clean which will remove all non printable chars.

As for the problem of row height it is becuase you are exceding the accepted...