Search results for query: *

I have created a select query based on my Table1. The query grabs all records where the field Similar is not blank. (this field has various codes stored in it). What i want to do is match up the various codes (e.g. all the ones are grouped, the two's are grouped, etc.) and then compare...

hi there I am trying to create an Access 2000 application that will send an email to which ever person is selected. But i'm not sure how to do this or where to begin with coding the email part. I am trying to make this as simple to use as possible for some of my users. I created a...

hi, It seems like Access 97 forces a page break between the Detail section and Group Footer section of a report. why is that and is there a way to get rid of it? I wouldn't use the Group Footer section but the Detail section is not long enough for the data that i need in the report. In fact...

Hi i found some code on a website that talks about automatically compacting an Access database. I cannot find any method of replying to them however. So i am asking you if you can tell me where i should put this code. Does it get placed somewhere within my database, or is it external to my...

hi I've looked around a bit for an answer to this but i cannot find it addressed anywhere. I'm just wondering if there is a way to extend Access 97 report detail section to make it longer. What i've had to do is create 2 separate reports because the detail section in one isn't long enough...

hi i have a report where there is a heading and then 8 labels which may be displayed under that heading. (These 8 labels are determined by using check boxes to select from 8 options on the main form.) So far i've gotten my report to only show the label(s) which is/are checked on the main form...

hi there, I have a problem which i think may sound like an easy solve, but then again who knows. Anyway, I have a combo box which lists Products. The user can select one, and then the related information is displayed in the Tab Control subform beneath. The only problem is if the user clicks...

Hi there, I've really appreciated the help that i've gotten from reading and submitting posts to Tek tips. I have a report that i want to produce. A simple looking report. It just displays a list of product where the criteria is true. On one of my forms, i have a list of 8 hard coded...

Hi I have a main form which has a command button that opens a modal 'options' form. I can click on any option i want on the modal form and it works fine. Then i close that form and go back to the modal form. Any option i click after that goes into "hiding" behind the main form...

Hi there, I am wondering if there is any way of justifying text that appears on a text box. On the form, it doesn't really matter how the text looks in the text box, but my superior wants me to produce a professional looking report (where the blocks of text are justified) so that he can give it...

i have a couple of questions which are gonna sound real simple but i've drawn a blank as to how to solve these issues. 1) I have two tables that are related and i want a form to be based on the both of them. What i have done was use a query which has the two tables in it as the source for the...

hi there, i have a custom menubar with multiple commands. There is one though that i only want enabled (or visible if possible) when the user is viewing a report on the screen. i thought of creating a separate menubar for this button (Close Report) but that would look less than...

hi there, i have a report that i want to open, but using the DoCmd method sends it to print. On the form is a combo box which has a list of mandates to choose from. When a mandate is chosen, the rest of the information is displayed in the tab display beneath the combo box. I want to open a...

hi there, again many thanks to those who continously take time to volunteer answers to others techy problems. On the primary form i have a combo box where i can select an investment advisor to be associated with a particular product. The product table stores the Investment Advisor selected in...

hi there I have a Combo box on my form which is used to select which record is displayed in the Tab Control form beneath it. When i get to the last field on the Tab Control form, and then tab back to the top, the record inside of the Tab Control form advances to the next record that is...

hi I have a combo box on the top of my form, on the bottom of my form i have a multiple page tab control. When a value is selected in the combo box, i am wanting the rest of the related record to be displayed in the tab control. (There are about 40 fields of information.) Is there a way that i...

hi there, I have a growing list of shipments. Now they can be sorted in two manners. The form will have 3 drop-down boxes. First, the user may want to use the top drop-down box which sorts them by distributor and then the bottom drop-down box displays all of the shipments that have that...

I am designing a database which has autonumber. This database imports hundreds of thousands of records every 3 months, and exports the previous 3 month's records at the same time and deletes it from the database. The autonumber for the new data starts where the autonumber of the old data left...

ok, i am trying to build a query that i can use for a report. What i am trying to do is to run a query which would give me the top 100 ITEMS in each CATEGORY in the MAIN_TABLE. (the ITEMS have an extra field which gives them a numerical value to be ranked on) (the CATEGORIES do not have a...

I'm wondering if there is a method to set a text box to be equal to 0 (zero) if it contains a null value. The reason being that i want to do some math with the text boxes: textbox 1 + textbox 2 = textbox 3 This calculation won't be performed if there is a null value in either one of the first...