Hi,
I get the following error "Invalid input parameter values. Check the
status values for detail".
I have a SQL 2005 backend, and an access front end. I have two tables,
MAIN, LOOKUP in my SQL server backend. If I create a view containing
value from table MAIN and enter data into it from a form in access
everything is ok.
However if I make a vew with both tables MAIN and table LOOKUP I get
the error above. Table MAIN contains some data and a foreign key
decoded by table LOOKUP.
Anyhow does anyone know how this can be fixed?
Thanks alot.
P.S. Using access 2003.
5  3493 
On 1 Aug 2006 13:19:45 -0700, "ken" <ge****@gmail.comwrote:
If you're lucky you can set the UniqueTable property of the form.
But first, you need to ALWAYS first test your queries in the SQL
Server environment. Run the view. Can you enter data?
-Tom.
>Hi,
I get the following error "Invalid input parameter values. Check the
status values for detail".
I have a SQL 2005 backend, and an access front end. I have two tables,
MAIN, LOOKUP in my SQL server backend. If I create a view containing
value from table MAIN and enter data into it from a form in access
everything is ok.
However if I make a vew with both tables MAIN and table LOOKUP I get
the error above. Table MAIN contains some data and a foreign key
decoded by table LOOKUP.
Anyhow does anyone know how this can be fixed?
Thanks alot.
P.S. Using access 2003.
When I'm in SQL I can enter data into the view.
However when I"m in access looking into the same view...can't enter
data...I"ll try setting unique table property..see if that works.
Tom van Stiphout wrote:
On 1 Aug 2006 13:19:45 -0700, "ken" <ge****@gmail.comwrote:
If you're lucky you can set the UniqueTable property of the form.
But first, you need to ALWAYS first test your queries in the SQL
Server environment. Run the view. Can you enter data?
-Tom.
Hi,
I get the following error "Invalid input parameter values. Check the
status values for detail".
I have a SQL 2005 backend, and an access front end. I have two tables,
MAIN, LOOKUP in my SQL server backend. If I create a view containing
value from table MAIN and enter data into it from a form in access
everything is ok.
However if I make a vew with both tables MAIN and table LOOKUP I get
the error above. Table MAIN contains some data and a foreign key
decoded by table LOOKUP.
Anyhow does anyone know how this can be fixed?
Thanks alot.
P.S. Using access 2003.
Just tried the unique table property and nothing...I can't enter data
in the form...or the view from access.
ken wrote:
When I'm in SQL I can enter data into the view.
However when I"m in access looking into the same view...can't enter
data...I"ll try setting unique table property..see if that works.
Tom van Stiphout wrote:
On 1 Aug 2006 13:19:45 -0700, "ken" <ge****@gmail.comwrote:
If you're lucky you can set the UniqueTable property of the form.
But first, you need to ALWAYS first test your queries in the SQL
Server environment. Run the view. Can you enter data?
-Tom.
>Hi,
>I get the following error "Invalid input parameter values. Check the
>status values for detail".
>I have a SQL 2005 backend, and an access front end. I have two tables,
>MAIN, LOOKUP in my SQL server backend. If I create a view containing
>value from table MAIN and enter data into it from a form in access
>everything is ok.
>
>However if I make a vew with both tables MAIN and table LOOKUP I get
>the error above. Table MAIN contains some data and a foreign key
>decoded by table LOOKUP.
>
>Anyhow does anyone know how this can be fixed?
>
>Thanks alot.
>
>
>P.S. Using access 2003.
On 2 Aug 2006 05:12:12 -0700, "ken" <ge****@gmail.comwrote:
Make sure all primary key fields are on the form. They can be hidden,
but have to be present.
-Tom.
>Just tried the unique table property and nothing...I can't enter data
in the form...or the view from access.
ken wrote:
>When I'm in SQL I can enter data into the view.
However when I"m in access looking into the same view...can't enter
data...I"ll try setting unique table property..see if that works.
Tom van Stiphout wrote:
On 1 Aug 2006 13:19:45 -0700, "ken" <ge****@gmail.comwrote:
If you're lucky you can set the UniqueTable property of the form.
But first, you need to ALWAYS first test your queries in the SQL
Server environment. Run the view. Can you enter data?
-Tom.
Hi,
I get the following error "Invalid input parameter values. Check the
status values for detail".
I have a SQL 2005 backend, and an access front end. I have two tables,
MAIN, LOOKUP in my SQL server backend. If I create a view containing
value from table MAIN and enter data into it from a form in access
everything is ok.
However if I make a vew with both tables MAIN and table LOOKUP I get
the error above. Table MAIN contains some data and a foreign key
decoded by table LOOKUP.
Anyhow does anyone know how this can be fixed?
Thanks alot.
P.S. Using access 2003.
Question...what does it matter what I have on the form, if the View in
access won't allow me to input data? I put all the keys on the form and
am getting the same result.
Tom van Stiphout wrote:
On 2 Aug 2006 05:12:12 -0700, "ken" <ge****@gmail.comwrote:
Make sure all primary key fields are on the form. They can be hidden,
but have to be present.
-Tom.
Just tried the unique table property and nothing...I can't enter data
in the form...or the view from access.
ken wrote:
When I'm in SQL I can enter data into the view.
However when I"m in access looking into the same view...can't enter
data...I"ll try setting unique table property..see if that works.
Tom van Stiphout wrote:
On 1 Aug 2006 13:19:45 -0700, "ken" <ge****@gmail.comwrote:
If you're lucky you can set the UniqueTable property of the form.
But first, you need to ALWAYS first test your queries in the SQL
Server environment. Run the view. Can you enter data?
-Tom.
>Hi,
>I get the following error "Invalid input parameter values. Check the
>status values for detail".
>I have a SQL 2005 backend, and an access front end. I have two tables,
>MAIN, LOOKUP in my SQL server backend. If I create a view containing
>value from table MAIN and enter data into it from a form in access
>everything is ok.
>
>However if I make a vew with both tables MAIN and table LOOKUP I get
>the error above. Table MAIN contains some data and a foreign key
>decoded by table LOOKUP.
>
>Anyhow does anyone know how this can be fixed?
>
>Thanks alot.
>
>
>P.S. Using access 2003.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jerome |
last post by:
Hi, I'm a bit confused ... when would I rather write an database
application using MS Access and Visual Basic and when (and why) would I
rather write it using Visual Studio .Net?
Is it as easy...
|
by: poohnie08 |
last post by:
I have an excel worksheet which display staff hours spent for certain
projects in a monthly basis (running calendar day 1 to end of the
month including sat and sun). I hope to use ms access and...
|
by: Kenneth Courville |
last post by:
Hello, I'm looking for assistance with the Access object model. I know
this is VB, but I'm building an Office Add-using C# directed at Access
2002. I'm literate in VB, so you can reply in VB... I...
|
by: Stickleback |
last post by:
Morning All
I have been developing and deploying with Office 2000 for about 3 years, mainly Access based
programs and although I have gotten used to it's quirks, I am starting to feel that I...
|
by: rufus |
last post by:
Hi,
On the project I am working on we need to encapsulate all data and business
logic in an activex dll. My question is: How do I do this? How can I
access the form objects ie text boxes,...
|
by: Marc |
last post by:
Here goes...
Outlook 2003 -> Access -> Crystal Reports ...via VB 6.0 code
Basically I have a VB 6.0 project working on my machine.
All with the click of a button , the Vb code extracts rows...
|
by: Neil |
last post by:
We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is
upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server
at the same time. We're moving to SQL Server...
|
by: Cheryl Langdon |
last post by:
Hello everyone,
This is my first attempt at getting help in this manner. Please
forgive me if this is an inappropriate request.
I suddenly find myself in urgent need of instruction on how to...
|
by: Mathieu Trentesaux |
last post by:
Hello
I downloaded Office 2007 for this reason :
It seems, once again, that it is impossible to save any modification
done in a VBA library, from the main project in Access.
The save button...
|
by: SAL |
last post by:
Hi,
I have Microsoft Enterprise Library 2005 installed on my local system. I'm
developing in C# using Visual Studio 2003 IDE with framework 1.1.
I am automating a process that will use a DLL...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
