Search results

Hi, The database has 3 important tables (the rest are just reference tables): - A table that contains names of issuers (companies) - A table that contains bonds issued by those companies (or not if they are listed as potential issuers but have not issued anything) - A table for funds that...

Hello, It's purely because I don't want to have 6 buttons to load 6 different forms to add 6 types of items. I'dd rather have one AddItem form (blank) with 6 subforms on each of the 6 tabs. I've been blocked for quite a while on this now and I cannot move on because I don't know how to refer...

Hi, Thx for the answer. I must admit I'm a bit confused now. I do have a main form, but that form only contains a tab control (with 6 tabs) and on each of those tab I have a subform (6 subform). The main form is just a blank page that contains the tab. Maybe I'm wrong altogether with that form? N

Hi forum, I have a main form with several tabs. Each of those tab has one subform linked to its related table. I would like to be able to enter a new item in one of the table via the subform and I used the following code: Private Sub Form_Load() DoCmd.GoToRecord acDataForm...

Hi, thanks a lot for this answer. This is exactly it a many-to-many relationship. I have never used it although i know it's quite basic and fundamental. So from what you say, i should have a "Syndicate" Junction Table that sits between tbl_DEALS and tbl_BANKS which contains 2 keys (Deal_ID and...

Hi, I started creating tables for a new financial Database. To simplify, I have a table "tbl_DEALS" that lists and describes a given security's characteristics (say, if it's a bond for instance, we would have [name of the borrower], [issue date], [type], [amount], [currency] and so on). I also...

Hi, Quick/easy question: what is the best type to choose, to create a field in a table (that will feed into a form) that could be "Buy" or "Sell". I would like it to be "buy" by default, because 99% of the time it will be "Buy". I want then in my form to have a combo box to change from buy...

Yes it is, that's why I'm totally lost :-) !

Hi, I have a textbox in a report that is based on the result of a query. I have a "comment" field (type memo) which contains a lot a text (say 10 - 20 sentences). When I run the query, the entire comment is displayed, but when I want to print the report, all the comments are "trimmed" (i.e...

Thanks ! It works now

Hi Forum, I have a select query, a form with a combo box (based on the select query) and a report (also based on the same query). When I select the name of an investor in my form through the cbo, the latest securities bought by this investors are displayed. I would like ot be able to print the...

Many thx, I'll try the second one which corresponds to my case and mark as "solved" when I'm done.

Hi, I have 2 small problems with my report. I have a list of Clients (header) and a list of factories. Each client can visit several factories, several times. The report template is as follows: Client 1 usine X - visit on 10/09/2010 - visit on 07/08/2010 - visit on le 08/05/2009 usine Z...

Hi, Yes that's what I did first, but the user can access the former items in the table. And I want him/her just to add data, not review them...

Hi Forum, I'm sure you will think that I could find the answer to my pb in FAQs. I might be stupid but I can't (btw, if you have an interesting link I'd love to read it). Well, I just need to create a form that will allow my user to capture data that will come to update my table...

I'm so carelessss! Indeed I mispelled sth (and I doublechecked it though!). Now I have another issue, When I click on the cbo_ContactRecord, (remember I have 4 columns, Contact_ID, Company (a reference nb), Firstname and Surname). How could I have Just the Firstname and Surname to appear in...

Sorry the error message is tblCONTACTS.Contact_ID

Hi I have a combo box from which I want to choose a list of options, which then will cause my second combo box to offer a list of options which are dependant on the first combo box. It's not unsual I know but I don't understand why it doesn't work. I have 2 tables (contacts and investors) and...

Hi, Yes indeed it works but only if there exist an occurrence with the delested investor and selected deal. It would be more "beautiful" to have my 2 combo boxes lists updated depending on what is selected in the other. For instance if there are 3 interests for deal A, one with investor B...

Thx a lot, Would you have any idea to filter both by "deal", and on another field ("investors") i.e. with 2 comboboxes? Cheers