Search results

Hello, The last couple of days I have been putting together a very large form. Basically it is a seriers of forms and then subforms spread out across different tabs. Anyway, one subform is based on a combo box selection i.e. the combo box is the Master part of the Master/Child relationship. It...

I think for the time being I am going to put the buttons back on. Thanks for the tip Fornation but this field is supposed to be a catch all field so I don't want to do another one. I can see that your method would work though. I'll keep it in mind and may switch in the future. Cheers, Dwight

I like the combo box approach but I have hit a small snag. I set up a table: Note1ID (PK) Autonumber Note (text) Then I used this table as the row source in the lookup. The idea for the field is really that it should have miscellaneous data but at times it would be repetive. Hence the post...

Thanks to both of you. Rich, the article is very good and now resides in my reference pile. Jon_Sg your solution was made to order. Works great! Kind regards, Dwight

Sounds like there couldn't be a better way. I'll check it out. Thanks, Dwight

This is very simple.....but beyond me. I have a control on my transaction entry form called Notes. It allows the user to add a brief description about the transaction. Sometimes the note will be a repetive, canned statment. Other times it will be unique. How would I put a button that would...

My database has a form that allows users to input transaction data. Two dates must be entered: 1) Trade Date and 2) Settle Date. I would like the default value of Settle Date to be Trade Date + 3 but if the Trade Date is a Friday it should be Trade Date + 5. Can a kind soul help me with the...

According to Pat: Text fields occupy the number of bytes specified by their length. So yes, you could save space by limiting the records to 20 from 50.

Very clever. I think I set it up the way I did out of habit but it just didn't feel right. Thanks, as always, for the steering.

Thanks Pat for the characteristically thorough response. Yes, a S&P press release would announce any changes. Actually, there are three levels below Sector (Industry Group, Industry Name, and Sub Industry Name) with successively narrower definitions. Each is more likely than the previous to be...

Here is how I would do it. It is a good idea to keep you users out of your tables. Let them change data in a form instead. I have attached a sample database with two tables. I added an hours type field to the course ID table. The second table has the actual hours for each hour type. This way...

I need some best practice advice. I have a table called SectorID. It uses Standard and Poor’s classifications. They have their own system as follows: Sector Code Sector Name 10 (Primary Key) Energy 15 Materials 20 Industrials 25 Consumer...

That's what I'll do then. Thanks for the advice.

No I don't really understand you post and it gets further away from the topic I am trying to address. But I appreciate the input. I think having a table/query structure is very powerful and flexible. I just wanted to know if I should use a separate PK field within the table. I think I should...

Right, that's pretty much what I am doing. The query contains a forumula based on the maturity date and the current date and is therefor dynamic. It just assigns a value (1, 2, 3) based on the time left as you mentioned. By linking the query to a table I think it makes it more powerful. For...

I have a database that stores information on government bonds. These need to be classified into 3 categories based on time to maturity: 1) Short Term 2) Medium Term and 3) Long Term. Since a bond’s classification can change as its maturity nears I set up a simple IIF based formula that compares...

I would read this paper. There is a sample database that should help you out as well. http://www.fmsinc.com/tpapers/datanorm/

YST, You should use an update query. Set it so that it will multiply the shares and divide the transaction price by the split ratio on less than or equal to the day the split becomes effective for the matching security. In your example: Acct. 1, Buy 500 shares Nextel on July 10, 03 at $5.00...

Thanks for the advice. The consensus seems to be to prevent the problem before it occurs. I can do that.

LauraS20, You need to set up your tables so that each record within the table is unique. Usually you use an autonumber primary key for this. And you need a common field in the table so that you can link it to the other tables. This is where the relationships come in. For example, if you had...