Search results

I am still having trouble with the following: =Sum(IIf([Number] Like "[A-G]",[Amount],""))

I have a table with two columns; [Number] and [Amount]. On the report, I have 3 fields; [Number], [Amount1] & [Amount2]. [Amount1] is =IIf([Number] Like "[A-G]",[Amount],"") [Amount2] is =IIf([Number] Like "[H-Z]",[Amount],"") The details are coming up correctly but I am having an error...

Aha...found it. Geez...I didn't realize the name of the form changed when I paste it to the main form. Anyway, I rename it to frmFixed with the following syntax: [Forms]![frmDeal]![frmFixed]![Form]![cboFYE] And, its working now! Thank you very much! On another related issue - when I select...

Bob: I changed it to: [Forms]![frmDeal]![Trades]![Form]![cboFYE] but it still didn't work. And, I am now more confused than ever - where did you find [Trades] in the db?

Rural: Its in the Row Source of cboBeginDate.

Bob: Its in a criteria of a query and I replaced it with: [Forms]![frmDeal]![Form]![frmFixed]![Form]![FYE] It still didn't work. I have attached the sample for your review. Please advice what went wrong. Thanks.

I am still having trouble getting it to work after changing it to [forms].[frmDeal].[frmfixed].[form].[FYE] or [forms].[frmDeal].[FYE].[form].[FYE] I am stumped!

I have the following line on my subform [frmFixedsubform] referring to the main form [frmFixed] and it is working fine. [Forms]![frmFixed]![FYE] I then put the main form to a tab control in a new form [frmDeal] and changed the syntax to the following but it didn’t work...

Rural: I deleted Option Explicit and it is working now. Guess that is not required?

After Debug>Compile, the error is on "cboBeginDate".

I am still having the error message. BTW, I have these lines at the beginning: Option Compare Database Option Explicit Dim cboOriginator As ComboBox The error started after I added the last 2 lines for a calendar.

I encountered a Compile Error: Variable not Define on the following combobox and have no idea how to fix it. Private Sub cboFYE_AfterUpdate() On Error Resume Next cboBeginDate.RowSource = "Select tblBeginDate.BeginDate " & _ "FROM tblBeginDate " & _ "WHERE...

Exactly what I need. Thank you!

I would like to limit the selection of records in a combobox to the selected record in another combobox. For example if I select 2009-10 fiscal year in the main form, the combobox in the subform will limit the selection to only 07/09 thru 06/09. I have attached the sample db. Thanks for any...

Thank you very much. Its working now and I have changed the field to number & primary key.

I am getting an error message when clicking on a preview button to retreive a report for the record shown and can't figure out why. The code is Private Sub PrintPreview_Click() Dim strReportName As String Dim strCriteria As String strReportName = "rptSales" strCriteria = "[sales_id]=" &...

I have multiple subforms and would like advise on how to load only one on the main form via a combobox. I searched the forum but can't find any past solutions. Thanks.

I finally figure out how to make it work. I placed an AfterUpdate like so: Private Sub Check1_AfterUpdate() If Me.Jul08 = True Then Me.Jul08 = Me.Jul08 + 1 + [FORMS]![1-Trades]![qty] * 31 End If End Sub Thanks.

When checked, qty*daysinmonth. I put the code into the box and the calculation is correct, but the checkbox is not functioning. Attached is the db sample. Thanks guys.

I have a couple of checkboxes and would like it to perform calculations when checked. Is it possible?