Search results

Thanks for your reply Doc man. Yes, the DB was compressed before and after the change, so I guess those "extra" forms did make a big difference. Still, I think it makes for a much cleaner look. Thanks again and happy holidays to all!

Hello all, I have two brief questions: 1. I have a DB with many reports and use SQL instead of a query as the Record Source. It makes for a lean Query list but does this increase the DB size or make for less efficient operation? 2. In the same DB, I recently switched form a 2-form menu system...

Tim, Tried writing to C:\Documents and Settings\Errors\PreMailError.txt and it worked fine! Maybe there is a glitch using Shared Documents ... I'll do some research on that. Many thanks for your insight. --Charles

The folder exists and I'm running the program as the Admin, so it seems like I would have permission (however, I've only recently installed Win XP and certainly am not an "expert" yet). I'll try the shortcut suggestion, but still wonder if there is a way to specify a valid directory path that...

I want to write an error file using the following statement: Open "C:\Shared Documents\PreMailError.txt" For Output As #1 I get an invalid directory with that, but it works fine with this one: Open "C:\PreMailError.txt" For Output As #1 Assume the space in the folder name is the...

CHRIS! Your suggestion worked! Making that simple change results in "The OpenReport action was canceled" message, with an OK to return to the calling form. That's all I need. Many, many thanks to all of you for your assistance. --Charles

Chris, I'll try your suggestion also. Thanks

Okay, I'll try to pull out relevant stuff and create a subset of the current 10Mb db. My time will be limited for a while; wife is scheduled for major surgery next week. Thanks for the suggestion.

End of My Story (I guess) Yesterday I stumbled across (literally) a page in Access Help that listed trappable errors for the Jet database engine. Errors were in the 2000-3999 range, and #2501 was not in the list. Interestingly, I looked through Help again today and could find no reference that...

Hi PDX MAN, Tried your suggestions but got the same result. I can trap the 2501 error but not before Access sees it and displays its own message. I'm using the code from Access Help in the OnError event for both the form and the report, where the statement "Response = acDataErrContinue" is...

I started over with this problem and got some more clues but still no solution. I created a form with a command button that runs a report based on a parameter query, then I inserted a Debug statement for every relevant event for the form, button, and report. The Debug argument looks like, for...

Sorry, that was a typo; I used 2501 in my test. And I'm beginning to wonder if my Access is corrupt. When I display the code for this form I show about 42% of System and User resources available; when I just click in the code without typing anything, resources plummet to 12%. Does that seem...

Okay, I commented out the On Error statements in every Sub in the form and included the following (from Access Help) for the OnError event, but still got the Access message instead of mine. Private Sub Form_Error(DataErr As Integer, Response As Integer) Const conCancelParameterReport = 2051...

Rich - Thanks for your post. I plugged this into my code but got the same result as before. It's as if the On Error line is ignored and Access goes right to its own standard error dialog. Charles

In Access 2000, I use a tab control form with an option group on each page as a menu to run various reports, triggered with a command button. When I click the command button and then try to Cancel a report based on a parameter query, I get a MS VB box with "Run-time error '2501'. The OpenReport...

Eureka! I solved my problem! Nothing I tried had worked, so I decided to zoom out from the "trees" in the code and look at the "forest" of form events. That's when I realized I was calling the code from the On Click event of the list box. I moved the code to the On Click event of a button...

Thanks, Ian, I'll try your rs!blnStatePick = ctl.Selected(i) shortcut. I am using rs.Close, but not the Set rs = Nothing (I'll add that). There are currently four items in the list. I can select all four and maybe deselect one or two before the error. But sometimes it happens after just a...

I'm getting random warning messages in a single-user Access 2000 application involving a multiselect list box (lstRegion), where the user can select more than one item from the list (thanks to MikeAngelastro for the suggesion). I need to save the user selections in a table, to be used in another...

Thanks, Mike. I'll give your suggestion a try. Charles

I'm using the following If statement in an Access 2000 procedure: If state = "KY" And county <> 'Knox' And county <> 'Scott' Then do something End If I want to change this to let a user pick one of more county names from a list, use the selections to build and save a "condition" clause in a...