|
%%%%%%%%%%%%%%%%%
...
|
1 |
22.08.2006 12:36:04 |
|
|
qqqqqqqqqqqqqqqqq
qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
qqqqqqqqqqqqqqqqqqqqqqqqqqqqq
qqqqqqqqqqqqqqqqqqqqqqqqqqqqq
qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
...
|
1 |
22.08.2006 11:46:00 |
|
|
xxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxx
...
|
1 |
22.08.2006 11:30:58 |
|
|
111111111
1111111111
...
|
1 |
22.08.2006 08:29:55 |
|
|
1111111111111111111111111111
1111111111111111111111111
...
|
1 |
22.08.2006 08:28:24 |
|
|
9999
...
|
1 |
22.08.2006 08:13:18 |
|
|
www
wwwwwwwwwwwwwwwwwwwwww
...
|
1 |
22.08.2006 08:07:17 |
|
|
zzzzz
zzzzzzzzzzzzzzzzzz
...
|
1 |
22.08.2006 08:05:59 |
|
|
aaAAAAAAAAAAAAA
dfgvrgvregft5rfg
...
|
1 |
22.08.2006 07:59:54 |
|
|
&&&&&&&&&
)))))))))))
...
|
1 |
22.08.2006 07:57:56 |
|
|
@@@@@@@@@@
@@@@@@@@@@@@@@@
...
|
1 |
22.08.2006 07:53:07 |
|
|
conditional calcuations
Hi,
I am doing an access project with SQL backend. I am sure this must have been
discussed earlier, but was not able to trace the solution:
i have a field for which i want to formulate the below, except that instead
of 0 for the false, it should allow me an input.
Currently if the status is 2, it correctly computes the value, but when the
status is any other number, it returns 0 becaus...
|
5 |
21.08.2006 16:39:10 |
|
|
SQL Scripts
Hi
Still working away on my ADP. Originally I took a copy of the Live SQL
database, and made any changes to the copy. So I'm ready to update the Live.
Most of changes are new tables. So I've generated some scripts, from within
table design. Thank MS for the auto script generator, as I hate writing
scripts!
Some questions:
1) I now have several scripts. Is is better to create one large ...
|
3 |
21.08.2006 11:21:57 |
|
|
DO NOT SEND ANY SPAM IN TECHNICAL NEWSGROUP !!!
DO NOT SEND ANY SPAM IN TECHNICAL NEWSGROUP !!!
...
|
1 |
19.08.2006 03:42:23 |
|
|
test2
test2
...
|
2 |
19.08.2006 03:42:07 |
|
|
DoCmd.TransferSpreadsheet acExport using a view as the source
is there some reason i can't use a view as an export source with
DoCmd.TransferSpreadsheet acExport?
i gat an error message that says my view cannot be found.
triple checked the spelling etc.
tia,
mcnewsxp
...
|
1 |
18.08.2006 14:24:22 |
|
|
Case When
Greetings everyone. I need help with a stored procedure. I need to add a
column to enter a value, either 1,2, or 3 depending on the value of another
field in the query. For example, if the value of the independent field is
'apple' I need the new dependent field to populate '2'. I think I need to do
a case when statement, but I can not get it to work. Is this anywhere close?
case wh...
|
7 |
18.08.2006 00:54:51 |
|
|
Push and Pull
I developed a database using access. One of the item requires that if
an number is chosen the description of the material number must be
shown with it. This part works for me; however, once the rest of the
info. is entered the information of the both number and description are
not displayed in the table. Can anyone help? I'd appreciate any
advise.
...
|
1 |
17.08.2006 21:23:53 |
|
|
ÎÒµ¨´ó
ÎÒµ¨Ð¡,¼áÇ¿,ÓÐÓÂÆø,³äÂúÐÅÐÄ,ÓйÇÆø,´Ó²»µÍÍ·.
...
|
2 |
17.08.2006 02:14:10 |
|
|
Global Variables for Query Parameters
I am missing something very basic that I need so I apologize for my inability
to grasp the obvious (because I'm sure it is) in advance.
I had an .mdb that I have converted to .adp. There are many forms that
provide the criteria for either the underlying queries or recordsets such
as...
PARAMETERS [Forms]![CallList_Frm].[BegState] Text ( 255 ),
[Forms]![CallList_Frm].[BegState] Text ...
|
4 |
16.08.2006 16:14:19 |
|
|
Relationships - Cascade Update and Delete
Hi
I set up Cascade Update and Delete relationships in a Database Diagram,
within SQL Entreprise Manager.
The relationships were to a Clients table.
If I change the Clients table design within Access ADP, I get message like
the ones below. It removes the Update/Delete that I set up.
'Submissions' table
- Relationship 'Submissions_FK00' is marked for CASCADE UPDATE. This
attribute will...
|
1 |
16.08.2006 16:00:49 |
|
|
Problem after upsizing
I've done the upsizing of my Access database with the SSMA wizard of Access.
This has worked well, but I've got the following problem:
On a lot of places I have this code:
Set DB = DBEngine.Workspaces(0).Databases(0)
Set MyTable = DB.OpenRecordset("Name_Of_Table", DB_OPEN_TABLE)
When I run the code, it gives me an error:
'Illegal operation' (something like that, I have a Dut...
|
7 |
16.08.2006 15:02:17 |
|
|
SQL Tables
I'm trying to convert a complex .MDB database into .ADP. This is all new to
me so I'm learning. I have read here that ADp files don't have data. If
this is so, where is the data? Currently all my data resides on an MDB file
(I long ago split the code from the data). What do I have to do to get those
tables onto the SQL server so my MDP front end can see/connect to them?
Please be v...
|
11 |
16.08.2006 13:32:10 |
|
|
ADP - on each users PC?
Hi
When I used mdbs, I always put a local front end database on each PC, with
the data on the server.
I'm new to ADPs, but I'm guessing that the same idea applies. A workmate is
suggesting that one ADP on the server will do the job.
Now, I thought one of the reasons for storing the frontend locally, was to
stop the forms and reports layout date being transferred over the network.
Wha...
|
7 |
16.08.2006 08:27:13 |
|
|
Looking for recomendation for Web Based front end
I have just converted several mdb's to adp's and now would like to migrate to
a web based product like .ASP. Does anyone have any recommendations as to
which product would be the most practical. I have about 150 users on military
bases and it is a real pain every time I make a change to the front end and
have to push a copy out to the server and have them grab it. I will still use
SQL as the...
|
4 |
16.08.2006 08:14:59 |