Database
A database is a structured collection of records or data.
Language
Basic
Remove
Platform
Any
License
Any
MS ACCESS ERROR ON OPENING A SUBFORM
1. For some records, when I click on a button to open a subform, I get an error. It appears to happen when 1 of 3 different fields for that record is null....
if you're using a connection string then set yur datagrid datasource to the recordset where you store the data.
set Datagrid1.DataSource = RecordSet
Datagrid1.Refresh
I installed SQL Server 2008 Express, basic edition (SQLEXPR32_x86_ENU_Bootstrapper.exe, version 9.0.30729.1) without any problem.
Then I attempted to install AdventureWorks Sample Databases for...
It's acually a better idea to make an rpg within visual basic because visual basic is better with databases such as mysql.
as far as I know yes. If you can establish a connection to a paradox db then simply use a TQuery component. SQL syntax is almost standard as I understand (some slight differences). basic statements...
I am trying to code "group by" function in Visual Basic. This is what I am trying to do:
I have these fields: EmpID(), Date, TimeWorked(). I will have multiple entries for each employee.
I need...
Hi There
I've been trying to get an application i am making to get data from a access database, but in totally stuck.
So far I've set the database up and established a connection with visubal...
It was working alright. But suddenly when I format the sql statement taking the variables and concatenating them to from the Insert Into Statement the error is there "Syntax Error in Insert...
: I'm a student and i'm working on some Access database system. It's
: an atm system project and i need the daily limit value to update
: back to 300 every 24 hours. I'm using Visual Basic to...
I'm a student and i'm working on some Access database system. It's an atm system project and i need the daily limit value to update back to 300 every 24 hours. I'm using Visual Basic to program the...
there are no stupid questions, just stupid people.. well, then i am a stupid person because i don't know sh*t about this stuff.. i am a graphic designer/ website creator.. i've made successful adult...
Ok, i solved the problem
The problem was in the connectionstring
this way, works fine:
Private m_Connection As String = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\ProjectoCefalo\GestCeph\GestCep...
I've converted code from my Visual Basic 2005 application that used microsoft access 97 in order to use SQL Server 2005, but i'm having problems on saving records. V.Basic gives me no errors but the...
You should be able to find many, many, many examples online. If you have specific questions they are more likey to be answered here. You can find basic information on how to use ado.net here...
: : Hi,
: :
: : Is it possible to add list of records to report dynamically?!
: :
: : I would like to display something like;
: :
: : ID Name Surname
: : ------------------------------
: :...
: Hi,
:
: Is it possible to add list of records to report dynamically?!
:
: I would like to display something like;
:
: ID Name Surname
: ------------------------------
: 1 Jonh Major
: 2...
: i am trying to make a login form wherein it will open another form
: if the user's input is registered in the sql database.
:
: here's my code:
:
: Dim conn As New ADODB.Connection
: Dim...
i am trying to make a login form wherein it will open another form if the user's input is registered in the sql database.
here's my code:
Dim conn As New ADODB.Connection
Dim rs As New ADODB...