Search results

  1. C

    Pull form info with Criteria based on Dropdown

    Hi. Forgive me if this is simple although still learning the ropes. I have a Table "Campaigns" which has 2 type options per campaign which are chosen by a dropdown. 1 - Sales 2 - Care. These I then have then created a query with all the fields. Then i have made a continuous form from the...
  2. C

    Active row in continuous form.

    Works a charm. Thanks for your help :)
  3. C

    Active row in continuous form.

    Hi. Im still pretty new to this and looking for someone to help me with some code. I have a form called "Interface" on that form there are tabs which display different forms. On the Tab "Accounts" i have a continuous form with multiple records. What i am trying to do is. - Have a text...
  4. C

    Data Grid View

    Brill! works fine thanks. I have a few more questions however off topic so will ask in another post.
  5. C

    Data Grid View

    Apologies upon re-reading my post it sounds quite snobbish. What i meant to say is that with this data sheet view i could not format to make it look more stylish. I am trying the continuous form now. Do you know how i would add a filter via a text box at the top?
  6. C

    Data Grid View

    Hi All. Im still really new to all of this. I have a form with tabs. In a tab i am trying to build a searchable table that contains account id, Account Name, Status, Type, Mobile and email address. At the top im trying to get boxes to search and boxes that display the data i have clicked on. I...
  7. C

    DLookup multiple values

    oh ok. I see what you mean. That worked a charm. Thanks for the help. :D
  8. C

    DLookup multiple values

    Thanks for getting to me. Not entirely sure how to use a dcount but i will look into it. Yeah i thought it was strange also. Logic i am trying to use is. Does Username match username in table Y/N Does PIN match whats in the table Y/N (both matching from form to table) Win/Fail...
  9. C

    DLookup multiple values

    Hi I am still quite new to this. Looking for some help with a DLookup. I am trying to build a password reset to my login screen as i am tired of changing passwords. I am currently stuck on how to have a dlookup that checks a pin (me.EnterPin) against what pin is stored in table "Users" as...
  10. C

    How to UPDATE table records from a form.

    Ah was missing the ) at the end. Thanks for your help JHB :D
  11. C

    How to UPDATE table records from a form.

    It returns a sytax error. It may be worth mentioning this is inside a VBA private sub. Would it help if i shared the whole code?
  12. C

    How to UPDATE table records from a form.

    Hi. I am new to access and have joined as i need help. I have multiple IFs statements in my VBA when a button is clicked. They are working fine but i need the end result which would be to: Lookup the Username on the form "Me.EnterExistingUsername" in Table "Users" Then i need it to replace...
  13. C

    Hello

    Hi. Very New to Access VBA. Look forward to sharing with you all.
Back
Top Bottom