Dialog Box

[Guest]

INSERT INTO Name_Total_Table ( [Library#], [First], Middle, [Last], Total,
last_date, block, amount )
I have the following query in a program that will ask for a date in a pop-up
dialog box. I would like that box to close once the date is entered, instead
of staying on the screen the entire time the program is running. This really
doesn't affect anything it's just an annoyance.

SELECT dbo_debt_borrower.[borrower#], ParseName([Name],"F") AS [First],
ParseName([Name],"M") AS Middle, ParseName([Name],"L") AS [Last],
CCur([total_amount]*0.01) AS totals, DateAdd("d",[last_date],"1 Jan 1970") AS
[Date], dbo_burb.block, dbo_burb.amount
FROM dbo_debt_borrower INNER JOIN dbo_burb ON dbo_debt_borrower.[borrower#]
= dbo_burb.[borrower#]
WHERE (((DateAdd("d",[last_date],"1 Jan 1970"))=[Enter Debt Collect Date use
this format only mm/dd/yyyy]) AND ((dbo_burb.block)="dc") AND
((dbo_debt_borrower.status)=0));

 

[[MVP] S.Clark]

It doesn't sound like this is the Access Parameter Input dialog, so do you
have your own form? If so, close the form before processing.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

 

[Guest]

I didn't use a form to create this. I noticed my note is right in the middle
of my query. This is in the middle of create table statement, it looks odd
because the database I am pulling the info from doesn't use date as a field
format, this is why there is a DateAdd statement so I can put it into date
format, then I ask the user to enter the date needed. This is where the
dialog box will pop-up, but it doesn't close after they enter the date.

INSERT INTO Name_Total_Table ( last_date )
SELECT DateAdd("d",[last_date],"1 Jan 1970") AS [Date]
FROM dbo_debt_borrower INNER JOIN dbo_burb ON dbo_debt_borrower.[borrower#]
= dbo_burb.[borrower#]
WHERE (((DateAdd("d",[last_date],"1 Jan 1970"))=[Enter Debt Collect Date use
this format only mm/dd/yyyy]));


--
Thanks Mary

It doesn't sound like this is the Access Parameter Input dialog, so do you
have your own form? If so, close the form before processing.


--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html

INSERT INTO Name_Total_Table ( [Library#], [First], Middle, [Last], Total,
last_date, block, amount )
I have the following query in a program that will ask for a date in a
pop-up
dialog box. I would like that box to close once the date is entered,
instead
of staying on the screen the entire time the program is running. This
really
doesn't affect anything it's just an annoyance.

SELECT dbo_debt_borrower.[borrower#], ParseName([Name],"F") AS [First],
ParseName([Name],"M") AS Middle, ParseName([Name],"L") AS [Last],
CCur([total_amount]*0.01) AS totals, DateAdd("d",[last_date],"1 Jan 1970")
AS
[Date], dbo_burb.block, dbo_burb.amount
FROM dbo_debt_borrower INNER JOIN dbo_burb ON
dbo_debt_borrower.[borrower#]
= dbo_burb.[borrower#]
WHERE (((DateAdd("d",[last_date],"1 Jan 1970"))=[Enter Debt Collect Date
use
this format only mm/dd/yyyy]) AND ((dbo_burb.block)="dc") AND
((dbo_debt_borrower.status)=0));