Search results

ok you are missing something you have On Error GoTo Err_Command27_Click but you dont have an Err_Command27_Click in your code I don't understand where this is missing or were it goes

I took all those lines out except the first one. Now I get a different compile error for the line For the line “Private Sub Command27_Click()” "Label not defined" It looks like this now Private Sub Command27_Click() On Error GoTo Err_Command27_Click Dim stDocName As String...

I have a command button on a form to run several queries. When I try to run it I get a Compile error: “Duplicate declaration in current scope” For the line “Private Sub Command27_Click()” Would someone please tell me what I'm doing wrong? Thanks Private Sub Command27_Click() On Error...

reversed, I hadn't thought of that! Thanks!

Would someone help me change this query (if it can be done) to select CASE where there are no DEP’s under the age of 18. A CASE can have more than one DEP SELECT [1 ALL OPEN CASES].DO, [1 ALL OPEN CASES].WORKER, [1 ALL OPEN CASES].CASE, NOLDBA_INT_CASE_MEMBER.MEMBER_ID AS DEP...

Attached is a DB. I'm trying to update the CASE table. But the update query has something wrong with it. Would someone please look at the update query and see if it appers I'm doing something wrong please. Thanks, Mike

ok, I figured it out with the info you gave me. Thanks again. Mike

I'm not sure how to change the query to add the NZ function, could you show me?

Why is there no FINAL AMT for cases that have nothing in the AMT2 column? Would someone please show me how to change this query to correct this issue? SELECT [22 TBL].CASE, [22 TBL].AMT1, [22 TBL].AMT2, Sum([22 TBL].AMT1+[22 TBL].AMT2) AS [FINAL AMT] INTO [23 TBL] FROM [22 TBL] GROUP BY...

ok thanks for the help

I have an Access DB with links to tables several tables in an Oracle DB. I want to create a button on one of my forms which will prompt the user to enter their User ID and Password for the Oracle DB. The Oracle DB name is CSEMEPRD. Can someone help me please? Thanks

Was that a statement or a question?

I have a table called NOLDBA_RPT_CASE_CHG_IND. The table has the fields shown below. The case status field can be “O” (open), “C” (closed), “H” (private). Each case in the system has several line entries for the date whenever the case status changes from one status to another. I’m trying to...

Is there a way to create a button on a form which will allow the user to log into an oracle DB using a macro?

That did it. Sorry I didn't give you all the information you needed the first time. Thanks again Mike

That didn't work either. Let me explain more, If the NOLDBA_INT_EMPLOYMENT_HISTORY_1.DATE_END is 12/31/9999 (which indicates that the end date field is empty, no date in it) the answer should be returned as "YES" if there is a date other that 12/31/9999 the answer would be no if the...

I just tried a simple query with the same wrong results..........

I spoke to quickly I tried the same change for another date field and everything gets returned as yes when there should be one no. Here is what I have, what did I do wrong? SELECT NOLDBA_INT_CASE_STATUS.IV_D_DO_CODE AS DO, NOLDBA_INT_CASE_STATUS.WORKER_ID AS WORKER...

Good Man That worked, THANKS SO MUCH. mIKE

I'm trying to have my query return either Yes or No based on a date field. If the field contains the date 12/31/9999 I want the field to return as yes, not the date and if it doesn't have 12/31/9999 I want the field to return as no. Can someone show me how? Here is the query SELECT...