Search results

  1. L

    Solved open form wiith criteria not equal "Won"

    Gosh i feel dumb, thank you !
  2. L

    Solved open form wiith criteria not equal "Won"

    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
  3. L

    Calculate Margin on every change

    The margin field is still blank with no change? What I mean is that on every new number entered eg for 1.75 it updates on the '1', then the '1.' then the '1.7', then the '1.75',
  4. L

    Calculate Margin on every change

    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...
  5. L

    Solved take Me.PANumberHelp and insert on another form that has focus

    I am glad I asked as I didn't even consider the fact that the focus might get changed by the user, and have changed to dialogue mode! seems to be working fine, had a good shot at trying to make it not work, but it appears sturdy enough as always, thanks for your help :D
  6. L

    Solved take Me.PANumberHelp and insert on another form that has focus

    on form close i have used the below code, it appears to work, though hope that it isnt bad code? Dim TempPANo As TempVars TempVars!TempPANo = Me.PANumberHelp.Value DoCmd.Close acForm, "PA Help" Screen.ActiveControl = ([TempVars]![TempPANo])
  7. L

    Solved take Me.PANumberHelp and insert on another form that has focus

    So i have just clicked about TempVars as i use that for login and user access levels just before i checked here for any more help. The bit I am stuck on most is how do i get the form to know what field is in focus on my other form as i close the PA Help form? as usually i would just put in the...
  8. L

    Solved take Me.PANumberHelp and insert on another form that has focus

    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...
  9. L

    Solved Dlookup result of Manager Codes combobox returning Manager Name from table

    You are fantastic, thank you! This one has been bugging me for a while, its always something so darn simple. help is very much appreciated, thanks again!
  10. L

    Solved Dlookup result of Manager Codes combobox returning Manager Name from table

    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...
  11. L

    Solved edit record button not taking me to the correct record in second form

    Fantastic, that has worked for me :D thanks so much, the previous way was working until ive changed something, still fumbling my way through learning VBA and even access. thanks again 🙂
  12. L

    Solved edit record button not taking me to the correct record in second form

    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...
  13. L

    Export to excel in an unspecified location (user chooses where to save)

    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.
Top Bottom