Search results

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...

Have I told you guys that you ROCK. Well you do. As always thanks for sharing your knowledge to us fledgelings...

To clarify a bit.... I have an admin form with several options on it.... Update/New Pilot = Update an existing pilot's information or create a new pilot record (name, address, phone #, etc.) Update/New MedCrew = Same as above but with special identifiers not applicable to a pilot When those...

I have a form with several buttons on it that operate very similar to each other. For instance Update/New Pilot Update/New MedCrew etc. Each would open a form asking NEW or SEARCH. But instead of having a NEW or SEARCh form for each of these I want one universal one that points the code in...

I have a cross tab query, which I got help under the REPORTS forum, but I need to better break out some data. My column headers are Salesperson then JAN FEB MAR et.c It is displaying number of cars sold per month per salesperson. but what I really need to see is number of USED and NEW per...

Figured it out. I added to the crosstab query Total New: Count(IIf([vehNewUsed]="New",0)) Total Used:Count(IIf([vehNewUsed]="Used",0)) Thanks for the nudge in the right direction. The only problem with my expression is that it only creates an overall total of NEW and USED and not total per...