Mailing time
svip
-
svip -
svip -
Hello,
I am desperately trying to merge Access and Word with a time field. No matter how much I specify \HH:mm, my result remains in the form 30/12/1899 09:30:00 instead of 9:30. How can I get rid of that 30/12/1899 and those seconds?
I've been looking through forums but can't find an answer, or the solutions don’t work!
Thank you in advance
I am desperately trying to merge Access and Word with a time field. No matter how much I specify \HH:mm, my result remains in the form 30/12/1899 09:30:00 instead of 9:30. How can I get rid of that 30/12/1899 and those seconds?
I've been looking through forums but can't find an answer, or the solutions don’t work!
Thank you in advance
Configuration: Windows XP / Firefox 3.5.8 / Word and Access 2003
3 answers
-
Good evening,
The DDE protocol is useful instead of OLE and it should work.
m@rina
--
- "On the office forum, questions about office automation are asked..."
- "Oh really???"-
Hello,
actually, the DDE protocol doesn't want to cooperate: I have to request to go through ODBC. So yes, in all the forums I read this magical answer, but it says: "unable to reestablish a DDE link with Microsoft Access to complete the current task", so I take the next option, and everything seemed to work fine, until my appointment times... If the solution is to go through DDE, how can I do that?
Thank you in advance.
-
-
Hello,
The DDE handles a lot of these kinds of issues, but the connection is also more temperamental!
As soon as we change something, we run into this type of error message.
In this case, we need to start from scratch.
I'm not asking you to redo your Access database ;)) but try creating a new Word document where you copy the content of the old one. Re-establish the connection from scratch via DDE while keeping the Access database closed.
m@rina
--
- "On the office forum, we ask questions about office tasks..."
- "Oh really ???"-
Hello,
I opened a blank Word document, I tried to do a mail merge via DDE, but I keep having the same issue. I then tried creating a new document in which I pasted my old one... still the same!
But it's been a long time that I've been trying to use DDE and it hasn't worked. So is there no other solution to import hours?
Thank you.
-
-
Hello,
Is your switch correct? ... Because the way you wrote it in your first post, it’s not right.
The switch should be:
\@ HH:mm
m@rina
--
- "On the office forum, questions about office work are asked..."
- "Oh really???"
