|
sproc has too many arguments problem
I'm using a sproc to return role membership values and it worked fine when I
used just one input and output parameter. I run the sproc on the adp's main
form and set different global variables to true for every role the user is a
member of. I want to try and pass all roles to the sproc at one time rather
than run it several times passing to it a different role name but I'm getting
an error "...
|
3 |
21.06.2006 21:42:06 |
|
|
hello!!
hello, my name is gualtiero,
i'm from palermo, in italy...
...
|
1 |
21.06.2006 19:35:13 |
|
|
Digital Signature in ADP
How can I apply a digital signature my ADP files? I have searched it, and
found the steps Microsoft gives to apply a dig. signature to a reg. Access
app, but I cannot find the places in my ADP.
Thanks,
Drew
...
|
10 |
21.06.2006 15:53:48 |
|
|
Parameter Query
I’m using sql 2000 and Access 2003. Ok, in Access to create a Parameter Query
you simply type in the fields criteria something like: [Enter a Trip No] and
you’re prompted to enter a Trip No.
With sql I’m trying to create the same type of Parameter Query that will ask
the user to input a Trip No. I’ve looked and tried everything to get this to
work without any luck.
What do I ...
|
2 |
21.06.2006 14:58:00 |
|
|
s
This is a multi-part message in MIME format.
------=_NextPart_000_0010_01C6952E.22828090
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_0011_01C6952E.22828090"
------=_NextPart_001_0011_01C6952E.22828090
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable
S=B3onecznik
HEELLLOOOOOOOO!!!!!!
------=_NextPart_001_0011_...
|
1 |
21.06.2006 10:28:00 |
|
|
Import Txt files into an ADP
Hello!
Anyone has the solution into how to import text files into a ADP using code?
I found something, but dont know how it works.
Thanks!
Private Sub Comando0_Click()
LeerDelimitado ("c:\casetas.txt")
End Sub
Public Sub LeerDelimitado(sArchivo As String)
'Requiere referencia a Microsoft Scripting Runtime
Dim MiFSO As FileSystemObject, MiSTR As TextStream
'Refere...
|
3 |
21.06.2006 04:02:18 |
|
|
canceling adp changes
Hi,
I am looking for a way of canceling any changes a user may have made on a
adp form if they cancel out of that form.
I have found that if the user is unhappy with the changes they have made
hitting escape before they leave the page will undo all their changes. Is
there an easy way to trigger the event mapped to the escape key, so I can add
this to my cancel button?...
|
2 |
20.06.2006 23:02:06 |
|
|
is identity
how can i programmatically determine if a field (column) is an
identity field?
...
|
2 |
20.06.2006 16:14:32 |
|
|
IP address
Good afternoon,
How can I get the IP address programmatically?
Thanks,
José Perdigão
...
|
7 |
20.06.2006 15:20:25 |
|
|
adp strengths?
Hi, I have a SQL 2005 database that I wanted to quickly deploy a
front-end to. I was happily surprised that Access 2003 seems to be a
great RAD tool for SQL when using ADP. I am a .net programmer but I
wasn't looking forward to creating a new application from scratch so
quickly.
I've read various opinion of ADP projects. I loved how I could define
my relationships and indexes in SQL 200...
|
4 |
20.06.2006 12:32:37 |
|
|
Table Descriptions
Hi,
Is there a way to add table/view/procedure/function descriptions in an ADP?
Thanks
Alan
...
|
2 |
20.06.2006 05:13:54 |
|
|
.ade runtime - SQL Connection issue
Hi,
I have packaged up an .ade project. Everything installs OK and when the
Splash screen opens the project tries to connect to a SQL server and then
fails - this OK. I was using a button to open the SQL Connection dialog in
the .adp project (which worked fine), but with the .ade/runtime version I
have no such luck. Therefore I can't change the SQL Connection and connect
the project t...
|
9 |
20.06.2006 05:12:48 |
|
|
Access Query Transform.. Pivot to SQL Server
Hi group i have this sql in a MDB that run perfect.
TRANSFORM Count([dbo_Incidencias tecnicas].Clave) AS CountOfClave
SELECT [dbo_Clientes y referencias].IdCliente, [dbo_Clientes y
referencias].Empresa, [dbo_Clientes y
referencias].FechaFinContratoMantenimientoHardware, dbo_Cuentas.Nombre
FROM ([dbo_Clientes y referencias] LEFT JOIN [dbo_Incidencias tecnicas] ON
[dbo_Clientes y referencia...
|
4 |
20.06.2006 04:55:38 |
|
|
Access 2002/XP Access Project (ADP) and SQL Server 2005
Access 2002/XP will not allow me to design any SQL Server 2005 objects. An
error appears saying my version of Access is older than the version of SQL
Server I am running. I'm instructed to go to Microsoft Downloads for a
solution, but cannot find any solutions on what to do.
Is it possible to modify SQL Server 2005 Tables, Stored Procedures, etc.
from and Access 2002/XP Project? You ca...
|
4 |
20.06.2006 04:54:29 |
|
|
Changed all objects from dbo to non dbo, now cannot send parameters
due to some tables not being owned by dbo, i needed to change all other
objects to the same owner. I have since updated the db to do this as
well as the ADP. However, when i run the adp, it fails. For some
reason it fails when either refreshing the stored procedure parameters,
or setting a value to a parameter. Usingthe same login in query
analyzer (or the queries tab in access) i am able...
|
3 |
20.06.2006 04:53:33 |
|
|
Moving to MS-SQL
I am moving a MS-ACCESS application to the Web and using MS-SQL 2000.
Obviously the Access form is replaced with a Web form. I need to know how to
pass parameters from the Web form to MS-SQL. Any tips or direction on this is
greatly appreciated.
--
Message posted via http://www.accessmonster.com...
|
2 |
20.06.2006 01:55:14 |
|
|
asdf
what is yor naem
...
|
3 |
19.06.2006 22:29:19 |
|
|
Hi! #Name? Problem on particular PC :(
Hi Guys
I have a format date command in an APD ie (Format[DataBooked],"ddd
dd-mmm-yy") Works perfect on my compiled ADP on my PC, but on another
PC it comes up with the usual #Name? error as if it cant find the field
or somet :(
Ive tred installing VB6 runtimes etc but its still not havin it!
Any other help would be much appreciated :)
Mattie
...
|
3 |
19.06.2006 20:19:38 |
|
|
The data was added to the database but the data won't be displayed
When Microsoft Access 2003 tries to retrieve a fresh inserted record on a
table with automatic identity handling, on a subscriber of a transactional
replication with queued updates (SQL Server 2005), it always shows the
message:
"The data was added to the database but the data won't be displayed in the
form because it doesn't satisfy the criteria in the underlying record source."
Acc...
|
4 |
19.06.2006 09:23:01 |
|
|
Adp form looses filter when filter criteria are updated
Hi there,
I have an Adp form (Acc2000) connected to a SQL Server 2000 database.
When I filter the form on area code, the resultset is for example 10 records
out of 100 records. After that I change the area code (part of the filter)
to a new value. Then the form looses its filter, 100 records are shown and
the recordnumber is an arbitrairy number, although the record itself is the
pro...
|
5 |
19.06.2006 09:07:41 |
|
|
hi
i am chinese
...
|
1 |
17.06.2006 12:36:36 |
|
|
$30,000 A WEEK INCOME. HAVE YOUR PART TIME ADVERTISING AGENCY
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P align=left><FONT face="Arial Black"><STRONG>$30,000.00 A WEEK INCOME. HAVE
YOUR PART TIME ADVERTISING AGENCY.</STRONG><BR></FONT><FONT
face=Arial> Work at home as our Advertising Booking...
|
1 |
17.06.2006 07:18:51 |
|
|
Conditional Calculation
I have a table with 2 fields: Zipcode and Dollar. I want to create a new
field "Relativity" that equals to Dollar/Dollar(when Zipcode=44444).
how do I write it in SQL?
Select ZipCode, Dollar, Relativity as Dollar/(Dollar When Zipcode=44444)
from table1;
Thanks,
Lily...
|
4 |
16.06.2006 21:18:42 |
|
|
hotfix http://support.microsoft.com/kb/827983/en-us
I am developing an adp report that loads a different picture for each record.
I am using image object, setting the .picture to the external file path of
jpg file in the group header for each record. Besides the load of each
picture being slow, I also was getting this message during development
(usually when applying/changing the source object on a subreport) "There
isn't enough memory to p...
|
3 |
16.06.2006 19:21:27 |
|
|
Amplify records
I have 10 records with 10 vehicles.
For example: Ford Explore
Honda Accord
.............
I have a table with 100 zipcodes.
My question is how can I amplify the 10 Vehicles by 100 zipcodes to generate
10*100 records.
I mean: 48152 Ford Explore
48152 Honda Accord
...................
44552 For...
|
4 |
16.06.2006 15:32:02 |