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 Chriss Miller 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. birgitd

    Report with Stored Procedure as source

    Have you gotten this to work? I tried it (loaded the variables with input boxes on Report_Activate), but it doesn't seem to recognize the input parameters were referring to variables. It gives me the pop-up boxes for the values like normal. Here is my Input Parameter data: @start_dt =...
  2. 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...
  3. 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...
  4. birgitd

    Database Opened Read Only Message

    One of the biggest issues I see with people going from an Access Database to an Access Project is that they want to treat the files the same. With the database, everybody HAD to log into the same file, since that is where the data was. In a Project, the data is not local, and there is...
  5. birgitd

    Stored Procedures and ADP

    Can you use a view instead of a stored procedure as the record source? You can typically update a view without writing custom extra code. Thanks, Birgit
  6. birgitd

    Alter ADP Connection String using VBA.

    Hi Eric, I have 2 suggestions. First, if you go to File -> Connection in your Project file (logged in as "sa"), there is a check-box called "allow password saving" .. make sure that is NOT clicked. Next, make a custom menu bar that does NOT include the Connection item...
  7. birgitd

    unable to crete ADE file

    That was the problem! Thanks so much for your help! Birgit
  8. birgitd

    Pessimistic Locking in ADP ???

    I've looked for almost a year and have found no indication that pessimistic is an option. All documentation explicitly states it's optimistic only. Sorry! Thanks, Birgit
  9. birgitd

    form loads slow

    In general, if you have a primary key on the table, that creates what is called a "Clustered Index", which means the data in the table is physically sorted in that order. For example, if you have a table "blah" which has 2 fields "blah_id INT PRIMARY KEY, blah_name...
  10. birgitd

    Hide passwords in table

    The way I handled this problem (which may be a bit of hack) is to use Windows Authentication for my SQL database, then I have a staff table that assigns each person to a user group and maps each user to a windows login (but no passwords are stored anywhere in the table). Next, I put a listbox...
  11. birgitd

    unable to crete ADE file

    Zirak, I am having exactly the same problem (did you figure it out?). Carla, I'm not sure what you mean by compiling the ADP. Could you elaborate? If anybody has suggestions, I'd greatly appreciate it. I've been poking around for HOURS trying to find an answer (Access help, Microsoft site...
  12. 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...
  13. birgitd

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

    Thanks for the answer. That solves my problem. I guess I should use style 102 unstead of style 1 in the convert. As far as why I convert, it appears to be more accurate. For example, when I run "where add_dt between '12/01/02' and '01/06/03'" I get no rows for 1/6/03. However, if...
  14. 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'...
  15. birgitd

    xp_sendmail "missing" messages

    Hi John, Here's the relevant portion of the stored proc: SET @var = 'Roster for ' + @last + ' Section: ' + @section_id + ' ' + convert(char(10),getdate(),1) SET @emailto = RTRIM(@email) EXEC master..xp_sendmail @recipients = @emailto, @copy_recipients ='internal email here', @query =...
  16. 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...
  17. birgitd

    Combo Boxes - Read only option?

    If you go into the properties of the combobox, under the data tab, there is an item called "Limit to List," set this value to "yes" and then users can only use values in the list. Hope that helps!
  18. birgitd

    How to enable delete navigation button on form

    Try checking the form properties. There is an item called "Allow Deletions" (also allow additions, allow edits, etc. etc.). If that is set to "Yes", that that's removed that as a problem. Next, if your form is based on a query with more than one table, you may be running...
  19. 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...
  20. birgitd

    Multiple Queries with one to many relationship

    This is off the top of my head (don't have those tables handy in a database), but it should be the right idea. I wasn't totally sure what you wanted here with the dates. This basic code should give you all orders between the dates specificed that also have invoices between the dates specified...

Part and Inventory Search

Back
Top