assign value to field with VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello,

i have written a line of VBA code to calculate the difference (in days)
between two dates. then i want VBA to insert the code in a form in Access.
this is the code i have written:

DAYS_LATE.value = DateDiff("d', RETURN_DATE.value, DUE_DATE.value)

however the VBA compiler has immediately highlighted 'RETURN_DATE' and
prompted me with the following message:

Compile error:
Expected: expression

i have knowledge in Visual Basic (version 2003 onwards) but have never
programmed in VBA before.

using any available method (VBA or non-VBA), how can i calculate the
difference between two days and assign the output to a field in an Access
table?

thanks very much.
 
Try:

Me.DAYS_LATE = DateDiff("d', Me.RETURN_DATE, Me.DUE_DATE)

This assumes DAYS_LATE etc. are text boxes on your form.

Cheers.

BW
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assigning field values to VBA variables and vice-versa 6
Assigning a VBA result in a Report to a field in a Table 5
How to write VBA for MS Access 2003? 1
VBA code to perform calculations 7
VBA Project Deleted 2
Writing VBA Code to control the background color of a form field 2
VBA To Access Multi-Value Lookup Field 2
Use VBA Code to Assign Macro Buttons to use Different Queries for Source in a SubForm 0

Back
Top