473,503 Members | 1,769 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Input box issue

2 New Member
I have an access form that i created, there is a combo box on this page that is dynamic. I places a command button next to this combobox (cboPtype).
When i click this button i want to use the input box to capture the input and add it to the respective table that contains this information. this is the code i have so far, i just cant figure out how to get the captured information to go into the table i want.
The table is named PTYPE and i want to add the input box info into this table.

Private Sub ADDPTYPE_Click()
Dim PTYPE As String
PTYPE = InputBox("Please enter the processor type", "Add Proc Type")

End Sub
Jul 26 '07 #1
1 1338
Rabbit
12,516 Recognized Expert Moderator MVP
I have an access form that i created, there is a combo box on this page that is dynamic. I places a command button next to this combobox (cboPtype).
When i click this button i want to use the input box to capture the input and add it to the respective table that contains this information. this is the code i have so far, i just cant figure out how to get the captured information to go into the table i want.
The table is named PTYPE and i want to add the input box info into this table.

Private Sub ADDPTYPE_Click()
Dim PTYPE As String
PTYPE = InputBox("Please enter the processor type", "Add Proc Type")

End Sub
The next line would be
Expand|Select|Wrap|Line Numbers
  1. DoCmd.RunSQL "INSERT INTO PTYPE (FieldName) VALUES ('" & PTYPE & "')"
  2.  
Jul 26 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
2121
by: Oeln | last post by:
I've got the following issue: in one form (1.php), I get the number of inputs to offer, $input_cnt (it could be from 1-10, for example). In a for loop, I then offer that number of input fields in...
8
1850
by: Oeln | last post by:
If I want to check for input of an integer I've got the following (I get the form input with $input = "$_POST"): if(!ereg("^+$",$_POST)) { echo "Input is incomplete or incorrect."; } If,...
6
22599
by: Trevor Fairchild | last post by:
Hello, all. I am writing a program that parses an html report (generated by another program). I use the Open "C:\...." for Input As myValue method to open the html, and read through it...
2
2760
by: Paul M | last post by:
Hi there, i hope someone can help me out here.. I have a input screen where i want the user to enter text in 2 different languages, english and macedonian. How is it possible to make the...
7
7013
by: F. Michael Miller | last post by:
I have a db with Access front end, sql back, linked tables. I need to be able to change input masks at the table level in code. Any ideas? Thanks!
8
6152
by: Ottar | last post by:
I have a few numeric fields, and when I update i get the error: "Input string was not in a correct format". Next line:" System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer&...
3
5629
by: Ralph | last post by:
Hi I have small function to generate my form controls: function buildInput(sType, vValue, vId, sName, sLabel){ var oInput = null; var oLabel = document.createElement('label'); var oCont =...
14
2382
by: n3o | last post by:
Hello Comp.Lang.C Members, I have an issue with user input that I have been trying to figure out for the longest. For instance, let's say you have something like this: void foo() { int num;...
1
3087
by: printline | last post by:
Hello All I'm quite new to xml vs. PHP, so i hope someone can help with an issue i have been struggeling with. I have an html form, that when submitted, it should create an xml file, and save...
2
3306
by: vijaykumardahiya | last post by:
Hello Sir, I have a simple Issue but It is not resolve by me i.e input parameter are not store in Ms-Access. I store the input parameter through Standard Action <jsp:useBean>. jsp:useBean call a...
0
7076
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...
0
7323
jinu1996
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...
1
6984
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...
0
4670
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...
0
3162
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...
0
3151
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1507
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 ...
1
732
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
377
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.