Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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!

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

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

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