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!

  • Congratulations gkittelson 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: *

  1. starbai007

    Automate MSWord Mail Merge + Windows Task Scheduler

    Hey guys. I would like to have my automated microsoft word tool open, go through the mail merge steps via a macro (which is does fine and dandy), but it stops at the end point and prompts me with "Do you want to revert to the saved "filename.doc"? with a Yes or No option. How or is it possible...
  2. starbai007

    Send selected combo box value INTO text box on ANOTHER form.

    is there something i'm not getting? Upon using a msgbox to output the global variable from pampers example i keep getting nothing.
  3. starbai007

    Send selected combo box value INTO text box on ANOTHER form.

    Hey guys. I have a combo box(File_Name) which is getting populated from a table. I want the user to select a file from the drop down, and when they click on "open" or "run it will open a Microsoft word document as well as open another form. This works fine, but here's the problem. For the...
  4. starbai007

    Track changes to Word documents

    I want to use Microsoft Access to be able to link to and open various MS Word files. Once the user opens the file, makes his or her changes, a screen should come up within Access that should prompt them to enter any changes that they have made into a comments box. Of course it would be ideal...
  5. starbai007

    how to append yesterdays data to existing table?

    AHHA! Basically the back end has the date/time field in a "DBTIMESTAMP" format...which i'm assuming is DB2. So my question remains how do transition this format over to mySQL using Navicat? I tried every data type supported! A few more days of struggling than I will officially give up
  6. starbai007

    how to append yesterdays data to existing table?

    I bet it is...but as of right now, this is the only unique identifier we have since the field goes so down to the 6th decimal of a second! I wish there was an easy way to automate this, but I guess no one has come across a solution for this.
  7. starbai007

    how to append yesterdays data to existing table?

    Okay i think i found the issue. back end has the time down to nanoseconds, but when i import as a timestamp/text/datetime or anything else NaviCat is only able to import up till the seconds. The reason why i need this is because the Create date will be our primary key seeing that no order can...
  8. starbai007

    how to append yesterdays data to existing table?

    Surprised that this forum doesnt have an option to edit a post. // > A date is not the same thing as a timestamp in DB2. DATE stores only a > date (format YYYY-MM-DD). A TIMESTAMP stores date and time (format is > YYYY-MM-DD-hh.mm.ss.uuuuuu). \\ So from the looks of it on the DB2 side its...
  9. starbai007

    how to append yesterdays data to existing table?

    I believe it is datetime. Is there a way to do CURRENT_DATE:<TIMEFORMAT ie. 00.00.00.000000> - INTERVAL 1 DAY.
  10. starbai007

    how to append yesterdays data to existing table?

    Navi loved they syntax, but unfortunately it did not work. After i put that code into the WHERE condition, and continue with the import it still pulls data from the beginning of the year. I'm assuming that the problem has to do with the way the date/time are together in one field with the...
  11. starbai007

    how to append yesterdays data to existing table?

    I simply have a table with Year To Date data. I'm looking to update this table every night at around 9pm with a scheduled task which will run any import function i wish. Using navi-cat i can also add a conditional statement on which to import the data with. Up until now I have had to...

Part and Inventory Search

Back
Top