Thank you, this is very informative.
Given that this TimeStamp field is not bound to the system date and time, do you know of any other field used by SQL that would actually store the date and time that a record is added or changed?
Does anyone know how to convert a binary timestamp from SQL Server into something Access can understand and report on? A binary field in an Access table looks empty, like it's coming from a different universe. How can I convert this to the usual mm/dd/yyyy stuff we all know?
- Ken
What I would have done is create a String variable called strSQL. Next, I would've said something like:
strSQL = strSQL & "(First 60 characters of the SQL code)"
strSQL = strSQL & "(next 60 characters")
etc.
I'd follow this up at the end with strSQL.execute
Ken
Thanks for the ToggleScreenSize() function. it undeniably 'works', but at the cost of resetting the screen refresh rate to 60Hz.
Obviously, this results in a heavy black border around everything. It's not a workable solution, since asking the user to change her/his refresh rate is even a...
I am trying to run an Access2000 database in XP, but continually am told that there's a missing or broken reference to msoutl9.olb. This .DLL is used in Access2000 to connect Access to Outlook. Do you know of any update to this program? I am wanting to run the AccessXP code under CITRIX.
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.