Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. 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...
  2. 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...
  3. Replies
    4
    Views
    403

    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...
  4. Replies
    0
    Views
    216

    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...
  5. Replies
    4
    Views
    403

    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...
  6. 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...
  7. 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?
  8. 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?
  9. Replies
    5
    Views
    632

    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...
  10. Replies
    5
    Views
    632

    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,...
  11. Replies
    5
    Views
    632

    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?
  12. 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...
  13. 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...
  14. 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...
  15. 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?
  16. Re: Is it Possible to write a Match Formula with a Defined Name Range?

    I was trying to write it to find any that match to give the count. Some of the fields I my defined search are not satisfactory. So, it gives an #na error.
  17. Is it Possible to write a Match Formula with a Defined Name Range?

    Was trying to write a match formula with a defined name range.
    =MATCH("Satisfactory",Yellow, 0)

    This gives an N/A error. Is it possible?

    Thanks.
  18. Replies
    10
    Views
    213

    Re: Count If Formula with a Defined Range

    Here's the workaround that I found:
    ...
  19. Re: CountIF Formula if cell is yellow and has Satisfactory

    It's colored manually by another group.
  20. Re: CountIF Formula if cell is yellow and has Satisfactory

    I was trying to use the VBA code on the sheet which I googled and go from there in the countif formula option. Any idea how I would set something like this up to work?
  21. CountIF Formula if cell is yellow and has Satisfactory

    How would I got about writing a countif formula if the cell is yellow and has satisfactory 'text' in it? 2 Factors for count if please?
  22. Replies
    10
    Views
    213

    Re: Count If Formula with a Defined Range

    Yup, still a #value error... does anyone have a work around?
  23. Replies
    10
    Views
    213

    Re: Count If Formula with a Defined Range

    I believe that's the case and was afraid of that with the split ranges. I will do those few edits where no dups or spaces to see if it fixes, but all in all I think its because of that darn rule with...
  24. Replies
    10
    Views
    213

    Re: Count If Formula with a Defined Range

    Okay, so for example it works fine if I use a small range of g2:g4 connected, its when I start using the defined range with g2:g4, g8, g9:g11.. it doesn't work. But, that's the reason I'm trying to...
  25. Replies
    10
    Views
    213

    Count If Formula with a Defined Range

    How would you write a countif formula using a defined name range?

    My range:...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4