|
·´¶ÔÁ¢¿Ì¸Ð
¶¼ÊÇʲôѽ?È«¿´²»¶®/./';.;',.;'['//.''
> >
> > ÎÒÒ² ÓРͬ¸Ð°¢ ¶÷ ¡¡¡¡¡¡
>
...
|
1 |
04.01.1980 04:22:44 |
|
|
ADP filters selected value not displayed properly
Hi all,
I have a issue with filters in Access ADP forms.
I have 4 filters that are applied simultaneously when selecting the
first filter it appears correctly. if i select a second filter that
returns no row it is impossible to remove the first filter on the
display to return to a defalt value.
by trying to set the DefaultValue or value property programmatically .
the filters are correctl...
|
1 |
02.11.2005 15:01:16 |
|
|
different stored procedure names when opeing file on different machines
I have an adp file that shows the correct stored procedure names.
When I open the same file on a second machine, the names are the same until
the very end. somehow, the names all show a semi-colon followed by the
number one.
ex:
sp_someName;1
How do I prevent this?
WB
...
|
3 |
02.11.2005 07:18:12 |
|
|
Query portions of a text field
I have a text field - nvarchar(1000) - that I want to query for just
portions of the text. In the text fields, there are notations enclosed in
square brackets, for example, one record may contain -
"[10/5/2005 9:50am ryan] Called rep - scheduled appt"
On a certain form I want the text to be displayed but I don't want to see
all the info within the square brackets, so the query should ju...
|
2 |
02.11.2005 05:24:47 |
|
|
first adp project
hey,
I just upsized my first access db to adp and an sql db. The sql server is
not in the same bldg as me -- I am in WA and it is in OH.
The upsizing wizard seems to have done its job. I can login into the sql
server and see the db in Enterprise Manager. But when I open the access
front end on my desktop -- the front end app is pretty much froze up.
I have beern trying to open a form (...
|
2 |
02.11.2005 00:53:30 |
|
|
How to stop users from "unfiltering" a form?
I have a form which I control the records filtered on using VB. Some users
are suppose to be able to see one group of records while other users can see
other records, there is criteria set up on Form_Load that checks their login
and shows them what they should see based on security settings. However, I
just realized that any user can easily remove the filter and see every
record in the...
|
8 |
01.11.2005 19:03:57 |
|
|
Windows Authentication with non current user name
Hello Everybody,
I have a client program for which I need to support Windows authentication.
I used the following SQL connection and it works for the current user
"server=localhost; database=myDB;Integrated Security=SSPI;"
But, I wanted to login using other windows login name ( i.e., not the
current logged on user ) and I used the following conection string
"server=localhost; database=...
|
9 |
01.11.2005 15:50:12 |
|
|
Problem with HOST_NAME Function with Linked View
I have an Access 2000 MDB file with a SQL 7 back end. I have a main table
with 50,000 records; and I have a selections table with 50,000 records for
each machine that uses the database (about 25-50). This allows each user to
have their own set of selections.
The selections table has three fields: ID (int), Sel (bit), MachName
(varchar). ID and MachName comprise the primary key.
I hav...
|
20 |
01.11.2005 08:06:22 |
|
|
concatenate date and time
Hi. I'm new to this list and to working with ADP's so forgive the
newbie questions! I am in the process of upsizing an Access 2003
database to an Access ADP/SQL Server app and thus need to make lots of
syntax changes to queries, etc. A form has a combo box that
concatenates the date with the time from two fields and i am having
trouble replicating this. Here is what i have, but the time co...
|
5 |
31.10.2005 22:20:02 |
|
|
Copy Data out of Table in an other Table within same DB
Hi
I've got a small Problem. I want to copy several rows out of (Ms SQL) Table
A into Table B. Table A and B are the same and are within the same DB
Is that possible?
Thanks for the help
Marcel
...
|
3 |
30.10.2005 20:48:33 |
|
|
ADP report truncates field at 4000 characters
Pardon the cross-post--I must have overlooked this NG when originally posting
to microsoft.public.access.reports. The below includes my original post as
well as some new findings. Original problem still exists.
X.
***************************
As the data comes into the report, I tried Debug.Print as well as writing the
text beyond the 4000 character mark to a textfile. It's just a bunch ...
|
4 |
28.10.2005 13:37:12 |
|
|
Query with changing table names
I have a web tracking program that writes it's data to a MSDE database.
Unfortunately it writes each day's data to a different table. It names them
connection_events_2005_10_20 then connection_events_2005_10_21 etc... I need
to create a report by the week from all of these tables. Is there away to
query all of the tables that start with "connection_events_ " at the same
time? Is there a...
|
3 |
27.10.2005 21:07:14 |
|
|
Invalid Field Name
I have an Access project that I created from an existing Access
database. SQL is 2000, Access is both 2000 and 2003.
The existing Access tables had field names like [IDF DATA(1)],
[IDF DATA (2)], [IDF DATA (3)]. Those names are ok in SQL as long as
you use the brackets around them. The user wanted to add a few more,
so in design view, she copied the line and inserted it below. She
chan...
|
5 |
27.10.2005 20:28:13 |
|
|
Date & Time internationalisation
Hi,
I'm currently building a client/server calendar system with access as
the primary front end and sql server 2000 at the back end. I also have a
web-front end that hasn't been finished yet. I've come up against an
internationalisation issue with time's.
Users are already using the system from Scandinavia, India and the UK,
and are soon going to be using it from a number of oth...
|
1 |
27.10.2005 16:01:04 |
|
|
Best Practive - Updates between Access and SQL Server
Hi,
Let me paint a picture...Access 2000 frontend, linking to a SQL Server
backend, inherited database, me - fairly new at this! :o)
The developer has, for better or for worse, (I'm not sure), designed a
frontend that grabs a set of order records from SQL and pulls them into
a form. While the records are there, the user can allocate the order to
a person by selecting t...
|
3 |
27.10.2005 00:42:43 |
|
|
SQL Batch Scripts
Just wondering if there is a way of calling a sql script from another sql
script. I have a bunch of .sql files that build my database and I execute
these through a .bat file. I was wondering if this could be done with a .sql
file instead. The reason is that I would like to build the database in query
analyzer vs. command window.
--
Message posted via http://www.accessmonster.com...
|
1 |
26.10.2005 17:48:40 |
|
|
ADP to backup/restore SQL server database
is it possible in the adp application im creating in access 2k3 to
create a routine that will allow the end user(only 1) to backup a sql
database and restore the database at will?
thanks for any and all help!
ben
...
|
1 |
26.10.2005 17:22:57 |
|
|
converting access 2002 to mssql 8.0
I have been asked to convert an access 2002 application to mssql 8.0 (keeping
the front end in access).
I have searched your site for information.
1)How do I actually transfer the mdb tables to mssql? I could not find this
information in mssql or access.
2)From what I have read on your site, "Simply switching an Access database to
use SQL tables will probably cause a dramatic SLOWING ...
|
1 |
26.10.2005 08:09:31 |
|
|
grafic objetc and ADP projet
This is a multi-part message in MIME format.
------=_NextPart_000_0045_01C5D8D1.7C9E97E0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I need insert in my report a grafic. But I need to pass two parameters, =
the initial date and the finish date of the report.
how can I pass this two parameters, if the grafics objets dont have any =
input...
|
1 |
24.10.2005 17:31:10 |
|
|
Compare db entry with dynamic text on asp page
Sorry I not making it clear,
If the dynamic filed on the asp page from recordset 1 was, for example,
London I neeed the code below to match 'London' to a list of entries in
Recordset 2 and return a row background colour based on the match. Recordset
2 is another table with a list of towns only.
<tr
<%
Record = Recordset1.Fields.Item("COLL_CITY_TOWN").Value
Record2 = Recordset2.Fi...
|
1 |
24.10.2005 05:20:00 |
|
|
perdijc@hotmail.com
...
|
1 |
09.03.2003 10:23:45 |
|
|
×£¸£
СµÄ·¢¸ö
...
|
1 |
09.03.2003 10:23:25 |