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

    Report with Stored Procedure as source

    Hi, I have a stored procedure that accepts 3 input variables (start_dt, end_dt and password). I would like the user to enter the first 2 (start_dt and end_dt), but I would like the system to look up the third one (from a file on the local hard drive) and transparently pass it to the stored...
  2. birgitd

    Large Scale Access Project Implementations

    Hi, I hope several of you can help me. I have a smallish Access Project (about 40 users), and I'm trying to get our parent organization to implement my solution. They have several hundred users and would like examples of companies that are using Access Project with this number of users (or...
  3. birgitd

    KDC Event 11 -- duplicate SQL Service Accounts

    Hi, This may be more of a Windows 2000 problem, but it's being caused by SQL Server, so I thought I'd throw it out and see if anybody can help me. I'm getting KDC Event ID 11 errors, the text is: There are multiple accounts with name MSSQLSvc/OURSERVERNAME:1433 of type 10. I've done some...
  4. birgitd

    HELP ... convert(varchar(10), date, 1) doesn't work w/2003!

    Hi, I use convert(varchar(10), date, 1) in a lot of my select statements to easily select all rows for a particular date, but when I use a date in 2003, I do not get any rows back. For example: select * from enrollment where convert(char(10), add_dt, 1) between '12/01/02' and '01/06/03'...
  5. birgitd

    xp_sendmail "missing" messages

    I have a situation where I send a lot of confirmation email messages from SQL Server using xp_sendmail. I batch them and send them once a day (or once a week). They way I do this is to run a stored procedure that pulls my recordset and cursors through it, sending a message to each row. The...
  6. birgitd

    Unbound Text Box...Truncated value

    I have a SQL Server database/Access project configuration. I have a field in SQL Server set up as a varchar(2000) ... it's a comment field and people need to write a lot. I have the user type their text into an unbound text box field on a form which I then use to build an insert query in a...
  7. birgitd

    Transaction using multiple DoCmd.Run SQL Statements

    I'm trying to set up something like: BEGIN TRANS DoCmd.RunSQL strSql1 DoCmd.RunSQL strSql2 DoCmd.RunSQL strSql3 mgs = "Are you sure you want to run this SQL?" If MsgBox(mgs, vbQuestion + vbYesNo) = vbYes Then COMMIT TRANS End If Else ROLLBACK TRANS But it doesn't...

Part and Inventory Search

Back
Top