msvisual.com Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

VB version of a VBA command

 
Post new topic   Reply to topic    msvisual.com Forum Index -> VB Syntax
Author Message
mikejs2000



Joined: 04 Oct 2007
Posts: 1

PostPosted: Tue Jul 04, 2006 12:02 pm    Post subject: VB version of a VBA command Reply with quote

Hi,
I am a vba developer that has now to produce a VB6 program due to
constraints in various comms areas.

What I need to know is, is there a VB6 command that does the same as the VB
command DoCmd.setwarnings, I have a seek command acting on a data control
that when a input is not found a message pops up stating record not found. I
need to stop this poping up and be able to show my own message or do my own
action. The Record not found error does not seem to have an error number
though I believe it does.

Thanks for the help

Mike J. Soames

Archived from group: microsoft>public>vb>syntax
Back to top
View user's profile Send private message
Jan Hyde



Joined: 04 Oct 2007
Posts: 1211

PostPosted: Tue Jul 04, 2006 9:05 pm    Post subject: Re: VB version of a VBA command Reply with quote

mikejs2000 's wild
thoughts were released on Tue, 4 Jul 2006 08:02:01 -0700
bearing the following fruit:

>Hi,
>I am a vba developer that has now to produce a VB6 program due to
>constraints in various comms areas.
>
>What I need to know is, is there a VB6 command that does the same as the VB
>command DoCmd.setwarnings, I have a seek command acting on a data control
>that when a input is not found a message pops up stating record not found. I
>need to stop this poping up and be able to show my own message or do my own
>action. The Record not found error does not seem to have an error number
>though I believe it does.
>
>Thanks for the help
>
>Mike J. Soames

The best advice I can give you is to dump the datacontrol
and deal with recordsets yourself. Then you'll be in control
of what happens.



Jan Hyde (VB MVP)

--
People are like tea bags.
You have to put them in hot water before you know how strong they are. (Bill Rayburn)

Back to top
View user's profile Send private message
Display posts from previous:   
Related Topics:
Split command I have an excel .csv file generated by getting external data from a SQL server database. If the data in a column contains a comma, the data will be enclosed in double quotes. I tried to use the Split command to split apart the comma delimited fields, but

The STR command has disappeared I have been working on a project where I frequently use the STR function. The project file got modified and now that function is gone. It doesn't even register in autocomplete anymore. I assume there is some sort of "include" file I must have misplaced. A

Using Shell Command I'm wanting the ability to open any file from inside my Visual Basic 6 application, using the association program on my users machine. Not sure just what I'm doing wrong here, could someone check my syntax and offer a solution. dim lngRet

Shell to Command I have a VB6 program that shells to the dos prompt then opens an ftp session to an IP address (obtained from a text file) and reads ftp commands from another text file. The ftp session transfers a file from the remote device to the local pc. The output is

trim command unrecognized Hello, I've writen a VB6.0 program to run under Me and Xp. Now I've tried it on a Windows2000 platform. It didn't work. So I installed VB6.0 on Win2000 and started debugging my program. First I had to declare all used variables and ADODB commands and reco
Post new topic   Reply to topic    msvisual.com Forum Index -> VB Syntax All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group