Total new to Access, How do I update data in a table using a from?

[nagiese]

Yep, I still get the error. Currently I'm unable to upload any attachements I keep getting the following error. I've sent an email to the administrator to see if I can get access to uploading files.

"Your submission could not be processed because a security token was missing.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error."

[nagiese]

I also think that the file is to big. its 76,640KB, i think you're only aloud to upload 500kb.

[Robeen]

Can you copy the database, take out everything except the part that you need help with & THEN try posting it?
Just leave the Form and the Table[s] needed to run the Form & then save & try & upload?
Did you try zipping the file?

[nagiese]

I've deleted everything but the table, form and module and after I zipped it its still comming up as 559kb.

[Robeen]

1. Is the Table large?
If so, can you strip all but like maybe 25 records?

2. Try zipping the file.

[nagiese]

got the zip to finally upload. Its the bare bones of everything.

[Robeen]

Ok. I'm looking at it now. I'll get back with you.

[Robeen]

Change your db.Execute statement to this:

 
db.Execute ("UPDATE [mtb-STAT3AR1] SET [mtb-STAT3AR1].[YearField] = " & Me.StrYear & " WHERE [mtb-STAT3AR1].[YearField] Is Null")

Let me know if that works!

[nagiese]

that worked, Thanks.

If I want this macro to update the year and period do I just add an addtional line and chang the [yearField] to [Period]? see example below.

Option Compare Database
Private Sub cmdUpdate_Click()

Dim db As Database

Set db = CurrentDb

db.Execute ("UPDATE [mtb-STAT3AR1] SET [mtb-STAT3AR1].[Year] = " & Me.StrYear & " WHERE [mtb-STAT3AR1].[Year] Is Null")

db.Execute ("UPDATE [mtb-STAT3AR1] SET [mtb-STAT3AR1].[Period] = " & Me.StrPeriod & " WHERE [mtb-STAT3AR1].[Period] Is Null")

End Sub

[Robeen]

You can do it that way or -
if both year AND period are always going to be either Null or Not Null -
kill both birds with one stone:

 
db.Execute ("UPDATE [mtb-STAT3AR1] SET [mtb-STAT3AR1].[Year] = " & Me.StrYear & "," & "[mtb-STAT3AR1].[Period] = " & Me.StrPeriod & " WHERE [mtb-STAT3AR1].[Year] Is Null")

** I have not tested the above code.

Is it possible that some records will have a year but no period . . . and vice versa?

If so - you can write a nested If Then Else statement to check which of the two are Null and then accordingly either update the one that is Null - or update both . . .

??

[nagiese]

This worked great. The way the data is imported, both fields will always be null. But I think I've got some other data that may need to utilize the nested if Then Else statement.

[Robeen]

Happy to help!

Mark the thread Solved if you think it has been solved.

Let me know if you need more help.
Post a reply here if you have any other questions.
Or - you can just start a new thread!!

All the best!