|
Stored Procedure (Using a variable in FROM Clause)
I have this stored proc:
Create PROCEDURE dbo.spoc_ev_update_branch_cds (
@dbName varchar(25))
AS
-- ===============================================================
-- Procedure: spoc_ev_update_branch_cds
-- Written By: xxxxxxxxxxxxxxxxxxxxxxxxxx
-- Purpose: Deletes all records from Branch Table,
-- and updates with new values.
--
-- Updates from @dbName
-- Date Developer D...
|
6 |
4/3/2006 7:10:55 PM |
|
|
datepart + dateadd
I am trying to select children from a table whose birthday falls within
21 and 28 days from today but am not having much success. Below is the
sql statement. Does anyone know what i'm doing wrong? Thanks.
SELECT dbo.tblChild.FName, dbo.tblChild.LName,
dbo.tblChild.Birthday
FROM dbo.tblChild
WHERE (CAST(DATEPART(month, dbo.tblChild.Birthday) + DATEPART(day,
dbo.tblChild.Bi...
|
7 |
4/3/2006 4:49:30 PM |
|
|
Decimals in stored proc parameters
I have a stored procedure which will return a list of records with geographic
coordinates (decimal degrees) within a certain range. The parameters it
prompts for are the coordinates of the top left hand corner and the bottom
right-hand corner of a rectangle - 4 parameters of data type decimal(10,6).
If I hard-code the coordinates into the stored proc, evrything works
perfectly. If I prom...
|
3 |
4/3/2006 2:28:01 AM |
|
|
Access Project (adp) with Sql Server 2000 - First Connection Latency
Hi folks,
after searching and searching (and sometimes just trying to foget the
problem) im really stuck...
I deployed an adp-application to a customer network (win2k-server with
Sql Server 2000/ win2k-workstations with mdac 2.8, Access 2000 Sp3) .
Everything works fine - only the first time I wait for accessing data
lasts for about 15 seconds or if the user leaves the application
untou...
|
13 |
3/31/2006 8:25:33 PM |
|
|
dlookup with stored proc's
hi, i am upgrading an Access97 mdb to Access2002 adp. As part of the
exercise i am implementing further security by utilising stored procedures
calls.
The existing mdb calls dlookup in a number of instances. Has anyone found a
workaround to using Dlookup with stored procedures? or is the alternative to
replace dlookup an ADO connection to the database?
thanks,
Stuart
--
Message p...
|
6 |
3/31/2006 5:53:07 PM |
|
|
creating email messages through Access 2003
I have an issure trying to send emails from Access 2003. I receive the
following error:
8007007e (-2147024770), "The specified module could not be found"
I tried the fixes listed at http://support.microsoft.com/kb/327219/en-us but
they didn't help.
I wish I didn't need to use Outlook Express components. Anybody know of
alternatives I could try?
Thanks!
--
Chris
...
|
2 |
3/31/2006 5:52:58 PM |
|
|
Table permissions: No matter what I set all users have full access?
Hi
Following my earlier question ((CROSS POSTED) Very strange: Connection under
process info not whats in front-end)
I have set the permissions for a particular table so that none of the listed
users can do anything (select, insert etc.) yet when I connect from another
machine via the ADP using Windows authentication (from a login thats not
even listed in the servers users I might ad...
|
6 |
3/30/2006 8:53:40 PM |
|
|
SQL coding not working in VBA
I am trying to run this query in VB but I must have it written wrong but I
can't find where.
Could some body help me out
RS.Open "Select email from team where SONumber = '" & SONumber & "' and where
Financialaccess ='" & 1 & "'", CurrentProject.Connection, adOpenKeyset,
adLockOptimistic
Thanks
--
Message posted via http://www.accessmonster.com...
|
3 |
3/30/2006 4:34:42 PM |
|
|
Call SQLServer UDF with decimal parameter
Hi,
when I attempt to call a SQLServer UDF from VBA/ADODB I get an errormessage:
Runtime error: -2147467259
Invalid scaling
UDF is as follows
CREATE FUNCTION [dbo].[fZeiteinheitUmrechnen] (
@Wert as decimal(10,2) ,
@QuellZeiteinheit as int,
@ZielZeiteinheit as int
)
RETURNS decimal(10,2) AS
BEGIN
Declare @ZeitZiel as decimal(10,2)
Select @ZeitZiel...
|
4 |
3/29/2006 6:39:01 PM |
|
|
ADO Find fails (yet not loaded recordset)
Windows XP + Access 2003 + SPs + ADO 2.8 + MS SQL Server 2000
While loading a bound single form, in the open statement i try to find a
given record. Unfortunatelly it fails, because the recordset isn't still
fully loaded.
facts:
1) the table holds about 450 records
2) The behevaiour differs between computers, it looks like slower computers
are affected
I've tried the following
...
|
4 |
3/29/2006 2:35:49 PM |
|
|
Data entry mode in form view
hi every body,
i am using access xp as front end and back end sql 2k.
i am trying to add some records for testing purpose using one form which is
bound to one table, when i use Data Entry Property = yes with default view =
Continuous Forms it shows nothing on the form for input, where as in normal
database (mdb) it shows blank controls for input and u can add records.
i am using Recor...
|
4 |
3/29/2006 7:51:02 AM |
|
|
??
...
|
1 |
3/28/2006 2:10:59 AM |
|
|
Age calculation
Hello everyone. I had the following DateDiff work fine in MDB
=DateDiff("d",[Invoice Date],Date()).
Does anyone know how to write the code for the same thing in ADP? I need to
do the above, which calculates the age of an invoice. I also need to be able
to calculate the difference in days between two dates of smalldatetime
format. Thank you in advance for any help....
|
2 |
3/27/2006 9:13:39 PM |
|
|
passing a form value into a report filter
Need help:
I have a form setup to run a report based off of data on that report. The
report needs to know which record its looking at based off of the primary key,
an int value autonumber. The report is setup to run based off of a stored
procedure:
SELECT [Case number]
FROM dbo.Support
WHERE ([Case number] = @Key)
Im using a command button to open the report with t...
|
4 |
3/27/2006 6:01:50 PM |
|
|
Develop in 2003 - Deploy in 2000
I've converted an Access 2000 mdb application to Access 2003 ADP with SQL
backend on Window XP SP2 platform. Deployed to client's Win 2000 running
Access 2000.
On the client's workstation when the application is adding a new record and
setting value on a database field on the main form, a series of Current
events are triggered on the 2 subforms and the main form. When control is
ret...
|
3 |
3/25/2006 3:25:20 AM |
|
|
Microsoft Support for Microsoft Access and ADP's
Hi All,
I have been hearing rumours, from Microsoft Product Support Technicians,
that Microsoft's enthusiasm in general for Microsoft Access, and in
particular .adp projects and SQL Server Client Data Manager Interface (CDM
OLE DB Service Provider) is on the wane; preferring instead, perhaps
understandably, to focus on the .NET family of products.
(Hence the reason that many ...
|
6 |
3/24/2006 7:20:46 AM |
|
|
Access 2003 / SQL Server 2005 Data Access (not design)
We are planning to roll out SQL 2005. We do all of our table/view/SP
development in Visual Studio already so loss of SQL Server design support in
Access won't be an issue for us. But...we have numerous ADPs which provide
forms UI, read and write data, call SPs and functions, generate reports, etc.
and it would be good if these continued to work.
Question: what is the *data access* sto...
|
2 |
3/24/2006 4:00:22 AM |
|
|
multiple startup forms
Need Help:
I am not much of a programer, but I manage to do pretty well with access. I
have an ADP application connected to MSDE. I want to be able to display
different forms on startup based on the user logging in. Currently users are
logging in using sql username/password. I know that I prob. need a table with
username and formname, but how do i access which user is logged in? Any help
w...
|
2 |
3/24/2006 3:56:57 AM |
|
|
g
...
|
1 |
3/24/2006 3:31:59 AM |
|
|
Connecting to SQL Server with Access 2003
Hi all,
I have a site with about 50 PCs, these all run XP pro other than 2 W2K
machines, I have Office 2003 Pro installed on all these machines. On the
Server is Windows 2003 server and it has an instance of SQL Server Express
running on it, I also have an instance of SQL Server 2000 running on another
machine.
My problem is as follows:
I open MS Access and select new, then select...
|
8 |
3/23/2006 11:23:44 AM |
|
|
Login
following, do I work with adp, do I use the safety of the sql server to
authenticate the users, then in my front I do configure the access with my
password, for the item connection of the menu, when do I distribute that
front for each station, (do they use runtime) does the system always suggest
my name in the login, do the users complain then because every time that
they enter, tá there my n...
|
3 |
3/23/2006 8:13:59 AM |
|
|
Just rolled out SQLS 2005. No ADP design?
Hi, I need some good news.
Please tell me this is a simple setting need to make somewhere to
design our views and stored procedues in our Access ADP files. We just
rolled out SQLS 2005 and no one can make any changes to the views? Is
there a patch? We are dead in the water.
Thanks,
AD
...
|
12 |
3/22/2006 9:51:00 PM |
|
|
Adding rows to Access/SQL table
Access 2003 SQL 2000 Win 2000
In Access I added new rows directly into the linked table which resides on an
SQL back-end. When clicking on the table in Access the new rows are visible,
however, when I view the table in SQL Enterprise Mgr they are not added to
the table. Updating existing rows works fine. I tried relinking the tables...
no change. The only way I can sync the data is to delete...
|
3 |
3/31/2006 5:02:51 AM |
|
|
Sum with expression in form footer returns #error
Hi ,
in my access project (adp) I've bound a form to a SQLServer table and create
a control in the forms footer.
The controlsource is:
=Sum(([zeitaufwand]*[internerkostensatz]))+Sum([externe_kosten])
[zeitaufwand], [internerkostensatz] and [externe_kosten] are tablecolumns.
When I open the form the control displays #Error.
However, when import the same form into a Access database (.mdb...
|
4 |
3/31/2006 11:16:02 AM |
|
|
Access To SQL
I'm converting an Access 2000 database to SQL 2000. In this conversion I will
be creating a Web front end and need to know how to conditionally format HTML
tables based on the results of a query/view in SQL. Example: If dept. A sales
are <= x then format table cell red. If dept A sales >= y then format table
cell green.
Should (can) I attempt to do the formatting in SQL prior to submi...
|
3 |
3/31/2006 2:09:13 PM |