Search:

Hi, folks

Thanks for taking the time to help me. I could solve my problems by using the info you have told me about.

Thanks again!
See you, Roselene

Hi, folks!

I'm receiving the following error message
"Run time error '3246' - this action was cancelled by an associated object"
when clicking a button which runs the line...

Damonous:

I've tried you suggestion, but have received the error message:
User defined type not defined
regarding to the expression CrystalReport1 in the line:

Dim Report1 as New...

bsmith,

Yes, I'm running Crystal reports from the VB program. There are 2 option buttons (Same name, different indexes) in a form in order to allow the user tho choose which report he/she wants to...

Bsmith,

Thanks for taking the time to help me. Could you please give me any further information? I'm afraid I can't understand your suggestion.

Thanks again,
Roselene

Hi, everybody!

I'm using 2 text boxes in a form as criteria to a SQL which feeds a Crystal reports. It's working nice, the problem is that I'd like the contents of the 2 text boxes (which are the...

Glen and Serge,

Thanks a lot for helping me.
Glen, I was saving data with the report, now I can see the result of my SQL Statment.
P.s. I'm using CRW32 4.6.1.116
Is this version very old?
...

Hi, everybody!

I'm using the command:
MyCrystalReportsControl.PrintReport

to display my report to the user. The problem is that the report appears too small. How can I get it to appear using...

Hi, everybody!

I've just started working with Crystal Reports. Have made one and been trying to change the SQL which feeds it, but have been unsucessful so far.

I choose the option -Show SQL...

netSurfer,

It works beautifully and you've helped to solve another problem. As usual, I must say!

Thanks very, very much!

Best wishes, ;)
Roselene

Hi, everybody!

I have a DataGrid which contains 2 columns. I’d like the user to not be allowed to add or change data in the 1rst. one, since it'll be filled by code.

The user also would be...

Hi, folks!

I'm working with my 2 first projects in VB.
They are going to deal with:

A)Data related to calibration of equipment, like sieves, crushers, thermometers, etc ...

B)Data related...

Hi, folks.

To Bigley and Martin Liss:
--------------------------

Thanks very much for taking the time to help me, I really appreciate that.

To Bigley
----------
I don't know how to use a...

Hi, everybody!

I'm trying to use Functions like MAX, IIF and DateADD in my SQL statment. is it possible?

Set MyDb = OpenDatabase("MyFile.mdb")
MySqlString = "SELECT Calibrations.RealDate,...

Andrew,

I've used your suggestion and now it's working beautifully.

Thanks very much for taking the time to help me with such an useful answer. :-)


See you,
Roselene

Hi, everybody!

I'm working with a form which displays a Data Grid like this:
=============================================
Expected Calibration Date - Consummated Calibration Date...

Hi, every body!

I'm trying to use a dateadd expression in a SQL statment, but I'm having problems cause this function calls for a parameter between double quotes:
eg.
dateadd("d", 1, date)

My...

Martin and Mark,

Thanks for taking the time to help me.
I was using those properties on the wrong way. Now, I'm using a code like this in my "Add New" button:
MyDataGrid.Enabled = True
...

Hi, folks!

I've added a Datagrid control to my form and have set its properties like this:
AllowAddNew = false
AllowDelete = false
AllowUpdate = false, on the form load event

There's a...

Roger,

Thanks for taking the time to help me. I really appreciate that.

I've tried
Dim MyADORecSet As Recordset
Set MyADORecSet = New Recordset
MyADORecSet.OpenRecordset "Select * from...

Hi, everybody!

I have an ADO Control which has nothing set for its recordsource in the window property.

I'm trying to set this property using code:

Private Sub Form_Load()
Set MyDb =...

Hi, everybody!

I have a Table which is the record source of an ADO Data Control. I'd like to refer to a field in this table using the ADO Control.
So, I've tried:
MsgBox...

Karun,

This way works also. I guess we can use this command with other keys:
SendKeys "{End}"
SendKeys "{home}"
SendKeys "{enter}" and so on?

Thanks for helping,
Roselene

Hi, people,

I have a SQL statment as record source of a DATA Control. I'm trying to insert a space between 2 fields, using this SQL:

If I use:
SELECT GroupID, GroupCode & GroupDescri AS Expr1...

Mark,

It works beautifully. Thanks for taking the time to help me.

Roselene

Hi, again!

Is there anyway to set the focus to a text box, at the end of its text?
Eg.
Textbox: 95LT
I'd like the cursor to be after the T, instead of before the 9, in order to avoid having to...

Hi, folks!

How are you?

I have a form to receive equipment data. These data are: EquipmenteGroup, EquipmentTAG and EquipmentDescription.
I'm using a DataCombo Control to deal with the...

Bsmith,

Thanks for helping! It's seems to be so simple, now that you've already given me the solution :-)

See you,
Roselene

Bsmith,

Thanks for helping! It's seems to be so simple, now that you've already given me the solution :-)

See you,
Roselene

Bsmith,

Thanks for helping! It's seems to be so simple, now that you've already given me the solution :-)

See you,
Roselene

Bsmith,

Thanks for helping! It's seems to be so simple, now that you've already given me the solution :-)

See you,
Roselene

Hi, everybody!

Is there a way I can simulate a click on a button?

Inside one button click event, I'd like to call another button click event, but if I use the line
Private Sub...

taLON,

Thanks for taking the time and trouble to help me. I really, really appreciate that.

yes, I've forgotten that the project will be turned into an .exe and that it's going to change their...

Hi, everybody!

I have a button called "Save" which the user clicks on after entering all the data in my form.

If the user adds a duplicate value, VB displays a message box:
Run-time error...

Seaweed,

Thanks for taking the time for helping me.
I'll give it a try!

See you,
Roselene

Hi, everybody!

Is there a way I can use to find out what of two buttons was the last one to be clicked?

I've got a button for "Changes" and a button for "New record" and I'd like my button...

Mark and Frederik,

Thanks very much for you attention and for taking the time to help me!

No error messages, even using the command
DB.Execute (strSQL), dbFailOnError

I’d like to bring up a...

Hi, people!

I’m trying to cope with an odd problem:
I’m using the following line in order to update a table field:
DB.Execute ("UPDATE MyTable SET MyField = " & Pesq(0) & " where counter = " &...

Hi,

Thanks Buzby!
Thanks Mark!

I'll give a try for both ScreenCam (if I can download it, it's been hard so far) and Demoshield, cause I am curious to know how these softwares work. In case I...

Hi, people!

I’d like to know if it’s possible to create an "animate" demo for my little VB System. I have heard that there’s a software that you can use to "record" the operations you do while...