Posted on 1999-11-23
Medium Priority
Last Modified: 2010-04-27
I am trying to populate an access database from combo boxes/textboxes in VB. I do not get an error, but the field"model" is still left blank.

Any input would be appreciated.

Private Sub cmdAdd_Click()
If vbclicked = True Then

rst.Fields("Model") = Trim(txtTest.Text)
End If

End Sub
Question by:jimmyloco

Author Comment

ID: 2228582
Edited text of question.

Expert Comment

ID: 2228700
Did you leave out the opening of the database?

Accepted Solution

mkolanu earned 140 total points
ID: 2230239
If you are only updating the single field of a table and there is a record existing then use rst.edit instead of rst.addnew.or try the following statments

dim rst as recordset;
 dim db as database
set rst = db.openrecordset("Select Model from tablename", dbopendynaset)

rst.fields(0) =trim(texttest.tect)


Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
A clone is a duplicate copy. Sheep have been cloned and maybe someday even people will be cloned, but disk cloning (performed by the hard drive cloning software) is a vital tool used to manage and protect data. Let’s look at what hard drive cloning …
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question