473,378 Members | 1,467 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Run-Time Error 2465 on Report

I have an Option GROUP which produces 6 different report between two
dates.

A separate Option BUTTON determines the period of the report once I
enter the From & To Dates into the textboxes.

I have deleted 5 of the 6 options (radio buttons) within the Option
GROUP.

Now when I run the report I receive Run-Time Error 2465 - "MS Access
can't find the field "Service Categories" referred to in your
expression."

I compared the VBA code from this working copy of the database to a
copy of the database prior to encountering this Run-Time Error.

Any ideas on how I may attempt to fix this?

Thanks!

John

Aug 5 '08 #1
2 2355
rkc
On Aug 5, 4:05 pm, zufie <john.marru...@illinois.govwrote:
I have an Option GROUP which produces 6 different report between two
dates.

A separate Option BUTTON determines the period of the report once I
enter the From & To Dates into the textboxes.

I have deleted 5 of the 6 options (radio buttons) within the Option
GROUP.

Now when I run the report I receive Run-Time Error 2465 - "MS Access
can't find the field "Service Categories" referred to in your
expression."

I compared the VBA code from this working copy of the database to a
copy of the database prior to encountering this Run-Time Error.

Any ideas on how I may attempt to fix this?
Are you given the option to debug along with the error message?

What else did you delete? It does not make sense that deleting
option buttons from an option group would cause that error as long
as the option group itself still exists.

What's the recordsource of the report look like?



Aug 5 '08 #2
On Aug 5, 4:34*pm, rkc <r...@rkcny.comwrote:
On Aug 5, 4:05 pm, zufie <john.marru...@illinois.govwrote:


I have an Option GROUP which produces 6 different report between two
dates.
A separate Option BUTTON determines the period of the report once I
enter the From & To Dates into the textboxes.
I have deleted 5 of the 6 options (radio buttons) within the Option
GROUP.
Now when I run the report I receive Run-Time Error 2465 - "MS Access
can't find the field "Service Categories" referred to in your
expression."
I compared the VBA code from this working copy of the database to a
copy of the database prior to encountering this Run-Time Error.
Any ideas on how I may attempt to fix this?

Are you given the option to debug along with the error message?

What else did you delete? It does not make sense that deleting
option buttons from an option group would cause that error as long
as the option group itself still exists.

What's the recordsource of the report look like?- Hide quoted text -

- Show quoted text -
Yes, I am given the option to debug along with the error message.

That's about it.

I think I fixed it by removing VBA statements that mention to the
Service Categories field such as
Me![Service Categories].Enabled = False AND Me![Service
Categories].Enabled = True

Thanks!

John
Aug 6 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: leroybt.rm | last post by:
Can someone tell me how to run a script from a interactive shell I type the following: >>>python filename >>>python filename.py >>>run filename >>>run filename.py >>>/run filename >>>/run...
4
by: Ed | last post by:
Hello, I took a course in asp about 2 years ago and I was practicing with IIS 5.0. Then I put it down for a while. Now trying to get back to it. I can't run asp files from subdirectories of...
2
by: Jenna Olson | last post by:
Hi all- I've never seen this particular issue addressed, but was wondering if there's anything to support one way or another. Say I have a class: class ManipulateData { public:...
6
by: orekin | last post by:
Hi There I have been trying to come to grips with Application.Run(), Application.Exit() and the Message Pump and I would really appreciate some feedback on the following questions .. There are...
13
by: Bob Day | last post by:
Using vs2003, vb.net I start a thread, giving it a name before start. Code snippet: 'give each thread a unique name (for later identification) Trunk_Thread.Name = "Trunk_0_Thread" ' allow...
19
by: Bryan | last post by:
How can i run a bit of code straight from the IDE? Right now i make a temporary button and put the code behind that, then i run debug mode and click on the button. Is there a way to highlight...
9
by: Brett Wesoloski | last post by:
I am new to VS2005. I changed my program.cs file to be a different form I am working on. But when I go to run the application it still brings up the form that was originally declared as new. ...
7
by: Lee Crabtree | last post by:
I remember when I was first getting into .NET Forms programming that there was a rather emphatic rule about not constructing a form before calling Application.Run with it. So this: ...
8
by: David Thielen | last post by:
Hi; In our setup program how do I determine if I need to run "aspnet_regiis –i" and if so, is there an API I can calll rather than finding that program on the user's disk and calling it? --...
7
by: mxdevit | last post by:
Task: run application from ASP.NET for example, you have a button on ASP.NET page, when press this button - one application is invoked. the code to run application (for example, notepad) is...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.