|
Sorting (ORDER BY) in Access SubForms (Adp on SqlServer)
Hello everyone,
i am trying to portate a Jet-Based Db-Application to SqlServer/AccessAdp.
the datastructure is complete normalized, and i am heavly using subforms to
display all splitted informations.
now i have reached a "stuck"-point, and am wondering if anyone would be so
kind to give me a hand with it:
i would like to sort the data in the subform,
the form uses a Sql-Statement ...
|
1 |
22.11.2005 23:15:08 |
|
|
MSGraph Pie Chart Missing Slice
A slice is being consistently omitted from MS Graph pie chart in report,
with remaining data rows' Data label Percentage breakdown re-balanced as
if
they were the only rows of data in the pie.
This is happening in ADP, but not on same data and query in an .mdb file,
or
same data in Excel or PowerPoint chart..
It is always the first slice data row, e.g. US Long/Short below.
The underl...
|
1 |
22.11.2005 16:24:11 |
|
|
Error passing Serverfilter to a Form
I have an application in Access 2000 + SQLServer 2000 working fine,
today I´m going to make a new option on it, I desing the form, the report,
etc... but when I call the form passing the serverfilter ... the forms loads
all the records and had no serverfilter
I use this sentence in a button
DoCmd.OpenForm "MIFORM", acNormal,varmyfilter , , , acWindowNormal
where varmyfilter...
|
1 |
21.11.2005 17:02:58 |
|
|
inactivity timeout
Is there a way to close a connection in an adp/ade after a certain period of
inactivity?
Thanks
Bill
...
|
2 |
21.11.2005 15:58:14 |
|
|
Problem with setting the Server Filter in code
I have posted this code previously, when I was having difficulty binding the
record source to my form and having the data be editable. I received a link
to a helpful MSDN article that I followed and now the data that comes up in
the form can be edited.
Now, the problem is, the code in this same routine that sets the server
filter doesn't seem to be working. Or rather, I'm guessing, ...
|
1 |
16.11.2005 19:55:35 |
|
|
Thinking of Access/jet to SQLServer or MySQL
We have developed an Access/Jet database (2000, XP & 2003 versions) that has
been used by clients all around the world for several years and is extremely
robust with 55 tables, 172 hard stored queries (plus about the same in VBA
SQL code), 60 forms and about 18,000 lines of code. The biggest advantage
with Access is that it doesn't cost the client anything for if they don't
have Access a...
|
3 |
16.11.2005 04:16:28 |
|
|
Problem using Access Upsizing Wizard .MDB-->SQL Server 2005
I'm trying for the first time to upgrade a .mdb database created with Access
2003 to use with the SQL server. I have Visual Studio 2005 installed, which
includes Microsoft SQL Server 2005 (Express Version). I've gone to the SQL
Server Configuration Manager and entered the same name and password as I have
for the computer administrator (which is me), and ensured that the SQL Server
is r...
|
5 |
12.11.2005 23:31:03 |
|
|
Replacing IIF with IF Construct in SQL Server 7
I am migrating date from Access 2000 to SQL Server and am trying to deal
with replacing the IIF with an IF.
In the simplified code below, I am getting an error around the IF statement.
Could someone let me know what's wrong here?
CREATE PROCEDURE _dumptest AS
Select descr,
IF quantity > 1
unitprc
ELSE
0
AS cost
From invcustl
GO
Many thanks
Mike Thomas
...
|
8 |
12.11.2005 09:49:10 |
|
|
Access Database with SQL 2005 linked tables
Hello,
I have a Microsoft Access front-end for a SQL 2005 database. The Access
front-end was in SQL 2000 and worked perfectly. When I migrated it to 2005,
I relinked the database and I can view the information, but I am unable to
add anything to the database. All of the Add Record functions have been
disabled.
Does anyone know why this is happening?
- Stewart
...
|
3 |
11.11.2005 20:47:33 |
|
|
How to Update from One table to another
Hi There,
How do I do this in an ADP?
UPDATE tbl_QuoteDates INNER JOIN Quotes ON tbl_QuoteDates.QuoteId =
Quotes.[Quote ID] SET tbl_QuoteDates.CustomerID = [Quotes].[CustomerID];
It appears as though the update statement cannot have joins? If so, then
how is this update done?
TIA,
Josh
...
|
3 |
11.11.2005 20:13:05 |
|
|
Need help with count function
I need to count how much "assenze" I have in this query, as cover is a text
field I try to use the IIF as you can see below. BUT It does work! Damn.
Query = "SELECT Sum(IIF(cover = 'NO', 1, 0)) as assenze, SUM(stato) as
daypresidio FROM copertura WHERE day between '11/12/2005' and '11/18/2005'
Group by day ORDER BY day ASC"
Please Help
...
|
3 |
11.11.2005 16:46:47 |
|
|
ADP and Sql Server 2005
Is it possible to connect to SQL Server 2005 from an APD project. When I
pull down the connection menu, it only shows the SQL 2000 server and does
not show the SQL 2005 server. Am I missing something simple here?
Ed Warren
...
|
3 |
10.11.2005 09:53:56 |
|
|
Convert MDB to ADP
I'm converting a MDB database to ADP and I have some problems:
1. Is it possibel to find any function in SQL server to replace Format,
left, mid functions?
2. I know, we can not use my VBA functions in SQL server.
In mdb, I have my functions to filter records open forms, queries, reports
based date and countries selected from a list box existing in a form.
Question.
How can I filter qu...
|
9 |
09.11.2005 18:55:40 |
|
|
SQL Query in .ADP
Hi,
how can i make a simple Select Query with VB in Access (.adp)?
Thanx a lot
...
|
3 |
09.11.2005 16:32:02 |
|
|
Newbie Q: Can't update data in underlying table.
I have been looking everywhere to track down the answer to something that I
suspect is simple but it has eluded me!!!
I am using an Access 2003 ADP project with an MDSE backend. I have just
recently used the wizard to change from and .mdb to an .adp. I have an
unbound form that I use in single form view to display details pieces of
artwork in a collection. I use ADO to bind the reco...
|
3 |
09.11.2005 16:21:08 |
|
|
create an msde replica in access db?
sorry for my english.
i need create one msde replica in the my adp database.
i use msde 2000 and access 2003.
someone can help me?
thanks
--
IgnazioC
----------------------
www.sitocomune.com
www.patx.net
----------------------...
|
1 |
08.11.2005 20:39:18 |
|
|
Stored Procedure Recordset closing!
Hi
I am in the process of trying to convert an Access DB to ADP/SQL Server
2000 - learing as I go. All help gratefully appreciated!!!
I had a VBA routine which added various records to various tables which
I have re-written as a stored procedure, and, after calling the
procedure via a form in the ADP, I want to return the ID from the first
header record written.
The procedure does th...
|
3 |
05.11.2005 21:52:46 |
|
|
Showing RAISERROR Messages in ADP
Hi,
I found that some computers does not show RAISERROR Messages while theothers
do.
Is that a version problem, Setting problem pr Access Service Pack Problem?
Andro Dgebuadze
...
|
3 |
05.11.2005 02:52:43 |
|
|
ADP works, ADE on same machine does not
I installed Access 2003 runtime on a Windows 2000 system and tried to start
an ADE which I had prepared shortly before on the server where the SQL Server
2000 database resides. I had to do so because the connection had to be
changed because we transferred the adp from the development environment to
the production environment. The ADE returns errors like 'The expression you
entered as OnC...
|
7 |
04.11.2005 10:52:40 |
|
|
selected filters disappear from combo box
My issue is that i'm using a form with 4 filters at the same time.
the filters are combo boxes that are filled using queries on a table.
my data are returned by another query on the same table but containing
the 4 fields corresponding to the filters.
when i choose the second filter and when the result returns no row the
selected value of the second filter briefly appear and then disappear
fr...
|
1 |
03.11.2005 10:07:05 |
|
|
adp filter display issue
My issue is that i'm using a form with 4 filters at the same time.
the filters are combo boxes that are filled using queries on a table.
my data are returned by another query on the same table but containing
the 4 fields corresponding to the filters.
when i choose the second filter and when the result returns no row the
selected value of the second filter briefly appear and then disappear
fr...
|
1 |
03.11.2005 10:04:33 |
|
|
Problem Building Pivot Chart Based on Stored Procedure
Hi there
I am having a problem building Pivot Chart based on this particular Stored
Procedure, quoted below.
Any Idea why?
I am using Access 2002 and SQL Server 2000.
===========================================
CREATE PROCEDURE dbo.STOCK_INVENTORY_LEVELS
(@item as int)
AS
SET NOCOUNT ON
CREATE TABLE #t (DT datetime)
DECLARE @dt as datetime
DECLARE @dt1 as datetime
DE...
|
1 |
03.11.2005 08:20:59 |
|
|
showing database username on Access form (adp)
Hi,
I am using access2003 frontend with sql2000 database (adp).
Most of the logic is implemented in stored procs.
What i want to achieve is to show the name of the database user on an access
form (e.g. 'sa')
(pretty much the result of a 'SELECT USER').
Can this be done without storing the data first in a (temporary) table?
Using Dlookup didn' t work so far...
Any help is appreciated.
...
|
3 |
02.11.2005 22:34:56 |
|
|
view shows diffent result in ADP & Enterprise manager
HI All
I have created a view in an ADP (A2K3, SQL2K) but I am getting a queer
behaviour. the view is just a simple select limited by a :
WHERE name LIKE '%john%'
When I run the view from Access it returns only a single record but when I
run the same view from within EM I get 5 records!! I have checked and there
is no fillter in Access..
Anyone experienced same sort of behaviour?
...
|
4 |
02.11.2005 16:58:25 |
|
|
Efficiency Question - Dlookup vs ADO cmd execution
Hi,
Pretty much as the title says, I've been updating an app that my company
uses and have noticed that in a lot of places it uses the VBA DLookUp
command to retrieve information (for example, detecting if a record exists).
Presumably all these DLookUps are a leftover from before the project was
updated from an MDB.
I was wondering, is it more efficient to retrieve information like t...
|
6 |
02.11.2005 15:56:16 |