sql - How do I update a table with a form in access using VBA or a Macro? -

-

i doing best build first database, have come against problem cannot find answer to. complete newbie in forum , writing sort of code please gentle.

i trying create new record in table when student's name double clicked inside list box inside form.

list box want take first (studentid) column value = lststudent

combo box want take second (courseid) column value from: cbocourseid

text box want take third (noteid) column value = txtcoursenoteid

the new record being created in desired table , there no incorrect code errors there no values being carried across fields. autonumber being created (attendanceid) other columns blank. here code:

  private sub lststudent_dblclick(cancel integer)      currentdb.execute "insert tblattendance (studentid, courseid, noteid) values ('me.lststudent','me.cbocourseid','me.txtcoursenoteid')"  end sub

the fields populated, isn't issue. formatting correct target fields , can't think of else in way.

the new record being created in desired table , there no incorrect code errors there no values being carried across fields. autonumber being created (attendanceid) other columns blank.

with insert statement, you're supplying text values 3 fields in new row ... 

insert tblattendance (studentid, courseid, noteid) values ('me.lststudent','me.cbocourseid','me.txtcoursenoteid')

however studentid, courseid, , noteid numeric fields, not accept text values. in situation, there nothing db engine can insert. still new row added (with new autonumber value in attendanceid), other fields empty.

if include dbfailonerror option .execute, access notify problem (error #3464, "data type mismatch in criteria expression") , abort insert --- new row not added ...

currentdb.execute "insert tblattendance (studentid, courseid, noteid) values ('me.lststudent','me.cbocourseid','me.txtcoursenoteid')", dbfailonerror

use approach similar @harveyfrench suggested, eliminate single quotes values list ...

dim strinsert string strinsert = "insert tblattendance (studentid, courseid, noteid)" & vbcrlf & _     "values (" & me.lststudent.value & "," & me.cbocourseid.value & "," & _     me.txtcoursenoteid.value & ");" debug.print strinsert ' <- view in immediate window; ctl+g take there currentdb.execute strinsert, dbfailonerror

based on you've told us, suspect work, i'm not sure it's best way reach goal. open dao.recordset , add new row there. or if can use bound form, access automatically take care of storing new row ... without need write code.


Comments

Post a Comment

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

-
Image
i've installed yii2-user module/dektrium yii2-app-basic application command composer require "dektrium/yii2-user:0.9.*@dev" config/console.php return [ . . 'modules' => [ 'gii' => 'yii\gii\module', 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] config/web.php 'components' => [ . . /* 'user' => [ 'identityclass' => 'app\models\user', 'enableautologin' => true, ], */ 'modules' => [ 'user' => [ 'class' => 'dektrium\user\module', ], ], . . ] after that, run command $ php yii migrate/up --migrationpath=@vendor/dektrium/yii2-user/migrations updating database schema . but, when run http://localhost/mylawsuit/yii/web/index.php?r=u
Read more

How to show in django cms breadcrumbs full path? -

-
need advice - how show in breadcrumbs whole path article or page? i've got code: {% ance in ancestors %} <li> {% if not forloop.last %} <a href="{{ ance.get_absolute_url }}">{{ ance.get_menu_title }}</a> {% else %} <span class="active">{{ ance.get_menu_title }}</span> {% endif %} </li> {% endfor %} but shows "home" , current page. how modify show whole path in breadcrumbs? i've found in file menu_tags.py code calls ancestors. @ least there class showbreadcrumbs: class showbreadcrumb(inclusiontag): """ shows breadcrumb node has same url current request - start level: after level should breadcrumb start? 0=home - template: template used render breadcrumb """ name = 'show_breadcrumb' template = 'menu/dummy.html' options = options( argument('start_level', default=0, require
Read more

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -

-
i have app uses rails framework , implements angularjs part of front end. i have pushed heroku , have heroku toolbelt installed, when try migrate db using "heroku run rake db:migrate" receive following error(s): installing core plugins heroku-cli-addons, heroku-apps, heroku-fork, heroku-git, heroku-local, heroku-run, heroku-status... error installing package. try running again gode_debug=info see more output. ! `run` not heroku command. ! perhaps meant `-h`, `2fa`, `auth`, `join`, `open`, `orgs`, `pg`, `ps` or `rake`. ! see `heroku help` list of available commands. i run command "gode_debug=info heroku run rake db:migrate" , receive error: npm err! darwin 14.5.0 npm err! argv "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/bin/node" "/users/christopher_pelnar/.heroku/node-v4.2.1-darwin-x64/lib/node_modules/npm/cli.js" "install" "heroku-cli-addons" "heroku-apps" "heroku-fork
Read more