Recent content by steve711

Hey spikepl, nothing as of yet. I'm working through your suggestion to see how it works for me. I like to keep my options open as usually there are multiple ways of accomplishing a single task. I'm away from work at the moment, until I get there to work on your idea others my chime in as...

To clear a few things up although some of you have already done so. Yes, NVG = night vision goggles. It is a sliding 60 day window always looking back from today 60 days and counting the number of times you landed with NVG's. To remain current a pilot must have made 6 landings in that 60 day...

Hello Everyone, I need to generate a report that shows the number of NVG landings in the previous 60 days and how many days remaining before they become uncurrent. Each pilot must perform a minimum of 6 NVG landings every 60 days. I have 2 queries for this - 1) totals the landings in the...

Ok, nevermind. I moved the disabling of this control to the first control when it gets the focus. Works cleaner that way it would seem.

On my subform I have a textbox that loads disabled. Based on the results of a combo before it I enable it or leave it disabled. Problem is once it is enabled I input a value in the textbox which happens to be the last control. So when I leave that control, or rather attempt to, I get an error...

You know I really love this forum. Thank you for the help, I always struggle with those statements, too many " and '.

Hello All, I've looked at the DLookup Usage Samples on Access Web but am unable to apply it to my needs. I keep getting wrong number of arguments... I am trying to count the number of days OFF for a particular pilot between two dates (payroll dates). Here is what I've got so far, I think I'm...

Thanks for the help. I'm not very happy about this at all. The whole idea of converting was to protect our very important data, backing up, etc. The Access FE/BE was working great but I was always thinking in the back of my mind, we were one hiccup away from data corruption... Let's see if...

I have an email into IT regarding the "how". I will assume, since all keys were lost, it was done via a wizard. How can I add them back now that they are gone?

Odd ball thing is that on my Access BE all but that one table had a primary key assigned. I now looked at each of the SQL linked tables and none of them have a primary key.

Thanks Bob, On the table giving me the error, no primary key. However, when I went and looked at the BE file when it is was still Access, BEFORE I gave it to IT to convert to SQL I had a primary key assigned. Now, how do I fix this problem? On another table it didn't have a primary key so I...

Hello Everyone, Our IT department just converted my BE to SQL and now when we go to open a form to enter NEW data we get Error 2105, Can't go to specified record. Here is the VB code I'm using to open this form ready for entry. It worked just fine under Access but no luck now after the...

There is always an easier way isn't there... Thanks yes it works. Always go simple first....

Thanks guys for your replies. The first part works great getting the first day of the 1/1 of the current year. It is the last day of the year that is killing me. I will try the suggestions listed. I have the same problem with the option "Last Year" it is the 12/31 XXXX that is getting me.

Hi Guys/Gals, I got this code from somewhere on this forum awhile back but have run into a problem with it. I have a combo that has "Current Month", "Current Quarter", etc. as well as one that says "Current Year". It should display 1/1/08 to 12/31/08. However it is showing 7/31/08 for the...