VB Forum / Database Access / September 2004

I have the following fieldname in an Access_Table:
Field 1 = Cust_ID (Primary key)
Field 2 = Date
Field 3 = Description

I'm trying to execute a store procedure that updates my database.  Please
view the following code:
    Dim EventLogConnectionStr As String
   ' EventLogConnectionStr = "Provider=SQLOLEDB.1; Data Source=SQLSERver"

two tables in access .mdb file
   tblLength - two fields fsShape(text) and fdLength(number)
   tblShape  - two fields fsShape(text) and fdArea(number)
querying via vba running in autocad

Hi. Im trying to solve a problem that envolved transactions, VB and Access.
The cuestion is that I work with Access to
develop third tie in small works, but working with transactions from VB and
ADO, the concurrecy of more than 2 users in the same operation (new

i am trying to create a project with no back ground form just the
picture boxes, labels, buttons, ect. ect. if this is possible please
help
thanx

I have multiple users trying to access and update a table of a database
This code gets the current Job Number from a Table and increments, updates
and returns the value.
but then two or more users are using the application I get this error:

Is there a way to automatically close Windows applications so that backups
can be performed after hours.  If any application is left open and files are
open as well, these files cannot be backed up to the network server.  I'd
like to run a script that will copy .pst files and 'My ...

I tried a million different ways to make this work, but cannot find a
solution.
I have opened a recordset via a ADO connection to an Access DB. I have
a form that  requires three boxes to be filled in. I then use that

Hello, I have a database extracted to a tabbed delimited file and I
need to extract certain fields in VB.  Example tabbed file:
data1     data2     data3     data4
data5     data6     data7     data8

I want to create Index in Access using ADOX/DAO in VB. Currently I am able
to create index. But i want to set up Indexed property to 'Yes (Duplicates
OK)' for a column which i am not able to set.
Please Help me to set this property.

I have built an Access 2000 application that contains several Recordset.Open
method calls, using CurrentProject.Connection as the Active Connection
argument.
These calls are all successful when I run the application locally. However,

Hi. Im trying to solve a problem that envolved transactions, VB and Access.
The cuestion is that I work with Access to
develop third tie in small works, but working with transactions from VB and
ADO, the concurrecy of more than 2 users in the same operation (new

I don't know why when I double click a combo box , there is no
response at all although I have written the code. But when I use a
Datacombo instead, it can run the code. Is the combo box cannot be
double clicked ?

Does anybody know a tool that could help me finding unused functions
on my VB applications?
Thanks for your help.
Bernard Davest

    I am developing budgeting application that facilliatates user
entering expenses and incomes and in the end i would like to present
user his expenditure report.
    In Expenditure report I want to show user both expenses and