473,320 Members | 1,691 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Append Query gives "validation rule violations" after text was edited in Combobox

23
Hi
I have a combobox on a form which gets it's Row Source from a table.
I then use an Append Query to save the selected data in the combobox to a file.
Everything works fine.

The Combobox's "Limit to List" property is set to No, thus the user can edit the text in the combobox.

However, the append query gives a "validation rule violations" if you change the text in the combobox.
If you restore the original text in the combobox, the append query runs fine again.

Thanx,
Gerhard
Sep 21 '08 #1
3 2338
NeoPa
32,556 Expert Mod 16PB
I presume the question that you meant to ask is something on the lines of "Why doesn't my APPEND query work?"

If so, then you will need to post the code of your query with any relevant explanations.

Please ensure any SQL is formatted in such a way that it is legible.
Sep 22 '08 #2
Gerhard
23
Thanx

I got it sorted out.
Sep 23 '08 #3
Stewart Ross
2,545 Expert Mod 2GB
Hi Gerhard. We value all questions in the forum, and do our best to help posters in whatever way we can. However, it saves the time and effort of the volunteers who staff the site if you would please not double-post your question. Your current post is much the same as this post, and asking twice does not lead to quicker answers.

Regarding your problem, in neither of the threads have you stated whether or not a validation rule has been defined for the table field concerned, and if so has that rule been violated in some way by changing the data?

Sometimes, error messages accurately reflect what has happened. But you will have checked this, won't you?

-Stewart
Sep 23 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mike | last post by:
Note: My XML experience to date has (unfortunately) been limited to reading and thinking, rather than implementation. Anyway, I am in the process of trying to figure out the most efficient way...
2
by: Laurent R. Therond | last post by:
Hi, I searched for something like this, but could not locate any information. I may have used bad keywords, or it does not make any sense... Anyhow, there it goes... Let's say you overlay...
1
by: Ghee | last post by:
Hello, I have a (java) DOM object that adheres to an XML schema. I want to manipulate it in code, but to ensure that the object still sticks to the schema (ie, validation during the life-cycle...
3
by: Joona I Palaste | last post by:
Consider this C program. #include <stdio.h> int main(void) { printf;("Hello world!\n"); return 0; } When we take into account the "as-if" rule, does this mean that the implementation is...
145
by: Sidney Cadot | last post by:
Hi all, In a discussion with Tak-Shing Chan the question came up whether the as-if rule can cover I/O functions. Basically, he maintains it can, and I think it doesn't. Consider two...
1
by: feng | last post by:
Hi, I know this might not be a question for this group but I would give it a try anyway as I couldn't find a better group for my question. I have noticed that there are a lot of articles out...
3
by: comp.lang.php | last post by:
I have a counter that evokes the "Three Strikes You're Out" rule.. if you make more than N mistakes it auto-resets to avoid flooding $_SESSION with attempt after attempt, etc. However, the...
11
by: gnortenjones | last post by:
I have a linked table (to an oracle db), and I am trying to run a simple update query against it to change some data, but I am getting the following error: "...didn't update 0 fields due to a type...
14
by: | last post by:
Hi, I program in asp.net. I have a date in TextBox in format "dd/MM/yyyy". I would like to validate if the date is realy correct. I used RegularExpressionValidator with...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.