Search results

Hi all, I have another problem on my vacation request forms. Everything is working perfectly except on the the new request form. When I click on the 'add a date' button, the code is supposed to save the record, then copy and paste it, so I should end up with two copies in the database. No...

Hi all, I have a form for entering time off for work. Each day of vacation has its own record in a table because we need to track who's covering that shift, and it could be different each day. The form for entering requests has a button which is supposed to copy that record and create a new...

after a lot of googling and trying to figure this one out on my own, i've come up with nothing. all i need is a combo box that starts with the current month and goes back one year. something like: May 2007 Apr 2007 Mar 2007 Feb 2007 Jan 2007 Dec 2006... i've tried a couple methods with no...

hi all. i need to set the parent form (MainMenu) to maximize on focus of child form field. anyone know the code to do that? thanks, mj

hi all, here's the dealio... i need perform an aggregate funtion off of a certain field, but it contains null values. i tried using Nz and an Iif IS NULL statement to get rid of the nulls. but both methods return the values as text. obviously, i can't get an Avg of these text values...

hi all, i normally just go into design view in my query to change the format type, but some of my subqueries are quite large, so i'm getting 'the expression exceeds the 1,024 character limit for the query design grid. i figured i could just multiply the subquery by 100, but the results are...

Here's a good one for the experts... I have a query that sums downtime on equipment. The problem that I came across is that there can be multiple status items open up on the same piece of equipment. When the restored time on one status item occurs after the down time of another, the query...

Here is how my table is set up: System1 Subsystem1 System1 Subsystem2 System1 Subsystem3 I need a query that puts the data into one record, different cells: System1 Subsystem1 Subsystem2 Subsystem3 Can this be done? Thanks, MJ

Hi all. I have a form with two lists on it; systems and subsystems. When I click on the system listbox, I want it to filter out just the applicable subsystems in the next listbox. The table that they are looking up has the systems as column headers with subsystems listed under each. So...

Hi all. Anyone know where I can find third party no-install exporting software. I need to export to HTML and maintain all my formatting on a report. Thank you, MJ

Hi all. I have a form with two fields that modify one cell in my table. The two fields are date and time, the cell being date/time. The control source is the same for both, and the format is set to short date for the first and short time for the second. They both pull up the records just...

Alrighty... My DB contains the following tables: VacTab - Keeps track of crew members on vacation and people covering their shifts. CrewRost - List of all the crew members and what crew they belong to. CrewSched - The complete schedule of what crew is working which shift (Currently programmed...

Howdy All! I have a subquery which is supposed to filter overtime hours based on name and date by month. The name is working fine, but it's skipping over the date. (SELECT SUM([Hours1])FROM[OTHours1] WHERE [OTHours1].[CoveringName1]=[CertificationRoster].[NameLast] AND [OTHours1].[LeaveDate...