Hi, I am having a problem. I have a very simple employee database.
The client needs to see everything on a form before any updates or
deletions can be made. I have a form that loads with two parameters
(date range) a start date and a end date. I have two queries -
Separation Update (adds to the separation table) and Separation Delete
(deletes from the main table), they both run with the same parameters
as the form. Is there a way that the user only has to enter once the
Start Date and the End Date? I can't figure out how to pass the
parameters from the form to the separation update query and then to
the separation delete query. Any assistance would be welcome. Thanks
in advance. Pat 3 2747
RoadRunner wrote:
Hi, I am having a problem. I have a very simple employee database.
The client needs to see everything on a form before any updates or
deletions can be made. I have a form that loads with two parameters
(date range) a start date and a end date. I have two queries -
Separation Update (adds to the separation table) and Separation Delete
(deletes from the main table), they both run with the same parameters
as the form. Is there a way that the user only has to enter once the
Start Date and the End Date? I can't figure out how to pass the
parameters from the form to the separation update query and then to
the separation delete query. Any assistance would be welcome. Thanks
in advance. Pat
Here's one method. Lets say your form name is called UpdtDelForm.
Open your query in design mode. Then under the start date column, in
the criteria row, enter
Forms!UpdtDelFo rm!StartDate
and under the end date
Forms!UpdtDelFo rm!EndDate
Change the field/form names to relect your own.
You could also check this out http://www.mvps.org/access/queries/qry0003.htm
The problem is that they are not separate fields, they are under one
field (Date) in both the form and the query.
On Sep 18, 1:54*pm, Salad <o...@vinegar.c omwrote:
RoadRunner wrote:
Hi, *I am having a problem. *I have a very simple employee database..
The client needs to see everything on a form before any updates or
deletions can be made. *I have a form that loads with two parameters
(date range) a start date and a end date. *I have two queries -
Separation Update (adds to the separation table) and Separation Delete
(deletes from the main table), they both run with the same parameters
as the form. *Is there a way that the user only has to enter once the
Start Date and the End Date? *I can't figure out how to pass the
parameters from the form to the separation update query and then to
the separation delete query. *Any assistance would be welcome. *Thanks
in advance. Pat
Here's one method. *Lets say your form name is called UpdtDelForm.
Open your query in design mode. *Then under the start date column, in
the criteria row, enter
* * * * Forms!UpdtDelFo rm!StartDate
and under the end date
* * * * Forms!UpdtDelFo rm!EndDate
Change the field/form names to relect your own.
You could also check this outhttp://www.mvps.org/access/queries/qry0003.htm
RoadRunner wrote:
The problem is that they are not separate fields, they are under one
field (Date) in both the form and the query.
If using Date as the fieldname, since it's a reserved word, use [Date]
If 1 column for the date field, then use Between in the criteria. Ex
Between [Forms]![Form1]![Date1] And [Forms]![Form1]![Date2]
>
On Sep 18, 1:54 pm, Salad <o...@vinegar.c omwrote:
>>RoadRunner wrote:
>>>Hi, I am having a problem. I have a very simple employee database. The client needs to see everything on a form before any updates or deletions can be made. I have a form that loads with two parameters (date range) a start date and a end date. I have two queries - Separation Update (adds to the separation table) and Separation Delete (deletes from the main table), they both run with the same parameters as the form. Is there a way that the user only has to enter once the Start Date and the End Date? I can't figure out how to pass the parameters from the form to the separation update query and then to the separation delete query. Any assistance would be welcome. Thanks in advance. Pat
Here's one method. Lets say your form name is called UpdtDelForm.
Open your query in design mode. Then under the start date column, in the criteria row, enter Forms!UpdtDelFo rm!StartDate and under the end date Forms!UpdtDelFo rm!EndDate
Change the field/form names to relect your own.
You could also check this outhttp://www.mvps.org/access/queries/qry0003.htm
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: androtech |
last post by:
Hello,
I'm looking for a function that returns a date range for a specified week
number of the year.
I'm not able to find functions like this anywhere. Any pointers/help would
be much appreciated.
TIA
|
by: manning_news |
last post by:
Using A2K. I've been asked to modify a report currently requiring only
one date parameter to now accept a date range. The main report has 2
subreports and is not bound to a table or query. The report prints
dental and hygenist appointments for the date (one subreport for each).
The user wants to enter a date range and have one page for each...
|
by: laurenq uantrell |
last post by:
I've gotten sort of fed up with dealing with regional date settings on
the client side and am considering the following scheme - just
wondering if anyone has a negative view of it or not:
Instead of
@StartDate datetime,
@EndDate datetime
Use:
|
by: dfetrow410 |
last post by:
Anyone have some code that will do this?
Dave
|
by: ZRexRider |
last post by:
Hi,
I've written reports based on stored procedures that receive parameters
and it usually seems straight forward.
Today I would like to use Crystal Reports parameter interface t prompt
for a "Date Range" and then pass the lower and upper date values to the
@StartDate and @EndDate of my SPROC's range.
Unfortunately when I try to build...
| |
by: devyon122 |
last post by:
I'm trying to allow a user to type in a beginning data and an ending date to be used in a crosstab query - Below is the query:
TRANSFORM Count(imagingdb.ID) AS CountOfID
TRANSFORM Count(imagingdb.ID) AS CountOfID
SELECT imagingdb.Scheduled, imagingdb.ATT, imagingdb.ACQ
FROM imagingdb
WHERE (((imagingdb.Scheduled) Is Not Null) AND...
|
by: Sandboxer |
last post by:
I want to be able to program Access to provide for me, by individual day, what my contract obligations are to my customers. Will Access recognize all the individual days in between a date range (simply a "from" date and a "to" date)? Additionally, I need to delivery a specific quantity of product when the customer's inventory is within about...
|
by: The KID |
last post by:
Hi All
So I'm new to this. What I am trying to is the user will fill in a series of text boxes or drop downs. Lets say for this instance begin date and end date. Then they would click a button and a new page would open and a report would display the information that was between that date range.
I can connect my drop downs ok, and i know...
|
by: grego9 |
last post by:
I have a problem in Excel 2000. I have written some VBA code that transfers data from the current excel workbook to a file called "Deal Input2.xls". Everything transfers ok apart from the date in cell ("G28"). This gets converted into an American date in Deal input 2.xls. So even though the date in the current workbook is entered as 02/05/2008...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
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...
|
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...
|
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...
|
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...
|
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...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |