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_PowerPoi nt, [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_Fina ncial, [MD TBL02 - GENERAL SKILLS].[Sap
Controlling] = Forms![FORM01 - Input]!Combo_SAP_Cont rolling, [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_N eeds
WHERE (((Forms![FORM01 - Input]!Combo_Excel)<> "") And (([MD TBL02 -
GENERAL SKILLS].EmplID)=Forms![FORM01 - Input]!EmplID_Selecti on));
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
1  1925 
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_PowerPoi nt, [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_Fina ncial, [MD TBL02 - GENERAL SKILLS].[Sap
Controlling] = Forms![FORM01 - Input]!Combo_SAP_Cont rolling, [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_N eeds
WHERE (((Forms![FORM01 - Input]!Combo_Excel)<> "") And (([MD TBL02 -
GENERAL SKILLS].EmplID)=Forms![FORM01 - Input]!EmplID_Selecti on));
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
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 the combobox a little unfeasable as
searching through this many names would be difficult and
time-consuming.
I would like the user to be able to select a group of people from a
first combobox, and then when he goes to the second, only the names of
|
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 combobox.
What is the solution?
Thank you in advance.
|
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 combo by allowing
the user to dynamically type in the new value directly in the combo box
whcih in turn updates the lookup table and then when they have finished
leaves that particular cell on the grid with the correct value.
Seems...
|
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 bound to a table as a lookup,
drawing values from another table to populate the available selections. This
all worked fine in VB6.
I have distilled the problem down to a simple form drawing data from the
Northwind database for a representative...
|
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 trying to do is make an autoscroll combobox. like you have on
html textbox's, but this time you hit enter for a change to be made. i
do this because i dont want to requery every time a single letter is
inputed. it would be too slow. so i make them hit...
| | |
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 a
listbox.selecteditem.
When a different item is selected in the listbox, all the fields are
repopulated with the correct data.
I have 1 combobox which is acting weird.
|
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 list of values from a
table, and as the user selects values, a datagrid displays related
records from another table because it is bound via FK relationship.
My table:
/****** Object: Table . Script Date: 06/19/2006
|
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 of different screens down to a minimum,
I'm trying to use the same Windows Forms for both browsing and for
updating. This works fine for TextBoxes, but I'm running into
problems with my DropDownLists (ComboBoxes).
|
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 object when text is
deleted.
However bound object contains old value in this case.
To reproduce:
1. Run code
|
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.
Bound Column = 1 and LimitToList = No,,, thus the user can edit the data in the 1st-Column after they selected one of the rows in the combobox.
However, I want to save the data of 2nd-Column and 3rd-Column, because if the user edits the 1st-column,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
