|
Row Headings in a Crosstab Query
This is a multi-part message in MIME format.
------=_NextPart_000_000D_01C63544.2776E770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi everybody,
=20
When executing a Crosstab Query I see only rows (defined in a row =
heading) that have values (defined in value field) in at least one =
column (defined as column headings). How can I ...
|
3 |
11.03.2006 15:45:49 |
|
|
Strange fault
Windows XP, Access 2003 + SP2, ADO, SQL server 2000
I have a very simple single form
it works perfectly, if the recordsource is:
SELECT * FROM [C - Giornale]
Setting a WHERE clause like
SELECT * FROM [C - Giornale] WHERE ( [data operazione] >=
CONVERT(DATETIME, '01-01-2005 00:00:00', 105) AND [data
operazione] <= CONVERT(DATETIME, '31- 12-2005 ...
|
13 |
16.03.2006 17:03:11 |
|
|
ADP multiuser deployment
Hi
I have recently upsized an MDB to an ADP and am ready to depoly it on my
network.
A problem I have encountered is that when I try to open more than one
concurrent ADP, the application does not let me. I understand from articles I
have read that you can not use the same front end application like you can
with an MDB, so I created copies of the ADP on the user's desktops but still ...
|
3 |
16.03.2006 14:51:56 |
|
|
dynamically changing selection options for a combo using row sourc
Hi,
I am using forms bound to stored procedures using the row source property
that allow users to enter values by selecting combo boxes based on
table/stored procedure lookups.
I now need to be able to reduce the available selection option in my second
combo based on the selected value in the first.
As and example I have two combo boxes producs and models. The first would
be po...
|
8 |
16.03.2006 09:22:24 |
|
|
Stored procedure problem
I have a stored procedure that is not returning what I expect it should. I am
passing the name of a Role and it should be passing me back a 1 if the user
is a member and a 0 if not. It always returns a zero regardless of wether the
user is a member or not. I will post both the Stored procedure and the VBA
code I'm using.
VBA code:
Dim cmd As ADODB.Command
Dim prm As ADODB.Parameter
S...
|
5 |
15.03.2006 22:17:43 |
|
|
Can't change or add something to an ADP ?
Hello everyone ,
First time for me to use Access with SQL server and got problems starting.
I am trying to use Access 2000 on a client with SQL Server 2000 on a server.
For testing I created a Test database on the SQL Server and set the right
permissions with Windows Authentication.
Next I started Access 2000 on a Win XP client and made a new Project with an
excisting database.
I gave i...
|
7 |
15.03.2006 20:26:35 |
|
|
Returning SQL Server error messages
I have an Accesss 2002 adp file that connects to SQL Server 2000. We are
now using Access 2003 and I have found that Access does not appear to be
catching errors raised on the server. I used to execute "RunCommand
acCmdSaveRecord" and if there were any errors on the server I would capture
Err number 5000. Under Access 2003 the server side errors do not get passed
to the client.
Any...
|
1 |
14.03.2006 22:11:56 |
|
|
Getting User Login/Role
Hi,
I am wanting to stop a User from opening a Form where the security is based
on their Application Role in SQL.
To get their NT name I use:
txtNT_Name = Dlookup("system_user","sysobjects")
How do I get the Users Application-level role? Is there a better way to go
about this?
I appreciate your help as always.
--
Regards,
Alan...
|
4 |
14.03.2006 22:11:07 |
|
|
Viewing Forms in ADP
I have a MS Access Project front end with a SQL backend. All users can see
the tables and open them. They can open querries, forms and any macros in
design view (no changes can be made to anything). They can not open the FORMS
in datasheet veiw . The FORMS are going to the table name in Access, when I
shared it in SQL the table names have my username and then the table name.
When I make chang...
|
5 |
14.03.2006 20:57:26 |
|
|
Using GUID as Filter for Report
I am trying to Filter a report with a GUID as the uniqueIdentifier. How is
this done? I can only filter using a secondary Unique string.
The code I would like to have work is:
Dim stDocName As String
stDocName = "Labels tblParts"
DoCmd.OpenReport stDocName, acPreview, "[PartID]=" & Me.PartID
Thankyou in advance for your help.
--
Regards,
Alan...
|
4 |
14.03.2006 12:01:27 |
|
|
Yet another syntax issue.
I can get this stored procedure to run when I call it manually but not with
VBA. Here is the code:
Dim cnn As ADODB.Connection
Dim cmd As ADODB.Command
Dim prm As ADODB.Parameter
Dim strJcn As String
Set cnn = CurrentProject.Connection
Set cmd = New ADODB.Command
strJcn = "'" & Me![STATUS_ESR_JCN] & "'"
...
|
6 |
13.03.2006 22:25:06 |
|
|
Hiding system databases in SQL Enterprise Manager
Hi all,
I'm sorry if there was already such a post.
May be someone knows from where can I set the parameters that will hide
system databases in SQL 2000 Ent. Man.
I don't need to hide, I need to make it visible :)
Application developer was doing something on a test laptop and now I cannot
see them, but when I start SQL Query Analizer - all system and non-system
databases are visible......
|
2 |
13.03.2006 18:03:15 |
|
|
Linked Server
I need to create a Linked Server to an Access MDB from my SQL Express.
In the past, I have always used EM to set up Linked Servers. EM does not
work with Express.
The Access MDB is not passworded. There is no workgroup.
I have attempted to use QA to create the Linked Server:
sp_addlinkedserver @server = 'MyJet', @srvproduct = '', @provider =
'Microsoft.Jet.OLEDB.4.0', @datasrc = ...
|
2 |
13.03.2006 06:23:30 |
|
|
I need help
every time I send and receive this error message comes up. It says incorrect
password or account nameCheck the username/password or security settings.
And it doesn't let me get my mail. can somebody help? my address is
eli.barr@providenceday.org
...
|
18 |
11.03.2006 15:51:33 |
|
|
Database Form security
Hi,
I have a fairly large adp project, but now I need to apply some Form-level
security. There are 4 SQL Groups with a User connecting to SQL via
NT-security. Is it best to use SQL to stop user access to Views or to create
new views with limited data for each Group.
My problem is that my adp Forms have all fields present, whereas applying
the new security Groups some of the Forms fi...
|
4 |
10.03.2006 04:51:03 |
|
|
custom buttons
I have an ADP that I have setup to open with the following startup options:
Allow Default Shortcut Menus - NO
Allow Full Menus - NO
Allow Built-In Toolbar - YES
Allow Toolbar/Menu Changes - NO
I have some menu features in the program that I want the users to have.
Example, when report is viewed, they SHOULD be able to use the feature that
converts the report to Excel document or Wor...
|
3 |
09.03.2006 22:19:42 |
|
|
BECOME A DOT.COM MILLIONAIRE WITH ONLY $5.99Cents or $1K.
...
|
1 |
09.03.2006 20:43:06 |
|
|
Parameters from a form
Is it possible to enter Parameter(or a retrieve specification) from a form in
an ADP select query. I used to do this all the time in Access 97, but i do
not seem to able to do this in an Access ADP. I just use to point to the Open
form, and the field that contains the data, sometimes the field on the form
could be unbound.
Thanks in advance, Im new to ADP projects....
|
12 |
08.03.2006 20:16:27 |
|
|
Connection Data Link
Hi, i've upsized From MDB to ADP and my problem is
change data link property (connection of ADP) with VB6 because now i use ADP
on different PC connected to different Server.
Thanks in advance.
Aragorn....
|
1 |
08.03.2006 09:08:27 |
|
|
×Ô¼º·¢²¼µÄÐÂÎÅ¿ÉÒÔÔÚÄÄ¿´¼ûѽ£¿
µµÌÚÓ¿ÓÐÁXµØ¡¡ÉÏ¡¡³´²ËµØ¼¼Êõ½»Á÷˹Âå·¥¿ËÈËÊÜ·Û¡¡¡¡¡¡¡¡
...
|
1 |
08.03.2006 01:35:49 |
|
|
µç×ÓÉÌÎñÖеÄÐÂÎÅ×é
ÓÃOUTLOOK
...
|
1 |
08.03.2006 01:34:27 |
|
|
SQL Syntax problem
I am getting a syntax error "Line 1 incorrect syntax near ' = ' " when I
run the following:
strSQL = "APPEND tblEarByStatus SET RedHours = " & sngRedTime _
& ", Status = " & intCurEc _
& ", ParcTag = '" & strCurEquip & "'"
With cmd
.ActiveConnection = CurrentP...
|
5 |
07.03.2006 22:39:18 |
|
|
Avoid logon dialog to connect to SQL 2005
I have the following problem with Access XP and SQL 2005 Express Edition:
i would like to avoid visualization of Access default logon dialog when I
open my ADP procedure.
I've read the following MS article:
ACC2000: Access Project Prompts You to Log On Even Though "Blank Password"
Check Box Is Selected (Q202615)
Obviously I have my custom logon form.
ADP project has a form (a switc...
|
2 |
06.03.2006 16:56:45 |
|
|
connect adp project to sql express via LAN
Hi all
I need a bit of advice - I've created a FE using ADP the BE is on SQL Express.
Connecting to the BE on the same computer is fine, but i now need to connect
to the BE via a LAN.
I can't seem to find a simple guide on how to do this. any pointers would be
welcome.
Thanks...
|
5 |
06.03.2006 16:44:34 |
|
|
access as frontend to backend sql 2000
Hello all,
i'm pretty new to access and sql, been reading up on them. currently i have
to develop a query system and using access as a frontend is one of my options.
my requirements are mainly speed, as the database and the users are based in
different countries.
ease of use with minimum coding involved and the ability to generate
spreadsheets(excel) from the results.
I understand ...
|
27 |
06.03.2006 03:09:48 |