Search:

Hi, everybody!
In Access when you right click on a column, appears a pop-up menu, where you can filter records, change sorting and so on.
Does anybody know how I can do it in VB. I don't mean to...

1. Did you put
rst.MoveFirst before Do Until?
2. I don't understand what you mean "Yet if I use "stemp" = tide(from textbox)"
3. With this line
Set rst = objcmd.Execute(, stemp & "%")
...

Did you put
rst.MoveFirst before Do Until?
Did you copy my code or just modify yours?
I didn't get any errors on my computer.

Try this


With objcmd
.CommandText = "sp_description"
.CommandType = adCmdStoredProc
.ActiveConnection = cn
End With

stemp = txtInfo.Text

Hi, there.
Could you post exact syntaxes of your stored procedure?
Did you hard coded 'stemp' in your sp or you used variable?

Hi, there.

You should use wildcharacters with LIKE:

'select proddesc from marcprod (index = mydesc) where proddesc like '%stemp%'

if you are looking for exact word 'stemp', then

'select...

The string in a where clause should be inclosed in single quotes.

This line is totally wrong:
strCLID = "select * from tbldigidoc where tbldigidoc.Cl_ID & like & strCLID"

It should be:

strCLID = "select * from tbldigidoc where tbldigidoc.Cl_ID like '" &...

Try this:

SELECT candidate.*, candidatehistory.*
FROM candidate INNER JOIN candidatehistory ON candidate.candidateID = candidatehistory .candidateID
WHERE candidate.candidateID= 4242424242
...

Hi, there. Did you try that:

SELECT candidate.*,candidatehistory.* from candidate,candidatehistory where candidateID = 4242424242

What datatype is candidateID?

It doesn't work this way.
SaveSetting alows you to access and save YOUR application specifics in ....\Software\VB and VBA applications or something like that. If you want to access any other keys -...

You can use Space function:

cboemail.AddItem ![Name] & Space(5) & ![email_addrs]

or

cboemail.AddItem ![Name] & " " & ![email_addrs]

Hi there.

DAO and ADO uses different methods to open recordset. Check Help. There may be other differences as well. Why did you switch libraries?

Hi.

You don't understand meaning of EOF and BOF.
BOF — Indicates that the current record position is before the first record in a Recordset object.


EOF — Indicates that the current record...

Hi, there.

You can try this:

Add Microsoft ADO Data Control 6.0 to your project.
Put it on your form. Right click on it, choose ADODC Properties. In General Tab check Use Connection String and...

Hi, there.

Try this:
Open Crystal Report in a Design view, right click on the field you want to change. Choose Format Field. Click Tab Number. Change value in Decimals box to 1.

Hope this...

Hi, smh.

First of all monte96 is right, you should declare database and recordset in Option Explicit.
Second - if rst.EOF is true you cannot use .MoveLast ,only .MovePrevious. EOF is not the last...

Hi, Afroide.

Try this:

1.Open report in a Design view, Click on the Group Footer or Report Footer (which one you don't want to see) and delete it. Summary information are displayed in a Report...

Paul Lewis,

Sory to tell you that it will never works in general because not every control within a form will have property Value. And that what is triggersd "Invalid use of property mentioned...

From Windows SDK:

126 The specified module could not be found. ERROR_MOD_NOT_FOUND

Regular datacontrol won't work with Access2000. You have to use ADO datacontrol.

Thom,
Check this post.
http://forums.vb-world.net/showthread.php?threadid=22135

Well Sarun ...

on error goto WrongDate
MyDate = CDate(AnyString)
on error gotot 0

That will work in any cases (including leap year.

srl !

Throw away line control, put Image control, make it thin as line and you will get a click event.... I think.

It is not about system events, realy.
I uderstand this like:

VB doesn't have a control over COM port because COM is a sistem device, end servised by system. But VB is notified by OS about any...

Are you working with COM ports? If so then dont foget that COM ports operate asynchronicaly. You are using loop with out DoEvents and you perfom some codes before Waiting 15 msec. You have to be sure...

Quite theoretical topic....

In one book (don't remember the name) author called Public variables of the class as "parameter". You like it or not it is quite a nature of public variables. If...

Can not find any info on this subject, Help !!!!!??????

I don't have that CD but I will check it out.
Thaks for direction.

Windows 2000 .....
The standard scheme in W2000 is different from W98 by colors (I can live with that) and default system font.
System font now is "Tahoma" and the problem is:

As soon as VB...

kedaman


Open Filename For Binary As fnum
File = Space(LOF(fnum))
Get #fnum, , File
Close fnum
For some reason File(a) returns empty string all the time.
What am I...

Looks promissing, I'll give it a tray.

Yes HeSaidJoe, now you got to the problem.

You see. The dos command is idial, the only thing is that it (shell) runs it asychronicaly. The next action in the application is to read from appendend...

Thanks.

I got to this point myself but the problem still remains.
The result of DOS commant copy A:*.txt c:\temp.txt is the only file, so maybe the question should be "How to append files"

Thank you , but you are missing my point: CopyFile does not take a "wild card". Otherwise I would not have a this question.

What would be an equivalent in VB for a simple DOS command?

copy A:*.txt c:\temp.txt
del A:*.txt

Or maybe someone can give me a hand to run such BAT file with help of Shell. the problem with...

Do you refresh recordset after delete?

What is a purpose of doing this?

And UDT are not objects so:Plugins.cls
'This is The Plugin Class

'local variable(s) to hold property value(s)
Private mvarmnm As PLUGIN_AUTHOR 'local copy
Friend Property Let Plugs(ByVal vData...

What is wrong with Friend?