VB Forum / Database Access / December 2005

All the examples that I have used deal with a single form for everything.  I have multiple forms and
am not sure what I am doing is the correct way.  Although I have a couple of areas (forms) that are
questionable, this post deals with one form, my FrmSearch.  The program works ...

On my windows xp sp1 computer ( checker shows mdac 2.7 rtm ) my application
uses an access 97 data with jet 3.5 (jet 4.0 connection also works fine)
but on a different xp computer, same application,  I get run time error 3607
(I do not know the mdac version)

I made application where is a part of code using SQL syntax with ADODB
object. I get error message at SQL Statement when It used in other
machine that was choose regional setting by Indonesia ( OS: Windows XP
Profesional Edition SP2). look at following a piece of code:

I'm using Visual Studio 2003, VB.Net.  I have loaded the Merant ODBC driver
for Sybase.  I am accessing a Sybase DB using the following constructs:
   Public ConnectTP As New ADODB.Connection
   Public RstTP As New ADODB.Recordset

I'm creating a new Access table using ADOX. I can add columns and
indexes, but I'm baffled on how to change field properties.  Can
someone give me a hand?
Want to change properties such as: Description (Column property?),

warning:
self taught beginner vb6/ado learner here.
Been reading posts/ngs/googles/msdn etc trying to grasp database concepts.
system context:

I am using VB6 connected to a MS Access database.
1.) When clicking on the arrows on a DAO control to move to a previous,
next, first, or, last record, how do you cancel that action? As soon as you
click on the button, it jumps to the Validate event. I know it's simple, but

Hi, I am using Excel to get data from Access via ADO and would like to
have a check on a the 5th column.  I want to see if the value is over
100, then change the font color to Red.
I step through the code, and see that it hits my check and drops to the

I'm using ADODB.Command object to update SQL Server table from VB6 app.
I need to update one of the fields with NULL if Text in the TextBox
associated with that field is empty.
I tried to use CommandText for Command:

I know that with \r\n it is possible to enter vbCrLf
into a string so that I can enter an multiline text
into a varchar field at mysql.
Now I need to do the same with an ms access database,

have created an stored proc which inserts data  - all works
in the same stored proc at the end I try and return the NEW unique ID
Problem: when I call set rs = cmd.execute (cmd being my adodb.command)
object

I have been writing T-SQL procedures for several years now but have not
called any of my procedures from VB. I am writing some test code to see if I
can do this but I don't know what the syntax would be to merely exec a
procedure.  I have created the query in a string and have ...