Recent content by shafh

Batman, The [Total Of Amount] field is in the [ParentIssuerListCrosstabQuery] and not the ParentIssuerList table. I tried setting the default to [ParentIssuerListCrosstabQuery ] and typing in [Total Of Amount] as the control source but I still get the #Name? error. p.s. I checked to see...

Hello People! I have an existing form (ParentTemplate) that consists of 14 tabs. Some of the tabs contain subforms. I am trying to add a field in the "Issuer" tab. The Issuer tab does not contain any subforms and is getting data for its existing 6 fields from the ParentIssuerList table. I want...

ok. I'll set the compact on close option on. thanks a lot guys. i had no idea access could be so inefficient.

Hi all, I have a weird problem. Everytime I run a macro (mcrUpdateLists) my database file size increases by about 4 MB. Even after I close the database and clear the clipboard and reopen the larger size is still present. New records are not being added to the database so I'm not sure why the...

Thanks Thanks a lot guys, especially Pat. Setting Default value to "Exception" did the trick. Sam

clarification Thanks Pat, I think I wrote my question wrong. I wanted the Table to show "Exception" in the empty records. You have mentioned how this could be done in a Report and Form. But is there any way to do this in the Tables view (i.e. when you open the table directly).

Hi everyone, I have a table that has a few records in 3 different fields that are empty. Is there any way I can get the table to show "EXCEPTION" in those records rather then leave it blank. Thanks, Sam

this worked!!! >Date()-Forms!frmMyPrompt!txtDaysBack and Forms!frmMyPrompt!cboAnalyst :p

Hi everyone, I have a report that is based on a Query. My query is based on two prompts from the user that appear everytime the query or report are run. These promts are: >Date()-[Number of calender days back you want records for:] and [Please type in FirstName LastName of Analyst:] My first...

Hi Peepz, I am having problems with an IIF statement in the field [Cusip] in my Query. I want to show "19810704" is there is no cusip number in the Bookcredit table. IIf(([BookCredit].[Cusip]) Is Null, ([BookCredit].[Cusip]) = "19810704",([BookCredit].[Cusip])) Thanks, sam

I have a report with labels on the left margin. Details on how to create the report are on the website : http://support.microsoft.com/default.aspx?scid=kb;en-us;210044 However, unlike the example, I want to have my labels to have a 2" width while my controls to be 1" wide. This difference in...

I have a macro that opens and prints out two sets of documents. First it uses OpenReport: [IndustryList]![Industry]=[Forms]![IndustryTemplate]![Industry] to open a one/two page report on an Industry specified by the user. Then it uses PrintOut to print out the one/two page Industry Report. I...

Thanks Thanks a lot Pat and Peter. I really appreciate both your help. I was able to figure it out thanks to your help and advice. Have a great weekend!

is it possible Can one have a SELECT FROM WHERE statement followed by a SELECT FROM WHERE followed by a UNION SELECT FROM WHERE to union the second and third SELECT's but not the first SELECTFROMWHERE statement.

Thanks a lot Pat and Peter. Pat your second suggestion is almost exactly what i want. However it still has one slight problem. What I want to records from within the last 30 days only. Within these records I want records created by John Smith only. When I use your second query then I get all...