Search:

Type: Posts; User: squeakums; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: Need help with a Match / Vlookup type formula

    Nevermind, I feel silly, I figured it out:

    =IFERROR(VLOOKUP([@ReqEval],'vlookup sheet'!A:A,1,TRUE), "")
  2. Re: Need help with a Match / Vlookup type formula

    That formula doesn't work for me. I need to look in an array column A on one sheet, and column A in another, if it matches (it won't match exactly) only partially, then pull from Archer Search...
  3. Need help with a Match / Vlookup type formula

    I have this data, it has too much details in one column. I'm trying to write a formula that will find only certain contents based on cell A on another tab. If it matches whats in one of those cells,...
  4. How to Link your Access DB to Sharepoint?

    I have never attempted this before. But, is there a way to place your Access DB on SharePoint, but have it linked to where it saved in the folder its linked to? Also, multiple users should be able to...
  5. Re: Access Macro to Show All in Query in Form

    It's only about 20 names. The combo box is used as a quick search field with the query table. It works when the Master Link and Child Link are setup with Name; and it doesn't work when nothing is...
  6. Re: Access Macro to Show All in Query in Form

    I have a sub query in a form. Due to the secure information I am unfortunately unable to share a screen shot of this data. The query only shows for example the names I have setup for the Link Master...
  7. Re: Access Macro to Show All in Query in Form

    I apologize, but that was not helpful at all. I actually, have my record source bound to the name column and if it isn't the query won't function at all with the combo box?
  8. Access Macro to Show All in Query in Form

    Currently, my form has a combo box, and it is only showing that in which is selected in the combo box. How can I have it show all items item an item is selected in the combo box? Macro? If so, how...
  9. Setup a List Box to Work with a Subform in Access

    How would you setup a list box to filter in your subform using two different items in the list box?
  10. Walkthrough on How to Create a Combo Box with a subform query

    Does anyone have a walkthrough on how to create a combo box with a subform query that is placed into a form please? Trying to get the combo box to search two different fields in the form but it isn't...
  11. get rid of an error occurred trying to save import/export specification ''

    How do I determine what is causing this error when I try to import into a brand new access db? It also occurs in other access db's as well. The file name is short and all together and the file size...
  12. Re: Annoying Error When Trying to Reload Excel Database

    Thank you for replying. I'm a pro at excel, but when it comes to Access, it really does hate me. I haven't used it on over 5 years. But, now I'm in the process of create an ad hoc form with a combo...
  13. Replies
    4
    Views
    559

    Re: Access Annoyance: ComboBox Ordeal

    Unfortunately, there are no Access DB sources in my area, otherwise, I would definitely reach out. This is the only source besides Google that I have. The combo box is linked to a table I loaded, in...
  14. Replies
    0
    Views
    370

    Help with (2) Forms linking

    I created a search form with a query in it. I want to be able to use the combo box (which I'm trying to fix currently) and then it will pull up search items. I need your help on trying to figure out...
  15. Replies
    4
    Views
    559

    Access Annoyance: ComboBox Ordeal

    Okay, I create a combo box in my form, to work with a query below. It is supposed to search for two columns in the query. It works at first. Then, I change the combo box to sort ascending and then it...
  16. Annoying Error When Trying to Reload Excel Database

    Cannot Define field more than once

    and

    The specification failed to execute. Try re-creating the specification

    I am simply trying to reload an excel file with the updated one, I've done it...
  17. Re: Show (2) Form Tabs Open when Access is Opened

    I figured, it out, when I open, it opens to the 2nd tab, how can write it in to open to the 1st tab?
  18. Show (2) Form Tabs Open when Access is Opened

    I have the access settings to show one form through options when Access is opened, but is there a way to show (2) form tabs when access is opened?
  19. Replies
    5
    Views
    656

    Re: Bound Column Change Not Working

    Actually, I figured this out on my own. Apparently, I did not have the correct MACRO written for the right field, I fixed it to link with the ID field instead of the name field and then changed the...
  20. Replies
    5
    Views
    656

    Re: Bound Column Change Not Working

    Thank you all for replying. I apologize that I did not provide much data. I wasn't sure what to provide. I'm building a Form, adding in a Combo Box - I'm pulling 3 fields in the Combo Box. Although,...
  21. Replies
    5
    Views
    656

    Bound Column Change Not Working

    I am using Bound Column 1 - which works fine, but if I want the Combo Box to use Column 3 to filter the form, it doesn't do anything?
  22. Re: Access Database Form Wont' Allow me to Update Records

    Can you convert the linked table to a local table and setup the primary key and make edits in that form that way? Or, since its already loaded, how should I load the table to where it isn't linked or...
  23. Access Database Form Wont' Allow me to Update Records

    I'm ultimately trying to setup an access database form, that has current data in it from an imported excel file that can allow updates. I have the form built but when I try to type in the fields it...
  24. Setup Combo Box (with 3 fields) - Assistance with why it won't sort my Form Items Correctly

    I have a Combo Box with (3) Fields:

    SELECT [GP Schedule].[EVM/VM], [GP Schedule].BEID, [GP Schedule].BusinessEntityName
    FROM [GP Schedule]
    WHERE ((([GP Schedule].[EVM/VM]) Is Not Null))
    ORDER...
  25. Replies
    2
    Views
    112

    Excel formula assistance - two if/thens

    I have this formula, but I'm trying to write into it:

    =IF(F4<=199, 0, 10)

    also, if f4 = "Chris" then "N/A"

    Help please?
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4