Search results

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

Is this possible? I'm trying to pass a string variable to a query with the criteria using IN(). Here's an example of what I'm trying to accomplish. SELECT SomeTable.* FROM SomeTable WHERE (((SomeTable.Cycle) In (BillDelqProcBD()))); 'This works when there's only one value passed in the...

Create a recordset on that table. Use the Count Records method for the recordset and check to see if it equals zero.

You can change what's being outputted from within the query. In SQL view it would look like this. SELECT tblEmp.FName AS [First Name], tblEmp.LName AS [Last Name] FROM tblEmp; Notice that it's selecting the field by it's original name then it has 'as whatever' following.

Try this, creating a loop to add the attachments. Here's an example. 'Make this a public variable. Assign the file link to this string 'You can change the index on the fly or however you'd like.. I've hard coded it to 10 Attachments Public Attachment(10) As String 'I have this function in a...

Here's another option if you wanted to keep this within the coding part. Since you are using the copyfromrecordset (which I haven't ever really used), you cannot format the data while you are outputting it. You can however format it within the recordset's sql statement. Since I'm not sure...