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 SkipVought 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. paulbent

    Need help with Like or Regular Expression

    SleepDepD, Thanks, that's just the job! Strongm, Thanks, I didn't know that. Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  2. paulbent

    Need help with Like or Regular Expression

    SleepDepD, Thanks for the quick response. Sorry, forgot to say the comparison is case-insensitive. Problem is that I'm parsing on the position of the underscores and will be discarding them so TYPE____JOBDESC_Filename.tif with 3 addit underscores would pass the test but defeat my parsing...
  3. paulbent

    Need help with Like or Regular Expression

    I'm processing files scanned into a drop folder. The drop filenames are in the form: TYPE_JOBDESC_Filename.tif TYPE_JOBDESC_Filename_Sm.jpg Where TYPE, JOBDESC and Filename are variable length and the filename extensions are illustrative but will always be 3 chars. I'd prefer to use the Like...
  4. paulbent

    Planning to upgrade from Approach 97; any suggestions?

    If you try a Google search you should find some possibilities but nothing like as many as there are for Access. Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  5. paulbent

    Hit the limits

    There's a detailed list of limitations at http://www.xpertss.com in the Lotus Approach Discussion areas. Follow the link to FAQs, fixes and tips | FAQs | Limitations of Approach. The 255 fields per record is a dBase IV limitation, not Approach. You can have max 20 charts per Approach session...
  6. paulbent

    Read file more than 70k in size.

    I don't think it's the file size. I just did a quck test to print the first hundred lines in a 2 Mb text file and there were no problems: Private Sub Command1_Click() Dim hFile As Long Dim intC1 As Integer Dim strTmp As String hFile = FreeFile Open...
  7. paulbent

    Run-time error "48"

    If you can identify which DLL it is, this kb article may help you troubleshoot it: http://support.microsoft.com/support/kb/articles/q142/8/14.asp Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  8. paulbent

    find "not including" text

    In Find mode, you can enter a condition as a formula that evaluates to True or False and in that formula you can use the same functions as in calculated fields. The formula can also compare fields in the record with values in variable fields. It's a powerful tool! Paul Bent Northwind IT Systems...
  9. paulbent

    Validating an email field using the GAL

    The GAL stores e-mail addresses in multiple formats: Exchange FQN, SMTP, X400 etc. Which format are you trying to validate? Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  10. paulbent

    Generating Weekly Reports Using Query By Box

    Create a variable field, type numeric, named vAge say. Create one named find on the view with this formula, substituting your own table and field names: If(Table.DateField >= @Today() - vAge) Put the variable field on the form, enter whatever days age you wish and run the find. Paul Bent...
  11. paulbent

    calculating a bank balance not working !!!

    I don't know! Approach 96 was the first 32bit version and is 8 years old now. It was bug ridden and soon replaced. I'd recommend you buy a copy of SmartSuite 9.7 or later. Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  12. paulbent

    find "not including" text

    This is the find condition, substitute your own table & field names If(Position(Upper(Table.Field), 'VIDEO', 1) = 0) Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  13. paulbent

    OL Address Book

    If you open the public folder in an Outlook Explorer, you should be able to launch the form from the menu. Menu items are exposed through the CommandBars collection. Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  14. paulbent

    Sent Items folder - Outlook Express

    No there isn't. Outlook Express doesn't have a programmable interface. Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  15. paulbent

    Generating Weekly Reports Using Query By Box

    I don't advise using Query By Box, especially with dates. It's a bit buggy. Create a named find on the view: On a form based on the table to be searched, in Browse, from the menu: Create | Named Find/Sort | New | View. Click in the date field and enter this as the condition: >=@Today()-7...
  16. paulbent

    OL Address Book

    Dim objApp As Outlook.Application Dim objNS As Outlook.Namespace Dim objAddrList As Outlook.AddressList Dim objAddrEntries As Outlook.AddressEntry Dim objAddrEntry As Outlook.AddressEntry Dim blnExists As Boolean Set objApp = CreateObject("Outlook.Application") Set objNS =...
  17. paulbent

    searching for " (double commas) in a string

    If Instr(1, strSource, Chr$(34) & Chr$(34)) Then Paul Bent Northwind IT Systems http://www.northwindit.co.uk
  18. paulbent

    Using VB to control Document Security in Adobe Acrobat

    Have a look at the Zeon DocuCom PDF Driver 6.x, http://www.zeon.com.tw/ You can set all the PDF properties at run-time via ini file entries. There is comprehensive control over document security. FYI, my ActiveX DLL, PDXPro, wraps the DocuCom ini access and exposes nearly 180 document settings...
  19. paulbent

    Problem with GetForm crashing my app

    It get stranger. The above code actually works fine in an exe. I'm writing an ActiveX DLL and when I put the equivalent of the cmdGetForm_Click code in a public method it crashes where I indicated. I developed the code for the other methods in a pilot exe then moved it to the dll. All other...
  20. paulbent

    Problem with GetForm crashing my app

    VB6 SP4/XP Pro. I'm calling the functions to manage printer forms. They are supported by NT/2000/XP. AddForm, DeleteForm, SetForm and EnumForms work fine but there's a problem with GetForm. It's called once to return the required size of the byte buffer that holdes a PRINTER_INFO_1 udt and a...

Part and Inventory Search

Back
Top