|
Cannot run Inline functions
I have an ADP project which I have distributed to 30 clients. The backend
database is SQL Server 2000. The clients are running Office 2003. On some
clients most of the Inline functions (called User defined functions in SQL
Server) do not run. I can open them in design mode but when trying to run
them nothing happens. It seems like this goes to those Inline functions which
contains parame...
|
6 |
6/26/2007 8:22:03 PM |
|
|
using store procedure as recordsource
Hello there
If i have store procedure with parameters, can i use it as record souce
without the enter parameter value to be opened and the data will be taken
from the current form
...
|
3 |
6/26/2007 5:53:41 PM |
|
|
reciving table with diffent schema
Hello there
I'm using access 2003 adp with sql server 2005
Some of my table relate to diffrent schema then dbo.
and i can't use them on the normal tables. only with ado
Is there a way to use them on schema
...
|
1 |
6/25/2007 6:21:04 AM |
|
|
Formatting Text boxes in ADP
Hi I am new to using Access Data Projects as have always used mdb in
the past.
Can someone tell me why the bound fields from SQL do not display the
selected format unless I set the control source to =cdbl([Field]). the
field is Decimal on SQL serrver?
...
|
1 |
6/25/2007 3:02:31 AM |
|
|
Report Link fields
I have a report that I have translated from and MDB into an ADP which has a
couple of subreports that sit in a group header and footer. It uses the Link
Child Field, Link Master Field features to filter the data displyed data
according to the Master record value. This feature does not work as it does
not restrict the data according to the links. This feature works fine in MDB
reports,...
|
3 |
6/24/2007 11:49:00 PM |
|
|
Diabetic Recipes and More...
Hi Cookers,
Welcome to our new website, cookersworld.com. We
have expanded the content links to ad Mr. Emeril
Lagasse's fine recipes along with recipes for diabetic's.
The website is full of great links from our partners. We
have links to free cookbooks and more. Please stop by
and support us. Visit all our links and choose the best
recipe for you or your family.
We look forward t...
|
1 |
6/24/2007 8:25:48 AM |
|
|
A2007 ADPs
Hi All,
Just some general comments and the odd question about A2007 projects...
Currently I am upgrading an Access 2002/2003 ADP to A2007.
It is a large application that was originally upsized from an .MDB to an
..ADP in Access 2000 for scalability, reliability and performance reasons
when ADPs were new and all the rage.
Comments - The Good and not so Good:
1) The...
|
38 |
6/24/2007 6:04:05 AM |
|
|
Oportunidad de negocio
<HTML>
<HEAD>
<META NAME="GENERATOR" Content='"Microsoft DHTML Editing Control"'>
<TITLE></TITLE>
</HEAD>
<BODY>
<DIV>
<P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><B><SPAN lang=ES-TRAD
style="FONT-SIZE: 18pt; COLOR: fuchsia; FONT-FAMILY: Arial; mso-bidi-font-size: 12.0pt; mso-ansi-language: ES-TRAD">TRABAJA
DESDE CASA Y GAN...
|
1 |
6/23/2007 10:54:27 PM |
|
|
recordset
Hi, what is the better way to open a Recordset and don't affect the memory
server. Actually I use recorset with cursorlocation = cliente and cursortype
=adOpenForwardOnly but my server memory goes up.
for your advice thanks.
...
|
2 |
6/23/2007 6:51:08 PM |
|
|
refreshing objects
Hello there
I have access 2003 adp that connect to sql server
I add new table/view/store procedure on sql server and in order to see it on
access i must refresh adp manually.
Is there a way to refresh access by code?
...
|
2 |
6/23/2007 12:50:51 PM |
|
|
To Norman Yuan...
Hello, I noticed you expllained to someone that she was in the wrong NG as
she needed help with Outlook Express.
I just opened a NG in my OE and I'm shocked that it's been downloaded into
my new NG over 100,000 NGs!!! So please kindly help me with these
Questions?:
(1) How can I find ONLY the microsoft.public for Internet Explorer and
Outlook Express both 6.0?
(2) How can I del...
|
2 |
6/22/2007 2:31:47 PM |
|
|
OpenForm WhereCondition & ADP
Hi - I posted tis in microsoft.public.access.formscoding a week back and Guy
who replied (thanks Guy), but did not spot any obvious errors, suggested
posting here. In the meantime I am opening the detail for as acDialogue which
gets round the problem but isn't as usefull to the user .
Im having some strange behaviour with the OpenForm method now my mdb is
upsized to adp.
I have a con...
|
4 |
6/21/2007 11:46:15 PM |
|
|
2950 error - Access 2007 ADP connecting to SQL 2005
I am in the process of upgrading an old Access ADP/SQL 2000 App to Access
2007 ADP/SQL 2005.
There are a lot of buttons in the Access form which are calling Access
Macros, the Macros call Stored Procedures in the SQL database. This is
resulting in '2950 Error' for all the macros.
Here is Microsoft' answer for that error:
http://support.microsoft.com/kb/931407
I have followed al...
|
2 |
6/21/2007 7:58:00 PM |
|
|
using OnError event
Hello there
I have form which has OnError event to track errors on entering data to
table. (validation rules, primary key, ect...)
on mdb in order to know what is this error i used with msgbox
DBEingine.errors(DataErr) which isn't working on adp. where is the error
object on adp?
...
|
2 |
6/21/2007 6:20:42 PM |
|
|
¼á³Ö·´¶Ô¿Ö²ÀÖ÷Òå
ÃÀ¹ú²»ÄÜÀ뿪ÒÁÀ¿Ë
ÒÁÀ¿ËÕ½ÕùÒѾËÄÄêÁË£¬ÏȲ»ÂÛÕ½ÕùµÄ¶Ô´í£¬Ó¦ÒªÃæ¶ÔÏÖʵµÄÐÎʽ£¬ÈçÒªÍ˳öÒÁÀ¿Ë£¬ÐÎÊÆÔõÑù£¿²»ÄÑ¿´³ö»¹ÊÇһƬÄÚÕ½£¬¶øÇÒ»á¸ü¼Ó²ÒÖØ£¬ÒòΪÕâÊÇÒ»¸öÏÖʵµÄÏëÏó£¬ÕâҲȷʵÊÇÓë¿Ö²ÀÖ÷ÒåµÄÕæÕý½ÏÁ¿£¬ÃÀ¹ú¾Í´ËÍ˳öÊÇÒ»ÖÖ²»¸ºÔðÈΡ£¶øÇÒ¹ú¼ÊÉç»áÒ²Ó¦²ÎÓ룬ҲÓÐÄÜÁ¦ÖÆÖ¹ÄÚÕ½£¬ÄѵÀ¾ÍÖ»ÊÇ¿´Âð£¬Èç´ËµØÆÀÂÛÂð£¿ÐļÆØϲ⣬ÊÇÏ£Íû±¾ÀµÇÊÇÓ®¼Ò°É¡£ÒªÓ®µÃÕâ´Î½ÏÁ¿£¬ÃÀ¹úÓ¦¸Ãսʤ¿Ö²ÀÖ÷Òå¡£
...
|
5 |
6/21/2007 10:57:38 AM |
|
|
using ckeck box in tables
Hello there
I have application on access 2003 adp.
To some subForm i have i bound access table in order to make it the
dinamicly way to work.
The table is sql server 2005.
in the table there are bit values. I would like to present them in my table
as checkboxes and not as yes/no or true/false.
Is there a way to so so automaticly?
...
|
4 |
6/20/2007 2:34:39 PM |
|
|
refreshing tables with code
Hello there
i have access 2003 adp.
one of my store procedures that i run create new table.
I need in the code that runs the store procedure to refresh the list of
tables in the adp so i can use these tables afterword.
on mdb i had: currentDb.tableDefs.refresh
is there another action that looks like this on adp?
...
|
2 |
6/20/2007 12:12:27 PM |
|
|
Ò°È˵ÄÊÀ½ç
ºÜ¼òµ¥£¬ºÜƽ¾²¡£Ã»ÓÐÕ½Õù/ûÓÐÎÛȾ¡£
...
|
2 |
6/20/2007 2:31:20 AM |
|
|
Join multiple stored procedure results using query editor ???
Hi,
I have a stored-procedure which executes seperate (parametrised) sprocs.
The resultset of each seperate sproc is put into a temp.table.
Then all the tables are joined togheter into one resultset.
This is working fine.
Question: is there a way to join the the temp.tables (result sets) in a more
graphically way (query designer)
I would use the result-sets of the executed sprocs in t...
|
2 |
6/19/2007 6:09:58 PM |
|
|
find out if all forms are closed
Hello. I'm working with an Access 2003 adp/SQL Server 2000. I'm
trying to write some VBA code that would get checked when any form is
closed to see if all other forms are also closed so that, if so, the
main menu form could come up. Is there a simple way to do this?
Thanks,
Jenn
...
|
3 |
6/19/2007 5:30:00 PM |
|
|
help! finding and restoring OE files after re-installing OD
Before my primary hard disk failed, I copied everything to my second hard
disk. Now I have a new hard disk and have reinstalled Windows XP home.
But now I cannot find my OE files on the second disk!
Has anyone any idea where they might be? And how I can find and restore
them?
Thanks.
Anne Wilson.
...
|
3 |
6/17/2007 1:07:45 AM |
|
|
esporte
...
|
1 |
6/17/2007 12:02:30 AM |
|
|
esporte
...
|
1 |
6/17/2007 12:02:04 AM |
|
|
display
Would anyone help me with a problem?
After a lengthy shutdown my other computer shows "Burn-in mode" on the
monitor and nothing else happens!
Any advice?
Brian
...
|
1 |
6/16/2007 1:48:57 PM |
|
|
ÎÔÊÒÈË
ÎÔÊÒÖйúÈË
...
|
2 |
6/16/2007 1:58:53 AM |