Search results for query: *

Solution worked as follows: CREATE PROCEDURE dbo.sp_att (@ID Core_AdmissionsNumber) AS CREATE TABLE dbo.StudentAtt(StudID Core_AdmissionsNumber) INSERT INTO dbo.StudentAtt (StudID) SELECT AdmissionsNumber FROM dbo.tbl_student_name WHERE RTrim(dbo.tbl_student_name.AdmissionsNumber)...

Thank you.

I need to create the table on the fly as I have found no other way to pass the data I need across from an Access form to the SQL view. If there is a better way, please enlighten me - I keep getting told "stored procedures are the way to go" but then when it comes to filtering my data, I get...

I have a stored procedure that returns no results: CREATE PROCEDURE dbo.sp_att (@ID Core_AdmissionsNumber) AS CREATE TABLE dbo.StudentAtt(StudID Core_AdmissionsNumber) INSERT INTO dbo.StudentAtt (StudID) SELECT AdmissionsNumber FROM dbo.tbl_student_name WHERE...

I've found some commented out code that a colleague had entered before going away... Would it be easier to adjust this? As you can tell, I'm rather inexperienced with regards SPs 'Write the admissions number to the stored procedure ' add records to Stored Procedure ' 'strsqlread = "SELECT *...

I've looked at stored procedures but still cannot find the best way to filter by a combobox at the server end - I'm transferring as much across to Views as I can so that I can eventually go for an adp. Unfortunately, I can't find a way to transfer an ID number (or group of numbers) across to...

I should have posted the view I'm trying to optimize. I've kept it as simple as I can. Basically, I want to filter to as few AdmissionNo rows as I can as this will ensure the views/reports based on this one cause as little work as possible. SELECT dbo.StudentDets.AdmissionNo...

Thinking I must be in stupid mode, I was no clearer after reading the FAQs, even after leaving it a while and coming back to it. The problem I still have is getting a table filtered from the combo box on an Access form in a database opened by multiple people on another server - eventually I'll...

Only just returning to this code - I've gone down the stored procedure route. Now all I need to do is work out a way (if there is one!) to link the stored procedure back into the database. I know I can reference it in the code but I'm assuming that to write the filtered data back to the stored...

Apologies if this is answered elsewhere - I couldn't find it. Basically, I have a view based on 2 other views. The 2 initial views running pretty quickly but as soon as they are combined, the time it takes increases greatly to about 35 seconds. In my limited experience I could then filter the...

Well, I knew that I was going to feel stupid... I thought I'd checked everything, but having put the db on the backburner a while (other priorities) I came back it with a fresh impetus. Stupid me forgot to check the values. Seems I missed a hidden column. Now, to the next error!

Hi Mutley1, The process I'm doing is as follows (this works no problem for the table). Yes, it is SQL Server 2000. I'm running the DRS Import/Export Wizard through the Enterprise Manager (just putting this all in for completeness so ignore anything not relevant!) The Datasource is "Microsoft...

Hi, This may be blindingly obvious but I'm having trouble exporting the results of a view on SQL to a text file (which is then imported into another package. I've 6 files to export - the table was easy enough with DTS but views aren't listed and I need to be able to automate it to execute each...

We have as part of our interface an option for people to send texts or e-mails to others and want to add the option of attachments. These are then sent from the server to the recipients. Basically, we're looking at what options there are in copying the file selected (in the designed dialog box...

It might be obvious to many, but the error message Access gives when failing to convert to an MDE is, erm, vague at best... After a little searching I found the following info to be useful. Having used it on a couple of databases it worked without the "decompile" option needing to be carried...

I should have mentioned that there is more code below what I posted (but shouldn't be an issue at this point because its not getting that far). The code worked in a previous database and I've renamed everything correctly so the adding of records etc should work. As I said, it is likely to be...

Hi all, This may be obvious, but the following code gives me an error of "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done". The code seems to trip up on the txtAdmissionsNumber (emboldened below) having played around with...

Can you put the code you're using into your next post? It appears (to me...) that its launching Outlook then sending the e-mail.

Sorted. Thanks for the pointers Remou - with setting the cmbRoom to "" seemed to be a problem but solved it with the code as follows: Private Sub btnTTview_Click() Dim stDocName As String If IsNull(cmbRoom) = False Then If cmbRoom <> "" Then stDocName = "rpt_TT_Room"...

I did have the reports opening correctly beforehand (I had 3 command buttons, one for each report) and was trying to simplify the interface/form to contain just 1 button but leave the 3 combo boxes in place. The code for setting each other to null when making a selection from one is... Private...