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

    CCRP DATETIMEPICKER EXECUTEABLE LOST

    ANYONE HAVE IT TO SEND ME? I FOUND ON THE INTERNET A CCRP DATETIMEPICKER EXECUTEABLE THAT WHEN RUN IT REGISTERED IT AND SHOWED UP IN ACCESS REFERENCES. I USED IT WHEN THE MICROSOFT ONE DIDN'T RUN RIGHT. I REPLACED THE NAME OF THE MICROSOFT ONE WITH THE CCRP ONE AND THE FIELD FOR THE DATE...
  2. plang99

    Want to use MCConCtl.DTpicker to update "WeekEnding" field.

    I have a field on a form called ActiveXCtl42 to choose the date and I want it to update a field called "WeekEnding". The choose date field is using MCConCtl.DTpicker. "WeekEnding" is a date field. I used the code: Private Sub ActiveXCtl42_LostFocus() [WeekEnd] =...
  3. plang99

    Access 2000 OLE on VB6 Form

    One for Access 97 works but the one for Access 2000 doesn't. What am I missing?
  4. plang99

    e-mail field with hyperlink in Access 2000

    Want to click on it to open message in Outlook with e-mail address inserted. What do I need?
  5. plang99

    E-mail hyperlink in e-mail field in Access 2000

    Want to click on it to open message in Outlook with e-mail address inserted. What do I need?
  6. plang99

    Access 2000 Northwind Orders Form button for "Add New Product"

    In Access 2000 Northwind.mdb I have a "Enter new Product" Button on Orders Form and on the "New Product" Form (based on qryProducts) I have a "Save" and "Close Form" button. When back to Orders Form and in the Subform the New Product does not show up. I...
  7. plang99

    Access 2000 Northwind Orders Form button for "Add New Product"

    In Access 2000 Northwind.mdb I have a "Enter new Product" Button on Orders Form and on the "New Product" Form (based on qryProducts) I have a "Save" and "Close Form" button. When back to Orders Form and in the Subform the New Product does not show up. I...
  8. plang99

    Validate [WeekEnd] Date is only a Sunday

    Validate [WeekEnd] Date is only a Sunday I put in: = Weekday(1) as Validation Rule for [WeekEnd] on Data Tab and get error message. I used the Expression Builder to make it. Also tried DatePart("d",[WeekEnd])=1 and that didn't work. The WeekBegin Date is automatically done...
  9. plang99

    Invoice Report sorting of detail band by CatergoryName, Product Name

    Invoice Report sorting of detail band by CatergoryName, Product Name Using Northwind.mdb as an example, I tried sorting the Invoices Query but that doesn't do it. I put Order By On in report and then Order By [CatergoryName], [ProductName] and that doesn't do it. I sorted the Order Details...
  10. plang99

    Text report writer for upload to mainframe.

    Access, Crystal Reports and R&R are good for paper reports but their text export adds extra spaces. Any suggestions on a third party report writer that has exact column beginning and ending alignment?
  11. plang99

    Third Part Report writer for exporting fixed field text to mainframe

    Third Part Report writer for exporting fixed field text to mainframe. Crystal Reports and R&R are good for paper as they add a space between fields. Don't need space between fields.
  12. plang99

    Need Third Part Report Generator as Access adds Trailing Spaces

    Need Third Part Report Generator as Access adds Trailing Spaces to fields and need no spaces between fields for upload to mainframe as Text file. Need to list one table (Products)in a detail band and one group (Orders and Order Details). I am used to dBase copy to filename SDF that does it...

Part and Inventory Search

Back
Top