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

    learning quark express

    i inserted a postscript < eps picture into a quark document> i only see the name of the file with the eps extension> is there a way for me to see this picture on the screen? thanks in advance
  2. lb1

    Text TouchUp

    In Acrobat 6 Professional I am trying to touchUp some text but I get the following error message. &quot;All or part of the selection has no available font. You cannot add or delete text using the currently selected font&quot; I installed the fonts sent by my customer and restart the acrobat...
  3. lb1

    Cannot connet to PC on network

    Hi, I can ping to a PC on my network but I cannot see it when I am using 'My NetworkPlace > Entire Network > Entire Content > Microsoft Windows Networks. If I am on the other PC, I can connect and see the folders on the Windows 2000 machine. The folder are shared on the two machines. I would...
  4. lb1

    Retrieve and parse data from access to excel

    I have a table in access from which I want to retrieve the data. These data need to be inserted in specific cells in excel. For example, the table &quot;AA&quot; has the following data: AAAAA 25 32 BBBBB 35 25 etc.. I found a piece of code that will allow me to copy and paste all...
  5. lb1

    Query sort

    When I make a sort in a query I get the following order: 1,12,19,2,30 How can I get a sort that is: 1, 2, 12, 19, 30 Is there a specific setup to do. Thanks for any help. Louis
  6. lb1

    Clear a full Worksheet in Excel

    I would like to clear all the cells from a worksheet. Is there a command to do this or do I need to use a range? Thanks in advance
  7. lb1

    User-defined type error

    In Excel VBA, I have a piece of code : ... Dim l_rsTable As Recordset Dim l_dbDatabase As Database Dim l_wsWorkSpace As Workspac etc.. When I run the code I get the following error: &quot;User-defined type not defined&quot; I believe that I need to 'Add-in' a specific module...
  8. lb1

    Excel VBA - Access MDB database processing

    I would like to regroup some processes and do the work from one Excel spreadsheet. The processes would do the following: 1 – read a text file and fill a table in an Access database 2 – run a query that will merge 2 tables and create a new table in the Access db. 3 – read the merged table and...
  9. lb1

    Export a certain number of records

    I have a table with 100000 records and I would like to export these to a few text files. For example the records 1 to 15000 to A1.TXT, 15001 to 25000 to A2.txt etc.... Is there a query I can use to do this? Thanks Louis
  10. lb1

    Repace a carscter with another one

    In Access I would like to replace a specific character (for ex $ by Dol). I would like to write a query in the query bject and use a statement looking like replace(&quot;$&quot;,&quot;Dol&quot;). Is it possible to do this and How can I do it? Thanks. Louis
  11. lb1

    Text Tools

    In version 4 I was able to change text when it was in the acrobat file. For exmple, i was able to add an 's' if it was not here. Now, after I updated to version 6 I cannot find a way to do this. Is there a tool that will allow me to make this kind of modification.? Thanks
  12. lb1

    Locked excel spreadsheet

    I have on my desktop an excel file that is locked by another user. I can open the file as Read only. My PC is not on a network and I would like to just delete this file. So far I cannot find a way to do this. Is there a way to just delete this file or do I need to see it forever? Thanks for any...
  13. lb1

    Processing a form using ASP

    I created a forma and would like to process the info on that form using a piece of ASP code that is on my server. If possible, how can I retrieve the info (request.form?). If not possible, Is there another way to get this data and populate automatically a database? Thanks for any hints. Louis
  14. lb1

    Newbie question

    I have two drive on an alpha server-vms. One drive is name DKB100 the other one is DKB0. I am in DCL, in drive DKB100 and would like to see the content of DKB0. I tried the command: SET DEF DKB0: this do not work, Which command should I use to do what I want? Also, is there a small manual of...
  15. lb1

    Gauge, Dial Library

    A few year ago I was using a library that help me represent data. This library was able to create Gauge, Dials etc to show data. Is there anybody using such library? I will need the name of it as well as where I coukd buy it. I may eventually use such tool in VB and VBA. Thanks in advance. Louis
  16. lb1

    Unlisted-recipients

    I would like to send email to a group of customer, but I do not want each customer to the other email address. I usually put the customer emails in the BCC field and it is fine. I noticed that I do receive email that shows 'Unlisted-recipients' in the To: field. I am trying to do the same but I...
  17. lb1

    Get Drop Down Value

    I have a block!!!! How can I retrieve the value of a DropDown that is in an Excel spresdsheet. Thanks.
  18. lb1

    Multi Table Query

    Hi, I created a large database where I record information specific to each customer. Each table gives me a list of products, general information or others that I can retrieve easily for each customer. For example, my tables are as follows: Table1: Customer ID Product Manufactured etc...
  19. lb1

    Save bookmark setup

    I have an Acrobat document where the Bookmarks are visible. When I save the document and reopen it, the bookmarks are not visible any more. Is there a way to reopen the document and keep the setup existing when closing it? Thanks in advance. Louis
  20. lb1

    Use apostrophe in query

    I have an SQL statement where my search criteria could include an apostrophe. The parameter is pased to the query. What could I do to correct the following query to accept an apostrophe in the test parameter? For example, il the search criteria is &quot;four o'clock&quot; how can I replace the...

Part and Inventory Search

Back
Top