VB Forum / Database Access / April 2004

I want to extract weekly report from access dataabse into recordset.
Scenario is as follows
WEEK        Number of SMS
  1                        50

I am using a form that when a button is clicked, it executed a select into
statement to create a new dbf file.
However, every time when I press the button, I get this error
Run-time error '-2147217900(80004005)'

I have downloaded an Access97 database which I want to use with my VB
project.
However every time I try to open it in access to view the tables it
complaines that I am not a member of the workgroup.

In VB 6 you could design a database file directly from VB without needing
SQL or Access.  Does such a tool exist in VB .Net 2003?
Regards,
Randy.

My old development computer, Windows XP Pro, Visual Basic 6 SP5, used then
following with success to fill a VB6 recordset from an ASP page, but my new
computer, Windows XP Pro, Visual Basic 6 SP6, gives an error:
SomePage.ASP looks like this with no HTML:

Hi, I'm new to VB but quite proficient using Access. I want to rewrite my Access application front end in VB and still use the Access back end with the possibility of migrating the data to SQL in the future. Can someone please suggest the best method to use for connecting to my ...

I'm trying to set up a pair of combo boxes so that you may select from
the first to load a specific list into the second combo box.  The code
of the class module for this part is:
Public Sub editBookFillItems()

I have a simple form with, among other things, an ADODC data control (called
"Adodc1"). The ADO connection to the database tests fine but when I try to add
code to any of the Adodc1 control's event procs and then run the app I get a
compiler error:

Using the following select statement running against an AS400/DB2 database with client side cursor
Where CLWH = '02' AND E1RUN# BETWEEN '04-082%' AND '04-092%' AND (CRTYPE = '' or CRTYPE = 'O'
Last week if I wanted to include all records between 04-082 and 04-092 I had to use as ...

I'm trying to connect to an Access 2000 DB recordset from VB6 SP6a,
and I keep getting the following error message:
Run time error '13'
Type mismatch.

Greetings, Friends.  I know this is a simple question but I haven't got the foggiest idea how to fix it.  My simple exe with an ADO control works fine on my machine (with has VB 6.0) on it.  However, it won't work on other machines.  The first error message said that I needed the ...

Bizarre problem - I'm using ADO 2.8's adAsyncExecute method, to call procedures asynchronously. In calling a stored procedure on SQL server, if this procedure has errored, it doesn't seem to be able to detect this in the ExecuteComplete event. None of the other events such as ...

  i want to calcuate a string formula looks like this "150000*0.08*91/365+20000*0.08*38/365" in VB, how can i achieve it??

I have a form with a ListView that has several columns, one is Date...format (MM/DD/YYYY)
The date are sorting by MM
Trying to figure out how to sort the dates by YYYY, then next by MM, then next by DD

Been trying to track this one down for awhile now. Occasionaly, I'll get the
message "Could not update - Currently locked" error when saving a record. At
the time the error shows up, there are no locks on the database (I'm the
only one in it). I can try again in a few minutes and ...