Search results for query: *

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

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

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

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

I'm looking to change the design of a form so that there are 3 combo boxes (cmbStaff, cmbRoom, cmbClass) that either have a value to filter by or a Null value (e.g. I've set the code to make Null cmbRoom and cmbClass when you select an item from cmbStaff etc.) so only 1 combo box has a value. I...

Hi, I've been trying to transfer the following statement in an Access query to a view in SQL and cannot figure out the best approach. I've investigated CASE but this fails whenever I use symbols like > but would be fine if I substituted in the CASE statement for a text entry. I'm sure its...

Hi, I've designed the table and query structure of a database to book people into 1 of 3 different types of fitness suite programme. My initial plan was to select the date on the form (using a pop-up calendar) and this would then display the day's bookings (in a sub-form?) for each of the 15...

Hi, I'm looking to view the structure of a database in the same way that Dreamweaver displays the structure of a website, I realise that to do it in every bit of detail may be difficult, but I've only ever managed to view the basics like tables, fields and a list of relationships... Someone...