Search results for query: *

Yeah that's what i'm trying to do now, either ignore the null values or something. This is another great idea, i'll give that a try. Thanks so much!!!

Got it, thanks again. YOU ROCK!!!!

Hi SkipVought, Thanks so much!!! Would null values also do this? That would make sense, they are very inconsistent in entering data altogether... Thanks again! LE

Hi everyone, I have an access database that is set up like a giant spreadsheet. I'm tasked with trying to turn it into a relational database but am having trouble with the field that holds a plan approval date. I've extracted the data from the database to an excel spreadsheet, and it comes...

Hi MajP, The Class Module is indeed "TaggedValues", and when comparing it to the older version, it's in there but for some reason it still runs in spite of the debug error (weird). I"m going to see if I can pursue either downgrading the user's Access back to 2007 in the meantime and I'll...

Thanks very much :D You're absolutely right, if it has an "s" on the end, it will be considered different. I'll take a very careful look at it on Monday and will also compare it with the working 2007 version to see if there are any differences or if 2010 just tossed something out. I really...

Thanks so much! I'll have to check to see what i copied over. It was a module named TaggedValues but I'd have to double check that it was a class module. I'll try to vpn in to work in the morning and pick it up to post. Thanks again for looking at this for me, I really appreciate it.

Thanks to everyone who has replied!!!! I am working from the original adp file as i always make backups and when things have no effect, i would rather note that and work again with the original file (esp. with something like VB that i know little about). 1. Everything is in its original...

All I was able to find was this, does that help any? I checked in the functions and there is no mention there of TaggedValue Public Property Get Text() As String Dim tv As TaggedValue Dim strOut As String ' Loop through each item in the collection. ' For any that have...

Thanks MajP i will try that right away! I'll check out any db references as it's made to be the sql front end and to run crystal reports through access. Thanks again, i will report back soon! LE

Hi! I have been given a project to update an old Access 2000 adp created by a vendor to Access 2010. It gives the end users various VB errors. When i try to debug it, i get the User defined type not defined error on the following code: Public Function Add(tag As String, _ Value As String)...

I failed to include the most intersting part: NumberVar TotalSec := Sum ({880_csv.Pay Hours}, {@Name}); NumberVar Hours := Truncate (TotalSec/ 3600) ; NumberVar Minutes := Truncate (Remainder ( TotalSec , 3600) / 60) ; Totext ( Hours , '00' ) + ':' + Totext ( Minutes , '00' )

For anyone who might be interested, I was able to then convert the sum by group by creating the following formula in addition to the original one: NumberVar Hours := Truncate (TotalSec/ 3600) ; NumberVar Minutes := Truncate (Remainder ( TotalSec , 3600) / 60) ; Totext ( Hours , '00'...

So far this is working but i also need to sum them up, and converting it to text won't allow me to provide a sum of hours: WhilePrintingRecords; NumberVar TotalSec := {880_csv.Pay Hours}; NumberVar Hours := Truncate (TotalSec/ 3600) ; NumberVar Minutes := Truncate (Remainder ( TotalSec...

Hi! I have a database that stores payroll information in seconds. Our payroll person would like the crystal report to show hours and minutes for each employee. The SQL query we're using produces: Badge Name Type Time (in seconds) 66666 Mephistopheles HOL 28800 66666 Mephistopheles REG...

lbass you are a genius! thanks sooooooo much, this is going to save me so much work! i can't thank you enough!!! LE

Hi! I'm actually working on a CR for my google export, and the lat/long for our bus stops in one of my programs (TransitMaster) is being displayed without a decimal point. Right now I am manually putting it in using excel and word, but they change the values and it's very cumbersome. I'd...

I have a query that is producing a report of Full Time employees and i still need to group them by those having over 80 hours and under 80 hours (which is the rollup total), and the rollup seems to be positioned at the beginning of each employee's records, I'd like it to be at the end. If you...

wow that worked great, thanks! my hours seem a bit weird but i can figure that part out!!!

Thanks! I'm giving it a try right now :D