VB Forum / Database Access / June 2006

How do I use DAO.36 code to add  3 fields to existing Access 2000 table
Thanks in advance

  I am looking for XML merging for the following scenarios. I want to load both the input files and show in the tree viewer and highlight the differences. Now its up to the user to select the correct node. Any non conflicting differences should be automatically merge onto the ...

i am a beginner in VB6. I am making a project using MSAccess2002 and
VB6. Theres a table
Table1(SKILL, EMPNO, DEPTNO)     and a Query - Query1 that i made in
MSAccess.

what is the syntax for asc function in VBA if the argument is "
? asc (""") returns, as expected an error message!
thank you!

I'm having problem with using DAO recordset in MS Access 2000 to append
record into a
table. Following is the code:
   Dim wkSpace As Workspace, db As Database

I'm trying to use VB in word to automatically save and send a form via
email.  I've figured out the email part and some of the save part but
I'm curious how I could make the file save with a dynamic name based on
data entry by the user. For example, when someone enters there name

Has anyone attempted this? I'd like some info on how to accomplish this if
possible. I'm not even sure what the filemaker table names are but I can
find out.
Best regards,

I am trying to populate a combo box with the names of all fields in a table
except non-autoincrement and memo fields. I am having trouble determining the
field properties in ADO. The following procedure shows the ADO code and the
DAO code.

I am returning  value from a stored procedure to vb 6.0 function. But I
think something is wrong in the SP or in the function. Its not returnig the
value proprly:
Below is my SP:

I was earlier using recordset and query in my vb code. But since I want to
implement transactions in my code to avoid any errors, I need to use sql
stored procedure instead of sql query. Below is the code i tried to use, but
i get error message: "Mehthod or sub not found" and the ...

I am trying to optimize my code for reading from an image column in an ADO
recordset using GetChunk.  With the below code an 'Out of Memory' error is
sometimes raised if the value in the column is too large.
<...>

I have a access front end(1) which connects to another access application(2)
to get data. I am calling them 1 and 2 to avoid confusion.The application 2
has the data source being moved to an sql server database.
Now my question is what do I need to use at in 1, in order to have ...

I have created a SQL and store records in a recordset.
How can I retrieve each row of records in the recordset?
More information for you:
I have added an "ORDER BY" condition in my query because I need to calculate

I created a database in MS-Access 2000 mdb as 2000 file format. When I
open it in VB 6.0 at Add-ins --> Visual Data Manager, it gives message
'Unrecognized database format'. I already applied vb6.0 sp5. My all
data is in this mdb. I also want to create form thru Visual Data

I currently have a front end desgined a coded (two forms), and the
backend (tables) are located in a different .mdb. My problem is that I
want two or more users to be able to use forms at the same time. I
tried just leaving it default, but if one opens the file, the other