|
Stored Procedures
Hi Folks
So what do you ADP guys use to write your Update, Append etc Queries?
Is there a graphical tool like there is in normal access?
Have a fairly complex Update to run, and I don't want to write it all in
SQL.
Thanks
Diarmuid
...
|
7 |
20.07.2006 18:07:56 |
|
|
Update form display and underlying record
I need help in just these couple of issues:
1. In the same project, which has a form "ENTRY FORM" I have used the
fields [invqty], [invprice], [invval], [poqty], [poprice] [poval], where
invval = invqty * invprice.....poval = [poqty]*[poprice].....
I am able to calculate the value, however, the invval is not displayed on the
form unless I save the record. How can I make this work so that ...
|
1 |
20.07.2006 21:40:38 |
|
|
ADP opened read-only
Hi everyone,
I occasionally accidentally launch and ADP file when I've already got it
opened, and I'm sure some of my users do it as well. Access, of course,
informs the user that it's opening the project read-only. Does anybody know
off-hand if there's a way to:
a) suppress that message, and/or
b) detect that condition once my code is running to pop up a friendlier
error ...
|
15 |
20.07.2006 18:05:55 |
|
|
Parameter from Combo box
I have a form (FactoriesOrders )with a ComboBox and a subform (FOrders) that
show the results of an SP.
The SP has a parameter and I have connected the parameter with the ComboBox
@parameter nvarchar(15) = Forms!FactoriesOrders.ComboBox
How can I refresh tha data of subform each time I change value to ComboBox?
Thanks
...
|
3 |
19.07.2006 22:57:12 |
|
|
duedate
I am a novice to Access and I have a small Access project file and need to
use the below, can some help me with formulating :
[subdate], [duedate] & [shipmode] being the fields in a query.
i want to formulate
[duedate] = if [shipmode] = "AIR", duedate + 30 days
if [shipmode] = "OCEAN" duedate + 60days...
|
5 |
19.07.2006 13:33:34 |
|
|
passing parameter values to SQL Server from CSharp
I'm having problems getting correct parameter values to pass to SQL Server
from C# code.
In my C# code, I assign a parameter '@appID' and give it a value based on
the option chosen by a user.
No matter what I select when debugging, the code always passes a value of
'1' to the stored procedure.
The stored procedure is as follows:
CREATE PROCEDURE [dbo].[spLockApplication]
@appID ...
|
3 |
18.07.2006 19:41:05 |
|
|
data refresh
I have the following:
- a form FClients with data from table Clients.
- an SP qOrders with data from ClientsOrders table with parameters @Client &
@Factory
- a Subform in FClients with data from SP qOrders in datasheet view. I have
put the parameters of SP in InputParameters.
I have put an unbound field (combo box) in FClients to select the
OrderFactory.
How can I refresh the data o...
|
1 |
18.07.2006 12:30:46 |
|
|
Passing Form input to stored procedure to populate a report
I know this has been asked before but I can't find an answer I
understand. I am new to ADP and in many ways wished I had just linked
tables in an MDB. Never the less, the power and flexibility for other
front ends when all is done has kept me pushing forward. Microsoft
provided an informative article 235359 discussing passing a form
selection to a second display form but I can't separate t...
|
9 |
17.07.2006 16:55:10 |
|
|
Error 15135 on upsizing Access to Sql Server
I am trying to upsize an Access DB to Sql Server. The upsizing wizard runs
fine when I try it locally to Sql Server Express 2005.
When I try to upload it to our remote server, I keep getting a bunch of
errors "
Server Error 15135: Object is invalid. Extended properties are not permitted
on 'dbo.<table>.<field>', or the object does not exist."
I googled the error but al...
|
7 |
15.07.2006 21:27:10 |
|
|
Form saves with Server Filter
If I open a form, with criteria, and then make design changes, the server
filter saves it.
For example, I open frmClient with ClientId = 'ABC'
If then make design changes, and save the form, it will now have a server
filter saved of ClientID = 'ABC'
Next time I open the form, it will still show ABC, no matter what ClientID I
specify in the criteria.
Is there a way around this? I know I...
|
3 |
14.07.2006 08:30:07 |
|
|
Filtering data in a form
I have a form FClients (data from Clients table) and a form FClientsOrders
(data from StoredProcedure qOrders).
I have created a button in FClients to open the FClientsOrders to see the
orders of the loaded client of FClients.
My problem is that I see all orders (of all clients).....
Thanks for any help
Dimitris
...
|
1 |
14.07.2006 05:30:13 |
|
|
Combo Box Requery
Hi. I'm new to Access ADPs and am using Access 2003 to create a SQL Server
2000 database.
I'm using a combo box in Table 1 to look up Table 2. With Table 1 still
open, after adding a record to Table 2, then doing F9 on the combo box, the
added record still doesn't appear in the list. Only when I close down Table
1 and reopen it does the added record in the other table appear in the...
|
25 |
12.07.2006 15:14:11 |
|
|
specifying database connection during deployment
Hi, I'm an ADP newbie. When I go to deploy my adp project at a
customer's site, what's the best way to specifiy the database
connection. Currently I'm developing against a local copy of SQL 2005
express. I was hoping there would be some setting text or xml file I
could deploy with my adp or ade file, but maybe we have to do it
interactively.
thanks,
Bruce
...
|
1 |
12.07.2006 11:25:52 |
|
|
QBF in an Access Project using a between
I was wondering how to use a between on the Order Date field in the
Stored Text Procedure portion of the MS KB article How to implement
Query by Form (QBF) in an Access project
http://support.microsoft.com/kb/286828/en-us. I tried a whole bunch of
different combinations but not with any success. So if anyone could get
me pointed in the right direction it would be greatly appreciated.
Thank...
|
8 |
12.07.2006 09:01:12 |
|
|
Access to SQL
Hi All,
Forgive my ignorance here and if this is the wrong forum then apologies and
can you advise where it should go please.
I am a mere mortal who has developed an Access 2003 shared database that has
outgrown its original single use brief and is now in use across the
organisation. We recently had a corruption that required some work getting
the database back and we now want to transfe...
|
6 |
12.07.2006 07:34:10 |
|
|
Storing Text
Hi
What do people use for storing text?
In Access, I used Text. (of course!)
In SQL, there's Char, nchar, VarChar, nvarchar and Text.
For ADP projects, is there a particular type I should choose?
I've used VarChar, and it pads out the string to the appropiate lenght. So
I'm looking for a way around this, withour resorting to Trim.
Thanks
Diarmuid
...
|
4 |
11.07.2006 08:13:05 |
|
|
hello.....
bla....bla....blas.....
...
|
1 |
11.07.2006 02:46:31 |
|
|
Ëæ±ã¹ä¹ä
°²¶¨·¨
...
|
1 |
10.07.2006 03:30:39 |
|
|
Go http://www.kamtek.permonline.ru
--
Go http://www.kamtek.permonline.ru
free girl russia
...
|
1 |
08.07.2006 21:22:07 |
|
|
Access Project connecting to multiple SQL Servers
Good morning. We are having an issue and would like to see what our solution
could be. We have an Access 2003 Project (.adp) connected to a SQL 2000
Server and all works great. We are adding an additional link to a SQL 2005
server. When the views are run individually, they work fine. However, when
we try to create view from those linked servers it times out. We have
changed the tim...
|
3 |
08.07.2006 07:44:47 |
|
|
scroll bar in table in html
hi
how i can create scroll bar in table in html?
thanks
lior...
|
1 |
07.07.2006 09:52:01 |
|
|
Access ADP Server Filter By Form two issues.
I have two issues with the functionality around Server Filter By Form.
1. When I set the "Server Filter By Form" property of a form to yes,
the form opens in Filter By Form view but is completely disabled and
greyed out ie I can't type anything into any of the fields and none of
the drop down lists function. I have to click "Apply Sever Filter" to
view the form in normal view and then cl...
|
1 |
06.07.2006 06:41:42 |
|
|
Open Report from button with variable
New to Access Programming and would like to open (preview) a report from
clicking a form button. I would like the form to pass a value (its UID) to
the underlying report query (Stored Procedure) to narrow the results. Not
working, any help? Thanks
Button's Event Procedure:
Private Sub Print_Roster_Click()
On Error GoTo Err_Print_Roster_Click
Dim stDocName As String
stDo...
|
17 |
05.07.2006 19:22:02 |
|
|
Access client with SQL 2000 back end stops responding
I have the following:
1. An Access 2000 MDB file.
2. The MDB file has all forms, queries, and code.
3. The 30+ tables are all linked tables to two back ends.
a. One read only Pervasive P.SQL 2000i SP4 database
b. One MS SQL 2000 (believe sp2a) database which users read and write
to.
4. Windows XP and 2000 clients all with latest Windows Updates
Once every couple of months for ...
|
2 |
05.07.2006 18:57:19 |
|
|
Rename a column using SQL
I am trying to rename a colum using an SQL statement run in a macro using the
RunSQL action. Some forums have told me to use the following:
ALTER TABLE [CurrentTable] RENAME COLUMN [OldName] TO [NewName];
When I try to run this I get the following message: "Syntax Error in the
ALTER TABLE statement". What am I doing wrong? It seems pretty simple to
me, and many other forums have off...
|
2 |
04.07.2006 20:52:47 |