|
Some Stored Procedure Help Please
Hi
I'd like to convert this access query into a stored prodedure.
INSERT INTO dbo_Clients_Schedule ( CS_ScheduleID, CS_Sequence, CS_Desc,
CS_Show, CS_ClientID )
SELECT dbo_ScheduleOfInsurances.ScheduleID,
dbo_ScheduleOfInsurances.Sch_Sequence, dbo_ScheduleOfInsurances.Sch_Desc,
True AS ShowSch, [Enter Client ID] AS SchClient
FROM dbo_ScheduleOfInsurances;
ClientID will be string of le...
|
3 |
21.09.2006 08:36:00 |
|
|
Scalar-Valued UDF Function
I've created new UDFs that return primary kesy from a table based on a string
passed. I'm using these within my stored procedures with no problem, so I
know my UDF's are working properly.
What I want to do now is use these same UDF's within my Access Application
to Return a looked up Primary Key or to find the Maximum Primary Key. How can
I retrieve a UDF Value in Access. (i.e. assign ...
|
3 |
21.09.2006 03:56:03 |
|
|
Stored Procedure and ACCESS
Need some assistance
I need a way to execute a stored procedure (truncate table) but unfor. user
cannot execute it due to having user restriction. Is there a way that a
username that can execute be hardcoded and after the stored procedure been
execute, bring the username back to the original username?...
|
2 |
20.09.2006 20:53:43 |
|
|
IF/THEN/ELSE
I'm working on my first SQL Server application using Access as the front-end.
As I do understand the most simple stored procedures and use defined
functions, I have some things I'm not quite sure how to handle. List below is
an example of what I need to do and my goal is to handle the IF/THEN clause
within a single Stored Procedure, as I think this would be best.
I have a table called,...
|
2 |
20.09.2006 20:47:15 |
|
|
Date function with CONVERT
Greetings everyone. I use the following to convert my dates to text format:
CONVERT (nvarchar(10), dbo.tbljob_info.SplECD, 101), with tbljob_info.SplECD
being smalldatetime. Basically it just lops off the time. It works fine,
but my problem is this. For one of the dates in my query I enter
'dbo.tbljob_info.SplECD-7' to show this date minus one week. It also works
fine, but I can not ...
|
18 |
20.09.2006 18:44:50 |
|
|
Truncate result
Greetings all. Since I have newly found the CONVERT statement, I have tried
using it in other applications. What I need to do is change this
'8705-3PF01BK' to this '3PF01BK'. I used the same CONVERT statement as in my
last post and it worked. There is one problem. When I do this,
CONVERT(nvarchar(7), EWO, 101), it changes '8705-3PF01BK' to this '8705-3P'.
Is there a way to make the...
|
4 |
20.09.2006 15:33:02 |
|
|
ORDER BY in View and ADP Form
When I open up a form in an Access ADP to access this view, the rows
are not sorted. I am using MS Access 2003 and MS SQL Server 2005. Is
there a reason why the rows are not sorted? Here is the code I used:
CREATE VIEW [dbo].[vwPatientInformation]
AS
SELECT TOP (100) PERCENT LastName, MiddleName, FirstName, Suffix, DOB,
MedicalRecordNumber, Prefix
FROM dbo.Patients
ORDER BY LastName, ...
|
10 |
20.09.2006 09:42:55 |
|
|
Data Conversion from Access to SQL 2005
This may not be the proper forum to ask this question, but I am totally stuck
on something that I need someone elses input on.
I just migrated my Access app to SQL Server 2005 and have found the the
learning curve for the SQL 2005 DTS Equivilant is steep and something I don't
have time for right now. Plus, I do not have access to SQL 2000 to do DTS.
Anyway, I am handling my data conver...
|
4 |
20.09.2006 02:14:08 |
|
|
Form Button SP call w/ parameters
I have asked this question in the past and have yet to find a clear answer as
I am a VBA novice.
Using Access & SQL 2000, I have a form (Enrollment) where I would like to
capture info in a few unbound textboxes and click a button to call a stored
procedure to perform the insert. Another major snag is that there is a
checkbox that will determine if the SP makes a single or double insert...
|
4 |
19.09.2006 22:34:19 |
|
|
Two field primary key
Greetings all. I know(think) it is possible, but can anyone explain how to
make a primary key involve two fields? Thank you....
|
4 |
19.09.2006 18:37:44 |
|
|
adp in Access 2003
Please find below the problem I'm struggling with.
I have an Addin that is linked to a runnable Addin. The runnable Addin is an
ADP project.
After launching the runnable Addin via Options/Add-ins it appears in the
project explorer.
Access 2000 allows to call certain functions through the command "run" which
belongs to the application object.
For some reason this doesn't seem to work an...
|
3 |
19.09.2006 15:26:29 |
|
|
Pass parameters to a Chart
I know pass paramater to a form, to a list box, comb box, subform...
How can I pass parameters to a chart in ms access 2003 ADP?
Thanks,
JP...
|
2 |
19.09.2006 15:24:37 |
|
|
ATTENTION EVERYONE!
I FARTED
...
|
1 |
19.09.2006 00:38:13 |
|
|
Cannot upsize with A2003 to ADP
When attempting to upsize an mdb in A2003 I receive the following
error;
Connection failed '01000'
SQL Server error 53
....
Server does not exist or denied. Do I need to perform or execute a
program prior to upsizing?
Any assistance will be greatly apprecaited.
Lar
...
|
2 |
19.09.2006 00:25:20 |
|
|
Migrating reports to an ADP
What is the most efficient way to migrate a report from an .mdb to an
..adp?
...
|
4 |
18.09.2006 16:49:13 |
|
|
Quick Access 2003 ADP/SQL Server 2005 question
Are there any recent software updates that enhance the functionality of
these two products working together?
...
|
6 |
18.09.2006 15:10:51 |
|
|
Code view keeps blowing up
i can't get into tot code view.
it creates an error message everytime.
it bee working fine.
?
...
|
2 |
18.09.2006 15:07:21 |
|
|
How can I get Atributes from the field of the table via VBA
Hi,
How can I get the propeties of the column via VBA?
I would like to get:
data type; lenght; caption; format. Is it possible?
Thanks
JP...
|
20 |
16.09.2006 14:38:37 |
|
|
softwear for upsizing
hi,
Is there a softwear for upsizing(mbd to adp)?
...
|
3 |
16.09.2006 12:00:24 |
|
|
Transform VB string array to table
Anyone out there know of a simple way to pull data from a 3 x 10 string
array in VBA into a SQL table?
Trying to avoid looping thru' the array!!!
TIA
Steve
...
|
2 |
15.09.2006 14:53:39 |
|
|
Where did the Stored Procedure pane go?
Hi
Using my Office 2000 ADP on a newer PC, which has Office XP. But now all the
stored procedure pane is gone, and the stored procedures are in the Query
pane. Hmm, also realised that its now a View pane anymore.
This isn't too bad, except I don't to see the system stored procedures in
there. For example, dt_addtosourcecontrol. How do I hide such Sps? They used
not appear in Office 2000....
|
5 |
15.09.2006 14:38:38 |
|
|
INSERT records
I have a SP:
CREATE PROCEDURE qINSERTORDER @ORDERID nvarchar(40)
AS
INSERT INTO Orders (ORDERID)
SELECT @ORDERID
I have a form FINSERTORDER with a Field ORDERID and a button to call the SP.
In Input parameters I have:
ORDERID nvarchar(40) = [Forms]![FINSERTORDER ]![ORDERID].
When I press the button I am asked to enter parameter value for ORDERID.
Thanks
Dimitris
...
|
8 |
15.09.2006 14:36:27 |
|
|
Read from image file into IMAGE column
Hi,
I have to place images programatically into a SQL Server IMAGE field (ie,to
avoid the drag'n'drop tedium).
OK, I got the recordset to read from the stream..
I also got the recordset to write to the SQL image field.
Only problem left: the SQL field now won't display the image, as it seems to
be the wrong data format!!
Hope someone out there can spot the flaw, as I'm now going cross...
|
2 |
15.09.2006 14:34:17 |
|
|
How do I fix speech
My speech doesn't work will not recogonize my profile how can I get it to
work please help me.
...
|
1 |
15.09.2006 14:23:11 |
|
|
70-431 exam
Please canyou help me where can I get samples for 70_431 exam. Implementing
and maintaining SQL Server 2005.
OR to guide to any sites that can help me .
thank you
...
|
1 |
15.09.2006 14:04:34 |