VB Forum / Database Access / April 2004

Our VB program has a feature where if a product item number button is
clicked, it searches in a particular folder for a jpeg image of that item
and displays it on a form.    We have an on error condition that if the jpeg
isn't found the form still pops up, but it is blank.

Please help me, in VB6 with TrueDBGrid 8 and ADO 2.8 and Access 2000, I´m
receiving this message when I insert a new record in grid: "Row cannot be
located fo updating. Some values may have been changed since it was last
read."

When someone modifies a field in a table, I like to find out which
field he/she changed.
Currently, only the LAST person to modify an object is saved.  For
example, if I modify an Application record, I will see "MyName" in the

It's real simple. I'm trying to query a FoxPro table using a date as th
filter
sSQL = "select custnum from contact.dbf where dated < " & mDat
mDate is string var which is generated every day like 04/29/2004

I want to import and read an Excel file into my vb application. I use
often adodc or an adodb.recordser objet to access database.
Please show me the way to do it.
Thank for all.

I have a query in Microsoft Access that uses a function. When I call this query from VB, I get an error message that the function is undefined. I can run query in Access with no problem and see the resultset
Any suggestion
Thanks in advanc
Ray

Using Openschema I can get the list of store procs and
views in Oracle.
Does any one know the syntax/whereabouts of the tables
holding the triggers and UDFs and the text of SPs and

I have been building a large DB application and now wish to review the
transaction management.
All I've read shows similar to the following simple code
_____________________

Greetings! I am a newbie so thanks for your patience
I would like to insert the current date and time in column Appointment.CheckInTime via a stored procedure. Here is my ADO code so far (in Access 2002 app) followed by the stored procedure
I get a syntax error on the "WHERE" line ...

How can I have a command button save my access database with a new name (incuding the data if possible) and create a new database with the original name, original forms & queries but empty of records, (that is save the structure only)? Thank

I've written some code that should call a stored, packaged Oracle
procedure that performs an insert of a single record into a table.
The procedure accepts input parameters for each of the columns and
returns a single output parameter that contains any errors found.

Ive been using VB6 ( sp5) to connect to a SQL server using a DSN and SQL authentication. I have run into  afew difficulities and it has been suggested that i should try using Windows authentication on the server instead.
to this end i have set up a dev server to look at this ...

I'm having the weirdest problem since Monday after editing a VB6 method
that has been working fine for five years now:
This method saves data from an object to a table in an Access 97
database file using Jet 3.51.  I have added a few fields to the object,

Hi, everyone!  I hate to sound like a simpleton here, but I'm working on a student project with my cohorts as a final, and we're in desperate need of help :(  Using Visual basic 6.0 and Access 2002, we need to create a progam that will allow students and visitors to the school to ...

    I have created small database programs using VB6 and access as the database..
Now i need to use Foxpro tables.. I tried.. i was able to connect using ado(oledb for) But for fields with character data types the white spaces reflects in my controls ex:("Philip__________"(_ is ...