473,320 Members | 1,856 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.

combobox update

Hello, i have a problem with a query that update a table with the combo
value and i have n combo. Ok, but when i don't insert any value in one
combobox and run the query, all the value are insert in the table also
the blank value that i don' t want to be update. The query that i use
is:

UPDATE [MD TBL02 - GENERAL SKILLS] SET [MD TBL02 - GENERAL
SKILLS].[Microsoft Excel] = Forms![FORM01 - Input]!Combo_Excel, [MD
TBL02 - GENERAL SKILLS].[Microsoft Access] = Forms![FORM01 -
Input]!Combo_Access, [MD TBL02 - GENERAL SKILLS].[Microsoft
PowerPoint] = Forms![FORM01 - Input]!Combo_PowerPoint, [MD TBL02 -
GENERAL SKILLS].[Microsoft Project] = Forms![FORM01 -
Input]!Combo_Project, [MD TBL02 - GENERAL SKILLS].[Business English] =
Forms![FORM01 - Input]!Combo_English, [MD TBL02 - GENERAL
SKILLS].[Sap Financial Courses] = Forms![FORM01 -
Input]!Combo_SAP_Financial, [MD TBL02 - GENERAL SKILLS].[Sap
Controlling] = Forms![FORM01 - Input]!Combo_SAP_Controlling, [MD TBL02
- GENERAL SKILLS].[Sap Fi/CO Base] = Forms![FORM01 -
Input]!Combo_SAP_FICO, [MD TBL02 - GENERAL SKILLS].[Sap BW R&A] =
Forms![FORM01 - Input]!Combo_SAP_BW, [MD TBL02 - GENERAL
SKILLS].[Additional Needs] = Forms![FORM01 - Input]!Txt_GenSkill_Needs
WHERE (((Forms![FORM01 - Input]!Combo_Excel)<>"") And (([MD TBL02 -
GENERAL SKILLS].EmplID)=Forms![FORM01 - Input]!EmplID_Selection));

i insert a WHERE but the result is the same.
example: I inset all the value and leave blank the combo_Excel,
i update and the old date insert are replace with the new value and
also the blank value of the combo that i leave blank

Tnx for help

Dec 4 '06 #1
1 1908

Sasa wrote:
Hello, i have a problem with a query that update a table with the combo
value and i have n combo. Ok, but when i don't insert any value in one
combobox and run the query, all the value are insert in the table also
the blank value that i don' t want to be update. The query that i use
is:

UPDATE [MD TBL02 - GENERAL SKILLS] SET [MD TBL02 - GENERAL
SKILLS].[Microsoft Excel] = Forms![FORM01 - Input]!Combo_Excel, [MD
TBL02 - GENERAL SKILLS].[Microsoft Access] = Forms![FORM01 -
Input]!Combo_Access, [MD TBL02 - GENERAL SKILLS].[Microsoft
PowerPoint] = Forms![FORM01 - Input]!Combo_PowerPoint, [MD TBL02 -
GENERAL SKILLS].[Microsoft Project] = Forms![FORM01 -
Input]!Combo_Project, [MD TBL02 - GENERAL SKILLS].[Business English] =
Forms![FORM01 - Input]!Combo_English, [MD TBL02 - GENERAL
SKILLS].[Sap Financial Courses] = Forms![FORM01 -
Input]!Combo_SAP_Financial, [MD TBL02 - GENERAL SKILLS].[Sap
Controlling] = Forms![FORM01 - Input]!Combo_SAP_Controlling, [MD TBL02
- GENERAL SKILLS].[Sap Fi/CO Base] = Forms![FORM01 -
Input]!Combo_SAP_FICO, [MD TBL02 - GENERAL SKILLS].[Sap BW R&A] =
Forms![FORM01 - Input]!Combo_SAP_BW, [MD TBL02 - GENERAL
SKILLS].[Additional Needs] = Forms![FORM01 - Input]!Txt_GenSkill_Needs
WHERE (((Forms![FORM01 - Input]!Combo_Excel)<>"") And (([MD TBL02 -
GENERAL SKILLS].EmplID)=Forms![FORM01 - Input]!EmplID_Selection));

i insert a WHERE but the result is the same.
example: I inset all the value and leave blank the combo_Excel,
i update and the old date insert are replace with the new value and
also the blank value of the combo that i leave blank

Tnx for help
To insert values into a table through a combobox, you need to use the
On Not In List event. Have a look eithert here on in the help for
examples.

Dec 4 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Pete | last post by:
I have a combobox which is used to select records, which is satisfactory at the moment. However, a second user is going to start using this database and there will be 1600 records. This makes...
8
by: Zlatko Matiæ | last post by:
There is a form (single form) and a combobox. I want that current record of the form is adjusted according to selected value in the combobox. Cuurrent record should be the same as the value in the...
5
by: Aaron Ackerman | last post by:
I have a bound combobox the appears on a cell within the column of my bound grid when the user clicks on a cell n(In my vb.net WinForm app). I am trying to allow the adding of an item to that bound...
4
by: jon f kaminsky | last post by:
Hi- I've seen this problem discussed a jillion times but I cannot seem to implement any advice that makes it work. I am porting a large project from VB6 to .NET. The issue is using the combo box...
5
by: Gil | last post by:
Is there a way to tell if a combbox is in dropdown mode. I tried and if statement combobox.dropdown = true but i get an error. dropwndown function doesnt store if its true or false what i am...
1
by: amber | last post by:
I'm having an issue with a combobox that is making no sense to me at all. I have a form with several comboboxes/textboxes. The values in these boxes are based on a datarowview, which is based on...
2
by: shumaker | last post by:
I have a combobox that is very much like the one found in the RSS project here: http://msdn.microsoft.com/vstudio/express/visualCSharp/learning/ My projectNameComboBox basically is filled with a...
0
by: Frnak McKenney | last post by:
Can I use a bound ComboBox for both browsing and editing? I'm working on a small, standalone database application using Visual C#.NET 2003 and an Access data file. In order to keep the number...
1
by: Andrus | last post by:
I need to enter null value from combobox to business object property. My combobox datasource does not contain ValueMember with null value. So I tried to create combobox which stores null to bound...
12
by: Gerhard | last post by:
This is bizarre... Im having problems with the combobox AfterUpdate event: Im running Access 2003. I created an unbound combobox with 3 columns on a form. The Row Source is from a table....
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
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: 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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
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: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
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...
0
isladogs
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 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.