Search results

Hi, im trying to open my form with a view of all records where [Tender Status] <> "Won" but with the below code it appears with a input box asking me to define "Won" DoCmd.OpenForm "TenderArchive", , , "[Tender Status] <> Won" how can i do this? thanks in advance

Hi, I want my margin to calculate with every change of PAPrice usually would use me.FIELDNAME.text but this is a numeric value and doesn't seem to work that way. this is what I have so far, but might be wayyyyyyy off. Private Sub PAPrice_Change() If Len(Me.PAPrice) > 0 Then...

I have a form that helps users get a PA number from using a dlookup search, i would then like it to automatically enter itself onto another field that has focus on a different form when they click accept PA number (close) I would need it to be in the field that has focus as this help form will...

Having the following message appear after using the below code, Run-Time error '3075': Syntax error (missing operator) in query expression 'ManagerCode - 813 L'. could the issue be because of the characters spaces and numbers? this is a long standing manager code format within the business...

I have a edit record button on my Landing Page that should take me to another form "ContractDetail" so it can be edited, however it will only take me to the first record it is not finding the record I have selected Dim ContractID As String ContractID = Me.ID DoCmd.Close acForm...

Hi, i would like the end user to use an export button to export form "ContractDetails" as a .xlsm document is there a way to do this? thank you.