Search results

I have a form called "HMLogMain" with the following fields [Account], [AccountName], [DateShred] and [ReasonToShred] that reside in the detail section. I also have a subform called "SubMenuShred" which captures the listing of the documents to be shredded with the following fields [DescOfDoc]...

I'm a newbie to MS Access and I need some guidance. I replaced one of the fields in my form design with the following expression =IIf([AMOUNT]>=10000.01,"YES","NO") so that once a user inputs in the field [AMOUNT] it will automaticly put a YES or NO depending on the amount entered. My problem...

Can someone show me how I can hide the main console that opens in MS Access and just open only the specific form the user will be working on. I saw this done once but I have not found a way to achieve it on my database. Thank you..

I have a field named [Account No] and in the properties of this field under the tab "data" I have the following a query built: SELECT [CIF Accounts].[Account No], [CIF Accounts].[Short Name], [CIF Accounts].[Relationship Name] FROM [CIF Accounts]; so when an account number is entered it will...

Can someone please help me construct the expression I have below. I'm getting an expression error. The expression should add a "1" to the count if it finds a "YES" in the field [form104Count] and a "0" if not. 104COUNT: Sum(([form104Count]="YES"),1,0) Thank you!

I have the following expression in a Query and for some reason its giving me correct results for the part of the expression of [AMOUNT] but it is not calculating [TRANSTYPE] ="Cash-In" the end result shows Cash-In and also Cash-Out.. When It should only give me Cash-In transactions. Is the...

I have the following expression in a Query and for some reason its giving me correct results for the part of the expression of [AMOUNT] but it is not calculating [TRANSTYPE] ="Cash-In" the end result shows Cash-In and also Cash-Out.. When It should only give me Cash-In transactions. Is the...

I have a report that in one column I have a mix of YES's and NO's and I'm trying to add only the yes's and get a total. From research DCount is my best choice I believe to make this work. The report is pulling its data from query "Weekly Report Filter" and the field that is storing the YES's...

Can someone give me a hand with the function Dcount for a report the I need to total the number of "YES" for a field called [FORM104]. The QUERY name that its feeding the data from is called -> Weekly Report Filter and the query is using Table: Clients.

Can someone give me a hand on the below code, Im missing something but im not getting it. Im getting a invalid syntax "You may have entered an operand without an operator". form104Count: IIf([FORM104]='YES',Count[FORM104])

I'm trying to make two fields, [RELATEDTO] & [RELNAME] populate automaticly at the same time when field name [ACCOUNT] is entered by a user. In the form "Transaction Log" in the field [ACCOUNT] I have created a event procedure in After Update (see below code). Which populates automaticly...

Can someone help me construct a formula in a form that I can incorporate into the control source in a field. The primary fields in my form that I need to evaluate for the formula are [Date], [Account] & [Amount]. I would like the field to add the sum of [Amount] for all [Account] numbers that...