Search results

Hi, I am using this statement. Format(IIf([Last Payment Made]<DateAdd("d",3,[DueDate])),0,[AmountDue]*0.1))),"Currency") Last Payment Made is a date field Dlookup, short date format. Due Date is in the table, short date format. The issue: Say my DueDate is 1/1/2016 If my Last Payment Made...

Hi, I have a mainform with a subform 1 to many relationship. I am trying to auto create a new record in the subform for each record in the mainform if a record does not already exist. Mainform has a PK MainID, the subform has a PK SubID, FK MainID. Obviously when I create a new record in the...

Brilliant! Many thanks. One more question. How can I format this result to Currency? Late Fee: IIf([WaiveLateFee]="Yes",0,IIf([Sum Amount Paid]=[AmountDue] And [Last Payment Made]<=[DueDate]+4,0,[AmountDue]*0.1))

Thanks, this is what I tried. IIf([WaiveLateFee]="Yes",0,IIf(Nz([Sum Amount Paid]=[AmountDue],0) And Nz([Last Payment Made]<=[DueDate]+4,0),0,[AmountDue]*0.1))

Hi, I have the following Expression that seems to work great except where there are null values for any of the fields. I have tried NZ but no luck, two fields are number fields and the other two are Date Fields. Is there a way in this expression to handle all nulls for both numbers and dates if...

Hi, I have a form that has a combobox and a tab control. The selection in the combobox determines which tabs are visible on current event. On one of the tabs I have a search window, when the user double clicks on the name the focus moves to that record in one of the tabs. What I am trying to...

Hi, I am trying to copy a record with a command button. I want to copy the record as a new record but append "SALVAGE" to the existing PK for the new record. In other words, original PK with SALVAGE added to it so when it goes in it does not violate PK integrity rules. The PK for all new...

Perfect of course! Thank you sir. Fen

Hi, I have a form with several currency bound fields. The users can delete the default value of $0.00 but I do not want that form to have null, is there a way I can always have $0.00 in that field if the user leaves it as null? Fen

Thank you, can I just use this on a form load or on dirty event in the form versus an append query? the field I want the value in is an unbound field on a subform. Private Sub Form_Load() If rec.Count = 0 Then Text76 = [Forms]![ManagePaymentsF]![Text50] End If End Sub

Hi, I have a main form with a subform. One to Many. I am passing a value from the main form to an unbound control on the subform. The trouble is I only want to add that value to the first record on the subform, not all if it happens to be a "many" This is where I am so far but does not seem...

Solved .Subject = "SOME TEXT HERE " & " " & [Forms]![name of form]![name of field]

Hi, I am wondering if it is possible to send an email using CDO where I can add a field from my form to the Subject or textbody of the email message? This is the code I am currently using, it works great but I want to add some information to the email regarding the record from which the email...

Paul, you are awesome! Worked perfectly- Thank you so much. You are truly valuable to this forum. Fen

Hi, I have an option group with two options 0 & 1 What I am trying to do is trigger an event if 0 is selected: Update the status of a different option group and run some code And if 1 is selected just update the status of the different option group but not run some code. What I have is below...

Thanks, so I am working from home today and brought the FE and BE with me to do some dev. I cannot get my FE to open though. Usually if the BE is missing I get a bark and am allowed to update links etc.. How can I get to External Data etc.. when the FE gui will not present? Thanks. Fen

Hello, I have a split db. Developed in access 2013. The issue I am having is when my BE is renamed or moved the FE opens to the generic Access screen and will not allow me to load the file so I can relink or correct the path to the BE. Older versions of Access would prompt me cannot find BE...

Hi, I have a split DB. FE & BE. MS Access 2013 I have some code for a linked table manager that appears to be working as it should. Runs on AutoExec at start up of program. The question I have, is when I change the name of the BE to test the code, ie cannot find BE, do you want to locate? ms...

Hi, I am using the standard attachment control on a table - form. I have created a query that shows all the attachments per record. Is there a way to show the file path of the attached picture in the query? Thanks. Fen

Hi, I am using an attachment control on a form. It works great. Is there a way to keep the "Forward" and "Back" option visible on the form without having to click on the control on the form? Thanks. Fen