Recent content by NOL

Hi Mario , No I don't. I cldn't figure it why the INSERT didn't work . Gina.

YIPPEE! The error trapping code in the form which opens the report, along with the Cancel = true in the OnNOData event did it ! And to think I'd thought I'd finally learnt where to look ! Dugantrain , yes I'd tried Setwarnings , but that doesn't work, in this case ... Thanks guys !! Gina

that no work either . I first get the message There is no data for this report. Canceling report..." when i clik on OK i get the next message viz. " The OpenReport Actin was cancelled" I even tried putting a msgbox in the on error event property of teh report .. doesn't even go there .

In the report .. Private Sub Report_NoData(Cancel As Integer) MsgBox "There is no data for this report. Canceling report...", , G_AppTitle Cancel = -1 End Sub I have tried using macro too ..

Hi , Thanks for the suggestion. But I still get the same message .. what is your code supposed to be doing ? Thanks, Gina.

Hi I tried this in a query and it worked fine .. SELECT DCount("[Customer Name]","TABLE","InStr([Customer Name],'Pre')>0") AS Expr1; Could it be coz you are doing "InStr([MyString],[MyField])" instead of "InStr([MyField],[MyString])" ? Gina.

Hi, I want to cancel opening of a report if it has no data. I've tried the suggestions on the forum viz. use macro with msgbox & cancel event / use VBA code with cancel = true No matter what I do ( on error resume next , error trapping, set warnings) I still get the message : "OpenReport...

Hi, For your first question : You would want to know the definition of a "valid ISBN" before creating a rule to validate it ... and for your second.. if your ISBN is always of fixed length say 10 chars, you can use -- Right( trim([ISBN]), 7) or if you don't know the length --- Right (...

Hi , There may be a better way , but this works for me .. Delete from Your_table where Your_Autonumber in (SELECT Max(YourAutoNumber) as Duplicate_record FROM Your_table GROUP BY A, B,C HAVING Count(YourAutoNumber)>1); :) Gina.

Hi, Try this .. delete * from someparts where Some_Parts.Part_ID not in (select Distinct Part_ID From All_parts) If that's what you wanted .. Good Luk, Gina

Very confused :) Try explaining again if you like ..

Hi Pat, I do know about the relinking tables with password save option. I was looking for a easier & faster method. Thanx for your advice.. The DBA has created this ORACLE user name for every1 concerned to use, but I'll keep the thought in mind now! Thanks, Gina.

Hi , I have a form in Access 2000 based on a table with embedded OLE Objects. When I insert an EXCEL OLE oject on my form , and double clik , it opens within teh container & shows me the worksheet with both horizontal and vertical scrollbars. however , if i insert a word object , there are...

Hi FoFa, I don't think I understand what you said. I have a user /pass in ORACLE with only SELECT permissions. and I use this to link the tables. Thanks, Gina.

Hi Pat, I'm sorry I couldn't reply immediately. Currently I do not have any forms , just tables/queries/functions/macros. How can i still make this work for me , such that when i clik on MS access , "strconnect" is sent to ORACLE & i dont' have to enter the password ? Thanks, Gina.