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 Rhinorhino 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: Tianjin
  • Content: Threads
  • Order by date
  1. Tianjin

    xcopy acts strange behavor

    I include a simple line xcopy c:\test.txt c:\temp in a batch file test.bat. File and folders in context are all exist. when I run this batch file through either double clicking batch file or typing batch file name in the command window, it gave me an infinite rolling screen with repeative text...
  2. Tianjin

    SQL CLR Can not run on other machine

    I wrote A SQL CLR Stroedprocdure using C# on my machine and then deployed it to SQL Server 2008 on our company server. I Create a crystal report called this stored procedure and it worked fine. However, when I run this report on the other machine, it gave me an error as "Failed to open rowset...
  3. Tianjin

    Barcode press Ctrl+S on keyboard

    Hi All, I have excel spread sheet where user can scan the barcode for data entry. instead of have user to use mouse or keycode to save workbook, I would like to use a barcode to act as if user press Ctrl+S which will trigger the saving. I found a piece of barcode for this purpose from a...
  4. Tianjin

    SQL with INNER JOIN run very slow

    I have two sql script as below that can generate same result. However, for unknow reason, the second one run almost 10 times faster than the one with "INNER JOIN", anybody can explain why? From my understanding,sql script that using INNER JOIN refer the newest sql syntax and it should run...
  5. Tianjin

    Inactivate part number cause integrity errors

    As too many very old part numbers in our mysis system might cause poor perfermance, Last night I deactivated 8000 out of 22000 part numbers in the item module through accpac importing function, and those numbers may be currently used in the BOM at different level. It looks like system run OK. I...
  6. Tianjin

    Need sample database file "DEMODATA"

    I don't know when the sample database "DEMODATA" was missed on the server and I am currently learning syntax of pervasive sql engine. Without the sample database in place, It really difficult to play around sql example. what I knew is that the sample database is installed along with pervasive...
  7. Tianjin

    Show one of four sections of a group header

    I have report has a group header with four sections that used to show different information. when group detail cross more than one page I would like to repeat only one of those four section. In other words, I can not just simply set group option to repeat the the header. Is this possible...
  8. Tianjin

    Installed report doesn't show in the allocated group

    I take an existing report from Mysis and add one more field into the report. Save as report in a different name. and then I installed the report with exactly setting as the report copied from. installation carried out successful. however, when I tried to run it from mysis, I could not find this...
  9. Tianjin

    Default to office 2000 over Office 2003

    I have both office 2000 and 2003 installed in my computer. by default, windows system uses office 2003 for opening all office file(xls, word...). However, All applications were developed with office 2000 and in addition, office 2003 is not available in many computers in my company. Is there a...
  10. Tianjin

    Summary based on running total, Possible?

    I have a report include a running total field that is used for check qty balance base on Stock Qty, OrderQty and Purchase order qty for each product. In this way, purchaser can discovered those purchase orders are later than sales order. balance qty could be a positive number which means OK and...
  11. Tianjin

    How to keep sql format in the pervasive view

    I created a view in pervasive control center by typing sql script as following with proper line feed. SELECT MIMOH.WOHID, MIMOMD.WOMDID, MIMOMD.ITEM, (MIMOMD.REQQTY-MIMOMD.ENDQTY)*-1 AS MOQTY, MIMOH.ORDERDATE, MIMOH.STARTDATE, MIMOH.ENDDATE FROM MIMOH, MIMOMD WHERE MIMOH.WOHID = MIMOMD.WOHID...
  12. Tianjin

    How make option's datasheet seting effect on existing form

    I made a form in datasheet view. however, I found the font size is too big to include all data. I change font size in tool-option-datasheet tab. from this point, every new form created in datasheet view takes effect on smaller size font, but existing form do not. Is there anybody could tell me...
  13. Tianjin

    Can Crystal Report merge two datasets together?

    Hi I have two datasets, one is from PO and the other one is MO. I would like to Merge these two datasets together with their common fields (Id, Item, Date) and sort merged list by date. I wonder if crystal can manipulate this type of operation. Thanks tianjin
  14. Tianjin

    Recorded Marco for Mysis Purchasing didn't process completely

    I recorded a Marco for receiving material in Mysis purchasing module. When I tried to re-use this code to process receiving other material. It shows integrity issue where STOCK didn't get increased and ONORDER QTY didn't get decremented. The only changes I made to the recorded code are replacing...
  15. Tianjin

    ADO Data Control 6.0 event failed to work

    I have a vb6.0 program that using ADO Data Control 6.0(SP3)(OLEDB) as data source, and I also need Microsoft ActiveX data Object 2.x library (SP3) for coding. However, as long as I reference to activeX data object library higher than 2.0 and run the program, it gave me an error at event of...
  16. Tianjin

    Crystal report can not run on COM Data source in Accpac

    I created a COM data source that can delivery different dataset based on each computer user. I use crystal report XI to create a sales analysis report base on this data source. It works fine in original crystal report. however when I tried to run this report from Accpac, it gave "logon failed"...
  17. Tianjin

    Open editable PDF through hyperlink in Excel

    I have a microsoft excel spreadsheet in which a lot of PDF file were entered as hyperlink. whenever I click on it, it opens pdf file with Adobe acrobat in an embed mode(read only). however, in some other computers, pdf file can be opened as an editable file. Anybody knows why? and how to make it...
  18. Tianjin

    How can I retrieve a complete hyperlink address

    I am working on a small piece code by which all hyperlinks in the workbooks will be verified and see whether or not a file associated to certain hyperlink is existing. My problem is that the return of code "hyperlinks(1).address" was truncated at left side. So I can use this address to tracing...
  19. Tianjin

    Create a centre Criteria for multiple queries

    I have several queries in my access database. All of them have exact same criteria. In some circumstance of changing existing or adding new records, I need to modify all criterias in each query in order to get right result. I wonder whether there is a simply way to just set up a centre criteria...
  20. Tianjin

    How can I reference criteria content in query design view

    I have a access query that will generate a product list base on different criteria. I save all the criterias in a seperate table. Is there any way that I can progammably change the criteria? So I don't need copy and paste criteria text into query design view. Thanks

Part and Inventory Search

Back
Top