you can set the Group Name property of each option button. Each Group Name will be associated with each other and act in the same exact fashion as what Ken metioned (the Frame).?
Please explain more that how we can set Name property of group.
Its giving error "Microsoft cannot find feild '|' reffered to in your expression".Here is the code:
Private Sub Combo269_AfterUpdate()
Me.Child281.Form.Filter = "Device_Type = '" & Combo269.Value & "'"
Me.Child281.Form.FilterOn = True
Me.Child281.Visible = True
Me.[Device_Details...
i pchanged this code and put in the after update event of combo. But its not working and i know its Syntax is not right.
Me![Device_Details subform].[Device_ID].Form.DefaultValue = Me.Combo269.Column(1)
Please tell me the right one.
I know it,but the problem is the foreign key in subform is SrNo which is PK in main form. So it is already giving me all the devices of related stores.Now i filter devices through combo in main form. When i filter, it filters fine giving Device_ID,Device type etc from table.
The problem is when...
I have a main form and subfrom in it. When I go for new record in subform, enter data in subform, I also have to put value of Device_ID which i already selected from comboBox in mainform. So I want Device_ID feild in subform should have the default value,no need to write.The following code...
Creating a form, I have made serveral group boxes, how do
get these boxes to not interact with one and other.
Group 1 = Yes
No
Group 2 Lost
Damaged
Obsolete
Group 3 New
Used
Rebuild
I want to click one option in each...
Hi All,
Is there any way to make invisible/hide A,B,C written in sheet.In the same way Rownames like(1,2,3,.....).I dont want to be visible. Any suggestion is most appreciated.
Thanx again Tom to guide me in right direction.Thats I want to know.
Another question, Can we use Excel Sheets to only input data like forms to see only not for input in Database. If yes,so how to do.Because I saw many sheets that user inputs data ,save it and send through email.
I am new in Excel.i recently made Db in Access with forms,reports etc. Now I came to know that there are excel files .xls like forms to enter data. I am using toolbar control in Excel to draw controls over it.But now i am confusing that after creating controls like textbox and command button in...
Thanx for quick reply Tom. You take it in wrong direction.Actually I want to Export data into Access DB. But in diffent way. I am creating Form in Excel and on Sunbmit button, Data in TextBox/Cell should be inserted in table feilds accordingly.
Hi guys,
I am working on excel very first time. So need guidness. Actually what I am trying to do is ,I want to send data which is accessible through textboxes by clicking button in my table of AccessDB.
So what is the connection string or what is the procedure of sending data,looks as excel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.