Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

...'Given a pointer to a string, returns the string Dim lngRtn As Long 'API function return value Dim pstrTmp As String * 512 'Buffer to copy the string into lngRtn = lstrcpy(pstrTmp, ByVal lngPtr) If InStr(1, pstrTmp, vbNullChar) > 0 Then 'Return the...