|
Datediff in ADP
Hello everyone. I can not get the Datediff function to work, and I can not
find the answer anywhere in the help menu. All I want to do is calculate the
number of days between two dates. I tried this, and many variations of it
but none work. Thank you.
DATEDIFF(date1,date2,"d")...
|
3 |
14.09.2006 01:42:35 |
|
|
RecordSourceQualifier
Hi
I'm using an ADP that was developed in Access 2000, in Office XP. ADPs in
Office XP seem to require a RecordSourceQualifier. Its set on some of my
reports, but not on others.
For example, if I had the record source as 'Clients' instead of
'dbo.Clients' then the report won't work. If I set the RecordSourceQualifier
to dbo then the problem is fixed.
Anyone know the code for stepping ...
|
3 |
15.09.2006 08:26:32 |
|
|
Open form with criteria in ADP
How can I open a form with a criteria?
In mdb, I use the following code:
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "F3_PsTpGrf"
stLinkCriteria = "[SelectID]=" & Me![SelectID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
I try to open in ADP but doesn´t work, What's happen?
Thanks
...
|
2 |
14.09.2006 16:05:33 |
|
|
Change SQL Sever user password from inside Access Project
I have developed an application that uses an adp file (Access 2000) as
a front-end and SQL server 2005 (in SQL server 2000 compatibility mode)
as a back-end.
Each user connects with its own user name and password.
When i first created the application only 4 users existed so it was
easy for me to change their passwords from SQL Enterprise manager.
Now we have more than 50 users and I would li...
|
1 |
14.09.2006 13:03:11 |
|
|
test3
test3 ...
|
1 |
14.09.2006 09:36:59 |
|
|
test2
...
|
1 |
14.09.2006 09:31:15 |
|
|
test1
...
|
1 |
14.09.2006 09:24:52 |
|
|
Call SP from command button
Hello using ADP, I have a form that takes user input in various text boxes
that are all unbound (not tied to rowsources) because the inserts need to be
dynamic. There is a checkbock that determines how the record(s) will be
inserted. (unchecked causes single table insert, checked performs a 2 table
insert) How do i code a command button's onclick event procedure to call a
store procedure...
|
5 |
13.09.2006 23:03:33 |
|
|
Get information of the table via VBA
Good afternoon.
How can I get the information (Caption, Format, Data Type; Lenght) of the
fields via VBA?
I'm using ADP project.
Thanks...
|
1 |
13.09.2006 20:00:01 |
|
|
IMPORT from Excel file
I have an excel file and I want to create a procedure to import the data of
the file into a table in the DB. I know hot to do it from 'Get External
Data' but I want to create a form to select the file and then to have a
button that calls a SP to insert the records into the table.
Thanks
Dimitris
...
|
1 |
13.09.2006 12:20:41 |
|
|
Restrictions form and a report
I have a form with a field DateFrom (shortdate) and I button to call a
report.
In the report I have in filter:
OrderDate>=[Forms]![ORD-RFOrdersDiary].[DateFrom]
When I press the button to execute the report (the report takes data from a
SP) I get the following error:
'Cannot apply Filter on one or more fields specified in the Filter property'
Thanks
Dimitris
...
|
1 |
13.09.2006 10:51:30 |
|
|
Can't see query using Grid
Can anyone explain why I can't see my criteria using the grid button
anymore.
I created the query using the grid and now I only can see the criteria using
the SQL button
I'm trying to access it using an adp (Access 2002 file format)
Any help is most appreciated
thanks
...
|
1 |
12.09.2006 20:36:33 |
|
|
Getting current DB with an adp connection
Hi,
I have set up an access conection to a external database on a sql
server through adp. I am trying to export a filtered subform in ms
access to excel
but I understand the best way to do it is to set up a query and change
the sql of the that query to filter the subform and then export the
query.
The problem is that when I set the db = CurrentDb and try to set a
QueryDef using db it t...
|
3 |
12.09.2006 15:05:49 |
|
|
From MDB to ADP
I have a form FOrders and a subform FOrdersTx.
In OnCurrent of FOrders I have:
Me.[ORD-FOrdersTx].Form.Combo6.Requery
In mdb file it works but in adp project I get an error 'Run-time error 2465'
Is there any different way to do it in adp?
Thanks
Dimitris
...
|
2 |
12.09.2006 15:00:48 |
|
|
Ó¢ÎÄ
ÐÂÎÅ×éµÄÄÚÈÝ.....
...
|
1 |
12.09.2006 07:39:12 |
|
|
Error 2115 in controls Before Update event
Hi gang!
I'm getting error 2115 'The macro or function set to the Before Update
property for this field is preventing the application from saving the data in
the field.'
in a Before Update event of a control.
The control is not bound.
The code basically just trims the length of the string entered if it exceeds
the fields size.
Here's the code:
Private Sub txtName_BeforeUpdate(Cance...
|
5 |
12.09.2006 03:59:01 |
|
|
Why can't I change data programmatically?
Dear friends,
I have two combo boxes on a bound form, and set the rowsource of the second
one thru vb code using the value of the first one in the where condition.
Recordset type is updatable snapshot. First combo is bound to the countryID,
and the second one to the CityID. Countries & cities are on different
tables. Whenever a country is changed second combo shows only the cities
that ...
|
2 |
12.09.2006 03:53:21 |
|
|
Simple division
Greetings all. Does anyone know the syntax to do a simple divison
calculation in a view? I have tried wording it every way possible, but I can
not get it to work. I need to do this expression.
dbo.tblmdu.qty_drops_spliced/dbo.tblmdu.qty_drops AS [%Drops Spliced]
both fields are tinyint. Thanks for any help....
|
11 |
12.09.2006 02:44:28 |
|
|
SELECT from SP
I have a stored procedure named [ORD-qClientsOrders] and I want to create
another SP that SELECTS records from
[ORD-qClientsOrders].
The error is 'Invalid object name ORD-qClientsOrders.'
Thanks
Dimitris
...
|
2 |
11.09.2006 14:09:16 |
|
|
Report Errors
Hi
I have a report, which has several sub reports. If there is an error in one
of the sub reports (e.g. a field is missing) I don't get any message. The
main report just hangs.
I have to open each sub report individually to find out what is wrong. I
don't remember this ever happening in an Access database. But in my ADP, the
report never opens, the progress bar just stays at nearly compl...
|
1 |
11.09.2006 14:04:42 |
|
|
Error when saving Access 2003 view
Dear friends,
I have XP professional SP2, Access 2003 and SQL svr 2000 with SP3 installed
on my machine.
whenever I try to save a view in access adp project I got the following
error message:
ADO Error: An invalid parameter or option was specified for procedure 'sp_
addextendedproperty'
The only chance to this dialog is OKand HELPand when I hit OK on the third
view is saved and runs ...
|
1 |
11.09.2006 09:16:06 |
|
|
newbie question - local queries
I've been asked to re-write an access app with sql backend.. can anyone
enlighten me regarding "how to emulate Access local queries"? Since
sql server is all on the backend, how does one make unique views for a
workstation?
Any advice is appreciated.
Lar
...
|
1 |
11.09.2006 01:57:30 |
|
|
Food for kids
This is a multi-part message in MIME format.
------=_NextPart_000_0021_01C6D3A7.95525D40
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I opened a checking and a savings account at BB&B. I have no money in =
my wallet. I'm not sure I have enough money to feed the kids were they =
to visit my place. I'd really like for them to visit and I b...
|
1 |
09.09.2006 04:33:48 |
|
|
Write conflict over-ride?
Hi guys
I have some code on a subform which changes a record that is displayed on a
different subform. The changes should overwrite whatever is there already.
When I move off the screen, or to another record, I get the "Write Conflict"
dialogue box asking if the wants to "Save Record", "Copy to Clipboard" or
"Drop Changes".
Is there a way I can tell the system to drop changes without ask...
|
4 |
07.09.2006 13:59:49 |
|
|
Running T_SQL script from Access (I can't get it right)
It might be an old subject, Running T_SQL script froms Access, but I can't
get it right.
I am running Access 2003 and SQL Server 2000.
I generate a SQL script from Enterprise Manager through Generate SQL script,
options International Text (Unicode).
The script Table1.sql looks like follows:
CREATE TABLE [dbo].[Table1] (
[Field1] [int] NOT NULL ,
[Field2] [char] (50) COLLATE Lat...
|
5 |
07.09.2006 08:33:30 |