Go Back   Computer Forums > General Computing > Programming
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 11-25-2014, 09:47 PM   #1
Baseband Member
Join Date: Jul 2014
Location: USA
Posts: 26
Default VBA Advice/ Help

I am looking for some advice on how to use VBA, I am completely new to this programming language so not sure exactly how it works, but I understand that most all programming languages do share some common ground. I am using this in Access, and am trying to create a function in the VBA to make a call to record a "New Record," I've got all the forms created in access I am just stuck on how to do this.
When called I want the finished product to display in a dialog box, so that the ultimate user of the database can just type in the values that they want and it saves it to the form. I was able to download a database off the web with an example but haven't really got the code to work for me here is some that code:
//Open form to add new values

DoCmd.OpenForm "frmNewProduct", acNormal, , , acFormAdd, acDialog

//Set Response argument to indicate that data is being added.

Response = acDataErrAdded

Any advice on where I could find information on how to use this language I would really be thankful for.
megan1989 is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 10:21 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2016, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0