Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Access 2000 Date Function

Comment:

Hey there guys, Just trying to finish off a database and i cant seem to get the date function to work. I have defined a string value "Today" and this works with the Now function when i code: today = now however whenever i try to assign today = date it does not work. i get the same with the time function. all i want to do is drop these fields from the system time and dat into two text boxes. txtdate and txttime. any help would be greatly appreciated. Chris Bradford Hants. UK

Reply:

So what exactly happens when you try to assign the date and time? Have you tried this: txtdate = date() txttime = time()

0

Reply:

No i haven't tried that, and i am pretty sure thats it!! I was getting nothing returned at all in my text boxes. Will try it out and let you know if it works. Thanks very much.

0

Graphics without X in lin...

Simple Counter

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I was wondering if anyone can help? I am having problems carrying out a time calculation. The application has to calculate the duration of time by looking at a time in and a timeout box and compa...

Summary: I'm trying to write a access 2000 VBA search function that accept user text input and return records based on case id or name found (as entered by user). Case id is the primary key for all records. Ca...

Summary: I have created a project (Reference Library) using VB6 and Access 2000. The VB front end consists of two forms, Title Form and Copy Form. The following code is run at ‘Form Activate’ and is situated...