On all but one PC the function "FileDateTi me" works fine, but on this
one PC I get the error #Name.
WHY???
On a form, in the textbox's ControlSource I typed:
="The Data for this program was last updated on: " &
Format(FileDate Time("\\Phxfs10 8\Shared2\Trans fer\Pics\new.tx t"),"Short
Date")
It returns the correct date on all but one PC.
WHY???
Thanks, Rick
3  5326 
Reference problem? http://allenbrowne.com/ser-38.html
File problem (e.g. permissions)?
Open the Immediate Window (Ctrl+G) and try:
? Dir("\\Phxfs108 \Shared2\Transf er\Pics\new.txt ")
Otherwise there could be differences in regional settings (Windows Control
Panel) or versions/service packs.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"2D Rick" <rb*******@comp userve.comwrote in message
news:11******** ************@k7 8g2000cwa.googl egroups.com...
On all but one PC the function "FileDateTi me" works fine, but on this
one PC I get the error #Name.
WHY???
On a form, in the textbox's ControlSource I typed:
="The Data for this program was last updated on: " &
Format(FileDate Time("\\Phxfs10 8\Shared2\Trans fer\Pics\new.tx t"),"Short
Date")
It returns the correct date on all but one PC.
WHY???
Thanks, Rick
On Feb 21, 6:27 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
Reference problem?
http://allenbrowne.com/ser-38.html
File problem (e.g. permissions)?
Open the Immediate Window (Ctrl+G) and try:
? Dir("\\Phxfs108 \Shared2\Transf er\Pics\new.txt ")
Otherwise there could be differences in regional settings (Windows Control
Panel) or versions/service packs.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"2D Rick" <rbrown...@comp userve.comwrote in message
news:11******** ************@k7 8g2000cwa.googl egroups.com...
On all but one PC the function "FileDateTi me" works fine, but on this
one PC I get the error #Name.
WHY???
On a form, in the textbox's ControlSource I typed:
="The Data for this program was last updated on: " &
Format(FileDate Time("\\Phxfs10 8\Shared2\Trans fer\Pics\new.tx t"),"Short
Date")
It returns the correct date on all but one PC.
WHY???
Thanks, Rick- Hide quoted text -
- Show quoted text -
What library contains the function "FileDateTi me"?
I thought it was part of the Access native libraries?
Thanks for your reply, I'll check his reference against mine.
Rick
What library contains the function "FileDateTi me"?
I thought it was part of the Access native libraries?
It appears in Tools References... as "Visual Basic for
Applications". Its location is
C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6 \VBE6.DLL
(or similar).
On Feb 22, 7:41 am, "2D Rick" <rbrown...@comp userve.comwrote :
On Feb 21, 6:27 pm, "Allen Browne" <AllenBro...@Se eSig.Invalidwro te:
Reference problem?
http://allenbrowne.com/ser-38.html
File problem (e.g. permissions)?
Open the Immediate Window (Ctrl+G) and try:
? Dir("\\Phxfs108 \Shared2\Transf er\Pics\new.txt ")
Otherwise there could be differences in regional settings (Windows Control
Panel) or versions/service packs.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"2D Rick" <rbrown...@comp userve.comwrote in message
news:11******** ************@k7 8g2000cwa.googl egroups.com...
On all but one PC the function "FileDateTi me" works fine, but on this
one PC I get the error #Name.
WHY???
On a form, in the textbox's ControlSource I typed:
="The Data for this program was last updated on: " &
Format(FileDate Time("\\Phxfs10 8\Shared2\Trans fer\Pics\new.tx t"),"Short
Date")
It returns the correct date on all but one PC.
WHY???
Thanks, Rick- Hide quoted text -
- Show quoted text -
What library contains the function "FileDateTi me"?
I thought it was part of the Access native libraries?
Thanks for your reply, I'll check his reference against mine.
Rick
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Bo Wisén |
last post by:
Hi,
Let's say I've some files in a folder with the same suffix, for example
..abc. Is there anyway I can let VB decide which one of them that is the
newest?
/ Bosse
|
by: Ron |
last post by:
Yes, I am trying to use the FileDateTime function from
vb.net in C#. I am just starting out in C#. Here is how
I use FileDateTime in vb.net:
Dim NewDate As DateTime
NewDate = FileDateTime("C:\SomeDir\TestFile.txt")
In C# I got this far:
DateTime NewDate;
|
by: Chris |
last post by:
I have a program in VB 6 and one in VB.NET that both call the
FileDateTime function. On the same file the VB 6 call returns the
correct modified time, the .NET code is exactly one hour off.
VB 6 code, returns 9/18/2003 1:59:28 PM (which is correct)
Private Sub Command1_Click()
MsgBox FileDateTime("c:\streets_f.shp.test")
|
by: Tom |
last post by:
It appears that you can't compare two dates in DotNet. You must use
ToString and compare the strings. Is that the only reliable way?
Try this:
Dim dteOne As Date = FileDateTime(Application.ExecutablePath)
Dim dteTwo As Date = FileDateTime(Application.ExecutablePath)
SaveSetting("Test", "Dates", "DateThree",
FileDateTime(Application.ExecutablePath))
Dim dteThree As Date = CDate(GetSetting("Test", "Dates",
|
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: liljet |
last post by:
***From previous post***
Is it possible to have an Access form that displays in a text box the
last modified date of c:\myworkbook.xls?
try setting the data property of the text box to ...
= FileDateTime("c:\myworkbook.xls")
My Question
|
by: cj |
last post by:
I am under the impression they are obsolete methods included for
backward compatibility. For instance is using
filedatetime("c:\myfile.txt") still the accepted way of getting the date
c:\myfile.txt was last modified? I see filedatetime is in the
Microsoft.VisualBasic namespace. Is there some
dim file as new something
dim lastchanged as date = file.datetime
method we are supposed to use now?
|
by: olle |
last post by:
HI Everyone.
I have tried to get the filedates of images in different maps using
Access2000.
To get the filenames I do like in the vba-code below. That is no
problems.
But how do do I get the actual date of the filename?
Is it possible to get the date that some jpg-images were created?
Hope someone know something about this.
|
by: Cliff72 |
last post by:
Is there a way in VBA to check if a linked table in the database has
been updated?
Example:
I have a table "LedgerTemp" which is a direct link to a text file on
the LAN "Ledger.txt"
This text file is periodically updated (overwritten) through out the
day and night by some mainframe jobs.
Right now I just manually run a macro that just basically appends data
from the linked "LedgerTemp" table to a local table "Ledger"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
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: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| | |
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...
| |
