Search results

1. put a text box 2. control source : =[SubformName].Form![FieldName]

the same code as mentioned by WayneRyan with an addition of the following Select Case Me.YourCombo Case "TextA" Me.Field1.Enabled = False Me.Field2.Enabled = False Me.Field3.Enabled = True Me.Field4.Enabled = True Me.Field1.Value = 0 Me.Field2.Value...

I have changed you code to the following Private Sub cmdCI_Click() On Error GoTo Err_cmdCI_Click Dim i As Variant Dim j As Variant For i = 0 To CurrentDb.TableDefs.Count - 1 For j = 0 To CurrentDb.TableDefs(i).Fields.Count - 1 If CurrentDb.TableDefs(i).Name = "tblInvoices" And _...

same as i have mentioned before Enabled = no locked = yes

in my OnCurrent of Invoice form i am trying to put the following Code If Me.Invoice.Value = True Then Me.InvoiceNumber.Visible = False Me.ManualInvoiceNo.Visible = True Else If Me.Invoice.Value = False Then Me.InvoiceNumber.Visible = True Me.ManualInvoiceNo.Visible = False End...

Sorry to be a Pain but where do i put this code. module or command button code or form

Question: How Do I change the Default Value Property of A Check Box in a Table Through A Form ?

how to use this code in a multiselect listbox to pass paramete toa report dim frm as form, ctl as control dim caritem as vairant dim strsql as sting set frm = form!frmMyForm setctl = frm!lbMultiselectListbox strSQL = "Select * from Employees where [EmpID] = " for each varitem in...

in the textbox properties se the following Enabled = No Locked = Yes

well tobe honest i really dont know, or i have tried yet. you have given somthing to work out. i will try to do it and let you know (Sorry for Disappointment)

pleasure is all mine. you have my email. just send anything ifyou need me.

is the field Type set to number. change it to Text or Currency. that shoud do the trick

hmmm,,, try this 1. create a combo box on you form with the details you have just mientioned. Id Number Surname Christian Name 2. the on the afterupdate event of the combox box place thefollowing code Me.Requery If Len(Me!ComboxboxName.Column(0)) = 0 Then DoCmd.ShowAllRecords...

well this is what i am doing presently 1. create an image fram on your form with any image. 2. put the following function in the declare section of your form Function setImagePath() Dim strImagePath As String On Error GoTo PictureNotAvailable strImagePath = Me.ImagePath...

hi popye can you be more elaborative, is this the same db you send me

can i give you an alternative method . instead of using the open arg method , use a macro which set value from form 1 to form 2 then in your listbox row source , refer it to you textbox , that would be fairly simple enough to get it done. supposingly your Textbox name is Text0 then SELECT...

Try using this on the onExit of you Item Code if isnull(me.itemcode) or me.itemCode = "" then Msgbox "Your Message",vbokonly,"YourTitle" me.itemcode.setfocus else me.NextField.setfocus endif end this will make sure that your itemcode is filled or not , if you are using no item code...

try making default value as 0

well i checked your DB and it is quite simple enought. you created an unbound textbox so that it will have the focus and you can disable or enable the other textbox or control. you want to remove the focus from it and that will be done when you go for modification. as soon as the first field...

can u send a db...presently i am only on the following hotmail mohammadagul@hotmail.com if you want more just add me and i can help you directly