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

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

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

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

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

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

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

Is there a way to disable the F1 key in report preview? I was able to set it up for the forms ok, but I can't find anything that tells me if I can or can't do this in the report preview. Thanks in advance.

I am working on a function that will sort a list box based off of command buttons that will act like headings for the list box. I have ran into some code before, but am unable to find it. I'm just wondering if anyone has anything like this. It would save me a lot of time and headaches. I...

Is it possible to count how many records are selected in an Append Query using a recordset count? Or will I have to make the sql statement into a select query before I am able to use the recordset function? Also, I need to know this exact way because I have other functions bases solely off...

I have Office 2000 installed on my pc, but also have access 97 installed. Everything works fine except when I am importing/exporting an excel file. I have already installed a service pack that fixed the import/export process for text files, but I want to know if there is something else I have...

How do you set a value or integer to return a certain amount of characters. Please refer to the example where I am asking to place zeros so that the value is still 4 numbers long. 0005 0025 0035 0100 0001 ?expression(txtbox)

Does anyone know where I can download a free calendar addin for Access that I can place on a form? I've used them before, but have switched jobs and we don't have licenses for the ones currently on this pc. Thanks for any info!

I am trying to cycle through some checkboxes on a form. I can't quite figure out the right code. Here is what I have. Private Sub chkSnap0_AfterUpdate() Dim intchk As Integer Dim rpt As CheckBox Dim strrpt(6) As String If chkSnap0 = -1 Then For intchk = 1 To 6 strrpt(intchk) =...