|
filter & command button question
hi,
I have a form that is based on a stored parameter query ( this is an adp
project ).
It works fine when I first open the form from a main menu. I am prompted for
a client number. However, when I want to look up another client number, I
can click on a button "change client " which has as it's event
("=openform("client ")... Well, I get a message telling me"apply/filter
action cont...
|
8 |
15.06.2006 12:59:12 |
|
|
Strange behaviour with rs.Find (ADODB)
Hi
Using Access XP with MSDE (2000) backend.
I am opening a form and naavigating to a specific record (based on the
openargs, not conditions as when I use conditions an activex control
displays in the wrong place - but thats another story).
Anyway, there are no filters on the form and I have stepped through the code
to prove that a) the recordset is populated and b) the record I'm loo...
|
3 |
14.06.2006 15:43:58 |
|
|
Problems when using replicated tables with identities on subscribers (SQL Server 2000 & 2005)
Scenario:
Transactional replication with queued updates using SQL Server 2005 SP1 (the
problem also happens on SQL 2000).
Some tables with identity key columns are published to subscribers.
Identity intervals management are set to default (10000 for publisher, 1000
for subscribers, 80%)
Access 2003 all SPs applied using ADP connects to a subscriber.
No forms, just open one of these tables...
|
6 |
14.06.2006 00:54:31 |
|
|
Àï΢ºÁ
ºöÈ»ÌرðÄÚ
...
|
1 |
13.06.2006 06:41:00 |
|
|
oop Programing quesiton....
Hello....
Not sure if this is the right newsgroup for this or not.
I'm trying to learn to migrate to using classes and oop.
Instead of referencing a form like
dim i as integer
i = Forms![MyForm].form.tbMyTextBox
docmd.openform("Form2")
Forms![Form2].form.inputparameters = i
How can I build and use a class like.....
dim a as new addr 'addr being a class
a.property1 = somevalue
d...
|
14 |
12.06.2006 18:22:17 |
|
|
create a POP up information
Hi,
I have a small sale database in Access 2002 with SQL 2000 back end. The
database works fine except that the manager want a POP up notice about any
product that is less than 5 in stock. Does anyone recommend possible
solution here?
SF
...
|
8 |
12.06.2006 10:24:51 |
|
|
ÍøÉϼæÖ°µÄÓÖһѡÔñ-»ú»áÀ´ÁË
0×ʽð¸öÈË´´Òµ¹ÜµÀ -¸ßÊÕÒæ-¿ÉÒÔ×ö´ó×öÇ¿- ´òÔìȫо¼ÃģʽµÄ¼æְƽ̨-ȦµØÍø
-ÈËÉú¿ÉÒÔ×ö´í£¬µ«ÊǾø¶Ô²»ÄÜ´í¹ý-»ú»áÀ´ÁË.
-ÊÀ½çÉÏÓжàÉÙÓвŻªµÄʧ°ÜÕß,ÊÀ½çÉÏÓкܶà¸ßѧÀúµÄÎÞÒµÓÎÃñÊÇÒòΪ¾ñÔñ´íÎó.
-ÔÚÕâÀïÖ»Òª°Ù·ÖÖ®Ò»µÄÄÜÁ¦,¼ÓÉÏ°Ù·ÖÖ®¾ÁÊ®¾ÁµÄŬÁ¦¾Í»á³É¹¦.
¡õ¡õȦµØÍøÊÇÒ»¸ö´´Ðµġ¢»ùÓÚ»¥ÁªÍøµÄ¸öÈË´´Òµ»ù´¡·þÎñƽ̨£¬Ö¼ÔÚ¾ÛºÏËùÓÐÍøÃñµÄ
ÒµÓàʱ¼ä£¬Í¨¹ý¹²Í¬ÕûºÏ»¥ÁªÍø×ÊÔ´£¬ÎªÈ«¹ú³¬¹ý2500Íò¼ÒµÄ´óÖÐСÐÍÆóÒµºÍ³¬¹...
|
1 |
09.06.2006 00:46:38 |
|
|
run SQL via VBA in MS Access
I've been fumbling around with this for entirely too long, and I need some
assistance.
What I'm trying to do is to set up a form where the user can select from a
particular set of fields (which obviously exist in one of my tables).
After selecting the fields, I'd like to execute an SQL query via VBA. I only
want the query to display the fields that have been selected.
Does anyone ...
|
3 |
08.06.2006 21:17:09 |
|
|
open hyperlink to asp page
Hi. I am trying to open a hyperlink through code to a redirected asp
page but it is not working. Here is a portion of my (revised) code:
Dim strsql as string
strsql = "http://dev.companyname.com/submitpayment/Redirect.asp"
Application.FollowHyperlink strsql, , True, , "id=2"
I have also tried not using the 'extra info' portion:
Dim strsql as string
strsql = "http://dev.companyname.co...
|
2 |
08.06.2006 16:49:26 |
|
|
ADP bound form refresh after subform record delete?
Hi. I have an Access 2002 ADP project connecting to a SQL 2000
database. I have a form "Main" using a stored proc as a record source.
I have a continuous subform "Sub" using a Select statement as a record
source.
In Sub's AfterUpdate event, I run a stored proc to update data in a
table and then I Refresh the Main form to display the updated data.
This event works fine if I am adding o...
|
6 |
08.06.2006 12:34:46 |
|
|
SQL2000-Database, SQLExpress, Access
I have a big MSSQL2000-Database. I want to query the data. I have no
SQL-Server yet. Is it a good Idea to install SQLExpress, attach the Datafile
and connect to Access 2003? Who has experiences?...
|
6 |
08.06.2006 00:24:09 |
|
|
Stored Procedures Object
Access 2003
I do not have a Stored Procedures object group on my database list. Instead
all of the Stored Procedures are listed in the Queries Objects list.
A couple of books I have read store a separate Object for Stored
Procedures. Did that change with 2003?
Thanks, Mike....
|
4 |
07.06.2006 16:50:35 |
|
|
SQL Server Access
I have an MS Access project with SQL Server on the back end.
How do you suggest I develop access/security in this scenario? I have an
application with two types of Users. Those can Insert, Update or Select
from any table but thye may may not delete (Group A). Or those who can
Select on any table only (Group B).
What is the best way to implement this ? From what I have, defining Use...
|
10 |
07.06.2006 02:34:25 |
|
|
Parameterized SP in WHERE Clause of Another SP
I've got this SP:
CREATE PROCEDURE
EWF_spCustom_AddProfiles_CompanyYear
@prmSchoolYear char(11)
AS
SELECT
ContactID
FROM
dbo.EWF_tblCustom_CompanyProfile
WHERE
SchoolYear = @prmSchoolYear
I'd like to be able to reference that in the where clause of another
SP. Is that possible?
I'd like to end up with something like this:
CREATE PROCEDURE
MyNewProc
@prmSchoolYear2 char(11)
...
|
3 |
06.06.2006 20:46:36 |
|
|
User Name
Good afternoon
I using the following function to get the login from Windows XP
ALTER FUNCTION dbo.iLogin ()
RETURNS varchar(30)
AS
BEGIN
/* Sql Server autentication mode */
IF CharIndex('\',system_user)=0
RETURN system_user
/* Windows Autentication mode */
RETURN SUBSTRING(system_user,CharIndex('\',system_user)+1,30)
ENDALTER FUNCTION dbo.iLogin ()
RETURNS varchar(30)
AS
BEGIN
/* ...
|
6 |
06.06.2006 07:45:02 |
|
|
Table Relationship Integrity - Null Values
We have been building databases for replication and therefore using primary
keys of type uniqueidentifier. The GUI is developed in Microsoft Access 2003,
which doesn’t seem to allow us to insert NULL values into the foreign keys
(of type uniqueidentifier) that reference these primary keys. This means that
our referential integrity is compromised as we are forced to enter a valid
value ...
|
6 |
06.06.2006 06:42:41 |
|
|
help me with group by
hey i'm trying to group by a doctor's last and first name is this possible
here is my sql i'm using...
SELECT DOC_FIRSTNAME, doctor_matrix.DOC_ID, DOC_PHOTO, DOC_LASTNAME,
VISIBLE_ID, DOC_TITLE, doctor_matrix.DEPTCONTACT_ID
FROM doctors, doctor_matrix, departments_contact
WHERE ((departments_contact.DEPT_ID = MMColParam) AND (doctor_matrix.
DEPTCONTACT_ID = departments_contact.DEPTCONTACT...
|
12 |
05.06.2006 18:07:01 |
|
|
Access 97 linking tables from Sql server 2000
Hi,
Can I link tables from SQL Server 2000 into Access 97???
Thanks!
Domac
...
|
2 |
05.06.2006 14:14:03 |
|
|
Relink Tables
is it possible with code to test the connection to sql and return some type
of prompt to choose the correct sql server or atleast prevent access from
trying to connect to a non-existant sql connection?
...
|
4 |
05.06.2006 00:46:30 |
|
|
print record crashes database
Hi. I have a client with an Access 2003 adp frontend to a SQL server
2000 backend. They want to be able to print a record directly from the
form, however, every time on any computer that this is attempted,
Access crashes. I have searched for this specific problem, but have
not found any answers. Anyone have any ideas? I've tried testing to
see if changing page setup and selecting to print...
|
2 |
03.06.2006 23:41:34 |
|
|
¿ªÐÄ
»¶ÀÖÖÁÉÏ
...
|
1 |
03.06.2006 07:51:12 |
|
|
Recordset and RecorsetClone do not Reflect Sorting and Filtering
Hello,
In adp's the forms Recordset and RecordsetClone do not reflect sorting and
filtering made by the user on the form. Thus, if you try to select records
based on the SelTop and SelHight properties of the form you might get the
wrong records.
Example: Assume following RecordSource: SELECT * FROM Address ORDER BY
LastName
'Simulate different sorting done by the use...
|
11 |
02.06.2006 15:59:57 |
|
|
Controls disappear in form using stored procedure as data source
Hi Experts,
I would like to use the sp "sp_routeStat_CTY_Total_TestForm" as data
source for the form "Ufo_Test" with the input paramter "@LAND".
But after I did so, all controls of the form desappeared during run
time.
The sp delivers a ranking of flight destinations. @LAND should limit
the result to one single country (filed CC in the tables):
data source of form properties: sp_ro...
|
5 |
01.06.2006 21:48:51 |
|
|
Help !! How to achieve accumulative totals
I have a simple data base:
Date Job # Hours Emp #
I need to be able to have a query that will give me a running total of job
hours per job even if I specify a date range....
|
3 |
01.06.2006 21:19:31 |
|
|
Ä㻪ʢ¶Ù»¹ÊÇ
µØ·½´«½ÌÊ¿´ó·ù¶È µñËܺ½¿ÕÓë»á¿×¼ÒµêÉÏ ´óʦ¸µºôÓõ¼Æ»®µÄµ«ÊǺ;»¥»áÊܵ½¼Æ»®
¿ÚºÅ¸Ð˵´ó»°¿äº£¿ÚÅ©»ú»¯¿Ãµ«ÊÇ Ê±´ú¸Ð»·¾³¿É»ªÊ¢¶Ù
...
|
1 |
01.06.2006 08:14:26 |