|
Edit conflicts between table and trigger
Hi folks
I probably shouldn't be posting this here but...
Using Access XP / MSDE
I am in the process of migrating a very complex mdb/mde to ADP. This will be
a two stage process (due to urgency), the first stage being migration of the
backend and some core functionaility to MSDE/mde and the second migrating
the remaining functionality to MSDE/ade.
I have a table which has a trigg...
|
6 |
21.03.2006 20:58:27 |
|
|
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 |
25.03.2006 03:25:20 |
|
|
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 |
29.03.2006 18:39:01 |
|
|
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 |
29.03.2006 14:35:49 |
|
|
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 |
29.03.2006 07:51:02 |
|
|
??
...
|
1 |
28.03.2006 02:10:59 |
|
|
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 |
27.03.2006 21:13:39 |
|
|
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 |
27.03.2006 18:01:50 |
|
|
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 |
24.03.2006 07:20:46 |
|
|
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 |
24.03.2006 04:00:22 |
|
|
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 |
24.03.2006 03:56:57 |
|
|
g
...
|
1 |
24.03.2006 03:31:59 |
|
|
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 |
23.03.2006 11:23:44 |
|
|
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 |
23.03.2006 08:13:59 |
|
|
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 |
22.03.2006 21:51:00 |
|
|
focus bug in between ADP and QA
Team;
I have seen this bug about 20 times in the past 3 years.
LITERALLY.
a) have an ADP open to the queries window
b) choose query analyzer on the taskbar
c) do something in qa
d) select access on the taskbar
Do you know what happens??
ADP sits there and automagically fires the sproc.
It doesn't happen all the time. But somehow; I have managed to his
this bug a TON and right ...
|
2 |
22.03.2006 17:55:10 |
|
|
Displaying Error Messages From Triggers
In my post below I described a problem I have been experiencing since the
client upgraded to Access 2003. I have since found the following article,
which refers to Access 2002 and several posts across the internet where
folks have been finding inconsistent issues that are not tied to a
particular version of Access. Sometimes, the problem occurs in 2002,
sometimes in 2003.
http://s...
|
16 |
21.03.2006 23:22:07 |
|
|
¤ China ZhongZhan Aids Mei Mei
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
1 |
21.03.2006 12:48:21 |
|
|
¤ China ZhongZhan Aids Mei Mei
Killer!
http://onfinite.com/libraries/175399/440.jpg
elmar@digi-art.de
...
|
1 |
21.03.2006 12:48:15 |
|
|
Ink
Sorry guys. The spam stuff was not my intent. I do oppoligies and won't
happen again. I have never been on newsgroups before and not sure how to
work them. I hope you guys can forgive a bad choice. Murphey...
|
1 |
20.03.2006 12:25:47 |
|
|
Access ADP, filter lookup & SQL Server 2000
Hi - I have an Access ADP front ending a SQL Server 2000 database. This has
been working fine for some time but I now have a problem that I have spent
many days trying to fix in vain.
The problem revolves around using the filter lookup property on some
textboxes on the Access forms. When I use the form everything works fine as I
am an administrator (we use NT Authentication on SQL Server) b...
|
4 |
17.03.2006 17:56:08 |
|
|
connection form
why I can´t open the connection form when I am using access runtime ?
Everaldo Ricardo
...
|
3 |
16.03.2006 22:05:07 |
|
|
Access - Outlook - Public Folder - Appointment
Hello,
I have written an Function:
Public Function MakeAppointment(strOutlookFolderID As String, strSubject As
String, datDatum As Date, strLocation As String, strBody As String, bolAllDay
As Boolean, Optional strvon As String, Optional strbis As String, Optional
strOutlook As String) As String
5 On Error GoTo Handler
Dim olfolder As Outlook.MAPIFolder
Dim ol...
|
7 |
16.03.2006 21:57:13 |
|
|
updating one record
I have a view on MSSQL which I load into a form in Access 2000 via ADO.
The view takes up to 5 seconds to generate depending on the number of
rows I ask for. On the same form are text boxes where the user can edit
various database values which are in turn used in the view's query.
My problem is that when the user edits these values, I need that to be
reflected in the controls that show the ...
|
4 |
16.03.2006 19:36:17 |
|
|
Trouble Opening Tables through ADP
I'm currently using an Access 2003 adp file to connect to SQL Server
2000. Everything works flawlessly except for one particular issue. When
I try to view a table's contents through the adp the table doesn't
open. It totally freezes. No error messages or anything. An interesting
sidenote is that I CAN view the table in design mode through the adp.
I thought that this issue could be related ...
|
6 |
16.03.2006 19:28:39 |