Search results

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

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

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

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

Hello People, I am having problems with a WHERE(…OR..AND) that I am trying to implement in a Query. I am trying to write the query so only those records that have been updated in the last 30 days and updated only by John Smith will show up. I’ve tried a lot of combinations but nothing seems to...

Hi, I am having problems with a report I’m working on. In my report I am getting data from 3 tables; “IndustryList”, “CompanyList” and “IndustryPositives”. From the IndustryList I am getting the IndustryName field. This consists of 41 different Industry names such as Healthcare or...

I'm not feeling the love. my post 'last 5 entries' is the only one on this page wothout ANY replies. :(

getting last 5 entries from a table Hi, I have to create a query that will get the 'last 5' transaction entries for 'each' company in a table. The table consists of about 100 companies, each with anywhere from 1 to 10 or so transactions. Any ideas on how to proceed. I tried the Multiple Entry...