Solved

Findfirst and edit record (string vs Single)

Posted on 2008-06-19
5
1,285 Views
Last Modified: 2013-11-27
Hello
  I am Trying to use findfirst to edit a record where the fields  are text , can't seam to get it to work ,
  but if i change the fields to numbers it works perfect  
  have no idea what i am doing wrong
 
Dim db As DAO.Database
          Dim rs As DAO.Recordset
          Set db = CurrentDb
               Set rs = db.OpenRecordset("parts", dbOpenDynaset)
               With rs
                    .FindFirst "[text]=" & Form.text1
                  If Not .NoMatch Then
                        .Edit
                        .Update
                       End If
                   Else
                     MsgBox "record not found"
                  End If
                End With
       Set rs = Nothing

Open in new window

0
Comment
Question by:darkprowler
  • 2
  • 2
5 Comments
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21819901
Hi darkprowler,

try  .FindFirst "[text]='" & Form.text1 & "'"

Good Luck!

Gary
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 21821200


                   .FindFirst "[text]='" & Me.text1 &"'"
0
 

Author Comment

by:darkprowler
ID: 21828909
hi Guys
sorry but that don't work i get an  error  3077  syntax error (missing operator) in both you cases
it is strange if i use it where the data type of the fields is set to number it works  but not when they are set to text
 
0
 
LVL 46

Expert Comment

by:tbsgadi
ID: 21829264
.FindFirst "[text]='" & Forms.Formname.text1 & "'"
Substitute Formname with the name of the form.
Do you have a field in the table called Text?
If so maybe change the name of the field.
If not replace text with the name of the field
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 250 total points
ID: 21830677
do a compact and repair

do a Debug>compile
clear errors

open your references see if you have MISSSING
if not unchecked one of the reference click OK
open the references and check the one that you unchecked ( refresh the references)
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

778 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