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    
post Jul 17 2019, 12:40 PM

Posts: 84
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.

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

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

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
post Jul 17 2019, 01:01 PM

Posts: 84
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    23rd August 2019 - 03:52 AM