I'm having trouble in Access trying to work with a UDT as a whole/record. I seem to recall that this is a limitation in Access that is not in VB6.
Specifically, I'd like to be able to initialize the record with spaces and be able to write it to disk as a whole with the Write or Print...
I have a field in a table of data type OLE Object. I can open the table in table view, right click and choose Insert Object, then choose Create From File, Linked and choose a graphic file (bmp, tif, etc.).
How do I do this in VBA code?
rs.mypicturefield...?
Hey PSC,
Thanks for the post. That /FO is a good solution.
Yesterday, I found another one at: http://www.mvps.org/emorcillo/en/code/shell/tasksched.shtml
The programmer wrote a tskschd.dll then wrote a VB6 project to use it.
I set a reference to the DLL in Access then wrote my own code to...
Thanks for the post (except for the implied sarcasm).
I've visited most of those sites and still have not found a complete record layout. Even the MSDN site has some data on the fixed portion of the record, but incomplete information on the variable portion.
Another question ...
I'm running Win XP SP2 which doesn't support the /XML parameter, so I've been doing:
schtasks /query /v > schtasks.txt
The only problem is that the 'Task to Run' column gets truncated because of a long path and parameters. Any idea how to get around this? I thought XML...
Jason,
Thanks for posting your solution. I need to get this working in MS Access. I created a VBA code module and pasted in your code.
I'm getting a not defined error on:
New cExport_Scheduled_Tasks
Is there a reference that I would need to set?
Thanks!
Brooks
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.