VB Forum / Database Access / November 2007

I am using Microsoft Visual Studio Team Edition for Database Professionals
Version 2.0.50727.354. I have imported the schema for my database. I get a
warning saying that an external db reference to master cannot be resolved. So
i import schema for master then i get the following ...

I have a data base table (in FoxPro DBF table) which has a definition
of Numeric(5,1). I have understood this to mean that the total field
width is 5 digits with one being a decimal digit and within the 5
digits there is space for  decimal point so that the largest value can

I have a date type field that is 23/11/2007 14:30:45 and I want to
convert to 2007-11-23 14:30:45. How can I do that?
I used
Format(TTime, "yyyy-mm-dd") where TTime is the variable that stores my

One of my VB reports is showing me this error below:
The XML parse error 0xc00ce56f occurred on line number 1, near the XML
text "<?xml version="1.0" encoding="utf-16"?>
etc..

I need to disable the minimize button in an Access 2003 database application
*NOT ON A FORM* in the Access application menu bar.
I know how to disable the CLOSE button using the following code. I have
played with this for hours but cannot change it so that the minimise button

I have an Access application in which I "Startup" with
a main form and hide the "Database Window".
I want to add a button so that it will initiate the
"Merge It with Microsoft Word" wizard on a specific

How do i code for "peel off effect" of text in a label control?

Please note that there could be a possible cross post as I originally posted
this elsewhere and was advised by an MVP there to post the question elsewhere.
We have the environment mentioned above. The Server OS is Windows Server 2003
SP2 and the client machine is XPPro SP 2. ...

I have 2 ADODB connections in VB 6 project - one to SQL Server 2000, another
one to Intuit QuickBooks data file via ODBC.
Is there a way to make selection from both, for instance (of cource it's not
working statement):

IHave received a file <filename.BDB.wdb>, which my Microsoft Word 2002 (from
Office XP) will not open, nor Access nor Excel. I understand I need a
"different" Microsoft "Word." All i want to do is open the file and read it.
Any suggestions? Thanks.

I am trying to add records to an access database in code with vb2005 and
having problems. I am fine using vb6 but problems in vb2005! Can anybody
help as i dont want to use databound controls.
Thanks

This is a good one that's baked my noodle!!
I have a standard table with lets say 2 cols:
NAME  string
DOB     date

Using Visual Studio 2005, VB windows app, trying to add a data source.  I
have system DSN's for two separate external databases, 1 MySQL and 1 Oracle.  
I have linked to both of these databases via Access successfully for years,
however neither of them works in VB.  Here are the ...

Private Declare Function GetForegroundWindow Lib "user32" () As Long
Public WithEvents IE As SHDocVw.InternetExplorer
Private Sub Timer1_Timer()
Dim strTitle As String

Hei all,
I need your help for this situation  :
I have a  appliaction in VB .NET  whose goal is to make the management
of the clients of my corporation.