Search results

Please excuse me for this post, but I could definitely use some assistance. I have searched through the forums and I am still struggling. I am trying to populate multiple email addresses based on a table and a yes/no check box. If the checkbox is checked, they receive an email. I have a table...

Realized I made this much more difficult than it need to be specifying the form instead of using Me.Control name. Thanks for the direction and making my life easier!!

I am trying to populate an email out of VBA with information from a form. I am just running into one problem. The data that is being pulled for RMA Initiated By in the next to last line pulls the index number instead of the 2nd column which is the name. How can I specify which column to pull...

I am opening a report to send to users in an email using the Emaildatabaseobject in Access 2010. This works great, but I would like to add data to the subject line in the macro pulled from the report I am opening. The reportname is RMA_Admin, and the field on the report I want to pull from is...

Got it!! Thanks!

Thanks again Bob, I am curious why this would be the better choice to use. This is for my own personal learning, so if you wouldn't mind sharing some wisdom it would be greatly appreciated. Thanks!!

My fault on this one!! It was giving me the error of the field is too small to paste into the form. I increased the size on the source and it worked great. Thanks for the assist.

Thanks Bob for the reply. I basically get an error when I run this, and it is the same thing that has been happening to me. It hi-lights the code in yellow and then when I roll over it with the mouse then it shows that Me.Status=Null. I am not sure why this is.

I can't get this to work. Any ideas? Private Sub Receipt_of_Parts_Date_AfterUpdate() If IsNull([Receipt_of_Parts_Date]) Then Status = " " Else Status.SetFocus Status = "Parts Received- -Awaiting Evaluation" End If End Sub

Can you update a text box on a form based on input of a date control? Here is what I have. I have several date controls on my form, and I want to update a status textbox based on which of these date boxes is filled out, but I need the status to be filled into the table as well. Do I update the...

Here is the database with the tables. I did not set up any of the relationships, and I hope I got the data types correct. I did not enter any of the information either, my other real work is tying me up more than I hoped. Please let me know anything I could have done differently, better, or just...

Thanks for the explanations. FK makes sense now. :) I completely understand getting some real work done, I need to put a little time into another project myself, so it will take me a little bit to get back to this. I appreciate your help working together on this. I will put together the tables...

Wow!! I was not expecting this!! Incredible. It will take me a bit to work through this, but I think I am understanding some of it. So is there any VBA code that goes along with this? OnUpdate, etc? Oh, help me out- -What is FK? Thanks for the assist!:D

No problem. I am just grateful for the assist and hopefully learning something I can use more in the future. :D

Yes, we have a whole string of customer information, test requests, etc in the table. If you mock up something simple though, it might just get me running in the right direction. Unfortunately, I inherited this database and it has been through a lot, but I am trying to add some functionality...

I guess this is where I am struggling. I have seen 2 different methods. The first is to have all of the values for each tier in separate tables, and then a more widely suggested method of putting everything into one table. If this is the case, I am not sure if I have the primary problem in the...

Perhaps that is where I need to start. Would you suggest all of the data in one table. I can give you a bit of information and hopefully that would help. We work with Diode Lasers, and these would be returns from the customer that failed for some reason. The first tier would be performance...

I am really struggling to wrap my head around how to make cascading comboboxes work. I am working on a database for returned products, and I need to break down as best as possible what the problem is. I thought the best way to do this would be cascading comboboxes. What I am trying to do is have...

Seems like this might work. I tried it in the query itself, but no success. Can you help me understand where I might place this line of code? Thanks, Dave

I know it is an easier task to accomplish in Excel, but I wanted to see if this same format could be accomplished in Access. We are tracking our training utilizing a database, and thought perhaps a matrix could be constructed pulling information from the tables in Access. Just wanted to throw...