Recent content by mahunter

Thank you Mihail, this fixed the problem and eliminated the Name? Error. The other issue I have is that I need the actual dates just written into the expression 11/15/13 and 11/25/13 to reference from the Form they're entered into and also have the form hold/default to the previous entry...

All, I'm having trouble with the Access DateDiff Function. I'm using this function in an unbound text box on a form and I get a Name? error even if I enter actual dates versus other fields on the form. Here's the syntax of the expression: =DateDiff("d",[11/25/13],[11/15/13]) Eventually I...

All, I'm having trouble with the Access DateDiff Function. I'm using this function in an unbound text box on a form and I get a Name? error even if I enter actual dates versus other fields on the form. Here's the syntax of the expression: =DateDiff("d",[11/25/13],[11/15/13]) Eventually...

Thanks for the knowledge sharing and expertise here. Could I instead pull from the last value in the Table column/field that the form is linked to? How would I do that? Really this date (which is the date of a piece of machinery installation that last 3 months or so will only change on...

All, I'm having trouble with a Form and getting a text box entry box (Date entry) default to the date entered on the last record, which is linked to a table. The only way I can get it to work is to type the date into the Text Box's Default property, for example, #11/13/13". Can anyone...

:) This fixed it!!! Thank you so much, Mark

I'm having a lot of trouble trying to get the Dlookup function to work within a database on a Form, looking up information from a Table. What I want to have happen is for Access to pull in (via the DLookup functions) parameters by grade or recipe on a data entry...