Search results

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

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

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

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

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

Dear Forum, I am quite agile with other ms applications but, a beginner in Access. My question is quite simple and I read a lot of solutions but none of them is working. I have a table "interests" in which I record interests from investors on some deals (I also have a table "deals" and...