Search results for query: *

Hi, I have a main form that pops up a form depending on what Line you select. The popup form is where the user puts in counts for different part numbers. I setup the following vbcode in the on close event of the popup form: Forms![Main Form]![Pieces Run] = (Part1 + Part2 + Part3) When the...

I have the following control source for a textbox in my report footer: Sum(IIf([Shift]='Aft',[Expr1],0)) It very simply sums up Expr1 for Aft shifts. The problem is a few lines don't run Aft shifts and the text box returns a value of 'Num#'. How do you I write an expression that returns '-' if...

I created a query involving two tables from two different databases. The following are my tables: Database 1 Database 2 Date Line Production Date Line Scrapped_Qty. 8/14 A 1000 8/14 A 100 8/14 B 900...

I have a form that opens up a subform based on a selection on the main form. The fields in the subform are automatically filled in based on a value in the main form. The user can change the values on the subform or just accept the default values. I have a problem, if the user just wants the...

How do I configure my form so that when I click the addrecord button on the main form, the record on both the main form and the subform are added?

I have a query that gives me the following output(Thanks Norris68): Date A B C D 8/10 100 100 100 100 8/11 50 50 50 50 I am trying to use a crosstab query to get the following output: Part 8/10 8/11 A 100 50 B 100...

I need to combine a couple of tables having one or more similar fields. For eg: T1 T2 T3 Date A B C D Date B C Date A C 8/1 10 10 10 10 8/2 20 20 8/1 30 30 8/2 10 10 10 10 8/2 30 30 8/3...

I have a report based on query. I need to sum the total of one column called Pieces. I tried putting a textbox in the report footer with the following expression in the controlsource Dsum("[Pieces]","[Production Query]"). It gives me an error message. I can't figure out what...

I have two tables: T1 T2 Date A B C Date A C D 8/1 10 10 10 8/1 20 20 20 8/2 15 15 15 8/2 10 10 10 8/3 20 20 20 Then I have a query based on these tables with the...

How can I use this table: Date A B C D 7/22 10 20 15 30 7/23 0 19 0 40 To run a crosstab query to get the following: Line 7/22 7/23 A 10 0 B 20 19 C 15 0 D 30 40 Thanks.

I have the following tables: Part1 Part2 Date A B C D E Date A B C D E 7/25 30 30 30 -- -- 7/25 20 10 -- 10 -- 7/26 15 45 -- 05 -- 7/25 -- 15 -- 25 10 7/27 -- 20 30 -- 30 7/25 20 -- -- 10 10 I need to get the following...

I created a form using the wizard based on a table. I recently added a new field name to the table but I am unable to make it appear on the field list so that I can put it on the form. How can I solve this problem?

This maybe a stupid question but I was setting up an automatic mailing system for my report snapshots. But after a couple of trial runs, access started spitting this message out "Report snapshot cannot be created because you don't have enough free disk space for temporary work files&quot...

Is there any way to have a paramter query/filter to show just the records you want on a data access webpage? I tried searching the forum but could not find anything. Hope someone can help me out. Thanks......

I was wondering if it is possible to open access forms from a webpage. I know you can save a report snapshot and then link the snapshot but is there any way I can have a link to the access forms which generate these reports?

I need to save the report as a file which can then be attached to an email. How do I automate the report snapshot feature so that if I click a button on a form it will save a file in a folder. Thanks...

Hi, I have a couple of tables with these fields: Date(Date/Time) Part 1(Number) Part 2(Number) Part 3(Number) etc. I need to setup the report so that it prints out in this format: 7/10 7/11 7/12 7/13 Part 1 4 5 1 4 Part 2 3 2 5...

Hi, I have a report based on a query that asks for a line name to a generate a report. Is there anyway I can have a lookup list in the message box that asks for the line name, instead of physicaly writing the line name.

I have a column chart of pieces per man hour (PPMH) v/s date by week. I have a target PPMH for the time period. I need to do two things: 1) Plot the target PPMH as a straight line on the chart. (Do I create a separate series for this?) 2) All columns below the target PPMH should be in the color...

I have a query that gives me the following table(Thanks Mike Pastore): Date Line Downtime Reason 07/10 A 2 d1 07/10 B 1 d2 07/10 C 3 d3 07/10 C 3 d1 07/10 C...