Recent content by OutbackInvestments

  1. O

    Linking images to a record

    Cant you set the field picture to OLE data type and do it that way? Then, if you need it automatically, I think this works. Form_On_Current: [Picture]=[Name]&".jpg" I think that might get it to work. Hope it helps
  2. O

    _PLEASE_ Help! Project nearly due in!

    Awesome. I didnt know that you could have double primary keys! I made the change, but I dont think I can put it into my project. I've already done the documentation (95 pages) and I dont want to re-print the whole meeting section. And it actually sounds good if I leave errors in. Thanks for your...
  3. O

    Can't add new item or edit form

    As far as I understand access queries (I dont use them much, I work around them) a query only accesses the data. It doesnt allow a change to be made. Like in a report, you can view the data as it would be printed, but you cant change the data. Same thing with a query (as I understand them)
  4. O

    Using combo box in a two table form

    So from that, it sounds like, when PaperID (im making up the names) is equal to something, display the price? Ok. easy enough. Link the combo box to PaperID. Now, two ways to do this. Easiest way is to create a text box, unlinked. Go to control source. Now, since it is in a subform (as I...
  5. O

    _PLEASE_ Help! Project nearly due in!

    In response to both messages, I do have those things. The meeting does have an ID for itself, and the Members have an ID. MeetingTable has MeetingID MemberTable has MemberID Present Table links MeetingID and MemberID what I want, is to make it so that if MeetingID and MemberID match in two...
  6. O

    _PLEASE_ Help! Project nearly due in!

    Hi, Im making a database for a school project and I have run into a small problem. I have a form for meeting minutes, and attendances to the meeting. The attendance is from PresentTable (many to many parser) that takes a member and makes them attend a meeting. However...
  7. O

    Using combo box in a two table form

    Ok, sounds a bit like my stock table. Let me just write this out as mine, with Stock Listing, and I'll transefer it to yours. So, Stock has Price, Listing, etc. Transactions get the price of the stock to make a purchase. 1 stock is used in many transactions, 1 transaction has many stocks. Many...
  8. O

    Using combo box in a two table form

    Just before I can post anything significant (if at all, im an experienced novice, if that makes any sense) I need to know how the two tables are set out. Could you perhaps, give an example of what you are trying to do, and what the two tables are, so I can understand the problem better? Also...
  9. O

    Time Tracking

    I dont know EXACTLY what you are getting at, but it sounded to me like you could use some "OnClick" coding to do what you want. I can only give you Pseudocode though, Im still working on figuring out VB-App myself. (Visual Basic for Applications (Access Basic)) Something like this? Private Sub...
  10. O

    One more ? on web work

    Not really a reply, just a notification of sorts. If you do get this to work, can you please send me the details? I have to make a database project for school, and the company that I selected would like to have their 10 members enter data from home computers on the company web page. my email is...
  11. O

    Radio Button Selection->One or The other

    Hi again. I have 2 radio buttons, BrokerFeeFlatRate and BrokerFeePercent which selects if the broker fee is a flat rate or a percentage of the total. I want to make it so that if one button is selected, the other is not. So if I click BrokerFeeFlatRate, BrokerFeePercent will be cleared, and if...
  12. O

    New Record at top of list

    Did you try using a sort decending command on the form you are sorting in? Alternatively, if you want the new record to be the default screen, just create a macro as follows. OnLoad=macroname in the macro RunCommand"RecordGoToNew" which will make it so that the new record screen is loaded...
  13. O

    Dlookup or otherwise, grabbing data

    Hi again. I am currently trying to grab information from a foriegn table and have it displayed as the default value (I dont want to have then related so that if I change 1, it does the other) and I am attempting to use the Dlookup command. The value I want to look up is StockPrice from the...
  14. O

    Automatic movie playing, embedding and linking.

    Hi again. I have a second question. I have a movie that contains the company logo that I wish loaded on startup. I have it as an avi file, in a directory. What I want is this, On start-up, the database looks in the root folder (where it is located) for the movie, then automatically plays it...
  15. O

    Calculating age automatically from Date Of Birth

    Hi. I know this is probably a simple question, and it probably has a simple answer, but I have to ask anyway. How do you make it so that you enter in a Birthdate, (dd,mm,yyyy) and have it calculate an age from that with Date$(). I have got a quasi-result with DateDiff, but It doesnt take into...
See more
Back
Top Bottom