Search results
-
K
How to close a Form using a macro?
I'am sitting here scratching my head in total confusion. I have an action button in a form that runs a macro. This macro is a one-step macro to close the form I have open. When I click the action button, the macro dues not run. An error message pops up that says: This action can't be carried... -
K
Query criteria = a specific record of a specific field
Hello, Does anyone know how to have a query criteria point to a certain table; field; & record? This table that I want to point to is going to be updated by the user to specify what record he/she wants to print. I know there is something like a user input box that could do this, but I am just... -
K
Inputbox value to be used as a filter on a query
Inputbox value to be stored to a particular table/row Hello, Could anyone guide me on how to get a macro to run an inputbox that would take a users input and edit a particular field of a certain record in a table? PHEW! The other question is, how to get a query to use this particular value... -
K
Counting Yes/No results wrong???
Hello again! I am now trying to sum a YES/NO field using an Expression in the Totals field of the query as follows: Abs(Sum([myfield])) I know for a fact that the total should equal 1, but the results keep on coming back as 2. NOTE: I have many records but of all the records, I only checked... -
K
NULL in an expression = NULL???
Hello all! Can someone provide advise? I am running a query against one table. There are a total of 5 fields in this query, four of which are from the queried table and the other field is an expresssion that adds the four other fields. For example: FIELD5: [FIELD1] + [FIELD1] + [FIELD2] +... -
K
Displaying the total count of a single field query
Hello, Could anybody help me understand why I can use a single field in a query, put a count (from the Totals view) on this field and display the total occurances for this field, but I cannot get any count to display as soon as I enter a criteria to filter out this field to obtain the filtered... -
K
Query totals
Good day! I am a total newbie at Access and have a question. Is it possible to run totals off of a query? For example: I have a simple test table with 3 fields: ID <autonumber> Field1 <number> Field2 <text> I'd like to run a query that filters out records based off of field2 and count & sum...