Module for Access VBA read image from table

Asked By rosellas phillips 10 points N/A Posted on - 12/16/2012

Will Access VBA read image from table, if so please sent me the module that will read a value directly from an Access  table using VBA code?

• Status: Open
• Question Views: 1456
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Access

Best Answer by Schneider Matthew

Go To Solution

Best Answer

Best Answer

Answered By Schneider Matthew 0 points N/A #165263

Module for Access VBA read image from table

Hi Rosellas Phillips,

Please find the below code snippet that may help your problem. This reads table as a record set.

Sub Readdb()

   Dim d As Database

   Dim r As Recordset

   Dim Price As Field, Qty As Field, UnitCost As Field

   Set d = CurrentDB()

   Set r = d.OpenRecordset("TableName")

   Set Price = r.Fields("Price")

   Set Qty = r.Fields("Qty")

   Set UnitCost = r.Fields("UnitCost")

   While Not r.EOF

      r.Edit

      Price = Qty * UnitCost

      r.Update

      r.MoveNext

   Wend

   r.Close

End Sub

Hope it helps

About Schneider Matthew

Questions
3

Answers
107

Best Answers
23

• Vote Up 0 Vote Down

• Posted on - 01/21/2013
• Question Category: MS Access

Answered By Maxwell Mark 0 points N/A #165264

Module for Access VBA read image from table

Hi,

Here's the code that you will need!

You will open a record, set object, find the record, and edit the field:

Code Snippet

Dim db As DAO.Database

Dim rst As DAO.Recordset

Dim strSQL As String

Set db=CurrentDB()

strSQL=""SELECT YourNumericField FROM YourTable WHERE … YourCondition=…. ""

set rst=db.OpenRecordset(strSQL, dbOpenDynaset)

With rst

   If .RecorCount>0 Then

      .MoveFirst

      .Edit

      !YourNumericField = Your value

      .Update

   End If

End With

Regards

About Maxwell Mark

Questions
5

Answers
101

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 01/26/2013
• Question Category: MS Access