Need help on choosing the language - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Programming - 葵花宝典

Need help on choosing the language

Need help on choosing the language# Programming - 葵花宝典

l*d2008-06-03 07:06

1 楼

【以下文字转载自 Immigration 讨论区】
发信人: TrueStory (不是幸福的坑不挖), 信区: Immigration
标题: Re: 请问网上查询case status
发信站: BBS 未名空间站 (Thu Dec 1 19:05:07 2011, 美东)
When I first got the email notice with the receipt number, I couldn't find
the case online, but I could find it the next day. The notice suggested us
to wait till we got the post-letter notice.
In LZ's case, the waiting has been much longer. However, I saw cases like
this that they couldn't check the case status till their cases were approved
. USCIS's performance is quite random on such things. I don't know for sure,
maybe LZ can call them to fix this bug?

c*y2008-06-03 07:06

2 楼

我的程序可以跑但是没结果。
rs.Field.Count是有结果的
rs.RecordCount结果是-1(肯定不对)
rs.GetRow或者掉rs结果都是error type mismatch.
我感觉是没有调出东西来？procedure肯定是好的，直接在excel上用connection有结果的
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim Cmd As ADODB.Command
Dim strConn As String
Set cn = New ADODB.Connection
Set rs = New ADODB.Recordset
Set Cmd = New ADODB.Command
strConn = "Provider=MSDASQL.1;Persist Security Info=True;DSN=pmw;Description
=PMW;UID=pmwreader;Trusted_Connection=Yes;APP=2007 Microsoft Office system;
WSID=BG-RXU;DATABASE=pmw"
cn.Open strConn
Cmd.ActiveConnection = cn
Cmd.CommandText = "Reports.HistoricalReturns"
Cmd.CommandType = adCmdStoredProc
Cmd.Parameters.Refresh
Cmd.Parameters(1).Value = "capf"
Cmd.Parameters(2).Value = Null
Cmd.Parameters(3).Value = "01/01/08"
Cmd.Parameters(4).Value = "10/31/11"
Set rs = Cmd.Execute()

j*a2008-06-03 07:06

3 楼

I need to write a program to search certain txt string in MS word file, for
example find all the strings with prefix "XXX_xxx" and write these string
into a .txt file.
Access VBA will be the best choice, but other script language is fine if it
is simple.

w*g2008-06-03 07:06

4 楼

Don't think you have many choices here. Isn't VBA good enough?

for
it

【在 j***a 的大作中提到】

: I need to write a program to search certain txt string in MS word file, for
: example find all the strings with prefix "XXX_xxx" and write these string
: into a .txt file.
: Access VBA will be the best choice, but other script language is fine if it
: is simple.

j*a2008-06-03 07:06

5 楼

Are you saying VBA can do all what I want, easily? - I am not very farmiliar
with VBA (did some tables and forms before). Could you point me to some
sample code site? Thanks.

【在 w***g 的大作中提到】

: Don't think you have many choices here. Isn't VBA good enough?
:
: for
: it