Recent content by rdg0351

Bingo.... Thank you to everyone that assisted in this data-messy situation. I appreciate all that assisted. Perhaps when there is more $$ in the budget, I could clean up this app Once again, thanks to all

Getting closer....I like your string of functions; however, you would think that it would return "0000" for a null date, BUT, it's returning, what looks like a blank value. If I perform IsDate(MyDateFld), it returns "0" for a null value and "-1" for a valid value. Sooooo, when I compare the...

I have this query with various dates per record, i.e. status tracking. Each record has values for at least the first date, but not necessarily any more dates. I've tried to create a Public Function which will return the string value of month & date: 1/15/2015 "0115" 2/1/2014...

Plog, while I appreciate your insight, I didn't have the luxury to break the master file down via normalization. I'll take this under advisement

Sorry, I should have mentioned that the event is a [Tax Year] for a client. Perhaps that offers further insight

Yes, the 3 fields represent status dates for an event. For example, an accountant wants to track the progress of tax preparation during the tax season, by comparing this year to prior years.

Thanks in advance for any help. I would like to create a query where I provide an As Of date to be compared to a number of fields from a table, and create an entry if ANY of the date/time fields match the month/day criteria. For example: 1 3/31/2012 4/05/2012 4/15/2012 2 3/31/2013...

Thanks to everyone who responded. It appears that the problem is related to the "default" DAO access method. By adding "dbOpenDynaset " to the FindFirst command, the code executes as expected. Thank you

I left some code out to protect the innocent. The variable glbOperator is the value entered from a login form. It's then supposed to validate the userid against a table, i.e. Operators. So, when it does a .findfirst, I get the error. I believe it has something to do with the libraries used, but...

I recently "dusted off" an older application, Access 2010 running under XP. I went to make some changes in a Win 10 Pro environment, and discovered that just about all the RecordSet operations failed. In particular, I have a simple screen that generates the following error code: "Operation is...

I appreciate your deep concern with regard to my methods and actions; however, the issue remains that I am receiving undefined reference errors that I cannot resolve. Any clues as to the library I am missing?

I'm using Access 2010, and after reverse splitting a database, I'm getting reference errors on a number of methods and functions that were working prior to the reverse split. One such example is .FindFirst " .....". I've checked the references in VB, and everything appears correct. One of my...

A1 & A2 are 2 separate records, but only count as a single vote. Therefore, the A's count as 1, the B's count as 1 and the C's are 0. I get confused over this as well

I have a report that has Detail, Lvl1, LVl2 and Grand totals. The Detail field is "Vote=Y/N". I'm trying to create a field which is a total of a subtotal and NOT the total of the detail. For example, Detail A1 - Y A2 - Y B1 - Y C1 - N I want a result based on counts of "Y" vs "N" unique to...

VBAInet, Thanks for everything. The use of WITH certainly got me over my hurdle. Can you recommend any reference material that discusses logic flow and data referencing techniques between forms? Certainly the "scope" and "focus" of the variables are what is giving me fits.