i usually get around this problem by formatting this field as TS (time stamp) which is not available in access. i format it like this and write it to the text field.
yyymmdd:hh:nn:ss:iiii
year/month/day
hours (military)
minutes
seconds
miliseconds
20070226:13:04:20:0645
' choose table name here depending on workstation or
' from a text file that contains the workstation name and
' the table name. or you can put them in an array
' connect to the database
db_path = "c:\acces_database_name.mdb"
Set objConnection = CreateObject("ADODB.Connection")...
i have had experience like this with a cmd window. it just flashes and goes away. it's usually when there's an error on the cmd window. or if telnet is not authorized by group policy or something.
thanks everybody.
this is good information. i downloaded freeundelete. disappointing results. it showed nothing on a 80 gig drive. i'll try other suggestions.
thanks again.
hi,
is there a way to recover / undelete files that were deleted in cmd window? my son deleted some files from a directory. and we can't find them in the recyble bin?
thanks.
you can terminate the first app by alt-f4 "%{F4}" then let it settle down wscript.sleep 200
then start the next app. unless when you terminate the first app, you have to press some other keys other than alt-F4!
spark,
thanks.
it worked. i tested the app. i used sendkeys to write the variable to notepad, then alt+F, then alt+P, and the print dialog comes up. we can close this thread.
thanks again everybody.
the cleanest way to do this, is to get the file type. and look at that.
you can use file property - file.type
this will return "text document" for .txt and "IQ file" for .IQ
Set fso = CreateObject("Scripting.FileSystemObject")
Set f = fso.GetFolder("C:\testlogs")
Set fc = f.Files
intCounter =...
sparks,
thanks.
this is jsut a file print. file > print.
the ideal solution is variable to print. var > print.
i have already used invokeverb to print a temp file. i'm looking for a way to print without a file. could this code work witout a file? if it does, then that's what i'm looking for...
i tried the Echo var>prn.
i think that it tried to send something to the printer. but tne network won't allow it, because the document doesn't have a name.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.