before change macro if record status="n" (1 Viewer)

murray83

Games Collector

Local time

Today, 07:33

Joined

Mar 31, 2017

Messages

728

• Jun 2, 2017

• #1

morning all have the following attached macro but cant seem to get it to work as i would like

if i don't add in the If then it works fine and after every update it adds the Now() time to endtime filed even when not wanted

help very much appreciated

cheers

 

Attachments

• 
  end time macro.png

  3.6 KB · Views: 101

C

CJ_London

Super Moderator

Staff member

Local time

Today, 07:33

Joined

Feb 19, 2013

Messages

16,605

• Jun 2, 2017

• #2

I don't use macro's so just a guess - remove the double quotes around 'done'

 

murray83

Games Collector

Local time

Today, 07:33

Joined

Mar 31, 2017

Messages

728

• Jun 2, 2017

• #3

tried that and i think i may have broke it as its stuck in a loop and now cant open my database ;(

 

murray83

Games Collector

Local time

Today, 07:33

Joined

Mar 31, 2017

Messages

728

• Jun 2, 2017

• #4

fixed it and looked something like this

Code:Copy to clipboard

If [TableName].[FiledName] = done then
Setfield
name [fieldname]
value now()
end if