This is the actual result: The report has 2 pages (the second label should not be printed on page 1 because ctPageHeader <> ctTrainingtypeHeader):
on Page 1
ctPageHeader = 1
ctTrainingtypeHeader = 1 lblWarningMsg
ctTrainingTypeHeader = 2...
I have a Label field (named lblWarningMsg) in my Header of the report, I want this Label field printed once on 1st header on every page, suppress the label field if the 2nd header appear on the same page.
I have 2 text fields called ctTrainingTypeHeader and ctPageHeader
both have the Control...
Thank you for your advice. For now, this table is only capturing that relationship. This database is going to track the relationship, for new comers to learn the business among all the companies that we are dealing with.
My original thinking is to have 2 tables to do the relationship among each others
In the 2 tables: I would have the following key fields
tblCompanyInfo
CompanyID Primary Key
Name
Address
etc.
tblCompanyRelationship
CompanyID Primary Key (a CompanyID)
RelatedCompanyID Primary Key (a...
I see a little light, but I want to digest further with the related posts.
on "You have different Categories - Suppliers, Distributers, Manufacturers."
Can I add a Category field in order to combine all the Category tables into one table? the Category field will capture whether this record for...
I am looking at the posts to figuring out how a company can be referencing among other companies.
How did you link the 5 tables to get the referencing among each other? Can I have the first 3 catogory table into one table because it have the same fields, what is the advantage to separate them...
I am seeking advice on relationship on a Company Profile Database. The objective is to do minimum data entry to link the all companies which have relationship among others.
Initially, I have two tables: One called tblCompanyInfo to store the company name, address, and service provided...
My AfterUpdate event in subform, I want to call the OnCurrent event on Main Form. I tried these codes
Call Forms![MainForm].OnCurrent
or
Call Forms.[MainForm].Form.OnCurren
obviously, I am not doing right. any suggestions? Thanks
...1
stFilter = "[StabilityDocStatus] Like 'Active/Approved'"
Case Is = 2
stFilter = "[StabilityDocStatus] Like 'Inactive*'"
Case Is = 3
stFilter = ""
End Select
stDocName = "rpt_StabilityProtocol_rpt"
DoCmd.OpenReport stDocName...
Thank you again hdookom and lameid for your reply.
I took your advice to add a calculation field on report's record source. This calculation field use a function to check all the conditions, the result will return 0, 1, & 2 for each record. I sum up on the headergroup, and the format will be...
Thank you hdookom and lameid for your reply.
Hdookon. Here is my GroupHeader on_format
Private Sub GroupHeader1_Format(Cancel As Integer, FormatCount As Integer)
If Sum(IsNull(Me.txtCountRed), 0, 1) > 0 Then
Me.txtTrainingName.BorderColor = vbRed
Else
Me.txtTrainingName.BorderColor...
Thanks for the ideas...I tried many things and I have half way through.
I added a unbound field, this field turns to 1 if Me.txtCurr_Version.BorderColor = vbRed, otherwise, stay 0.
Now, how can i sum up this unbound field
I used
=Sum(txtCountRed)
That doesn't work.
I have 12 ‘If’ statements to check on 16 fields on Detail section, then I format one field (called txtCurr_Version) based on the 12 ‘If’ statements. This is one of ‘if’ statement on the Detail_Format.
If IsNull(Me.txtRevision_num) Then
Me.txtCurr_Version.BorderStyle = 1...
Romou,
I used code in a different form, it works good.
ProgramError and TheAceMan1,
The database uses User Level Security. The users who doesn't have write access won't be able to add records. The user will encounter the error '2105', but I have the error handler take the user to First...
Yes, I step through the code (it is short code), the error is stop at
DoCmd.GoToRecord , , acNewRec
with error message "Run time error '2105'. You can't goto the specific record"
I thought the error handler would trigger if err.number = 2150. It is kind of odd that the error handler don't...
TheAceMan1
I was thinking to use the trick of error handler which will generate the '2105' error which means the user has write access (can't goto new record), thus on the error handler, the error handler will trigger and go to the first record.
Remou
I have to step through using an account...
I didn't have the code to detect Write Access. I was thinking if VBA gets the error message "Run time error '2105'. You can't goto the specific record", then the Error Handled would take you to the First record because the error '2105'.
Do I need to code Write Access? Can I program sonething...
I have an On Error handling on Form_Load, basically, if the user has the write access, goto New record. Usually, if the user doesn't have the write access, it generate error code 2105. So I have the error handling by goto First record. But My problem is the Error Handler didn't trigger...
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.