Application.ExportXML
Fri, 23 May 2008 07:48:26 -0700
Hello, I have a question about exporting xml using Access. I would like to
export XML data from stored procedure "procedure". This stored procedure have
one parameter "where", lets say
ALTER PROCEDURE procedure(@Where varchar(50)) as
Select * from table where ID = @Where
where table is valid table with colu ...
|
No Projects in Access 2007
Thu, 22 May 2008 06:19:02 -0700
I understand that Access 2007 doesn't support projects. We have currently
have several projects using Access 2000. What is suggested instead? If
someone could point me to some articles suggesting alternatives, I would
greatly appreciate it. ...
|
views not updatable in ACC2k prjct (.adp, SQL Srv 7, MDAC 2.5)
Thu, 22 May 2008 03:58:01 -0700
Hi,
some years ago I created a client server solution with an SQL server 7 as
backend and Access 2000 project (.adp/.ade) as frontend. The client platforms
were NT 4.0 WS or W2k (always with MDAC 2.5). Everything worked "fine" for
many years until I caught someday upgrades to MDAC 2.8 with a third software ...
|
Printing Only Once& Form view
Wed, 21 May 2008 15:52:36 GMT
Hi,
I have trouble in allowing report printing to only once or twice. How can
I do that?
Another thing is that how can I limit the number of form viewed to 5
forms only everytime. Thanks.
Jack
--
Message posted via http://www.accessmonster.com
...
|
Refresh A Table or Stored Procedure in Access ADP
Tue, 20 May 2008 12:01:09 -0700
hi,
I am creating a stored proc (or a make table) with the same name but
different structure depending on which button is pressed in Access ADP. for
example if i press
button 1 the statement would be:
"SELECT * INTO mytempreportstable FROM table1"
then on a button2:
"SELECT * INTO mytempreportstable FRO ...
|
test from Nhan
Tue, 20 May 2008 14:54:54 +0700
1 2 3 4 5
...
|
test thu coi
Tue, 20 May 2008 14:50:27 +0700
helllo. i am Tram from VietNam
...
|
|
|
LESBETHT drummen 6412vvHETNET`` NL
Tue, 20 May 2008 09:15:47 +0200
IK HOOP DAT DZEN BRICHT OOK ONDT VAGEN KRYGDT EIDEN VAN MY BRIEF
GROETJES VAN SCHANT LIEBEHT XXXX
...
|
SQL Function not returning same value over ADP
Mon, 19 May 2008 11:38:46 -0700 (PDT)
Here's my function in MS SQL 2000:
ALTER FUNCTION dbo.fncDecimalHoursToHrsMins
(
@dInput DECIMAL(38,10)
)
RETURNS VARCHAR(10) AS
BEGIN
DECLARE @iMins INT
SET @iMins = ROUND((@dInput - CAST(FLOOR(@dInput) AS
DECIMAL(38,10))) * 60.00000, 0)
RETURN
(
LTRIM(RTRIM(STR(FLOO ...
|
Join two SELECT staements as one recordset
Mon, 19 May 2008 18:29:16 GMT
I have a table (tblQcCdrlSchedule) with the following fields:
DateCdrlDue
DateCdrlSubmittedToAf
I need a simple report which shows how many CDRLS's were submmited in the
quarter (fiscal year starts in Oct) and how many were submitted late
I have made a recordset which shows how many CDRLS where submitted li ...
|
