I have a table with a List, Date, T

[hongbin81]

I have a table with a List, Date, Time, Duration, and Price Field.

The list fields are composed of names such as
List Duration
D:\Commercials\tiger1.mpg
D:\Commercials\tiger2.mpg
D:\Commercials\tiger3.mpg
D:\Commercials\tiger1.mpg
D:\Commercials\tiger1.mpg
D:\Commercials\tiger1.mpg
D:\Commercials\tiger1.mpg
D:\Commercials\tiger2.mpg
D:\Commercials\tiger2.mpg

and so on.

for example I need to extract tiger1 and enter a Duration like 30.

This would automatically put a Duration of 30 where tiger1's are available.

How should I approach this?

 

[dhookom]

I think you need an update query. Your SQL view would look something like:
UPDATE tblList
SET Duration = 30
WHERE

• Like "*tiger1*";
  
  Duane
  MS Access MVP

 

[hongbin81]

Would this work?
Let TxtResp = InputBox("Enter Listings", TITLE)
Set [tblLogs]![Duration].[Value] = 30 WHERE [tblLogs]!

• like '*" & TxtResp & "*';
  

 

[dhookom]

No.
You could create a query like:
UPDATE tblList
SET Duration = 30
WHERE

• Like "*" & [Enter Listing] & "*";
  When you run the query, the user will be prompted for a listing value.
  
  Duane
  MS Access MVP

 

[hongbin81]

k thanks

 

[hongbin81]

What is the syntax to open query using code?

 

[dhookom]

I would create a form that has a combo box:
cboListing (unique list values)
and a text box:
txtDuration
and a command button:
cmdUpdate

The On Click event of the button:
Dim strSQL as String
strSQL = "UPDATE tblList SET Duration = " & _
Me.txtDuration & " WHERE

• =""" & _
  Me.cboListing & """"
  DoCmd.RunSQL strSQL
  
  
  
  Duane
  MS Access MVP