- SQL Server / ADP

Thread preview

Thread	Last Post	Replies

DLookup function in ADP form Validation Rule	24 Oct 2005 17:35 GMT	8
Running A2003, SQL Server 2000, WinXP. After upsizing an MDB to ADP, I discovered that the DLookup function is not supported. [It is not widely publicized. I finally found it in Microsoft Office Access Help, "Examples of expressions that look up values in other
How to Show User Define Function?	24 Oct 2005 12:54 GMT	4
I have created a couple of UDFs in the SQL Server. However when I create an .adp MS Access (2000 version) file and when I look at the View and Stored Procedure, I just could not find one of the UDFs that I created... Is there any way to have them show on the .adp file? Since I ...
Input Parameters	24 Oct 2005 12:50 GMT	10
I'm just trying to work with Input Parameters for the first time (I normally just construct a recordsource & requery, but thought I'd try it this way for a change), and I'm having a bit of trouble figuring out why the following doesn't work:
problem using between in a field date	24 Oct 2005 10:14 GMT	2
Working on a Access database a try to retrieve data selecting all the data that match the following condition: SELECT * FROM Tabel1
Showing only part of data in dynamic field	22 Oct 2005 05:35 GMT	1
I have an asp page that shows dynamic data from the db, I only want to show the first 3 letters / digits from the db on the ASP page. Thanks in advance Simon
Falsh text if time NOW() IS < 20 MINUTES AWAY	22 Oct 2005 05:34 GMT	1
I need to Flash dynamic text on ASP page if the time in the record is less than 20 minutes from NOW() time. Thanks in advance Simon
modify datafie	21 Oct 2005 23:46 GMT	2
I have a database file like this: id status time 001 in 8:20 001 out 10:00
Runtime access 2000 to SQLServer	21 Oct 2005 19:42 GMT	3
Hi Guys, this is my first post here. I have just about finished an access application - Forms, Query's, Reports in access, Tables in SQL Server. I need to make the front end into an access runtime version ( I've never done this before but I've been reading about it) and this run ...
Table and Query Descriptions in ADP	21 Oct 2005 19:25 GMT	3
Is there a way to fill in the Database Window Description column for SQLServer Objects? Thanks. Alan
Export data from ADP file	21 Oct 2005 04:31 GMT	2
I want to create a tab delimited text file without any field qualifier from a stored procedure which has 2 parameters. I'm trying to use DoCmd.OutputTo method. My problems:
SQL Server Bit Fields & Bound Form Fields Incompatibility	21 Oct 2005 01:22 GMT	23
At the firm I am currently employed we have been developing an Access 2002 ADP with SQL Server 2000 database. We ran into some issues with binding check/radio buttons to the bit fields. Upon changing the value the application would crash. Initially, I believed a few things to be ...
SQL and ROUND()	20 Oct 2005 04:44 GMT	6
I have an ADP runnning on SQL2000 and this calculation is driving me crazy. I have a simple calculation that determine commissions. The base amount is a value of: $12,736.50 The agent's portion is 85%
Download AgileInfoSoftware PowerQuery and get free license!	19 Oct 2005 16:00 GMT	1
AgileInfoSoftware LLC is proud to announce AgileInfoSoftware PowerQuery 4.1 release. PowerQuery is free database query tool to work with multiple databases simultaneously and effectively. The key features of PowerQuery 4.1 are:
Automate Queries	19 Oct 2005 14:52 GMT	1
What is the procedure to automate quiries? I have about a dozen that need to be run at end of each month.
where are tables	18 Oct 2005 21:10 GMT	4
Generally speaking, in this newsgroup, are the sql tables in same building on a server, or are the tables in another city. I'm trying to figure out if some of the techniques I've learned from this newsgroup, and using a small network at work, will also work on a remote (meaning ...