|
|
Accessing Access database in the VBA form
Hi,
I have a form in which i have a combo box and a comand button.
Now based on the values selected in the combo box, i need to "update" a
field in the access table. The form and the access table are not linked.
Please let me know how can we do this?
|
|
0
|
|
|
|
Reply
|
 Utf
|
10/30/2007 10:26:02 AM |
|
With limited info givven:
Private Sub Cmd1_Click()
CurrentDb.Execute "UPDATE myTable Set Myfield1=' & Me.combo1.Value & "'
WHERE MyField2='" & Me.combo1.Column(1) & "'"
End Sub
Pieter
"Ashish" <Ashish@discussions.microsoft.com> wrote in message
news:16D91D22-FDE3-414D-981A-8B716082F017@microsoft.com...
> Hi,
>
> I have a form in which i have a combo box and a comand button.
> Now based on the values selected in the combo box, i need to "update" a
> field in the access table. The form and the access table are not linked.
>
> Please let me know how can we do this?
|
|
|
0
|
|
|
|
Reply
|
Pieter
|
10/30/2007 10:36:24 AM
|
|
|
1 Replies
362 Views
(page loaded in 0.054 seconds)
Similiar Articles: Can VBA open a form in an already open database? - microsoft ...Visual Basic for Applications (VBA ... mdb file and run VB program from ... Opening another Access Database file with VBA ... ... Opening XFDL form using VBA - microsoft ... Opening XFDL form using VBA - microsoft.public.access ...I have a need to open the form from an Access >database and pass ... Hyperlinked Command Button accessing .xfdl file - microsoft.public ..... file from Access VBA ... Accessing the Data Connection Strings and Command Text (SQL) in VB ...... text (SQL) using VBA. In Access this would be easy to do, creating a database object ... Connection from Excel to Access - microsoft.public.access ... Accessing the Data ... Accessing current record - microsoft.public.accessAccessing current record Follow ... sure how to submit a SQL statement within VBA ... Print Current Record from Access Form to Report | Database ... Can I extract VBA code from *.mdb file and run VB program from ...I have a *.mdb Access database which contains VBA code with a couple of forms. Can I somehow extract all the VBA code into an external file (or multi... Hyperlinked Command Button accessing .xfdl file - microsoft.public ...Hyperlinked Command Button accessing .xfdl file - microsoft.public ... Hyperlink to Access record/Form ... Opening another Access Database file with VBA - microsoft ... opening a form from a VBA module? - microsoft.public.access.forms ...Hi all, I'd like a module to open and load a form in my Access 2003 database... ... If you are opening the form ... Visual Basic For Applications ... 2000 set form size on ... Access: select multiple records in a form, process list in VBA ...Using MS Access: MS ACCESS SELECT RECORDS ON FORM, strsql, column ... Using MS Access /MS ACCESS SELECT RECORDS ON FORM ... VBA - Accessing Access; Select the Table for ... Hide Access Window, Database Window, etc Showing only User Forms ...Hello, I have just written a small app in Access 2003 in VBA. When the application starts it show the access windos, database window, then the Use... Input Form Field Names in VBA - microsoft.public.access.forms ...... VBA buffer name? No. You may be applying the logic of some different program to Access. A Form is just a tool to display and edit data ... Visual Basic for Applications VBA - Accessing Access - About Visual Basic... VBA - Visual Basic for Applications. This segment shows how to use VBA with Access ... VBA - Accessing Access. By Dan ... the database field to the textbox on the form. Access is ... Accessing form variables in VBA: vba, form, access, variables... from VBA (i.e. not using DoCmd), and secondly, how to access form-level... ... MS Access; Accessing form variables in VBA ... input some data, close the form ... VBA - Accessing Access - About Visual BasicVBA - Accessing Access Part 4: The Access Form ... the form. Access is such an easy-to-use database ... vba visual basic for applications; vba programming in access; forms ... Microsoft Access: Accessing Table with VBA Code - database.itags.orgHi, I am currently using the following code in my form: Private Sub Form_Load() Set dbs = CurrentDb Set doc = dbs.Containers("Databases")!UserDefined Microsoft Access: Accessing single record from multiple item form ...database.itags.org: Microsoft Access question: Accessing single record from multiple item form in VBA, created at:Fri, 04 Jan 2008 22:42:00 GMT with 341 bytes, last ... 7/22/2012 4:21:41 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 