Using Acc2k
Can anyone suggest some sample code for returning the date of a Linked File?
I am linking MyFile.xls as tblMyFile. Simply put, somewhere on a form I would
like to the date of the xls file.
Any suggestion appreciated.
Thanks in advance
"And.... Exactly at which point did you consider this a good idea?" 6 10246
On 10 Oct 2003 13:37:42 GMT, cl*******@aol.c omNoSpam (Clint Stowers)
wrote:
What part of the FileDateTime function don't you like?
-Tom. Using Acc2k
Can anyone suggest some sample code for returning the date of a Linked File?
I am linking MyFile.xls as tblMyFile. Simply put, somewhere on a form I would like to the date of the xls file.
Any suggestion appreciated.
Thanks in advance
"And.... Exactly at which point did you consider this a good idea?"
In article <rg************ *************** *****@4ax.com>, Tom van Stiphout
<to*****@no.spa m.cox.net> writes: What part of the FileDateTime function don't you like?
Just the date. Would be nice to know how current is the file. Time is of no
value.
"And.... Exactly at which point did you consider this a good idea?"
In article <rg************ *************** *****@4ax.com>, Tom van Stiphout
<to*****@no.spa m.cox.net> writes: What part of the FileDateTime function don't you like?
Seems like Tom has gotten redirected.
What I would like is to return the date (mm/dd/yy) of a spicific file.
"And.... Exactly at which point did you consider this a good idea?"
Well, this would be very tricky, but how about
Int( FileDateTime( pathname ) )
Roberto
"Clint Stowers" <cl*******@aol. comNoSpam> escreveu na mensagem
news:20******** *************** ****@mb-m13.aol.com... In article <rg************ *************** *****@4ax.com>, Tom van Stiphout <to*****@no.spa m.cox.net> writes:
What part of the FileDateTime function don't you like?
Seems like Tom has gotten redirected.
What I would like is to return the date (mm/dd/yy) of a spicific file. "And.... Exactly at which point did you consider this a good idea?"
"Clint Stowers" <cl*******@aol. comNoSpam> wrote in message
news:20******** *************** ****@mb-m13.aol.com... In article <rg************ *************** *****@4ax.com>, Tom van Stiphout <to*****@no.spa m.cox.net> writes:
What I would like is to return the date (mm/dd/yy) of a spicific file.
dim fDate as Variant
fDate = FileDateTime("d :\stuff\specifi c.txt")
MsgBox Format(fDate, "mm/dd/yy")
In article <PG************ *******@twister .nyroc.rr.com>, "rkc"
<rk*@yabba.dabb a.do.rochester. rr.com> writes: dim fDate as Variant fDate = FileDateTime("d :\stuff\specifi c.txt") MsgBox Format(fDate, "mm/dd/yy")
Sorry for not getting back sooner. Had one of Unscheduled Emergencies.
Looks like it will do the trick.
Thanks.
"And.... Exactly at which point did you consider this a good idea?" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: mbosco51 |
last post by:
Hi. I am tring to setup an asp script that will do the following...
If file date/time is within last 10 minutes then
response.redirect to file
else
do something else
end if
The text file is not located on the webserver. I created a virtual
directory on the webserver which allows me to response.redirect to the
|
by: Mike Brashars |
last post by:
Hi all,
I have been searching for a week and am unable to find and example to
"Populate picklist from directory and return file name".
I have a php script that reads a log file and plots a graph. Right now, the
log name is hard coded. The logs are archived each day in the form of say
ddmmyy.log and I would like to put a drop down list in the script that would
allow my script to run off the "log" picked or default to the current "hard...
|
by: AP |
last post by:
Is there anyway to determine what the modified or create date is for a
file? In my example I am uploading a text file using the following to
select the filename: GetOpenFileName Lib "COMDLG32.DLL". Is there
anyway to point to that file and return the information about the file
properties? Size, date modified, created, etc?
Thanks
|
by: Pierre Maricq |
last post by:
Hi,
I am using Win2000 and Access2000.
I need to build build a macro or write a VBA in Access that would screen all
files contained in a directory on my C drive (files are structrured DAT
files ) and update an Access table with the following
information:
(1) Filename (variable lenght)
(2) Modified File Date/Time
|
by: Agnes |
last post by:
Does .net provide any function for such purpose ?
e.g today is 21-10-2004, the week is 43, now I want to get the DATE with
(week 42, Monday)
Thanks alot
| |
by: Thomas Homan |
last post by:
Hello,
Is there a method in the FtpWebRequest that allows for preservation of the
file being transferred original date and time in vs2005 vb?
In the FTPSample the method is to set up stream for incoming file and
create. This sets the file date and time to the system date/time when file
is actually transferred rather than retaining the date and time of the file
as it sits on the FTP server.
|
by: Mike Charney |
last post by:
Is there a way to check a files date and time stamp from VBA in access.
I have a need check a date stamp on a file that I am importing.
Thanks in advance,
Mike
m charney at dunlap hospital dot org
|
by: bindumabraham |
last post by:
what is the reason for a datefield control return system date as today's date in coldfusion
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |