473,320 Members | 2,193 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,320 software developers and data experts.

User Input in an Access Report?

Hi

I have a report that is made of 4 subreports. There is no actual
information in the main report, and the record source is empty. In
the Header section of the main report, I have a text box and I want
some user input to go in there every time the report is run. I'm
putting =[Enter something:] into the control source but it comes up as
#Name? when I run the report.

If I put something in the record source for the main form, the text
box/user input bit works but for some reason my 2 page report is
repeated numerous times, depending on which table or query is in the
record source.

I know very little about SQL code or expressions... has anyone got any
ideas?

Thanks
Clare
Nov 12 '05 #1
3 16879
You may want to simply build an input form that asks the user for the input
and then, when the user clicks "Go" or something, populates the report.

Hope this helps.

-DC Fan

"Clare" <cl**********@cambridgeshire.gov.uk> wrote in message
news:af**************************@posting.google.c om...
Hi

I have a report that is made of 4 subreports. There is no actual
information in the main report, and the record source is empty. In
the Header section of the main report, I have a text box and I want
some user input to go in there every time the report is run. I'm
putting =[Enter something:] into the control source but it comes up as
#Name? when I run the report.

If I put something in the record source for the main form, the text
box/user input bit works but for some reason my 2 page report is
repeated numerous times, depending on which table or query is in the
record source.

I know very little about SQL code or expressions... has anyone got any
ideas?

Thanks
Clare

Nov 12 '05 #2
Try using the InputBox function in the control source property of your
text box:

=InputBox("Enter something","My Title")

Take a look at the InputBox function in Help for a description of its
available parameters. HTH

Rick Collard
www.msc-lims.com

On 14 Apr 2004 07:53:23 -0700, cl**********@cambridgeshire.gov.uk
(Clare) wrote:
Hi

I have a report that is made of 4 subreports. There is no actual
information in the main report, and the record source is empty. In
the Header section of the main report, I have a text box and I want
some user input to go in there every time the report is run. I'm
putting =[Enter something:] into the control source but it comes up as
#Name? when I run the report.

If I put something in the record source for the main form, the text
box/user input bit works but for some reason my 2 page report is
repeated numerous times, depending on which table or query is in the
record source.

I know very little about SQL code or expressions... has anyone got any
ideas?

Thanks
Clare


Nov 12 '05 #3
no****@nospam.nospam (Rick Collard) wrote in message news:<40***************@news.west.earthlink.net>.. .
Try using the InputBox function in the control source property of your
text box:

=InputBox("Enter something","My Title")


That works perfectly! Thank you very much :o)

Clare
Nov 12 '05 #4

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

Similar topics

0
by: Mark | last post by:
Hello, Access2000, Win98 I'm tring to use acCmdOLEDDELinks to automatically update an Excel object in an Access Report. Is it possible to use RunComand acCmdOLEDDELinks without user input? ...
2
by: Steven Stewart | last post by:
Hi there, I don't have a lot of experience with this so I am looking for some help. I have a form that allows a user to choose the options she wants. How do I set it up so that the report...
2
by: Vikrant | last post by:
Hey Friends I need to export an Access Report using a filter. I am using the method OutputTo m_pDoCmd->OutputTo( 3, // asOutputReport COleVariant(strReportName), // <report name>...
3
by: Clare | last post by:
Hi I have a report that is made of 4 subreports. There is no actual information in the main report, and the record source is empty. In the Header section of the main report, I have a text box...
4
by: timgeitz | last post by:
I have a church database set up with multiple forms and reports. I would like to have the user input their own church name, address, etc. into a form which is stored in an underlying table and which...
6
by: DeniseY | last post by:
I have an Access report that is created on the fly by the user selecting the fields to be included. The Access report comes out fine, but I want it to automatically output to an Excel spreadsheet....
7
by: vaiism | last post by:
I am creating a report that outputs the contact information and details about a water treatment plant, and needs to include information about people who work there. If I tie all the information...
4
by: Coolboy55 | last post by:
I have a report that I'd like to filter based on the user's input. The user would select the month and year that they would like to see data from, and the report would return that data along with...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.