This select statement works and gives me True/False in RC33 column however the second statement gives me following error. Any idea?
odbc--call failed.
[oracle][odbc][ora]ora-00907: missing right parenthesis
- - - this on works - - -
[Code=sql]SELECT tblAccount.Acct _Num, tblAccount.STAT US, tblAccount.RC1, tblAccount.RC_2 , tblAccount.RC_3 , 33 In ([RC1],[RC_2],[RC_3]) RC33
FROM tblAccount;[/Code]
...
ozarka
Last Activity: Mar 27 '08, 01:12 PM
Joined: Oct 23 '07
Location:
-
error: missing right parenthesis
-
I used this and now it's working.
Private Sub txtEnterLoanNum _KeyDown(KeyCod e As Integer, Shift As Integer)
If KeyCode = 13 Then
f_runitnow
End If
End Sub -
on enter event - nothing is happening
I have a search form. and many unbound control. My main search text box "txtAccount " is acting weird or I am not doing it right.
I want user to input a value and hit the enter key. I put something on the "on Enter" event but the code kicks in as soon as I load the form.
After by passing the first error I enter something in my search box and hit the enter key on my keyboard and nothing happens. I... -
I am sorry, I had the command button twice in my vba. it worked perfectly.
Thanks a million.Leave a comment:
-
Thank you very much for the code. I am getting Ambigous name detected when I click on the command button.Leave a comment:
-
can you please tell me which line i need to remove. i got the expensive (lol) code from vbcity.http://vbcity.com/forums/topic.asp?tid=2 3815Leave a comment:
-
i got the code from vbcity. i dont know what is doing. can you please offer a better solution.Leave a comment:
-
out of memory error
I am getting "out of memory" (run time error 7) error on ReDim Preserve myArr(totalAmou nt). When I put my mouse over this line it reads 65894. My text file has 780k lines (almost a meg.). Anything I can do to make this go away. I am trying to retrieve certain row from a large text file.
...Code:Private Sub cmdImportRow_Click() Dim myPath, myFile As String Dim myLine As Integer myPath = "\\server path\my
-
Hi there,
Thank you very very much for responding to my post.
1. Yes, I do have vb and ms-access background. Backend is mdb (msaccess db) but it will migrate to oracle.
2. Dataset (table has been created). See my sql for table and field name.
3. Do I need to have MS visual studio in order for me to create just 1 or 2 asp.net pages?
4. All I want user to input account id and click on "Search"....Leave a comment:
-
New asp page for search
I would like to create a asp.net page where user will input account number and click on "Search" button. The result should come from a mdb table.
I am using this query and i need to replace this with asp because we dont want to install small mdb apps on user machine.
SELECT all_pages.*
FROM all_pages
WHERE all_pages.id=[Enter Account ID]
I have never done asp.net but please do... -
HOW COME NO ONE NEVER HELPS ME.
Here is the solution and hope it works for update query.
...Code:SELECT [tbl_Fees].Acct_Num, [tbl_Fees].Fees_Allowed, [tbl_Fees]!Fees_Allowed<>[tbl_Fees2_on_Release]!Fees_Allowed AS Compare, [tbl_Fees2_on_Release].Fees_Allowed FROM [tbl_Fees] LEFT JOIN [tbl_Fees2_on_Release] ON [tbl_Fees].Acct_Num = [tbl_Fees2_on_Release].Acct_Num WHERE ((([tbl_Fees]!Fees_Allowed<>[tbl_Fees2_on_Release]!Fees_Allowed)=-1))
Leave a comment:
-
compare two fields
I am trying to create a query where tblfees2!fees_a llowed does not match tblfees.fees_al lowed. why the following is not working? I am not getting any result. I should get 2 records. because in my tblfees2 table there are two records one with null and other one has "S".
...Code:SELECT [tblFees].Acct_Num, [tblFees].Fees_Allowed, [tblFees2_on_Release].Fees_Allowed FROM [tblFees] LEFT JOIN [tblFees2_on_Release] ON [tblFees].Acct_Num
-
This code works..
Public Sub GetTable()
Dim strSQL As String
strSQL = "SELECT *" & _
" INTO [tblTEST]" & _
" FROM [tblTEST]" & _
" IN '\\svr774\techy \test.mdb'"
CurrentDb.Execu te strSQL, dbFailOnError
End Sub
Thanks to BrentLeave a comment:
-
This routine works great. It makes tbltest2 on the server. I want tbltest2 to be on the current db. tbltest is coming from server.
Sub adoAppend()
'// Append records from Remote Table to Current MDB table
Dim con As ADODB.Connectio n
Dim cmd As ADODB.Command
Set con = New ADODB.Connectio n
Set cmd = New ADODB.Command
cmd.CommandText = "SELECT * INTO [tblTEST2]...Leave a comment:
-
copy a table
I need to copy a table "tblUsage" (which is remotely located on \\server45\tech dbs\tech34.mdb) to current mdb using a command button. Is it possible? (no linking is allowed, I mean i am not allow to link the tables from above server).
Thanks -
Hi Fish,
sorry about not answering # 16,
cancel for all of your questions. we dont let it continue and keep the original values.Leave a comment:
-
I dont want recordcount. i can get that easily. thats kool. i am just going to drop this. taking too much time.Leave a comment:
-
countinous form - get row #
I put this on my form (bounded-contineous) in txtRow control under default value. the control populates with the total number of records. in this case all the records shows 11 in the txtRow text box.
[code=vb]
Public Function GetRowNum() As Long
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Dim intNCt As Integer
Dim strSQL As String
Set dbs = CurrentDb()
strSQL = "SELECT... -
Fish,
Have you looked at the sample db yet? Can I streamline the code?
ThanksLeave a comment:
-
http://www.e-topco.com/test/db2.zip
I got this one from my co-worker. But I really dont like it.Leave a comment:
No activity results to display
Leave a comment: