Search:

Hi Shaikh.Riyaz.a,

seems I did not make it clear:

The Backup Program is a 3rd Party tool. We bought it.

My program calls that backup program with user-specific commandline-parameters
...

Hi out there,

I created a VB-program that calls another application via shellexecute.
That app is a backup program, that gets commandline parameters from my VB-program.

Now sometimes the...

Hi,

ok guess I found the solution. If anyone is interested:
Inside a VB-Addin, this should be the principal way to deal with autogenerated lines. There has to be some more work concerning...

If you get the data of the table via recordsets, check the .locktype property of the recordset. Your description of the problem indicates that you use adlockpessimistic. That should be changed to...

Hi Hensa,

I thought that my english may be too bad to make me clear ...

What I need is a possiblility to auto-generate code via the VB-IDE.

Lets assume I am in a collection, in the...

Hi out there,

I'm having some problems with the following:

After being sick and tired with all those weird and bad Addins for VB to implement a more advanced errorhandling, I've decided to...

Hi Comintern,

I like your idea with the boolean, though I hoped that there may exist a method (maybe of the form) that could handle that. Now sadly I have to write some code :)

Hi out there,

I have several collection classes that contain Data from a database.
I need to add a .sort method for each of them, where I dynamically pass the property to be sorted and the...

Hi out there,
I have a problem around a usercontrol that I've developed.
On a Form I have several instances of the usercontrol. On changing a combo on that control it gets data from a database,...

Hi out there,

I've got a problem with the package & deployment wizard in VB, after we upgraded from CR8.5 to CR 11.
The setup that is built just does not work, when CR is called, the application...

In general I recommend to use 3 Classes.
1) Basic class which properties represent the fields of a table
2) collection class for the abovementioned one
3) Class that handles the database connect...

@deepbuti:
AFAIK the round function of Microsoft is just buggy (not only in the context you've described in the link you gave), just don't use it.
It is much better to write your own round...

Hi George,

to round 3.305 to 3.31 is absolutely correct (based on 2 decimals), I just do not understand why you want to get the wrong result??

int or fix should do that. Depending on the question what you want to do if you're dividing something that return negative values:

dim retval as integer

retval = int(51/2) ' returns 25
retval...

@Shuja: ???

@jason:

Solution 1
in class b:

private mClassA as classA

public propery get cClassA() as ClassA

Select top 1 [fieldnames ...] from [Tablename] ..... Order by Primary key desc

delievers the first and

Select top 1 [fieldnames ...] from [Tablename] ..... Order by [Primary key] asc
...

Hi Rahul,

IMHO your code is not very safe:
- It assumes that you always have a ascending sort by the field of the primary key (-> Auto Number) as a part of the query.
- It is completely...

Hi,

I disagree with all the previous posters, as from my experience (in my company we tried to convert several Access97 clients to newer versions i.e. 2000) you can forget about making the app...

Hi out there,

I have a Report that gets its data from a database, and is filled by passing first a Parameter to a text field in the report that is later used to filter the records that come from...

Hi,

why don't you just create an unbound recordset (please do *not* try to use recordset.clone!!), fill it from the database, and when clicking on the post- button save it to the table? You then...

Hi Wizbang,

that's impressive,
and a solution that I can use in another context for code optimizing for a task that I have currently (Resistor and capacitor values that I get from a database are...

Hi Wizbang,



AFAIK you're absolutely correct.
But to be honest, nowadays I just do not consider the need to check the resources having a high priority.
IMHO it is just a matter of concept,...

Hi,

you have to set the .cursorlocation property of the recordset to aduseclient.
It is quite clear that .recordcount cannot work without this, as the recordset object "assumes" :) that the...

This looks like a problem of handling the classes.
I would recommend this

- create for every class (Prefix cls here) that is / would be used in a 1:n relationship in Database tables an...

Just curious:

Is there a reason why you are not using the .Filter-method of Adodb.recordset?