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

    SQL DMO - EnumAvailableMedia

    Can anyone tell me how to interpret the results from EnumAvailableMedia I have queried my Application object and it returns these results about my drives: Drive 1 QR.GetColumnString(I, 1) = "C:\" QR.GetColumnLong(I, 2) = 920580096 QR.GetColumnLong(I, 3) = 0 Drive 2...
  2. JRumage

    Delimiters with LIKE

    Is there any way to use an apostrophe inside the like statement?&nbsp;&nbsp;For instance I want to find people with the last name that starts with <b>O'Co</b> as in O'Connell.<br><br>Are there other delimiters that can be used to make SQL ignore the apostrophe without using the _...
  3. JRumage

    Has the Form Changed???

    Can anyone tell me what cause the following message:<br> <br> 'MyFormName' has been changed since the last time you opened it, either by another user or because another instance of it was opened on your machine.<br> <br> <br> I get this error on a form when I jump from it to an invoicing screen...
  4. JRumage

    Importing changing data statistics from router

    Are you running a delete query before you import the new data? Are there any Autonumber fields in the table, that may be getting stomped on with the new data?
  5. JRumage

    Programatic Wizards

    Does anyone know the correct procedure calls to start the built-in wizards (Mailing Labels). For instance to pass the wizard an SQL statement. <br> <br> <br> Thanks
  6. JRumage

    2000 compliance in Microsft Access 97

    Access 95 & 97 both use the OLE Automation library to determine what rules to apply to dates. So any software you install that updates or changes this library will affect how access handles dates. <br> <br> I suggest (If you haven't already) that you read the following article:<br> <br>...
  7. JRumage

    Access basic 97

    Here is a Brute force approach with no error trapping,<br> <br> <br> Sub ClearForm()<br> Dim frm As Form, ctl As Control<br> <br> ' Set the current form as the target<br> Set frm = Screen.ActiveForm<br> ' Enumerate Controls collection of each form.<br> For Each ctl In...

Part and Inventory Search

Back
Top