Search results

Hi, In one of my forms (access 2007) I have a button for sending emails to clients with outlook 2007. In the click event of the button I use a macro with the SendObject action. The macro works fine when it is used for first time. However, the next time I try to send an email the whole...

Hi all, I 've been looking for days to find out why when I split my db (access 2007) the commands AddFromOutlook does not function. I keep getting the message "the command or action AddFromOutlook isn't available now". Both front and back ends are placed in trusted folder. Any suggestion for...

Hi all, When we open a password protected access 2007 the small “password required” window pops up. If cancelled is chosen, instead of typing the password, the small window closes however access remains open. Is there a way to force access to close too? Thanks, Pavlos

Hi, The attached sample.mdb file contains a form with two charts, chart A comes from table A and chart B comes from table B. For comparison reasons I would like to have both graphs on one chart, any suggestion how to do it? :confused:

Hi, I would like to ask if there is a way to have the "edit items list" button of a combo box in accde format. Thanks in adnavce, Pavlos

Hi, I use a union query as follows SELECT ALL [A], [B] FROM [Εμβόλια παιδιών] WHERE [B]>"0" UNION ALL SELECT [C], [D] FROM [Εμβόλια παιδιών] WHERE [D]>"0" UNION ALL SELECT [E], [F] FROM [Εμβόλια παιδιών] WHERE [F]>"0"; When the query runs I need to have the numbers of resulted rows (if...

Hi, This forum has been a great help so far! I have a tabbed form with 5 pages. What's the code to use so that when i am viewing ONLY a certain page (for example page 2) to disable a button command on the form? I guess in the On_curent event of the form I have to use a code that looks like...

Hi, I use the following code to implement a multi select list box. I tried to modified it (by using a loop) so that the user cannot select more than 5 items in the list box and probably to take a message the limit of selections is reached. Any help? Private Sub List15_AfterUpdate()...

Hi, In one of my forms I use a column chart with its data table to depict statistical results. However, when I reduce the height of the plot area the height of the data table reduces analogous and vice versa. Is there a way to chnage ONLY the height of the plot area, or ONLY of the data table...

Hi, I have a small pop up form that is bound to a select query. I need to add a check box on the form so that when it is checked the form will pop up every time the db opens.

Hi all, In the attached access file there are two issues that I tried to resolve without success... therefore would like to ask your help. 1) In STUDENTS DETAILS form -> GRADES page I would like the combo box in the subform to keep the teaching unit instead of IDtu. 2) The value of IDtu...

Hi, I try to create a student administration database and need some help… I use two tables, table STUDENTS and table GRADES. Table STUDENTS stores all the usual info (name, address, tel, email, etc). Table GRADES has about 10 fields, the first has the manes of the teaching units (about 10) and...

Hi, what's the way of using DateAdd function to return blank instead of #error when the interval filed is null? I did try the following expression but the results is string instead of date. NewDate: IIf(IsNull(n)," ",DateAdd("m",n,date)) regards, pavlos

Hi, The CUSTOMERS table is the "parent" in the relationship and has an autonumber as its primary key. The DETAILS table is "child" and it’s primary key is defined as number [Long Integer indexed(no duplicates)]. I related both fields with a one-to-one relationship and checked both cascade...

Hi all, I know the title of this thread is not correct but it accurately describes my problem: how can I create a relationship between two tables (A and B) where each line from table A links(relates) with ALL lines of B. I tried different ways using one-to-many relationships without success...

Hi, I use the "contact management database" template from access 2007. When the database opens both forms "Contact list" and "Contact details" are set to open in a non pop up mode. The database is set up to display tabbed documents. When I add a new contact in the "Contact details" form and...