Search results

Ok, I am not great at access but I did this once in a class I took. I am not sure if it will work for you because I was not using yes/no and if u look at my problem I had posted just a little while ago, I am having a problem doing something just like this. Anyways, try this, create another field...

your right about the brackets...I realized that a little later after lookingat some examples...but it still ask for an imput. I have exactly what you have and it still asks for fixedexpenseoccurance

Please read the above one if you haven't it explains in detail the problem...anyways, I am going one by one to c if the IIf statement works. I figured out that I had parenthesis before the iif, can't do that. So now here it is: IIf(fixedExpenseOccurance=Quaterly,amount/3,0) Now that runs...

Here is the problem again in a more detailed explanation and the problem that is occuring: MonthlyExpenseAmount: (IIf(FixedExpenseOccurance)="Quarterly",(amount)/3,0)(IIf(FixedExpenseOccurance)="SemiAnnually",(amount)/6,0)(IIf(FixedExpenseOccurance)="Yearly",(amount)/12,0) I was wondering if...

Hi - Well, the "represents a yearly total" is whatever is selected from a dropdown box and can be either monthly, quarterly, semiannually, or yearly. I am making reports for each. Any expense that is yearly is divided by 12 to make the monthly expense...do you see what I am doing? Every value...

Expr1: (IIf([FixedExpenseOccurance]="Quarterly",[amount]/3,0))+(IIf([FixedExpenseOccurance]="SemiAnnually",[amount]/6,0))+(IIf([FixedExpenseOccurance]="Yearly",[amount]/12,0)) FixedExpenseOccurance is the the field and "*" is the values which get looked up from a table. I am trying to create an...

Well the records are sorted by date. Each day new records get inserted, so they are sequential...Will this (Previous post) work the correct way? I want it to show yesterday's additions every day I go into the forms. Thanks for ya'lls help

I want to have my records in my form show the latest entry, not a completely new form. The user will click on the new record button to create a new record but I want the user to be able to see the last record. Anybody know how to do this?

My Date Table (I think my Parent table b/c it is the 1 in the one-many relationship) contains an AutoID which is the Primary Key. It is seperate from the 3 forms which I am assuming I have as the child forms. (being the many side of the relationship) I used the wizard, added the two fields from...

Just thought the title was pretty funny, I know, u all are thinking this was an access forum not a dating site... I have a relationship question that I was hoping would be quick and easy if you don't mind. I have 3 different forms (Metric Records, Variable Expenses, Fixed Expenses) that I want...

Private Sub MetricName_NotInList(NewData As String, Response As Integer) On Error GoTo MetricName_NotInList_Err Dim intAnswer As Integer Dim strSQL As String intAnswer = MsgBox("The metric " & Chr(34) & NewData & Chr(34) & " is not currently listed." & vbCrLf & "Would you like to add it...

Private Sub MetricName_NotInList(NewData As String, Response As Integer) 'suppress the default error message. Response = acDataErrContinue 'Prompt user to verify if they wsh to add a new value If MsgBox("The Metric " & NewData & " is not in the list. Add it?", vbYesNo) = vbYes Then 'Set Response...

I have it look up a value in a table but there are no entries in the table. The limit to list is "no". After Update I have Me.MetricName.Requery

Do I need it to lookup a table first or something or can I have it unbound in my form (the form would be the first instance of the list entries)?

Please Help!

Private Sub MetricName_AfterUpdate () [Forms]![EmployeeMetricRecordsForm]![MetricName].Requery End Sub I have entered this into the form's code but it does not update it? the next record still has an empty list

I want to have a dropdown box in a form but allow additions to be made, but after they are made, instead of them not showing up in the box like usual, I want them to become a part of the list. Plz help! Thanks

Well I am making revisions to a database I made for the company I work for. There are some changes my boss wants made and that is one of them. He does not want to have to put in a new name for it to appear in the listobx.

I have attatched a word document showing values and what I need. I want to create queries (monthly, quarterly, semi-anually, yearly). I am working with the monthly right now and if I can figure that out I am assuming I will be able to figure the others out the same way. For the monthly report I...

Alright, I have a field called metrics that looks up the text in another table caled Metric Name. I want to delete the table that is being used to supply the values, but I still want a listbox with all those names. Also I want to be able to add names to that listbox. I am not sure how to do this.