I am writing a calendar application for my Church as follows.
1 Outlook exports its data to a CSV file in "Windows" format.
2. I use VB6 code to transfer the data from the CSV fil...
Front end : Visual BAsic 6.0
BAck end: Access(Visual Data manager provided with VB)
I have problems on VB.
First Question.
-------------------
I have a table with field serial numbe...
Hi,
At the moment we have invoices created with Crystal Reports 4.6, which works fine for us, but replaces some Czech characters with wrong characters.
So I have to make invoices datarepor...
Hi,
My access DB has a number of functions that import data from external sources such as text files. The import operations work well; however, sometimes, ImportError tables are generated. ...
I have an existing dbf table, that I would like to add an additional column.
I have tried 2 different ways without any success.
1st way. (gDBDIr is the directory where the dbf files exi...
I want to give my user an option to create a new database or open an existing one...
i am usign common dialog box-save for new database...where the databaseis saved with extension new.mdb. bu...
Hi,
We have a VB application running of Laptops using Wireless Network adapaters for connecting to the central server Oracle 8.1.6 database.
Our application maintains a persistent Databa...
I work with an Access program in which VBA code sitting behind a user form generates Excel charts based on Access queries by importing chunks of SQL.
The program works fine except for when ...
I have the following RowSource set to a listbox:
Me.List248.RowSource = "SELECT Products_PackageDetail.ProductID as [ID], Products_Main.Name, Products_Main.Price FROM Products_PackageDetail...
I have an application that was written in vb. The application runs off the server and is shared by several users. I can run the application from any machine and it runs fine except for one c...
According to the following code, why always the result in MsgBox = -1
------------------------------------------------------
Dim conn As new Connection
Dim rs As New Recordset
conn.Co...
Hello all, I have a question.
SOME HISTORY: I have implemented a DTS package that allows me to import data from a FoxPro dbf file. The only thing is, because the version of the dbf file is o...
In a vb6 appln, I am inserting current time(datetime.now) into an oracle database. But it fails if there is inconsistancy in the Oracle date and VB6 date format.
Is there a generic way ...
Dear all,
We have a question in database programming with Visual Basic and Oracle 8i.
We are using stored procedures(grouped into packages) to get data from the database using the OraO...
Hi All
Keep getting -1 on the recordcount, any help is appreciated
thanks
Private Sub FindByClientRef()
Dim objConn As ADODB.Connection
Dim rstResults As ADODB.Records...
In VB6 using an ADO connection, my application will sometimes generate the error "Could not use ''; file already in use." . Folder settings where DB resides is set to Full control - all users....
My app is erroring out on the code below...
Me.TableAdapter.Fill(Me.DataSet.Table, variable)
Dim row As DataSet.TableRow
row = DataSet.Table.Rows.Item(0)
If row.DateTimeField is DBNull...
I need to use bind variables to insert a date-time into an Oracle DB column of type date.
The problem is that the time portion of the date gets truncated in Oracle. I know the SQL to inse...
Oracle 7.3.3
VB 5
Object : execute a PLS/SQL procedure with TABLE of RECORD as parameter
Details :
I want to access an oracle stored on an oracle 7.3.3 database. The problem is that I ne...
Can i use an XML File which was exported from an ADO Recordset as an input for a Crystal Report.
So, Basically i dont want the Report to access the Database directly...instead i can export ...
Hello all. I am about to start migrating data from an old MS Access db to a new version. In order to author a decent module to do this i need to be able to get a list of all of the field nam...
I am trying to use the rs.update function for the first time since i am trying to write some binary data to the
microsoft table. I am used to using rs.open Sqlstr, cn syntax to insert and upd...
I am new to Visual Basic, so please humour me even if this is a dumb question!
I am using VBA in Excel 97. I have used Objects for Session, Database and Dynaset.
I can execute Oracle sto...
option explicit
dim u_name, p_word
on error resume next
u_name=inputbox("Enter your user name: ")
u_name="SERVER\" & u_name
msgbox "The name you entered was " & u_name
p_word=input...
Hi i would like to ask what is the meaning of vbCr and vbCrLf
