Search results

can anyone tell me how do I get the ProductID value in one form to show on a different form when the second form is opened. i have two joined tables with ProductID as the PK on both. thanks

Paid is a check box field, I am running 2010

I am still not seeing the value of myval in the Paid2 text box on the form

Private Sub Paid_Click() Dim myval As String If Me.Paid.Value = -1 Then myval = 1 Else myval = 0 End If Me.Paid2 = myval End Sub this is what I have

it has a value and Me.text7 is not displaying the string

I have a string Myval and I it to be output on a form text field. How do I do it I tried [text7]= Myval but I am not getting any output in the field text7

sorry about the last post it should read Dim ctl as Control For Each ctl in me.controls if ctlControlType = acCheckBox (?) then if me.ctl.value = -1 myval = 1 else myval = 0 end if end if next ctl

I found this snipet on MS website it loops through all the Y/N fields and changes their values from -1,0 to 1,0 Dim ctl as Control For Each ctl in me.controls if ctlControlType = acCheckBox (?) then if me.ctl.value = -1 myval = 1 else myval = 0 end if end if next ctl Dim ctl as...

have you guys left me?

I need a check box not a text box

is not working for me

the tables are all empty, I have no data yet I am designing a gui, and the requirements are for y=1 and n=0 as the data values. Thanks for trying to help me

is not working

I am running 2010, sorry I am trying to change the yn values of -1,0 to 1,0

data type is YN

I am trying to change the value of a checked field from a y/n box from -1,0 to 1,0, doesnt seem to be working

Thanks, i am not getting the error anymore but the code is not working. What was my error? was it just the layout of my code it didnt like?

Private Sub Paid_Click() Dim Vrbpaid As String If [Paid] = True Then Vrbpaid = 1 ElseIf [Paid] = False Then Vrbpaid = 0 End If [Paid] = Vrbpaid End Sub Can anyone tell me what the error is with this code? I keep getting Else without If error message. I have a check box...

one has product data and the other is the product label data

I have two entities with aone to one relationship. Can I use 1 primary key for both tables? ie can the primary key in table a be the same (Store ID)as the primary key in table b (Store ID)? or do i need to define a unique primary key in each table