robtech4
Last Activity: Aug 9 '12, 07:29 PM
Joined: Jul 24 '12
Location:
-
I really hope in some way I will eventually be able to help you or start answering some of the other questions on here! -
...Code:On Error GoTo EH Dim strSubject As String Dim strAddressees As String [B]Dim strCC As String[/B] Dim strEMailBody As String strSubject = "Changes Requested" strAddressees = "yourname@company.com" [B]strCC = "yourname@company.com"[/B] strEMailBody = "Please look at changes. Thank you." DoCmd.SendObject acSendNoObject, , acFormatTXT,Leave a comment:
-
How to CC a person on an email with VBA code
I have this code, curtisy of Twinnyfo but I am looking to add another recipient email address as a "cc". Can you please advise on the addition to the code...
...Code:Private Sub cmdSubmit_Click() On Error GoTo EH Dim strSubject As String Dim strAddressees As String Dim strEMailBody As String strSubject = "Changes Requested" strAddressees = "your.name@company.com" -
Greg,
I have a seperate form for the approval process but the master table fields are coming up as #Name? rather then blank.
--When we check the chkbox to approve each field and then select the Approve button...the record is NOT being written into the fields and therefore into the Master Table.
Please advise :)Leave a comment:
-
So I was able to get the code going to compare old data with new data thanks to your help! My new and what seems to be my last issue (hopefully) is approving the addition of a new supplier.
I have a seperate form in which you can add additions (new supplier) and then once you select "Submit Request" it updates into the replica table.
Then, when I go to the form to approve/deny the changes that others have...Leave a comment:
-
GOT IT! The code worked like a charm.
THANK YOU!!Leave a comment:
-
Twinny,
Could you provide a bit more detail? I have the query somewhat set up but I am not sure exactly what the SQL should look like and the correct way to incorporate the code you sent.
Where is the output field in the query?
Thank you for your patience and help!Leave a comment:
-
worked perfectly! Thank you!!Leave a comment:
-
VBA code for button to make a chkField not selected
Hello,
I currently have a button on a form that sends an email and I was wondering if I could add a second function to the button to un-check a checkbox on the same form.
The issue is that the check box needs to not be selected in order for record in the table to draw into another form to compare old and new changes.
--That may sound a little confusing but ultimately if its possible to add a second set... -
With the "Reviewed: checkbox on the form that edits the tblReplica, I am noticing that unless it is unchecked the record will not show up in the frmApproval (with approve/deny buttons). In otherwords it will not automatically realize that two records with the same primary key in the tblMaster and tblReplica have other fields that do not match. Is there a way for it to automatically pick up on this and feed the records into the frmApproval to...Leave a comment:
-
Just wanted to check and be sure you did not forget to upload that sample database...wasn 't sure if you did end up making it based on the first paragraph.
Thanks.Leave a comment:
-
Conditional Formatting from blank fields to
Twinnyfo!
When using the conditional formatting to compare two fields...
It is working great for fields that already have something in them; however, when the field is blank and then gets updated to contain some text it is not formatting the field.Code:[Field1]<>[Forms]![frmApprove]![Field1]
Thanks! -
I made the join query, or at least I thought I did but I am still showing all 275 records to click through rather then just the ones that have changes.
With the Yes/No Field and the Date/Time field...does that require code for it to autofill?
I hesitate to ask but if it is not too much work for you to throw together, do you think you could add the following into the sample database you provided. The database you provided...Leave a comment:
-
I realized why the form was not populating. I still had my form set to compare the tblAud with the tblMaster rather than the tblMaster with the tblReplica. The record I was making the "test" changes on was in the Replica table so in turn was in the tblAud but not in the tblMaster. Once again, as you suggested I am switching the database to two tables in order to avoid this error and the many others that coincide with it.
...Leave a comment:
-
So I have been working on this just about all day. The part that I am all of a sudden having trouble with is getting my form to populate with data. I am assuming my recordsource could be wrong but am not sure. It was working fine earlier today then as I continued to add more and more subforms (one to each tab on the tab control...for a better appearance as you suggested in the past) nothing shows! In form view the form is literally blank! :( I have...Leave a comment:
-
The record source in the report is the tblMaster and the record source in the form is a query that just references the tblMaster. I honestly don't know why I have it set up like this but looking at it and telling you this makes me feel like an idiot because there is no way that can be right. Can you please advise on what it should be...
With Appreciation,
RobLeave a comment:
-
Slowly but surely I am making my way through this, without the attached file I would be getting nowhere as it is very helpful.
1) Can you explain what you mean by the second paragraph? Do my columns have to be Field1...etc or are you saying that my rows have to?
--currently my rows are per company and the columns are information about the company.
2) The reason I want to use the audit table instead of the replica...Leave a comment:
-
That would be correct. Everything in the left column comes from the same table and everything in the right column comes from a seperate table (they are updated changes made my non-admin users.Leave a comment:
-
Hopefully this is not too hard to see...Leave a comment:
-
Twinnyfo,
The printing button is linked to a report. When the print button is pressed a report opens up in access and the information that was in the form is supposed to be what's printing. Everything except for the manually entered data is printing (showing in the report).
The record source of the form is linked to a query which is populating the automated fields out of my "tblMaster" (as we discussed in the...Leave a comment:
No activity results to display
Leave a comment: