Search results

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

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

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

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

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

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

I am having a tough time getting my report format to look like my old Excel results. I would like to have SalesPerson down the first column and JAN FEB etc across the top. Earch SalesPerson row would contain 2 numbers one for new and used cars sold for that particular month. Currently I...

Hello All, I'm not quite sure how to ask this question, but here goes. I am attempting to build a database for a car dealership. They have sales objectives that they want to enter for each month. What I would like to do is build a form and subform to all them to enter: MONTH YEAR combo for...

Maybe it won't be a challenge for you all. Here is what I need to accomplish: I have developed a database to help me with payroll. Currently I use a table for the start date of each pay period (every two weeks starting on a Thursday and ending on a Wednesday). So it is a simple thing to...

I have a query that lists a SalesPersons information for the month. Date of Sale (MONTH YEAR) Date of Goals (MONTH YEAR) we set this at the beginning of the month Date of UPPS (MONTH YEAR) total of customer visits he has done for the month I have a form that allows me to search through my...

Hello All, I am trying to open a report filtered by a date range (that part works fine) and also based on a value from a listbox when the user selects another criteria for the filtered report. That is where the problem is occurring. I have a report named rpt_DutyTime (under properties filter...

Hello All, I am having problems getting the following lines to do what I need exactly. The formatting is kicking my butt basically. Bob helped with these lines but I actually need the result to be last month. For instance it is now Jan. 07 and I need the query to total up the hours flown for...

I have a query that allows the user to see how many hours we've flown, sorted by month for the current year. Problem is that in the query I have to manually put in the criteria "january 2007" or "february 2007" or etc.... What I would like it to be able to do is based on the current year (2007...

I have a database that has one aspect that is highly dependent on certain payroll information. For example: When a pilot begins entering his flight for the day at the bottom of the entry form it tells him the payroll dates are from x to x and you have worked X number of days in this pay...

Hello everyone. I have a strange new problem, for me at least. I have a report that during ON PRINT event it needs to highlight dates based on some criteria. This has been working great for a long time. Now I have decided to add a new column to the mix and use the exact same color criteria...

You guys/girls have been such a huge help for me when it has come to my Access questions so I thought I would try this forum out to see if you all could help me one more time. I have recently put together a new computer and everything is working great except for one thing. RDP will not connect...

Hello All. I searched on here awhile back and downloaded a great little piece of code that would disable the taskbar close, file menu close, and the Access program close X. The thing is the code works great when I call setenabledstate(false) one time on the start of my application. However...

Hello All, I am considering selling the license to use a program I have written but before doing so I want to protect myself just in case any data may be lost when they begin using my program. Many times we have all clicked ACCEPT while installing a program, such as any Microsoft software, and...

Ok I have searched, but haven't found a solution to the minor problem I have, which is just ticking me off at this point. I use the code below to disable the Acces "X" and Exit in the File menu. It also disables Close (Alt+F4) option when someone right clicks the taskbar of my application...