Stewart,
Thanks for the reply.
I'd gone to each query and formated it:
...>=#" & Format(sMyDate, "mm-dd-yyyy") & "# AND...
It then queries the DB using the english date format. I still do not understand it as when using Format(sMyDate, "dd-mm-yyyy") it searches for data using the american way. As if it works opposite... Anyway it works.
Thanks again.
tom26pr
Last Activity: Jun 9 '08, 09:46 AM
Joined: Mar 17 '08
Location:
-
american date format in VBA
Hi there,
When trying to query the DB with the following:
...WHERE ((filed)>=" & UKDate(sFromDat e) & " And (field)<=" & UKDate (sToDate) & ")
I'm getting output in american format.
The UKDate() function seems correct:
Function UKDate(varDate As Variant) As String
If IsDate(varDate) Then
UKDate = "#"... -
Stang02GT ,
1. I've managed to add and use a .bmp file for a new/additional topic (using image workshop).
2. When I open this project (that needs edited in Robohelp) and go to 'Project' pane, then Topics | All Topics | right click 'new' | 'topic'
I manage to add a new topic to the file (and it is dropped at the bottom of the word.rtf) as intended. The same procedure will let me deleted unwanted/existing topics. This...Leave a comment:
-
Stang02GT
Thanks for your prompt answer...
Sorry, I meant a help file based on word.doc.
I have installed Robohelp 6 and palyed around with it a bit and the story is as follows:
1. I will need to edit the existing help file (that is based on a word.doc). I will need to remove some parts and add other.
2. I've managed to add a new topic to the file, however I don't seem to be able to format the title of...Leave a comment:
-
How do I create a help file for a word.doc?
Hi there,
I will need to create a help file for a word document.
I've never done this before so the question is:
Would you do that manually or use a tool (robohelp for instance)?
Do you know of any open source tools that would be helpful here?
Any ideas appreciated.
Regards. -
marcf...
Thanks a lot. This is what I am going to do. I will simply import it. I don't think I can change the shape of a table without changing its data content (using 'synch' option).
Thanks for your reply.Leave a comment:
-
How do I update Access 2003 with changes?
Hi there,
I have the folloiwng issue.
I have implemented major changes to the application's forms (Access 2003 DB), mods, tables, queries (design part) and so on.
I need to update the client's application with those changes but I cannot (for instance) change the actuall data in the tables. So the only changes in question are those design ones... (for instance, I will need to add a few fields to a particular table but...
No activity results to display
Leave a comment: