Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: QueTech
  • Order by date
  1. QueTech

    Type Mismatch error

    Thanks, that worked.
  2. QueTech

    Date Variable error

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

    Type Mismatch error

    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...
  4. QueTech

    Date Variable error

    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\" &...
  5. QueTech

    Word Macro for saving documents

    Thanks that worked!
  6. QueTech

    Word Macro for saving documents

    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...
  7. QueTech

    Type Mismatch error

    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.
  8. QueTech

    Type Mismatch error

    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...
  9. QueTech

    Type Mismatch error

    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...
  10. QueTech

    Type Mismatch error

    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...
  11. QueTech

    DIsplaying services for client that were active during the date range.

    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...
  12. QueTech

    Type Mismatch error

    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...
  13. QueTech

    Type Mismatch error

    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...
  14. QueTech

    Type Mismatch error

    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...
  15. QueTech

    Type Mismatch error

    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...
  16. QueTech

    Date manipulations

    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...
  17. QueTech

    Date manipulations

    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...
  18. QueTech

    Date manipulations

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

    Date manipulations

    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.
  20. QueTech

    Date manipulations

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

Part and Inventory Search

Back
Top