UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
4 Pages V « < 2 3 4  (Go to first unread post)
   Reply to this topicStart new topic
> Using Weekday Function To Detect Sat Or Sunday, Access 2013    
 
   
Doug Galayda
post Jun 19 2017, 03:38 PM
Post#61



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


The zipped file is attached:
I know what you say is true, that they are indeed generated by the report
but I moved the report layout around in designer,
checked the controls, tried to look at the group by/footer.
Could not find the cause:
Compared controls to yours, looked the same in properties.
Thank you for the Title Date range also
see attached file containing
Dbo_tblPermits--------------Table
qryDue-----------------------Query
rptDue-----------------------Report
ActionDateCalculation_2----User defined function(UDF)
I look at my control panel and i cannot see my attached .zip file called Test06192017.zip
This post has been edited by Doug Galayda: Jun 19 2017, 04:37 PM
Go to the top of the page
 
Doug Galayda
post Jun 19 2017, 04:43 PM
Post#62



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


At 442pm Monday/6/19/2017:
Trying to upload the Test06192017.zip file again containing the test database
with a UDF, Query, table and Report.

I see at the bottom left the message:
"you did not select a file to upload"
and
Manage current attachements says (0)

Thanks
This post has been edited by Doug Galayda: Jun 19 2017, 04:53 PM
Go to the top of the page
 
RJD
post Jun 19 2017, 04:53 PM
Post#63


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


With a new message, click on Choose File (below lower right of message box), then choose the zip file to attach in the file dialog and click Open in the file dialog (you should then see the file name next to Choose File), then click on UPLOAD (again, below lower right of the message box). The current attachments count should increment to 1.

Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 19 2017, 05:02 PM
Post#64



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


Yes, did begin a new message,
and attempted to attach the .zip at 4:56pm, through 5:03 pm
I can browse for the file,
I select and/or double click on it
and I see my directory path and file in the browse field
then I hit upload,
it does say file "uploading",,,,,
then I am back in the message/reply window.
I see "Manage current attachments (0) on bottom right
and
"you did not select a file to upload" on bottom left
for some reason, the file is not "sticking"
tried this 2 to 3 times.
I appreciate your help and this will make me dig harder for the
controls in the body or group by footer area.
This post has been edited by Doug Galayda: Jun 19 2017, 05:06 PM
Go to the top of the page
 
RJD
post Jun 19 2017, 05:29 PM
Post#65


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


How big is your zip file. We have a 2mb limit. Did you compact before zipping?

Joe
from phone

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
RJD
post Jun 19 2017, 05:32 PM
Post#66


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


And did you look at Group and Sort to see what is there that might cause the prompts?

Joe
from phone

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 19 2017, 06:59 PM
Post#67



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


I did not compact before zip,
the zip file is now 40KB
I deleted a local table and did a compact and repair.
I will look at the group and sort
Thanks!
This post has been edited by Doug Galayda: Jun 19 2017, 07:05 PM
Attached File(s)
Attached File  Test06192017.zip ( 39.05K )Number of downloads: 1
 
Go to the top of the page
 
RJD
post Jun 19 2017, 09:17 PM
Post#68


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


Okay, several things...

You had a sort on a field that no longer exists. That was your Action prompt. I changed that to ActionDate and the prompt went away, and the sort is correct.
You used Action_Date_Field in an expression in a control to decide whether to put a * before another control. There is no such named field. This expression also refers to a form that is not present in the db. I deleted the control - you can reconstruct it when you have all the pieces there.
You showed a link to an ODBC database for the table, which did not work here, of course. I replaced that with the local table we used before, with the same name.

Now the report seems to work without the other prompts.

The table expanded the db size, so the zipped file is almost 2mb now.

HTH
Joe
Attached File(s)
Attached File  Test06192017_Rev1.zip ( 1.85MB )Number of downloads: 3
 

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 20 2017, 01:32 AM
Post#69



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


This is posted after you sent me the solution, I want you to know that I tried.
I fell asleep about 9:00pm and it is 1:00am now.
I took a copy of the version I sent you and kept trying to find the control that was causing the parameter values screens to come up.
I thought I could find the flaw in report by the process of elimination.
so if I delete all the fields, every possible field on the report.
I still get an Action parameter screen when the report is ran.
that is where I left off at.

Since I see your response, I understand what was causing the prompts.
I will take off the ascending sort on Action_date field(that don't exist anymore)
and I did have a local table in there but deleted it, causing the odbc failure.
I will do the corrective measures you state, I did not see those errors within the query code.
Getting a cup of coffee and then will download the .accdb
I am very grateful for your help.
Thank you.
This post has been edited by Doug Galayda: Jun 20 2017, 02:17 AM
Go to the top of the page
 
RJD
post Jun 20 2017, 08:26 AM
Post#70


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


All the problems are in the report, not the query. Try the revised db, and look hard at how the report gets sorted. And in your version, look at the control that produces the *.

Joe
from phone

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 20 2017, 01:32 PM
Post#71



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


Will do,
I ran the report in the Test example,
I will look thoroughly at the report until I get it
I will look at the control that produces the *
This is a opportunity to learn.

Thank you.
This post has been edited by Doug Galayda: Jun 20 2017, 01:37 PM
Go to the top of the page
 
RJD
post Jun 20 2017, 09:08 PM
Post#72


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


You are welcome. Good luck with your project.

Regards
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 21 2017, 06:16 AM
Post#73



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


Sorry I did not mean to ignore you, I will look at the report, But, yesterday was 12 hours of scramble, I was physically and emotionally consumed by tracking transactions through oracle, mainframe to server platforms that did not get up dated in the server tables viewed by the web screens. Then I had to manually correct 590 mainframe file records before that file went through the mainframe (3 hours), both problems not fixed yet. Norman Vincent Peale once said, “Lord, I have run out of tough problems, give me some more tough problems to make me stronger” well I am grateful to God today, and your patience. Thanks.
This post has been edited by Doug Galayda: Jun 21 2017, 06:22 AM
Go to the top of the page
 
Doug Galayda
post Jun 21 2017, 05:59 PM
Post#74



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


On my version, to find my errors and learn from my mistakes:

1) I right clicked on the “Detail” then I toggled/turned off with the X, the sorting and grouping,
then ran the report, the Action Prompt was gone! Good!
And then I saw how to set the order by to Action_Date, so I did that.

"You had a sort on a field that no longer exists. That was your Action prompt.
I changed that to ActionDate and the prompt went away, and the sort is correct".

2) I am still searching for the “Action_Date_Field” used in an expression, but I will find it!

"You used Action_Date_Field in an expression in a control to decide whether to put a *
before another control"

Thanks!
This post has been edited by Doug Galayda: Jun 21 2017, 06:09 PM
Go to the top of the page
 
RJD
post Jun 21 2017, 06:23 PM
Post#75


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


Doug: Look at the control just before (to the left of) the pkLog_No in your db (not my revision). It is very small. It is used to display a * in some cases. In Design View, right-click on the control and select properties. You'll see the expression with the field that does not exist, plus a ref to a control on a form. I do not know what the form control is used for, since you didn't include the form in your posted db. And it did not look right to me anyway. Dig into that.

HTH
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 22 2017, 09:53 AM
Post#76



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


Joe,
I think the * may actually be a pound sign.
There is a pound sign(#) on the report, before the log number,
I will look at it right away, I have backup, not the revision to look at to find it.
Thanks, appreciate your help!
Go to the top of the page
 
RJD
post Jun 22 2017, 11:51 AM
Post#77


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


No, actually it is a * ... Here's what is in the control in the report in the db you posted ...

=IIf([Action_Date_Field]<DateSerial(Year(Now()),Month(Now()),Day(Now())) And [Forms]![Dues]![cbxPast],"*"," ")

Action_Date_Field is no longer a valid field name, and the form was not included in your posted db.

Plus, the use of DateSerial is not necessary. You could just use Date() instead of picking apart Now() with the DateSerial.

HTH
Joe

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
Doug Galayda
post Jun 22 2017, 12:05 PM
Post#78



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


ok, Thanks!
Go to the top of the page
 
Doug Galayda
post Jun 22 2017, 04:39 PM
Post#79



Posts: 158
Joined: 19-May 10
From: Springfield, Illinois


On a test copy of the report
After I deleted the small field(control) off the layout next to the pkLog_NO,
the report would generate with out the Action_Date_Field prompt.
(when the report generates, that field appears to me as a # sign)

that small field did indeed contain this code on the control source property line
=IIf([Action_Date_Field]<DateSerial(Year(Now()),Month(Now()),Day(Now())) And [Forms]![Dues]![cbxPast],"*"," ")

I did not know that IIF code was in the control source property of that small field.
(This is code that was already there before me)

Thanks for a good detection lesson, every lesson will be used in a decision further down the road.
(I noticed before that if I deleted All the controls, the prompt went away,
~~But I absolutely did not know it was because of IIF code in a control's source line,
Thank you!!
This post has been edited by Doug Galayda: Jun 22 2017, 04:44 PM
Go to the top of the page
 
RJD
post Jun 22 2017, 04:42 PM
Post#80


UtterAccess VIP
Posts: 7,495
Joined: 25-October 10
From: Gulf South USA


thumbup.gif

--------------------
"Each problem that I solved became a rule, which served afterwards to solve other problems."
"You just keep pushing. You just keep pushing. I made every mistake that could be made. But I just kept pushing."

Rene Descartes 1596-1650 (Mathematician and Philosopher)
Go to the top of the page
 
4 Pages V « < 2 3 4


Custom Search
RSSSearch   Top   Lo-Fi    26th June 2017 - 12:22 PM