Dim SchoolID As String
Dim result As Integer
result = InStr(1, UserName, "dx", 1)
Dim length As Integer
length = result + 1
Dim i As Integer
i = 0
UserName = "ynsfdxjx"
i = Len(UserName)
SchoolID = Left(UserName, length)
其中UserName是全局变量,但是运行之后,i的值为0,SchoolID的值为空。。
这个是什么问题?
Dim result As Integer
result = InStr(1, UserName, "dx", 1)
Dim length As Integer
length = result + 1
Dim i As Integer
i = 0
UserName = "ynsfdxjx"
i = Len(UserName)
SchoolID = Left(UserName, length)
其中UserName是全局变量,但是运行之后,i的值为0,SchoolID的值为空。。
这个是什么问题?
解决方案 »
- 流量高位数据转换,谁做过,请指导下
- 动态创建的控件的删除
- *********在线等待 谁知道vb6能用的免费视频捕捉控件*******************
- 企业作的系统中含有短信群发的功能?多谢!
- 关于将数据从excel中复制到MSflexgrid控件后查询的问题
- 请问谁有免费的图形菜单组件(不是xp风格)给我一个
- 怎么自动执行EXCEL,以及EXECL里面的VBA宏?
- 我想把新生成的文件保存到主程序的安装目录内?急
- 换个问法:程序运行屏幕截图时遇到屏保或省电设置(屏幕关闭)如何用代码解决?
- 怎样用数组作函数的参数
- 有关于通过MSHFLEX控件导出EXCEL,请教各位高手
- vb 如何读取java的properties配置文件?
2.你之前UserName 是什么类型变量?保险起见,倒数第二行改为 i=len(cstr(username))
3.每一次变量赋值后,DEBUG看一次,或者msgbox看一下成功取到值没有。比如 result = InStr(1, UserName, "dx", 1) 之后就应该 debug 或者 msgbox (result)看一下。分分钟就能找出问题所在
Dim SchoolID As String
Dim result As Integer
UserName = "ynsfdxjx"
result = InStr(1, UserName, "dx", 1)
Dim length As Integer
length = result + 1
Dim i As Integer
i = 0
i = Len(UserName)
SchoolID = Left(UserName, length)
Debug.Print i
Debug.Print SchoolID
End Sub
Dim SchoolID As String
Dim result As Integer
result = InStr(1, UserName, "dx", 1)
Dim length As Integer
length = result + 1
SchoolID = Left(UserName, length)
其中UserName是全局变量,但是SchoolID的值为空??
Dim result As Integer
debug.print UserName '看是否有值
result = InStr(1, UserName, "dx", 1)
Dim length As Integer
length = result + 1
SchoolID = Left(UserName, length)