Pull info from access to excel userfom and edit an existing record


S

sam

Hi All,

I have created a system which consists of a Userform in excell and database
in Access. Rite now I have the following features in the form:

- Users can insert data into the database through the userform by clicking a
button "Enter"

I want to add two more features:

1. I want users to pull info from the database into userform fields
Eg: if user enters "User ID: " fields like "Name" "Phone" "Fax" should
be pulled from access into respective userform fields.

2. Once the user pulls these data from access, the user should be able to
update their details and on clicking "Enter" button that particular users
data should be updated in access.
Eg: If ueer enters "E111009" in the "User ID:" field the details pulled
from access are" "Name: Tom" ; "Phone: 123 456 7890" ; "Fax: 122 333 4444"

so once user updated his "Fax" to "999 999 9999" and clicks "Enter" I want
the new fax number to update the users record. I dont want to enter a new
enter in access once anything change. I want to identify the same row and
update that particular row if there is any edit made to the record.

Hope I made it clear,

Thanks in Advance
 
Ad

Advertisements

M

Mike

something like this
With rs
.Fields("Name") = Me.Textbox1.value
.Fields("Fax") = Me.Textbox2.value
.Update
End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top