|
by: Betrock |
last post by:
This is probably very simple, but I just can't see my way thru it.....
Short version: keyed values(numeric)in a lookup table are stored in a
main table. They are displayed as text values - the keyed values
description. I need a parameter query to return a range of these
values. The parameter input won't accept the 'text' version. You can
do it with 'Find' because you can select 'as formatted'. But I need a
range. Please, any...
|
by: Matt W via AccessMonster.com |
last post by:
I based my parameter query off the following posting, but can't seem to work
out a little kink. I cannot bring up a report without first typing in the
month and year three times. The first time for my Form , the second
for the parameter form, and the third
which I can't figure out where on earth that one came from. How do I clean
this up so I can type in the criteria just once into the form I created? I
tried putting !! in the criteria...
|
by: sara |
last post by:
I have reports that run from a form where the user can choose a date
range, or they run automatically for a week in the "Weekly Reports"
option.
I created 2 queries and 2 reports - one query uses the WeekEndDate to
filter, and its associated report heading says "For the week Ending " &
forms!frmPrintReports.getWeekEndDate.
The other query selects the date range using "Between" and the 2 dates
on the form. Its associated report header...
|
by: allie357 |
last post by:
I am trying to add a form with a combo box to an existing parameter
query report.
I followed the directions from this
link:http://office.microsoft.com/en-us/assistance/HA011170771033.aspx
However, even though the form pops up when I click on the report, the
combo box is not populating and the report still has popping up
parameters, even though I thought I removed them.
Any help is appreciated.
|
by: TonyJH |
last post by:
Hi.
I'm new to this database world. Just started Access training a few months ago and have a somewhat complicated database already built. In a nutshell, I have a select query that uses a parameter callout so the user can enter a serial number of a widget and get test information for a report. The query pops out the test data in, for simplicity, in two columns, rest result Type A and Type B. The challenge for me is getting the results broken...
|
|
by: Ben |
last post by:
NooB: Anyone help with what I could be doing incorrectly here? Trying to
have a parameter drop down list where a user can select one or more of the
available values contained in the table to filter out results. Have a
single table with five values. Keep getting the following error....
Table name is Name
Field is NickName
Parameter name is "Nick", datatype string, prompt "Select NickNames",
|
by: ashutoshvyas |
last post by:
I am designing a data report in VB6. In data environment it is possible to selet tables and 'select quries'. But I want to generate a report based on parameters passed by user, so i had created a parameter query in ACCESS which is not available in the properties of command1.
SQL code of query is as under :
SELECT Customers.account_no, Customers.card_no, Customers.name, payments.amount, payments.payment_date, dlt_3., total_amount.
FROM...
|
by: KaleeyJ |
last post by:
I have a report that uses a parameter query where the parameter is supplied by a form in my db - frmSINGLE. I need to run this report based on a different form - frmMULTI. frmSINGLE may or may not be open - in any case, I don't want to use it.
I would like to avoid having two reports (and two queries) that have the exact same contents save one criteria on one field - this db is big enough as is. So my plan is to change the record source on...
|
by: jmborron |
last post by:
I have an Access report that is populated by a parameter query. I need to run the report for 250 different filters then save. How do I write a code that will run the report then save it as pdf250 times?
Jason
|
by: Jeffrey Tan |
last post by:
Hi there..
So i am trying to email a parameter query report that takes in a date formatted to m/yyyy and compiles a report based on the specific month and year.
however, when i click the command button to email the report, the input box window pops up, i type in a month and year, say 6/2010, then hit enter and then it breaks into the following code highlighting it yellow:
DoCmd.OutputTo acOutputReport, strReportName, acFormatPDF,...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|