SQL Procedur with many of Records
Sat, 13 Oct 2007 19:07:58 +0200
Hello,
perhabs anyone can help me.
Ich have an Procedur on an SQL Server.
This Procedur returns one or many Records back.
How can I get this as an Recorset via VB or VBA?
I can't change the Server SQL. Or make an new querie.
Thanks
Sincerely,
Marius ...
|
¹Å¶£¨1912-1949£©Ãñ¹ú´É²èºø528°Ñ¡¢´ÉÆ÷400¼þÇë¹ÛÉÍ£¡Antique 1912-1949 Porcelain teapot 528 chinaware 400 invitation visit
Fri, 12 Oct 2007 17:15:09 -0700
¹Å¶£¨1912-1949£©Ãñ¹ú´É²èºø528°Ñ¡¢´ÉÆ÷400¼þÇë¹ÛÉÍ£¡
È«±£ÕæÖлªÃñ¹ú´É²èºø528°Ñ¡¢´ÉÆ÷400¼þÇë¹ÛÉÍ¡£
Ð콨ÐÛ
¹ÅÒÕÐù¹Å¶ÊÕ²ØÖ®¶¼
ÍøÕ¾£ºhttp://www.xjx588.com
µçÓÊ£ºxjx_588@tom.com
xjx_588@126.com
µç»°£º0575-83103731
ÊÖ»ú£º13002632782
Antique 1912-1949 Porcelain teapot 528 chinaware 400 invitation visit
Website http:// ...
|
Issues accessing MDB
Fri, 12 Oct 2007 10:07:46 -0400
I've been able to successfully develop a program that pulls data from an MDB
file and exports it intoa VNC file for remotely accessing workstations at my
network. The program works fine on the computer I designed it on. However,
when I attempted to access the program from another computer (general
manager' ...
|
write data into a field which is located on exact row number
Sun, 7 Oct 2007 11:18:08 -0700
Hello, everyone. does anybody can help me out? I want to locate and write
data into the empty field which I konw is on 101 row. there are 5 rows need
be writen.
After debug the row number moved to 283 for some unkown reason.
Set db = CurrentDb
Set rs = db.OpenRecordset("master")
rs.MoveF ...
|
covertaccessoproject with secure dbs
Wed, 3 Oct 2007 10:58:02 -0700
hi, i am writing an upgrade for a legacy access 97 application. My new
application (written in .NET) will upgrade the existing access 97 app to 2003
upon completion of the installer. I have been successfull in converting the
97 database using the application.convertaccessproject method, however
because the ...
|
A question on Access Report header format
Tue, 2 Oct 2007 15:23:02 -0700
Hello,
I'm building a customized payroll report in Access in which some of the
headings have a vertical orientation. The problem is, I haven't found a way
to change the direction of the vertical text. I'd like this text to be read
from bottom to top. So far, I can only produce vertical text that reads from
...
|
CopyFromRecordset vs Ado.recordset filter
Sun, 30 Sep 2007 01:21:00 -0700
I created a recordset and now I need to use recordset filter to export data
into excel.
I use the CopyFromRecordset method to export data into excel
When I use this method using the recordset filter, it ignores the filter and
CopyFromRecordset export to all records to excel.
There is an away to export dat ...
|
|
|
Close recordset
Sun, 30 Sep 2007 01:01:01 -0700
How can I detect if any recordset is open and then close it?
Is it possible to do this procedure?
I appreciate any suggestions.
Thanks
jcp
--
Jose ...
|
Re: Binding Visio Object (shapes) into Access forms
Fri, 28 Sep 2007 17:21:37 +0200
"SY" <SY@discussions.microsoft.com> a écrit dans le message de
news:96863787-BF07-4951-B16C-9567D017DD9B@microsoft.com...
> Does anyone have any suggestions or recommendations in how to bind Visio
> objects (shapes) into Access 2003 forms? Right now, when I add Visio
shapes
> with Textbox on Access forms show ...
|
Word vba macro
Thu, 27 Sep 2007 15:46:03 -0700
Have a word vba macro that has been working fine with access 2002. Brought
up access 2007 & converted the 2002 files to 2007 format (.accdb). Its a
front end back end db. Now the word vba program no longer works. I get a
3343 error. Here is the statement that fails:'Set dbsDb =
opendatabase(strdbp, Options: ...
|
