Search results for query: *

Thanks, that worked.

I want the date to display in the filename in the follow format: "yyyy-mm-dd_hh_nn

FYI I am using the code below to save the document. However the dtdate variable is giving me an (variable not defined) error. Private Sub CommandButton1_Click() dtdate = Format(Now, "yyyy-mm-dd_hh_nn") ActiveDocument.SaveAs filename:="C:\temp\" & dtdate & "Format." & "TEST3" Unload...

I am using a VB macro to save my document with the filename I provide. I want to use the current date and time in the file name. I use the following code: Option Explicit Private Sub CommandButton1_Click() dtdate = Format(Now, "yyyy-mm-dd_hh_nn") ActiveDocument.SaveAs filename:="C:\temp\" &...

Thanks that worked!

I am using MS Word and VB 6.3. I need to save my document at the close of the document. I would like to code the path and filename of the document. My current code is below, this code works so far, however, Words save dialogue box opens after I exit the save dialogue box I created. Can I...

I am in need of help for both but the saving issue will do me now good, with out the header text placement issue resolved. Previously, you wrote that there is away around the text placement issue. If you could provide that information I will implement the fix.

In the Header there are two tables (created by going to Table > Insert > Table). The first table consist of two columns and Three rows, each column is 4 inches in width and the rows are 1/4 inch in hieght. The second table consist of two columns and 7 rows with same diminsions as the first...

I have not corrected my issue with the placing text in each header, however,I think I understand why I recieved the 5491 error. In an attempt to clarify what I am trying to produce: My macro opens a form that gather information and the macro places the text on the document. Once the user is...

The first eight headers are the same. The nineth header is different and headers 10 and 11 are the same as the first eight. I have "Link to the Preveious" for headers 2 - 8 back to Header 1 . Headers 2-8 state (at the top) "Same as Previous" Header 9 is dfferent Header 10 does not state "Same...

I am using Crystal 10 on Win Xp machine. I use OBDC connection to Intersystems Cashe driver to Cashe database. I need to display services provided to clients that were active during the date range provided. Tables utilized tx_history_all , Movement_history. I create a parameter (?date) using...

I believe I have inserted the bookmarks correctly on all of the pages of my template. However, when I run the macro the text is place on the last page only, withou the 5941 error. Here is my VB code. Private Sub CmdFill_Click() namevar = frmFormat.txtname.Text idvar = frmFormat.txtID.Text...

What I should have said was that my process for creating a bookmark was different(not the wrong type). Previously I would place the text "(name)", "(number)", etc. in the header by typing them in the header. I would then use my code to search the header for the text and replace the text(as...

Hi, I want to respond to the following questions. 1. WHAT "wrong" type of bookmark???????? Since you did not post the code showing how you inserting these, I am very curious as to what you were doing. I think I hav addressed that in a previous posting. But I am using Word to insert book...

I'm using MS Word 2003 there I add bookmarks to the header and body of a template (Format.dot). I used the Bookmard otion found under Insert menu option. Once they were added I save the document and I run my macro. The macro operates correctly with a couple of exceptions. Despite that, the...

OK, There was a typo in my views Here they are now. CREATE VIEW dbo.DatesandReasons AS SELECT TOP 100 PERCENT UPR00100.EMPLOYID, UPR00100.STRTDATE, UPR00100.INACTIVE, HR2EMP02.CHANGEREASON_I, HR2EMP02.CHANGEDATE_I, HR2EMP02.EMPID_I, UPR00100.FRSTNAME...

Here is the Code for the DateandReason View: CREATE VIEW dbo.LatestChanges AS SELECT TOP 100 PERCENT UPR00100.EMPLOYID, UPR00100.STRTDATE, UPR00100.INACTIVE, HR2EMP02.CHANGEREASON_I, HR2EMP02.CHANGEDATE_I, HR2EMP02.EMPID_I, UPR00100.FRSTNAME, UPR00100.LASTNAME...

Expr1 was an alias for EMPLOYID which I have changed to EMPLOYID.

The original table is HR2EMP02 and the field is CHANGEDATE_I which is a datetime field. I have obtained the MAX(CHANGEDATE_I) AS LatestDatePositionChanged.

The LatestDatePositionChanged should be datetime and Grace should be a datetime. How so I ensure that LatestDatePositionChanged is a datetime?