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

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
2 Pages V < 1 2  (Go to first unread post)
   Reply to this topicStart new topic
> Get Week Day Into Code, Access 2013    
 
   
theDBguy
post Oct 5 2017, 02:23 PM
Post#21


Access Wiki and Forums Moderator
Posts: 70,820
Joined: 19-June 07
From: SunnySandyEggo


Hi Tom,

Did you see the animated image I posted earlier? If not, try clicking on it to see the animation.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
wizcow
post Oct 5 2017, 06:49 PM
Post#22



Posts: 283
Joined: 10-April 03
From: B.C. Canada


dbGuy

you need to hold the shift key while opening smile.gif

Thanks
Tom
Attached File(s)
Attached File  Employee.zip ( 54.27K )Number of downloads: 3
 

--------------------
Anything worth doin'
is worth OVER-doin' !!!
Go to the top of the page
 
theDBguy
post Oct 5 2017, 09:20 PM
Post#23


Access Wiki and Forums Moderator
Posts: 70,820
Joined: 19-June 07
From: SunnySandyEggo


Hi Tom,

Thanks. It really helps a lot when we can see the problem in action.

Take a look at the attached and let us know if you have any questions.

Hope it helps...

Attached File(s)
Attached File  Employee.zip ( 37.99K )Number of downloads: 2
 

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
gemmathehusky
post Oct 10 2017, 06:09 AM
Post#24


UtterAccess VIP
Posts: 4,426
Joined: 5-June 07
From: UK


I would prefer to use the date itself, rather than a caption
this sort of thing.

CODE
If weekday(thedate) = vbSaturday Then
GetMail
End If

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 
wizcow
post Oct 12 2017, 12:49 PM
Post#25



Posts: 283
Joined: 10-April 03
From: B.C. Canada


Thank you sooo much everyone!
That fixed the problem.
I dont know what I would do with out this forum.
Tom

--------------------
Anything worth doin'
is worth OVER-doin' !!!
Go to the top of the page
 
theDBguy
post Oct 12 2017, 12:51 PM
Post#26


Access Wiki and Forums Moderator
Posts: 70,820
Joined: 19-June 07
From: SunnySandyEggo


Hi Tom,

You're welcome. We were all happy to assist. Good luck with your project.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
cheekybuddha
post Oct 12 2017, 01:06 PM
Post#27


UtterAccess VIP
Posts: 9,175
Joined: 6-December 03
From: Telegraph Hill


What was the problem in the end?

(Sorry, too lazy to download!)

--------------------


Regards,

David Marten
Go to the top of the page
 
theDBguy
post Oct 12 2017, 01:11 PM
Post#28


Access Wiki and Forums Moderator
Posts: 70,820
Joined: 19-June 07
From: SunnySandyEggo


Text data type instead of numeric.

--------------------
Just my 2 cents... "And if I claim to be a wise man, it surely means that I don't know" - Kansas
Microsoft Access MVP | Access Website | Access Blog | Email
Go to the top of the page
 
cheekybuddha
post Oct 12 2017, 01:12 PM
Post#29


UtterAccess VIP
Posts: 9,175
Joined: 6-December 03
From: Telegraph Hill


thumbup.gif

d

--------------------


Regards,

David Marten
Go to the top of the page
 
2 Pages V < 1 2


Custom Search
RSSSearch   Top   Lo-Fi    18th October 2017 - 11:50 AM