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
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',
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 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
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])
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...
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...
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!
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...
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 🙂
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...