Search:

IDE to mean - Integrated Development Environment. No one says it better than Wikipedia http://en.wikipedia.org/wiki/Visual_Basic

Thanks for the light bulb. This is what I did and so far it counts 21 days fine.



Private Sub DTPicker1_Change()
Dim d As String, dtp As Date, myPickDate As Date
myPickDate =...

So where do I set it to pick the date on the DTPicker1? Do I have an extra line with



myPickDate=DTPicker1.Value

You will also remember to teach us.

Halo,

My application captures data using date pickers. Items are taken and returned after certain intervals.
I have code that should change the date in DTPicker2 by 21 days if DTPicker1 has been...

If txtRepName.Text = "" Then ' blank field
MsgBox "Please Enter the Rep Name"
txtRepName.SetFocus
Exit Sub
End If

So what is included in this ini file to override the defaults? I am interested especially on the reports since that is where I get lost.

I think what WoF has said sums it up. Is it possible to declare the path of a report? I usually have problems declaring the path of a report and I go round it by first knowing where the application...

& CStr(empID) & should be changed to & CStr(emp_ID) &, check if this will work!

I don't know if this code really opens the workbooks as it is supposed to... Is there a way of ensuring the workbook is seen as open? Then access can be made to the chart. I don't know how to do this...

How did you define Excel.Workbook? take a look at its definition because according to your program, it cannot see chart 4

You could keep them in a file. First you need to put the random number generated in a text box then take it from the text box into your file. You can then read it from the file and assign your seed...

Thanks a million. This took me three days to realize and you took just a while to get it right. The program now works just fine.

let me try and see what comes then get back to you. Thanks.

Halo friends,

I am developing a stock control program that calls data from a database. this particular form has been built using text boxes that form an array. It should be a grid of ItemCode,...

Hi Brad,

I hope I am the first person to post.... 24hours later.

Agina

Got the answer!

To eliminate the error, open the .LNK file using note pad and replace the line that has DLLSelfRegisterEx with DLLSelfRegister. Then this solved the problem. I should have googled...

I have used the package and deployment wizard to cerate a setup for a software that I have done. When I try to install the software in a machine it gives me the following error



The file...

Looking at what TheCPUwizard had to say, I now understand that I have to be more careful. I was also of the opinion that there is no point of creating relationships since VB does not know they exist....

I think this happened to me a while back and I used some simple positioning code that does not let me down.



Form Load ()
'Fix position at start up
Me.Top = 100
Me..Left = 100

'Fix the...

Not so fast to judge... that was his/her first post!

What are the objects that you have on your form? Seems like an object is missing

Halo,

This is what is happening!


This can be done by creating the following in your form



Set rsTableInDB = New ADODB.Recordset

Someone once gave me a hint here that if you want success in creating reports, create them in the folder that your application will be installing to on the FINAL computer. So if, say, you will be...

I wish I had my VB installed but the system just crashed, here is some code to start you off.

Place this code in a module



Option Explicit

Public Cnn As ADODB.Connection
Public Rs As...