forms - How to use VBA to add new record in MS Access? -

-

i'm using bound forms user update information on new or existing customers. right i'm using add new record macro on submit button (because i'm not sure how add or save new record through vba). added before update event (using vba) have user confirm want save changes before exiting form. reason overriding add record button , users cannot add new record until exiting forms.

how can use vba add new customer information correct table? should done macros instead?

form beforeupdate code:

private sub form_beforeupdate(cancel integer)  dim strmsg string  strmsg = "data has been changed."  strmsg = strmsg & " save record?"  if msgbox(strmsg, vbyesno, "") = vbno      docmd.runcommand accmdundo  else  end if  end sub

add record button:

private sub btnaddrecord_click()  dim tblcustomers dao.recordset   set tblcustomers = currentdb.openrecordset("select * [tblcustomers]")  tblcustomers.addnew  tblcustomers![customer_id] = me.txtcustomerid.value  tblcustomers![customername] = me.txtcustomername.value  tblcustomers![customeraddressline1] = me.txtcustomeraddressline1.value  tblcustomers![city] = me.txtcity.value  tblcustomers![zip] = me.txtzip.value  tblcustomers.update  tblcustomers.close  set tblcustomers = nothing  docmd.close  end sub

in order submit record using vba, create on click event button, , in sub run following command:

private sub submitbutton_click()  'all code validate user input. prompt user make sure want submit form, etc.  docmd.runsql "insert tblcustomers (txtcustomerid.value, txtcustomername.value, txtcustomeraddressline1.value, txtcity.value, txtzip.value)"  end sub

in sub, can add code want validate values user entered , choose whether or not want submit record. there's lot of control using vba submit forms, not need beforeupdate event.

also, not use bound forms method. don't know repercussions wouldn't try it. access great starting off, want more complex things, easier use vba.


Comments

Post a Comment

Popular posts from this blog

mysql - Dreamhost PyCharm Django Python 3 Launching a Site -

-
i'm new python/django , created simple django website using pycharm. site works fine running on computer, i'm lost when comes taking site onto host (dreamhost). i'm able upload files correct directories fine, , believe made correct changes database on mysql. i'm not sure go there though. right now, page shows files rather site. direction appreciated. much! you should not run django application using python manage.py runserver on production. how run application on django depends on server (apache, nginx) want use for apache - https://docs.djangoproject.com/en/1.10/howto/deployment/wsgi/modwsgi/ for nginx - https://www.digitalocean.com/community/tutorials/how-to-serve-django-applications-with-uwsgi-and-nginx-on-ubuntu-14-04 the mysql database should, of course, exist , have correct credentials. or, if choose use sqlite, file should accessible, readable , writable www-user (may different depending on linux distributive)
Read more

java - Sending SMS with SMSLib and Web Services -

-
i have made rest web service send smss using hsdpa usb modem. using smslib in java send smss. every time web service invoked, create gateway start service, send message, stop service , remove gateway. takes 20 seconds each message. found starting service takes lot of time. part of code use send smss service.getinstance().addgateway(gateway); service.getinstance().startservice(); outboundmessage msg = new outboundmessage(phonenumber, message); if (service.getinstance().sendmessage(msg)) { result = "message sent successfully!!"; } else { result = "could not send message."; } service.getinstance().stopservice(); service.getinstance().removegateway(gateway);//remove gateway is there way can start service once if not started , use send message when ever web service invoked? why dont group messages , send in 1 go? service.getinstance().sendmessages(messa...
Read more

java - How to resolve The method toString() in the type Object is not applicable for the arguments (InputStream) -

-
i'm trying read json file local machine. @path("/") public class jsonparsing { file f = new file("file.json"); if (f.exists()){ inputstream = new fileinputstream("file.json"); string jsontxt = ioutils.tostring(is); system.out.println(jsontxt); jsonobject json = new jsonobject(jsontxt); string = json.getstring("1000"); system.out.println(a); } } but i'm getting error in tostring() method. possible read .txt file containing json object local machine? if possible, how done? firstly: whenever ask question- add imports well. secondly: yes possible read .txt file containing json object. steps: 1. add maven dependency in pom.xml - <dependency> <groupid>com.googlecode.json-simple</groupid> <artifactid>json-simple</artifactid> <version>1.1.1</version> </dependency> or add jar of dependency. 2.import...
Read more