Search results

How do i make a page (tab) in a tab control come to the front? atm ive got tables changing from visible to not visible. I prefer to make the pages come to the front any ideas?

woohoo fixed it :)

Run-time 2427 you entered an expression that has no value thats what it says!??!?!

could this be the problem Me.tboCashCommission = Me.tboRepComFig1 making a textbox = a textbox? would i need to first move the variables into a temp thing then make the temp equal teh textbox?

puttign them on another line i dont think will work tbo = textbox ;)

thats what i did originally and it threw a whobbly saying i was missing End If ;)

Private Sub RepCommissionBoxGroup_AfterUpdate() If Me.ckbRepCom1 = True Then Me.tboCashCommission = Me.tboRepComFig1 End If If Me.ckbRepCom2 = True Then Me.tboCashCommission = Me.tboRepComFig2 End If If Me.ckbRepCom3 = True Then Me.tboCashCommission = Me.tboRepComFig3 End If If Me.ckbRepCom4...

nvm it was suppose to be tboDiscount = tboDiscount + 0.5 its fixed now :)

Ive made a button to + 0.5 to a text field the vba code is simple Private Sub btnDiscountUp_Click() Dim DiscountValue As Double Dim Temp As Double DV = DiscountValue Temp = DV + 0.5 tboDiscount = Temp End Sub However it ONLY works once, if i click it again it doesnt add another 0.5 on. What...

what do you mean unbound it doesnt seem to be working. Me.SomeDBField = Me.MyCalculatedField Me.MyCalculatedField is the field on the form where you perform the calculation. What is Me.SomeDBField is that the database table field i want to store it to?

Ive created a button using the wizard here is the VBA code for click event: Private Sub btnOpenSales_Click() On Error GoTo Err_btnOpenSales_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "Sales" DoCmd.OpenForm stDocName, , , stLinkCriteria...

Sorry i cant post a sample :( what does AFTER update mean?

Finance House Product Code Term They are the levels atm: Private Sub cboProductCode_AfterUpdate() If IsNull(Me.cboProductCode) Then Me.cboTerm = Null Me.cboTerm.Enabled = False Me.cboTerm.Locked = True Else Me.cboTerm.Enabled = True...

i want the combo boxes to change depending on what you select above in whatever combo box. The whole idea of the cascading combo boxes was to filter out unwanted things for EACH record, not for all the records. I was suprised when i found out it never updated everytime u changed the parent...

the problem is it isnt pulling or showing any data no matter what date you enter

all i am using atm is the combo box in the F&Q all ive done is rename the field names added ONE more level to it thats it. What should the even procedure on the field be? After Update? It works on the current record but as soon as you change to record 2 its the same for the LAST field. the...

whats the vba code for checking to see if a checkbox is ticked? its Checked or something isnt it? please can you provide me with an example because i want to use it in a if statement. Thanks

where is this option? at the moment i cant seem to get the start and end date working correctly? i look at the order entry example and i cant see what i am doing wrong?

How do i save data in a textfield where i do calculations, if i was using a normal textbox which asked for simple text input i can add a control source and save it in that field in whatever table. If i add a calculation/ formula to a field i loose the control source option. Same goes for when i...

ive got a problem with my Cascading Comboboxes, they work fine and update to whatever thing you choose. HOWEVER on my LAST level of combo boxes ive got several numbers listed based of product. Whatever product i choose first the numbers after will be the same for ALL other products. It doesnt...