|
test
gkgdolkdk,mf;lf,khd',dhhh
...
|
1 |
14.12.2005 10:48:52 |
|
|
new yare 2006
salam
happy new yare
...
|
1 |
14.12.2005 10:47:12 |
|
|
PLATA FACIL
¿NECESITA DINERO RÁPIDO? APRENDA A COMO HACER DINERO FACIL, DE FORMA SEGURA
Y TOTALMENTE LEGAL Hola, amigo/a : Te cuento mi caso: Estando en una
situación económica muy precaria y donde las puertas se me cerraban una tras
otra y no teniendo a quién acudir, pues en estos momentos los amigos se
alejan o están demasiado ocupados para ayudarte, fue que me encontré con un
aviso en Internet ...
|
1 |
13.12.2005 22:25:30 |
|
|
PLATA FACIL
...
|
1 |
13.12.2005 22:25:18 |
|
|
ÍõÈÙ£º21ºÅ 2005Äê12ÔÂ13ÈÕ
...
|
1 |
13.12.2005 07:45:53 |
|
|
2005¡£12¡£13 ÍõÈÙѧºÅ£º21
...
|
1 |
13.12.2005 07:40:00 |
|
|
select identical and unique rows in different tables
I have a database system of three table consisting of partly identical
information.
Now I want a few things:
-I want to select the rows from the tables that are present in all three
tables.
-I want to select the rows from the tables that are present in two tables
and not in the other one.
-I want to select rows that are unique to table 1
Can you help me with the SQL statements that make ...
|
2 |
13.12.2005 06:31:16 |
|
|
Switching a Form's Recordsource at RunTime to a SP w/ a Parameter
Hi - I have been upsizing a complex application to an ADP app (Access
2003 and SQL Server 2K) for the past few months, and have reached an
impasse that I can't just seem to get past, and am hoping for some
help. I have a form based on a view with several listboxes and subforms
based on SPs with parameters. I want to limit the default recordset to
records created in the past 60 days but need t...
|
8 |
13.12.2005 06:12:43 |
|
|
select unique and identical rows in different tables
I have a database system of three table consisting of partly identical
information.
Now I want a few things:
-I want to select the rows from the tables that are present in all three
tables.
-I want to select the rows from the tables that are present in two tables
and not in the other one.
-I want to select rows that are unique to table 1
Can you help me with the SQL statements that make ...
|
1 |
12.12.2005 22:09:40 |
|
|
Set a binary field to NULL ?
Folks,
A pretty basic question... how do I set a binary field to NULL ?
Simple assignement is clearly not correct, I get the following message:
You tried to assign the Null value to a variable that is not a Variant
data type.
Thanks
--alexT
...
|
10 |
12.12.2005 05:56:50 |
|
|
Using ADP Subreports with Stored Procedures with Parameters
Hi - anyone out there that can help a tormented soul??!!
I am in the process of doing my first MDB to ADP conversion, and have
come across my first sub-report which I am trying to pass parameters to
via a SP.
Having read through the groups I understand the conflict between using
an SP as a record source and the link parent/child settings on the
form, and found an entry under "solution! s...
|
4 |
10.12.2005 23:56:02 |
|
|
How to get and set Custom Database properties in ADP?
Most of my MDB upsized ok but I cannot figure out how to read some custom
database properties that I use.
Example
'read version from Database, Properties, Custom
Set dblocal = CurrentDb()
myDBVersion = GetDatabaseProp(dblocal, "Version")
using:
Function GetDatabaseProp(dbDatabase, strPropertyName As String) As Variant
GetDatabaseProp =
dbDatabase.Containers!Dat...
|
6 |
10.12.2005 22:15:16 |
|
|
wdq v b
ÄãºÃ°¡,ËûÊÇʲô¶«Î÷
...
|
1 |
09.12.2005 12:49:27 |
|
|
лл
...
|
1 |
09.12.2005 12:42:20 |
|
|
VBA function works in form but not in queries
I am converting an Access 2003 app to an ADP/SQL Server app. The
application was created by someone else. There are several forms,
queries and reports that call a VBA function that contatenates a
person's name in a presentable format (it deals with whether they have
a prefix, suffix, etc. )using a CASE SELECT statement. This function
works fine after the upsize in forms, but does not work c...
|
4 |
09.12.2005 12:39:49 |
|
|
data doesn't satisfy the criteria in the underlying record source ERROR Message
I keep getting the Error 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" I am using a SQL Server
backend and Access 2003 forms. This only happens when I am finished
entering a record.
Any suggestions?
Thanks!
-Lisa
...
|
3 |
08.12.2005 18:55:22 |
|
|
parameter report
I have a report in Access2002. The source of the report is a query on a SQL
server2000.
By opening the report, I want that there appears a dialog box, so the user
can type some text (for example: a title for the report). The typed text has
to appear somewhere in the report.
By using access mdb-files, I make a text box in the report, with a parameter
as source (for example: = [Type a ...
|
12 |
08.12.2005 17:52:57 |
|
|
Update Berechtigung auf Spalten prüfen
Hallo zusammen,
ich möchte in einem Access-Projekt (einem Formular) vermeiden dass der
Benutzer (genauer gesagt eigentlich die Gruppe welcher er angehört) erst
beim speichern seiner Änderungen erfährt dass er keine Berechtigung hat ein
Feld zu ändern.
Dabei bin ich auf die SQL-Server-Funktion "permissions" gestoßen, damit
lässt sich das ganze aber leider nur für den aktuellen Benutzer ...
|
1 |
07.12.2005 17:54:44 |
|
|
MS SQL and Sybase db
Does anyone have any information regarding running both db's
on 1 server?
I work in manufacturing and a current expansion project
involves 2 different vendors using these databases for their
backends.
I'm just wondering if I can locate both on 1 box?
Both would be fairly low transaction databases.
Any help appriciated.
Thanks
rp...
|
2 |
07.12.2005 16:25:20 |
|
|
Kein exklusiver Zugriff
Hallo NG,
habe eine SQLS2k-Entwicklerversion auf einem Rechner installiert und
greife darauf auf demselben Rechner mit einer A2k-adp zu. Jetzt habe
ich einen zweiten Rechner im Netz, auf dem ich ebenfalls mit einer
A2k-adp auf dem SQLServer arbeiten will. Ich kann die adp auch auf dem
zweiten Rechner öffnen, aber wenn ich z.B. eine neue Tabelle anlegen
will, kommt die Meldung:
"Sie habe...
|
1 |
07.12.2005 10:10:23 |
|
|
Best practice advise - performance problem
Folks
I'm having a performance problem with an ADP project I wish to submit
to your collective wisdom...
In summary I have a search form and a detail form connected to a fairly
complex underlying query.
The search form allows the user to select a small subset of the
underlying query and everything works fine. It takes some time to run
the query but it's acceptable.
Now the proble...
|
7 |
06.12.2005 22:27:47 |
|
|
I com
hi. I com.
...
|
1 |
06.12.2005 03:03:09 |
|
|
ADP Connection properties
Hi,
I have a function that checks the ADP SQL connection using:
CurrentProject.Connection.State
I trap the error and return FALSE.
I would like to present the user with some detailed information
regarding the connection string that was used to attempt the
connection. I find that I cannot use:
CurrentProject.Connection.ConnectionString
Since it seems to go out and try to connec...
|
3 |
06.12.2005 00:20:14 |
|
|
msado21.tlb
How can I register msado21.tbl in a access xp runtime running in windows
98.
...
|
2 |
06.12.2005 00:09:49 |
|
|
Date Format in a ListBox
Hello:
I have an invoce table, and a Date Field. I input the data as 12/08/2005
and it goes well. (Also have the Getdate() function. Also works fine)
The problem is that I want to show this data in a listbox, but the date fiel
would like to showit as dd-mmmm-yyyy and it does not work.
Any Ideas???
Thanks!!
...
|
1 |
05.12.2005 23:27:45 |