UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Using Declared Variables For Searching A Record Set., Access 2016    
 
   
Jdk412
post Jul 17 2019, 12:40 PM
Post#1



Posts: 80
Joined: 16-July 18
From: Detroit, MI


Good afternoon,

I have some lines of code i need some assistance with

I am trying to call some data from a recordset using my concatenated variables but I cant refer to my variables in the rsa! statment.

how would I type this up so that my string is placed inside my rsa![***string placed here***]? this looks for a field called tempstart which the table does not have one.

CODE
TempStart = TempVars!ScheduleDep + "HoursStart"
TempEnd = TempVars!ScheduleDep + "HoursEnd"
DayHours = DateDiff("n", rsa![TempStart], rsa![TempEnd]) / 60
Go to the top of the page
 
DanielPineault
post Jul 17 2019, 12:55 PM
Post#2


UtterAccess VIP
Posts: 6,765
Joined: 30-June 11



Try
CODE
DayHours = DateDiff("n", rsa(TempStart), rsa(TempEnd)) / 60

--------------------
Daniel Pineault (2010-2019 Microsoft MVP)
Professional Help: http://www.cardaconsultants.com
Free MS Access Code, Tips, Tricks and Samples: http://www.devhut.net

* Design should never say "Look at me". It should always say "Look at this". -- David Craib
* A user interface is like a joke, if you have to explain it, it's not that good! -- Martin LeBlanc


All code samples, demonstration databases, links,... are provided 'AS IS' and are to be used at your own risk! Take the necessary steps to check, validate ...(you are responsible for your choices and actions)
Go to the top of the page
 
Jdk412
post Jul 17 2019, 01:01 PM
Post#3



Posts: 80
Joined: 16-July 18
From: Detroit, MI


Awesome this worked!! dance.gif

Thank you very much for your speedy response to my problem. uarulez2.gif
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    18th August 2019 - 11:32 PM