Forum Articles
  Welcome back Join CF
You are here You are here: Home | Forum | A little help required with VBA in Access please (Dates)

You are currently viewing our boards as a guest which gives you limited access to view most of the discussions, articles and other free features. By joining our Virgin Media community you will have full access to all discussions, be able to view and post threads, communicate privately with other members (PM), respond to polls, upload your own images/photos, and access many other special features. Registration is fast, simple and absolutely free so please join our community today.


Welcome to Cable Forum
Go Back   Cable Forum > Computers & IT > General IT Discussion
Register FAQ Community Calendar

A little help required with VBA in Access please (Dates)
Reply
 
Thread Tools
Old 23-03-2005, 13:50   #1
Raistlin
Inactive
 
Join Date: Feb 2004
Location: There's no place like 127.0.0.1
Services: Depends on the person and the price they're offering
Posts: 12,384
Raistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered stars
Raistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered stars
A little help required with VBA in Access please (Dates)

Hi Guys,

This is probably very simple but I don't really know where to start.....

I want to evaluate what time it is and then have a message box pop up that says "Good Morning" if it's AM and "Good Afternoon" if it's PM.

(That's not really quite what I want to do but I'd like to get that working and then try and adapt it for my own needs from there)

Anybody know how I can accomplish this?

Thanks.
Raistlin is offline   Reply With Quote
Advertisement
Old 23-03-2005, 14:04   #2
gary_580
Guest
 
Posts: n/a
Re: A little help required with VBA in Access please (Dates)

If Hour(Now) > "11" Then
MsgBox "PM"
Else
MsgBox "AM"
End If
  Reply With Quote
Old 23-03-2005, 14:06   #3
Raistlin
Inactive
 
Join Date: Feb 2004
Location: There's no place like 127.0.0.1
Services: Depends on the person and the price they're offering
Posts: 12,384
Raistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered stars
Raistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered starsRaistlin is seeing silvered stars
Nice one Gary mate, knew it was probably simple enough
Raistlin is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:42.


Server: lithium.zmnt.uk
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2026, vBulletin Solutions Inc.
All Posts and Content are © Cable Forum