Recent content by fpendino

Hi, I have a stored proc which I'm using for a user login and it contains output parameters. I can not retreive the output paramters. This is just a test retrieval but here is what I have. DECLARE @curSession varchar(100) DECLARE @ERR varchar(300) DECLARE @DONE bit exec spLoginUser...

Thank you for those replies. I will take these into suggestion and I understand how your opinions would be useful. If anyone else would like to have some input, feel free. I've attached a new picture showing the tables and relationships.

Hi, I am redeveloping a SQL database that I started several years ago. I have actually left this company and came back. Since being back, other developers have suggested different ways of storing/pulling data. I don't necessarily agree with their suggestions. I just have a couple scenarios where...

Nevermind, I just changed the Recordsource of the form instead

It's been a while since using Access. Been doing ASP.net and SQL. I have a form with a subform. I'm trying to filter the subform which is disabled, with the value from a listbox. On the double click of the listbox I have... frmTeamEdit is the subform...

Hello, I know that I'm able to open a new html document on the fly, but am unable to figure out how. I'm thinking that vbscript will allow me to do this. What I'm trying to do is create a button or link that will open a new window, with customized code. That code will be storing the...

It looks like you are referring to ASP.net, unfortunately I'm using original ASP. I appreciate the help though. I'm eventually going to switch this report over to asp.net, but I'm more familiar with original ASP at this time. I'll defenitely keep that post as a reference though for the future...

Thanks for both of the replies! I did happen to find out about the NextRecordset function, and thought that it was going to work for what I was wanting, but it won't because I would have to come back to the first and second recordset. My page will display a couple different layers of detail...

I'm using Sql Server 2000 and ASP to display this info. My question is, what is the best way to display data w/totals onto a page using a stored procedure. I've built stored procedures before that include totals, but in this case, doing so will cause there to be prob like 100+ columns. I also...

I found a solution for anyone interested. Due to using the response.write, I had to surround the file path and target with double quotes. strQString = "pmonth='01/01/2006'&pdate='" & request("Date") & "'&PBd=" & kpirs(2) & "&RptID=" & request("cmbReportID") & "&COLL='" & kpirs(1) & "'"...

Hopefully, this wonderful forum can help me. I like this forum, but haven't had much web help from it, but here we go. This may be a simple answer, but I just can't seem to figure it out. If I have a link on a page and want to send a querystring along with the link, and no I can't create a...

Here's what I came up with. It works, but if anyone has anything better, please don't hesitate to post. SELECT convert(varchar,convert(varchar,datepart(mm,Date))+ '/01/'+ convert(varchar,datepart(yyyy,Date)),101) AS Month

Is there a quick way to format a date in SQL to return, lets say the first day of that month? In ms access i could go Format([date],"mm/01/yyyy") and if the date = 12/15/2005, then it would return 12/01/2005. I've looked into the Datepart function but can't get it to return the way i'm...

I'm using Access 2003 and when I edit Forms (bounded or unbounded) it seems like it is locking the database from being used. Is there a solution to this? This database is using an .mdw file and is secured. The .mdw file is not named the same as the database .mdb file as I know this was an...

Here are a couple of other solutions that you could try. 1. If consolidating this report into one is a viable option, you could setup the report to Group by the PRACT_ID field and have it create a new page for each. Search for Sorting and Grouping Reports for more info if needed. 2. You can...