Search results

Thanks to all. Sorry I couldn't respond yesterday as I had to run out of the office. I went with the INTEGER option. It appeared to be the simplest way. However, once again, I certainly appreciate all of your options. Tim

Mark...I have played very little with code. Where exactly do I put the year function within a table? The code I have played with is always within a form or report. Usually a form. So I make the table field a 4 character number and then put: Dim MyDate, MyYear MyDate = #February 12, 1969# '...

I am far better in Excel where year is simply yyyy What is the correct way to set the input mask for yyyy only in access as simply putting yyyy doesn't seem to work.

Thanks for the quick reply. Just to clarify FoFa.... better approach would be to use YEAR([yourdate]) BETWEEN 2001 AND 2003 (for a range) or YEAR([yourdate]) = 2003 for a specific year Would this be put into the table query...?

Year only -How hard can this be!!! I want a field in a table that is a date but that is the year only. I only want this because I want to be able to filter my charts to show one or a span of years for comparison. I have criteria in a query that states between [forms].[charts].[begin] and...

If one of the "coding masters" in this forum could assist me, I would be very appreciative. I have wasted an extrodinary amount of time trying to do something that should be exceedingly simple. I want to chart out some very simple data. Employess have pagers and get called out to work. My...

Thanks I will add that in. HAve to try to cover all the "ifs" before I send this to the director.

:o Silly me.... I figured it out. Sometimes the simplest things stump me when I am stressed. On the on close event of the open form, "filter" i put...... Private Sub Form_Close() DoCmd.OpenForm "standby", acNormal End Sub Just in case someone pulls up the same post someday looking for...

This is probably very simple and I am wasting time on it so I thought I would ask for a quick fix. I have a form "Standby" that minimizes when a buton is pressed to open a second form "Filter." This works great. I want the "standby" form to restore to it's original size when I close the...

Many Thanks Many Thanks Jon K. I certainly appreciate the time you took to give me the answers. I have had more trouble with times and dates than anything else I have done. After reading the threads I understand why. Funny thing is some people were recommending 4 pages of code to get...

Forgot. I emailed the database to myself. Tried it...it worked. I BOW BEFORE YOU Jon K. Seriously though. I should have just asked after 2 hours but I don't want to abuse this forum. I try to do it myself first because that is the way to learn. But wasting a day isn't really...

Will give it a go. I have the database at work....thankfully! I will give it a try on Monday and post my success/failure. If it works...well you'll beat my highest expectation =-)

Hello to all. I have been at this for 6 hours and have read countless entires in this forum. I have come close......but not close enough. I am trying to calculate the difference between two times. I can't use a combination of date and time because if I do, those who use the database won't...

There was two pictures but no explanation that I could see.

I have two records in a table/query. Time1 and time2. I want to calculate the difference between the time2 of the first record and the time1 of the next record. Can this be done on a line in a query? If not can it be done in a form and sent back to a table? Biggest question....if so how...

Thanks....and if anyone is feeling academic ! Thanks to all.....the add new record button is doing the trick. If anyone has the code to do what rich has suggested...or if anyone has a sample DB with such code that I could work from....that would be great. I have to believe that I am not the...

Thanks...that was a work around...BUT But just out of pure curiosity now....can it be done?

I don't want to waste time trying to accomplish the impossible so I will ask the experts (the end users). I have a form based on two linked queries. A main form and a subform. The main form is based on a list of clients with tombstone data and the subform is a list of couses taken. Works...

Thanks again Thanks again...and if you ever want a good laugh...I'll send you the databse and you can view code written by a hobiest with a lotta luck and help......probably good for a laugh or for educational purposes. Gotta love the government :cool:

Got me OK.....you got me. Spelling is trash too. Thank God for the invention of spell checking. Quick question...since I have your ear :) I noticed (too late unfortunately) that when you delete a form's object, that the code is not deleted necessarily. Consequently there is a huge...