hi,
1.
You can use field Record Source to enter stored procedure name and Input Parameters for procedure parameters. For example
Record Source sp_check_me
Input parameters @A = [FORMS]![...], @B = ...
2. You can name form fields exactly as stored procedure parameters. During runinig, stored...
hi,
i have problem that makes me creazy ;)
scenario 1: adp project works in multi user environment. 2 users open concurently the same form binded to ms sql data.
they look into data moving beetween records.
problem 1:one of them changes data in some records but other have the same data as...
You can:
1. Try to connect to SQL Server by, for example, Enterprise Manager from remote computer.
2. Try to make, on remote computer, DSN connection and then test this connection.
K.
Hi,
You have to check that ip address of sql server can be accessed from outside world. If not You have to open (probably on firewall - Your or Your provider) proper port and ip address. If you do that you have no other problems I think :)
K.
Hi,
In ADP projects you can not use Advanced Filter/Sort but You can replace its functionality with ServerFilter. The only problem with ServerFilter is that it handle date fields only after first open, next time You will see error message that Access can not construct filter. This error is in...
My form has almost no code. But from the beginning ...
First, what i want to achieve. I try user be able to open server filter in any moment of work with application to restrict number of records obtain from sql server. It's also have to substitute advanced filter present in access mdb file...
Hello,
I have some problem with ServerFilter by form in Access 2000 ADP project.
When i open form with property ServerFilterByForm set to Yes and try to filter data by date field (for example > '2003-01-01') all is correct.
But when i try do it again (even with the same filter) i receive...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.