ms access - Writing Dynamic SQL Statement -


I am very new to Microsoft Access.

I would like to select a column from a table, the value of a parameter (i.e. the column is x, y and z in my table and I have a chosen color parameter The user is set up using the dropdown.

I can choose one / one column using all the selection commands, however, I instead of my parameter selectedcol I would like to use.

After reading around, In order to use the SET and EXEC commands, entering them into the SQL command enters just errors.

Please give me some advice on how I know about implementing a dynamic-SQL query in Access (properly detailed I think I am writing commands in the wrong place at the moment ...) < / P>

First I created an example table in Access.

here Your table is accessed

After this, I have created an example form to query your value. The dropdown is called 'Selective', select a value from the column dropdown selection and press the "Look Value" button.

Here is your access form

Here's the "lookup value" Click the button Click on the event. A SQL statement is dynamically created with the column you selected. Column [FieldName] is changed to that it can be referenced by 

  private sub btnLookup_Click () retarded rsLookup New ADODB.Recordset as string strSQL as string StrSQL = "Select" & amp; Selector Price & amp; "As [FieldName] from Table1 where id = 1" rsLookup.Open strSQL, CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly then rsLookup.EOF = false then txtValue.SetFocus txtValue.Text = rsLookup! [FieldName] Finally, rsLookup.Close End Sub

When the button is pushed, whatever column will be given the value you selected. For this simple example, I'm always returning data for row 1.


Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more