jberry7285
Registered User.
- Local time
- Today, 23:15
- Joined
- Aug 6, 2010
- Messages
- 16
Hi all,
I am knew to this forum so any help greatly appreciated.
I have a few problems with a DB I have created, if you feel you can help on any of the problems please reply to my thread!
1, I have a date and time field in my DB, In form view the D&T displays perfectly, in table view how ever the D&T do not pull through into the table on each record? Any ideas?
2, I have made some fields mandatory - is there a way i can change the text that is displayed if the field is not filled in - somethign more user friendly is what i am after!
3, I need a piece of code to do the followinf caluclations - i have a decent enough VB knowledge but im stuggling to get these to work!
Calculations:
Number of Nets * Cases Checked = Total (This box is hidden)
No Of Major Defects / Total * 100 = %
IF % is higher than 4 then the “CommandButton” says “NO”
IF % is less than 4 then the “CommandButton” says “YES”
This is my top priorirty problme if anybody can help!!
many thanks in advance!!
Jon
I am knew to this forum so any help greatly appreciated.
I have a few problems with a DB I have created, if you feel you can help on any of the problems please reply to my thread!
1, I have a date and time field in my DB, In form view the D&T displays perfectly, in table view how ever the D&T do not pull through into the table on each record? Any ideas?
2, I have made some fields mandatory - is there a way i can change the text that is displayed if the field is not filled in - somethign more user friendly is what i am after!
3, I need a piece of code to do the followinf caluclations - i have a decent enough VB knowledge but im stuggling to get these to work!
Calculations:
Number of Nets * Cases Checked = Total (This box is hidden)
No Of Major Defects / Total * 100 = %
IF % is higher than 4 then the “CommandButton” says “NO”
IF % is less than 4 then the “CommandButton” says “YES”
This is my top priorirty problme if anybody can help!!
many thanks in advance!!
Jon