I have a number of queries, running one after the other, which do quite a
complex calculation. A text box on a form provides the date for this routine.
I have another routine I wish to do and it happens that the final query in the
above routine contains the data I need. However I don`t want to fire this
routine from the same form as before.
I could make copies and rename the queries I suppose but is there a way I could
enter the date in a new form, maybe open the original form, minimised ? send the
date to that text box then run the routine ?
Hope that makes sense. Suspect there is a simple way to do this but I`m missing
it
David B
Hexham UK
5  1595 
Perhaps you could run your first set of queries from a button on a different
form than your date form. The first line of code would be:
DoCmd.OpenForm "NameOfForm ToEnterDate",,, ,,acDialog
<Code to run queries>
DoCmd.OpenForm "NameOfSecondFo rm"
DoCmd.Close acForm, "NameOfFirstFor m"
<Code to run other routine>
DoCmd.Close acForm, "NameOfForm ToEnterDate"
DoCmd.Close acForm, "NameOfFirstFor m"
In the Date form, you would need the following code in the AfterUpdate event of
the Date textbox:
Me.Visible = False
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdata sheet.com www.pcdatasheet.com
"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c0******** **@news5.svr.po l.co.uk... I have a number of queries, running one after the other, which do quite a
complex calculation. A text box on a form provides the date for this routine.
I have another routine I wish to do and it happens that the final query in the
above routine contains the data I need. However I don`t want to fire this
routine from the same form as before.
I could make copies and rename the queries I suppose but is there a way I
could enter the date in a new form, maybe open the original form, minimised ? send
the date to that text box then run the routine ?
Hope that makes sense. Suspect there is a simple way to do this but I`m
missing it
David B
Hexham UK
That should work. effectively call a popup form to enter the date
Thanks
DB
PC Datasheet <sp**@nospam.sp am> wrote in message
news:I0******** *********@newsr ead3.news.atl.e arthlink.net... Perhaps you could run your first set of queries from a button on a different
form than your date form. The first line of code would be:
DoCmd.OpenForm "NameOfForm ToEnterDate",,, ,,acDialog
<Code to run queries>
DoCmd.OpenForm "NameOfSecondFo rm"
DoCmd.Close acForm, "NameOfFirstFor m"
<Code to run other routine>
DoCmd.Close acForm, "NameOfForm ToEnterDate"
DoCmd.Close acForm, "NameOfFirstFor m"
In the Date form, you would need the following code in the AfterUpdate event
of the Date textbox:
Me.Visible = False
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c0******** **@news5.svr.po l.co.uk... I have a number of queries, running one after the other, which do quite a
complex calculation. A text box on a form provides the date for this
routine.
I have another routine I wish to do and it happens that the final query in
the above routine contains the data I need. However I don`t want to fire this
routine from the same form as before.
I could make copies and rename the queries I suppose but is there a way I
could enter the date in a new form, maybe open the original form, minimised ? send
the date to that text box then run the routine ?
Hope that makes sense. Suspect there is a simple way to do this but I`m
missing it
David B
Hexham UK
What do you mean by "routine"? If you are trying to use the same reports,
then how does it matter that it comes from a new form? The results will be
the same unless you are changing the queries in the reports somehow.
Mike Storr www.veraccess.com
"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c0******** **@news5.svr.po l.co.uk... I have a number of queries, running one after the other, which do quite a
complex calculation. A text box on a form provides the date for this
routine.
I have another routine I wish to do and it happens that the final query in
the above routine contains the data I need. However I don`t want to fire this
routine from the same form as before.
I could make copies and rename the queries I suppose but is there a way I
could enter the date in a new form, maybe open the original form, minimised ?
send the date to that text box then run the routine ?
Hope that makes sense. Suspect there is a simple way to do this but I`m
missing it
David B
Hexham UK
I want to display the data differently on a different form and in a different
part of my app.
David
Mike Storr <no****@somewhe re.con> wrote in message
news:pW******** ************@ne ws20.bellglobal .com... What do you mean by "routine"? If you are trying to use the same reports,
then how does it matter that it comes from a new form? The results will be
the same unless you are changing the queries in the reports somehow.
Mike Storr
www.veraccess.com
"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c0******** **@news5.svr.po l.co.uk... I have a number of queries, running one after the other, which do quite a
complex calculation. A text box on a form provides the date for this
routine.
I have another routine I wish to do and it happens that the final query in
the above routine contains the data I need. However I don`t want to fire this
routine from the same form as before.
I could make copies and rename the queries I suppose but is there a way I
could enter the date in a new form, maybe open the original form, minimised ?
send the date to that text box then run the routine ?
Hope that makes sense. Suspect there is a simple way to do this but I`m
missing it
David B
Hexham UK
Yes, and the key to it working is to make the popup form not visible so the date
is available to the second form.
Good luck!
Steve
PC Datasheet
"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c0******** **@newsg3.svr.p ol.co.uk... That should work. effectively call a popup form to enter the date
Thanks
DB
PC Datasheet <sp**@nospam.sp am> wrote in message
news:I0******** *********@newsr ead3.news.atl.e arthlink.net... Perhaps you could run your first set of queries from a button on a different
form than your date form. The first line of code would be:
DoCmd.OpenForm "NameOfForm ToEnterDate",,, ,,acDialog
<Code to run queries>
DoCmd.OpenForm "NameOfSecondFo rm"
DoCmd.Close acForm, "NameOfFirstFor m"
<Code to run other routine>
DoCmd.Close acForm, "NameOfForm ToEnterDate"
DoCmd.Close acForm, "NameOfFirstFor m"
In the Date form, you would need the following code in the AfterUpdate event
of the Date textbox:
Me.Visible = False
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com
"David B" <Da***@marleyco tenospam.fsnet. co.uk> wrote in message
news:c0******** **@news5.svr.po l.co.uk... I have a number of queries, running one after the other, which do quite a
complex calculation. A text box on a form provides the date for this routine.
I have another routine I wish to do and it happens that the final query in the above routine contains the data I need. However I don`t want to fire this
routine from the same form as before.
I could make copies and rename the queries I suppose but is there a way I
could enter the date in a new form, maybe open the original form, minimised ?
send the date to that text box then run the routine ?
Hope that makes sense. Suspect there is a simple way to do this but I`m
missing it
David B
Hexham UK
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: vnl |
last post by:
I'm trying to run a SQL query but can't find any records when trying to
select a certain date. Here's the sql:
SELECT field 1, field2, date_and_time,
FROM table1
WHERE date_and_time = '01-SEP-02'
I'm getting no results. The date_and_time field is formatted like this:
2002-SEP-02 00:01:04
|
by: Raghu |
last post by:
Hello...
I am running into a problem while running a query..can some1 help..
this is the query :
**************
SELECT *
from Table S
where S.dtDate1 BETWEEN dateadd(year,1,dateadd(month,-1,getdate()))
AND dateadd(day,-1,(dateadd(month,1,dateadd(year,1,dateadd(month,-1,getdate())))))
***************
(first part of the date calculation comes out to be '2005-05-01' and
|
by: Ken |
last post by:
I wrote a function to use in queries that takes a date and adds or
subtracts a certain length time and then returns the new value. There
are times when my function needs to return Null values.
Function DateCalc (blah...) As Variant
Do Stuff...
If Not IsNull(varNewDate) Then
DateCalc = varNewDate
End If
End Function
|
by: Lyn |
last post by:
Hi,
I am developing a project in which I am checking for records with
overlapping start/end dates. Record dates must not overlap date of birth,
date of death, be in the future, and must not overlap existing records from
the same table.
I had this all working some time ago, but recently when I have gone back to
do more testing, part of these validations no longer work. While there have
been changes to the code in the meantime, I cannot...
|
by: Julie Wardlow |
last post by:
Help!
I am calculating a future date using the DateAdd function in a query (the
calculation also involves an IIf statement), and have managed to get this
formula to produce the required result.
I then want to search through the records and select those with dates (as
caluclated above) within a user defined range, and so I am using a parameter
query. However, this query returns dates outside of the range and appears to
have particular...
| | |
by: seegoon |
last post by:
Hi to all.
I have a small problem I hope someone can help me with.
I am running a sql query to a csv file. The query searches for the
total of a column between 2 dates.
This is a copy of one of the query's:
Dim SF_SMT As New OleDb.OleDbCommand("Select count(*) from
fault_records.csv where F4 = '" & lblprod.Text & " ' " & " AND F8 AND
F1 between #" & SelectproductForm.datestart & "# and #" & Now.Date &
|
by: Dixie |
last post by:
How can I programatically, take some Date/Time fields present in a table in
the current database and change their type to text?
dixie
|
by: Daniel |
last post by:
In Microsoft Access I can write a query that includes the criteria:
Between Date()-7 And Date()
to retrieve the records from a table that fall within the last week.
I'm trying to write a procedure to do this in VB.NET (2005 Express
Edition). But I always get the message that the Jet database engine
does not recognize the syntax (of the Date function I assume). I've
also tried Now() and it works but only by itself. I seem to add or
|
by: bleachie |
last post by:
Hey,
I just need some help, my form seems to not send me all of the 'guestNames' and 'guestEmails' forms.
i use this function to add more guestnames and guestemail fields based on the number of guests added.
form.php
function createGuestNameAndEmailElements()
{
|
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: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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 most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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: 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: 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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
