I've tried to remove every thing else except the most relevant things to fit into the 5 mb limit. Pls have a look and give yr comments. Thanks
Rajesh
User Profile
Collapse
-
Yes the above outline is generally correct, so as not to confuse you any frther am enclosing a copy of the project;
Sorry I didnt know earlier .. its too bigger than the limit set here, I'll try to delete some parts and send it again,
Good night for nowLeave a comment:
-
Thanks to both of you..
As suggested I have changed my tables and included Profiles, even though for data entry I have used ( at least fr the time being) Unbound forms with AddNew command to each control...
The profiles approach has significantly changed everything, I had to make different reports as well. But I found it to be more effective than my earlier approach of using filtered subforms.. thnks to you again.
I am trying to...Leave a comment:
-
Sorry Didn't reply earlier- was out of town and touch fr three days, will come back soon with my seemingly foolish questions again...RajeshLeave a comment:
-
Thanks ADezii, fr the thorough explanation, would get back after studying all..Leave a comment:
-
Thanks Malcolm, i sincerely hope this is not too "painful" a "headache" for you. I'm downloading and will get back after studying it..
RajeshLeave a comment:
-
The Problem I am facing here is
1) one test belongs to 2 or more profile- so if I add a profile column do I make it multiple values, would the code work same or give double values??
2) Even with this model there is repetition of parameters ( which is the core issue now!!!)
thnx
( I've learned a lot with yr example and still trying to digest all BTW- if possible pls clarify/ explain this line in simpler terms..
Set rstTests...Leave a comment:
-
Thanks a lot!
As I opened it It looks exactly what i was looking for..
I'm writing this just to thank you! Would get back after i've gone through the code.Leave a comment:
-
Thanks for writing! This could be an intresting way out. If I am understood rightly-
You propose a seperate table for profiles and link them to testName ( In fact Malcolm also proposes a seperate table but with help of Binary flags, only here the flags are ID,,,, am I getting things right?)
I'll try to work out a new table with profiles and get back on this forum.Leave a comment:
-
I'm very thankful to you , you've taken grt pains to understand/ and explain to me. I'm still trying to understand everything, at the onset I figure out that my problem is something like this -in tblTestID if I select Break overhaul-(break cable) and (break fluid) is inserted automatically. But the problem now is in there was a group Hydraulic systems which may include break fluid as well as other parameters ( so break fluid is common to 2 or more...Leave a comment:
-
Thanks for replying Malcolm!
In the meantime as I am downloading and Digesting all that you've told me I would share How I solved this issue for the time being, I used the addnew() command with If
as follows:
...Code:Private Sub TestName_AfterUpdate() ' Create form entries for CBC test If Me.TestName = 36 Then Dim dbN As DAO.Database Dim rsN As Recordset Set dbN = CurrentDbLeave a comment:
-
Thnks fr answering! even the largest test group would not contain more than 20 items ( a binary data type would do if thats what you suggest)I am attaching a screen cap of the table and the form. pls see here http://www.dbforums.com/microsoft-ac...ml#post6486489Leave a comment:
-
need to populate a form with a predecided set of fields
Please Help; need to populate a form with a predecided set of fileds which may be used seperately as well. To be more specific; I have a form (frmTestValues - a continuous form) based on table (tblTestValue) which stores the TestOrderId, Date etc and most important- values of tests , the name of the test is stored in a lookup form and selected (tblTestName.Te stName), value is entered against it.
Now a group of test has to be performed frequently... -
Rajesh Kesari started a topic Make tab move from one subform to another within the same parent after updatein AccessMake tab move from one subform to another within the same parent after update
I have a parent form with 3 subforms- after entering data in subform 1 I want cursor to move to a control in subform 2 and likewise to sub3 afterwards; what is the best way of doing that;
I tried after update goto control; but that works only for controls in the same subform; I tried giving the full identifier of the control; but still didnot work' Pls HELP
No activity results to display
Show More
Leave a comment: