Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi all! We have been experiencing an issue on site where threads have been missing the latest postings. The platform host Vanilla are working on this issue. A workaround that has been used by some is to navigate back from 1 to 10+ pages to re-sync the thread and this will then show the latest posts. Thanks, Mike.
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MS Access Help - Kilcock/Maynooth area

  • 14-11-2014 12:55pm
    #1
    Storm99
    Registered Users Posts: 81 ✭✭


    Hi, Im looking for someone who's good with MS Access that can sit with me for maybe two hours a week for about 2 to 3 weeks to assist in building an MS Access Database.
    Im self taught and struggling with some sections of a database im trying to build.
    Preferably I'd like someone local that can come to my residence or I can drop to them if in the Kildare area. A Student would be ideal !

    I can pay €20 an hour.

    Thanks !
    Tagged:


Comments

  • #2
    TrueDub
    Moderators, Sports Moderators, Regional Abroad Moderators Posts: 2,655 Mod ✭✭✭✭TrueDub


    Can't help you on the face-to-face bit, but if you throw out specific questions here there are several folks who'll try to assist, me included.

    What bits are you having trouble with, and what have you tried so far?


  • #3
    Storm99
    Registered Users Posts: 81 ✭✭Storm99


    Well, it's kinda hard to explain on paper, the database is pretty big and has to have a lot of complexity. But let me throw out one relatively straight forward issue.

    I was looking to see if I can have some advice on List Boxes, I want to use a list box in a form to select a from a list of products and use the selected list in a query or multiple queries.

    The key issue being I want to be able to select multiple products from the list box and have the query run for all the selected products by using "[FORMS]![FORMNAME]![FORMLIST]" in the parameter of my query

    But I have found that the list box will only let me select one molecule at a time. Even if I change the list box to allow me to select multiple products by holding down CTRL, the queries will still only run one product.


    So My list box will drop down like this....

    Product 1
    Product 2
    Product 3
    Product 4
    Product 5
    Product 6


    But I may want to selct Just product 1 OR I may want to selct Product 3 5 and 6 and have my queri run for the items I selected in the form.

    I am open to changing the method if a Form List box does not suit, but I don't want to have to type the list of products manually into the parameters.

    Hope that makes sense ?>

    Thanks a mill !


  • #4
    Beano
    Closed Accounts Posts: 3,357 ✭✭✭Beano


    Multi selects require a little work
    http://access.mvps.org/access/forms/frm0007.htm


  • #5
    Storm99
    Registered Users Posts: 81 ✭✭Storm99


    Thanks a mill ! I appreciate that, unfortunately that's a bit beyond my ability ! :( Im not sure how to create a control in my query and then Im not sure of all the variables I have to change in the code to select to my forms and fields.

    This is why I wanted to get a person to person session. The consultancy agencies are ridiculous money, so a student looking for some spare cash would be ideal.

    Im on a tight budget ;)


Advertisement