Search results

Original ASP, eh? :eek: I didn't know there were still any of you out there. :D Come on over ... the water is nice.

In that case, use a data adaptor to fill in the tables and then you can reference each table in any order and go back and forth and up and down and ... with your recordsets.

You can have the SP output several recordsets and then cycle to the next recordset your DataReader in ASP. Here, let me do a quick Google search; http://www.velocityreviews.com/forums/t72012-multiple-recordset-from-a-stored-procedure.html

The language (TSQL) isn't the problem, creating the algorithm is our challenge. I will give you the framework and you can fill in a couple of the areas I noted to create a function: DECLARE @StartDate DATETIME DECLARE @EndDate DATETIME DECLARE @StartTime FLOAT DECLARE @EndTime FLOAT DECLARE...

How do you know if something should be Fax, Phone or Mail? Take a look at the SWITCH function.

This can be done a couple ways and should also answer your other post. select [employee] , EmpID INTO #MYEmp from [table1] where [Num]= 1 select t.[Meeting Time] from [Time] t (INNER | LEFT | RIGHT) JOIN #MyEmp m ON t.EmpID = m.EmpID -- You must have something in common between [Time]...

DoCmd.SetWarnings False

I don't believe it inherantly does, but I found lots of articles from a Google search, so ...

Why are you wanting to move the installation? I would leave the installation alone and relocate the data and log files. But ... If you are really wanting to move the installation, detach all of the databases, move the data and log files to a drive different from the new installation...

I believe you can just put this in the criteria for Field A: [Enter a value for A or leave blank] or [Enter a value for A or leave blank] is null

That would work fine for you. When you create the table, you can also set the permissions for your users as far as being able to add/edit/delete (INSERT, UPDATE, DELETE). You should build an interface to add/edit/delete the records.

If moving to a SQL backend is the only thing that changed, then I would look at security. How are you authenticating the users on SQL? What permissions does there login have? What happens if you grant this user sa rights? What is frm defined as? What line is generating the error?

Prefix: WHERE (WORK_DESC LIKE ('R/C%') Suffix: WHERE (WORK_DESC LIKE ('%R/C') Anywhere: WHERE (WORK_DESC LIKE ('%R/C%')

It won't be an issue in QA with that setting as long as the field size for COL1 + COL2 doesn't exceed 4000. Is this the full scope of your issue? Don't mean to sound b!tchy, but first you have TSQL which appears you are running in QA, then, you ask about Stored Procedures only to be followed...

Hello, I was in Vegas for a few days. Have you tried stepping through your code? On what line do you get this error? Try this: Private Sub PopUsers_Click() Dim TheFile As String ListUsers.RowSource = "" TheFile = "M:\PBS Wealth Management\Head office\Operations\Staff Database\PBS - Wealth...

I'm running out the door, but it the path does need to be fully qualified with the extension, too. Call ShowUserRosterMultipleUsers("M:\PBS Wealth Management\Head office\Operations\Staff Database\PBS - Wealth Management Staff DB.mdb") Also, you need to populate your listbox While Not rs.EOF...

Yes, that would work. I used the Select Case to illustrate that you can optionally test for lots of things. BTW, the reason the function does not work just returning the string is what the query sees coming back is " 'a', 'b', 'c' ". So if your criteria is: IN (GetCrit([blah])) what the...

Re-creating the SQL from the form is a good idea using QueryDefs and updating the SQL. Depending on the values you will be having, another option is to create a calculated field and query against it. In my example I have created a table and put in values a, b, c, d, e, f, g, h. Here is my...

Please post this query.

Just to confirm, your query utilizing aliases looked like: SELECT * FROM [Subject Assessment] sa INNER JOIN [Staff Profiles] sp1 ON sa.[Teacher ID1]=sp1.[Teacher ID] INNER JOIN [Staff Profiles] sp2 ON sa.[Teacher ID2]=sp2.[Teacher ID]; If you are typing this in vs using the QBE, your error may...