Hi,

Man i dont wana to dash your hopes, but what you r trying to do is quite difficult using such controls. I advise you to look for an alternative idea.

Hi,
Open the new form in a new application and change the form name preperty and save it. After that add it to your application and it will work. Or you can change the name property of the original...

Hi,

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

Hi,

I previously had a function that gets a screen shot but i can't finf it any more. Look on the internet for a function that perform "Print Screen" and then a function to crop that picture.

Hi,

When u say you have to build an internet application do u mean you want to create dynamic webs or what??

Hi,

I think the altimate challange in VB is graphics (such as dynamic drawing and games). But as no one uses VB for that APIs are good and proivde you with 100s of functions that you didn't think...

Hi,

Mainly passwords are stored in databases with adding restrictions over the tables that it is stored in. Unless you encode those text files some way I advise you not to store it as text files....

Hi,

Please attach a sample of each of the files and i will check it.

Hi,

I have created you a small example of recprdset coding and attached it. Check if it is what you need. If further assistance is needed please reply.

Hi,

The pro. way of doing it is using the index of the field for ex: rsPegawai(1)

Hi,

My friend, you will get no benefit like this. Did you even bothered yourself looking for some ideas??
At leaset start with something and am sure every one will be more than welling to help...

Hi,

Use rsPegawai(x)

Hi,

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

Hi,

The mshflexigrid mainly provides grouping utility of records ex:

in msflexigrid data will look like
Jan 1
Jan 6
Feb 7
Mar 7
Mar 3

Hi,

Check below example, for it to work add the component "Microsoft Common Dialouge Control" and add one to your form:

Private Sub Command1_Click()

Dim xl
Dim xlsheet
Dim xlwbook
Dim...

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,

Try this:
Private Sub Calendar1_Click()
Me.Label1.Caption = Me.Calendar1.Value
End Sub

Hi,

You can always add a registry for you application. And on the first form your application will check if you are authorized to run the application by reading the value stored in registry editor...

hi,

I didn't test it but i think you are adding extra "s. The statment shall look somthing like:
"SELECT * from Trans where IsNull(DateReturned)=True And StudId like '" & Text1(8).Text & "'"...

Hi,

You can start with this simple example:

Hi,

Can you attach some sample data and the code you have already built, and I will check if I can help you.

Hi,

You have to create a module, and in that module declare a public variable (ex: Public PetNam as string). Now in frmPet and on the textbox after update event (or change event) add the following...

Hi,

I don't know what IDE you are using but if VB You can't use the richtext control to display an html file?? and even if you used the .filename property you will get the html source of the file...

Hi,

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

Hi,

Send it to kbaalbakixxx@xxxgmail.com
Please remove all "x" letters from the address (added for spams evade)

Hi,

That depends on the type of files (excel, word, text ...)???

Hi,
Check the attached example, I hope this is what you are looking for.

Hi,

Dealing with pictures in word is tricky. Because when you insert a picture to word it is inserted as inlineshape that is not allowed to be hidden through code. What you have to do is copy the...

Hi,

If you want to save you work just before xl.quit add:
xlwbook.saveas "c:\x.xls"

Hi,

Use this code:

Private Sub Command1_Click()

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

Hi,
Are you saving the document?? the following code will work:
Private Sub Command1_Click()

Dim xl
Dim Worksh
Dim xlwbook

Set xl = CreateObject("Excel.Application")
Set...

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,
I think u r trying to create a checkbox on runtime and give it the name stored in variable b. if so below is the code to do it:

Private Sub Command1_Click()

Dim a As CheckBox
Dim...

Hi,

You can use Range("A:A") and the whole col will be used.

Hi,

Not so clear but if I understand what you mean you need a grid that includes some file names and an OLE object to display the content??

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.