Visual Basic
Visual Basic was derived from BASIC and enables the rapid application development (RAD) of graphical user interface (GUI) applications, access to databases using DAO, RDO, or ADO, and creation of ActiveX controls and objects.
Application
Database
Remove
Platform
Any
License
Any
Hello,
We have a VB.Net application that runs on a network with about 10 workstations reading and writing to the same MS Access database.
We occasionally get locking problems. Also, the program...
0 Then
: : : .MoveFirst
: : : End If
: : : End With
: : :
: : :
: : : C:\Dos
: : : C:\Dos Run
: : : Run Dos Run
: : :
: : :
: : :
: : :
: : Hey thanks it seemed to...
0 Then
: : .MoveFirst
: : End If
: : End With
: :
: :
: : C:\Dos
: : C:\Dos Run
: : Run Dos Run
: :
: :
: :
: :
: Hey thanks it seemed to work better, and it's much...
0 Then
: .MoveFirst
: End If
: End With
:
:
: C:\Dos
: C:\Dos Run
: Run Dos Run
:
:
:
:
Hey thanks it seemed to work better, and it's much easier to keep track of...
: : : Hi to everyone,
: : :
: : : For most of my apps, when data handling is requested, I'm using an Access DB to store/retrieve data.
: : :
: : : With that no probs.
: : :
: : : Now, I'd...
: : Hi to everyone,
: :
: : For most of my apps, when data handling is requested, I'm using an Access DB to store/retrieve data.
: :
: : With that no probs.
: :
: : Now, I'd like to give a...
: Hi to everyone,
:
: For most of my apps, when data handling is requested, I'm using an Access DB to store/retrieve data.
:
: With that no probs.
:
: Now, I'd like to give a 'security...
Hi to everyone,
For most of my apps, when data handling is requested, I'm using an Access DB to store/retrieve data.
With that no probs.
Now, I'd like to give a 'security power-up' to the DB...
: : : I have the following code that is failing, please help
: : :
: : :
: : : dim sql as string
: : : dim rs as adodb.recordset
: : :
: : : sql = "Select blah, blah blah from Customer"
: :...
can somebody tell me how to execute the sql views in visual basic or open it through recrdset
0 Then
.MoveFirst
End If
End With
End Function
ok.. It seemed to work, but when I created a form, and loaded a text box, and button and assinged the button on click to run the...
Mmmmmmm...I'm not sure about one SQL command able to perform the whole operation. I think that the solution is a 2-step one, as You suggested. I'll try to check if there is such SQL command, in that...
you are using DAO? DAO only supports Access 97 databases, Try using ADO
: : I'm trying to write a piece of code which will update a MS Access database. I'm a newbie and Im trying to follow a...
Hello
I am working on a database app but am getting this error "Item cannot be found in the collection corresponding to the requested name or ordinal. The combobox is getting filled as far as...
SQL commands are basically the same either we use SQL, access or ORACLE db. i have no problem executing operations and functions within the same database line as in your example. on your example...
: strSQL = ("SELECT * FROM tblFirst WHERE First_ID = lstNames.ItemData(lstNames.ListIndex")
:
What would SQL know about your listbox? You need to move the VB portion out of the quotes so...
, or item in query expression First_ID = lstNames.ItemData(lstNames.ListIndex.
' take value from ItemData property use it to build a SELECT statement to locate
' record that matches value...
SELECT first, last, other, first + last as suma FROM mytable ...
I didnt try on SQL Server, but at least you should try, it works fine in ORACLE and Access.
: yep, this will help. i'll do...
I will try...
dim objExcel as Excel.Application ' early binding
set objexcel = new excel.application
objexcel.open "xxx.xls"
rem objexcel.workbook(0).worksheet(0).range("A1").value = "new...
DAO ONLY RECOGNIZE ACCESS 97.
: : My application uses "Microsoft DAO 3.51 Object Library" and my databases are in Acess97 but when i try to access a Microsoft Access2000 database, an error occurs...
