Search results for query: *

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.

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

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

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

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

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

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

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

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

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

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

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