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!

Register Log in
  • Congratulations Rhinorhino 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. glenellis

    Deleted Users

    This morning users had been completely removed from various SQL databases on our SQL Server 2000 installation. To our knowledge, we made no changes to permissions/users. Is there a way to view a log that would show when these changes occured or is there a valid explanation? Thanks in advance.
  2. glenellis

    Transact-SQL Count of records returned by query

    Have records in SQL table, many records with same date. Example Rcd1 04/01/02 Rcd2 04/01/02 Rcd3 04/02/02 Rcd4 04/02/02 Need to perform stored procedure which will pass back the number of unique dates (in this case 2) represented within a date range that I...
  3. glenellis

    Calendar Control

    I have the Form_Load & Click events tied to the Calendar form. When I run I get an error on the calDateLookup.Value = form1.text1.Text line - Error 424 Object required???
  4. glenellis

    Calendar Control

    Is it possible to display a date in a text box (04/24/02) and give the user the capability to double-click on that box to invoke a Calendar control, where they could then navigate to their desired date. It appears to me that when you use just the Calendar control the "box" is very...
  5. glenellis

    ADO

    Oops, here is the code. ========== Private Sub Form_Load() Set adoConnect = New Connection Set adoConnect2 = New Connection adoConnect.Open _ "Provider=Microsoft.JET.OLEDB.4.0;" & _ "Data Source=C:\temp\biblio.mdb;" adoConnect2.Open _...
  6. glenellis

    ADO

    I have a "simple" program to write. Need to read an Access table, perform some calcs, then write new records out to a different Access table. Got a book on ADO and I'm not quite there yet. I have attached the following test code. I've found that when I declare 2 tables, the 2nd one...
  7. glenellis

    Detail Section records

    Developing report for Purchase Req system. As an example, req #1 has 2 detail line items, and 5 comment lines that are independent of the detail lines. Want to print the 2 req detail lines together, then the comment lines after, either in a seperate detail section or in the footer. Currently...
  8. glenellis

    Exchange 5.5 Deleted users

    Manager had admin assistant (user id ASST) and she was set up as a delegate so she could see/manage Manager calendar. ASST left company and her XCHG mailbox and domain account was deleted. Now whenever users invite Manager to meeting thru Calendar function, they get message returned to their...
  9. glenellis

    SubReports

    Have primary report with parameter that asks for Barrel number. Reports lists all input arrays for that barrel. There could be multiple input arrays per barrel assembly. When I now link subreport and specify input array as the link, the "link" brings me to the subreport showing me...
  10. glenellis

    Records not being SELECTed

    Had to do with NULL values. Changed the formula to IsNull ({Requisition.Status}) and is working fine. Thanks
  11. glenellis

    Records not being SELECTed

    Have an Access table with a status field. Field values are D - Deleted, R - Rejected, E - Exported, and blank. When I use the SELECT expert and click on the drop down on values, only D, R, and E are shown, although there are many records in the table where the value is blanks. I need to...
  12. glenellis

    Order Acknowledgement

    I need to generate 3 copies of an order acknowledgement. The only difference betwen the 3 copies will be at the bottom of the page, where a literal will read either CUSTOMER COPY, FILE COPY, or ACCOUNTING COPY. Other than that, the data on each output it exactly the same. Is their an easy way...

Part and Inventory Search

Back
Top