Search results

So, can you help me to learn what would be a better method. Since I have a linked table I can't add my checkboxes to this table, correct? What would be a better method? Any thoughts? I will give what you suggested a try and begin looking at other things as well. There has to be a better way...

The attached image shows how I have my table set up. I set it up this way because of pulling the employee and email from the linked table. Basically, based on the checkboxes, I want to send an email if the checkbox is checked. I have several steps, and there is a checkbox assigned to each...

So this is getting me the index of the employee, but not the text or the email. Dim rs As Recordset Dim strEmail As String Set rs = CurrentDb.OpenRecordset("SELECT * FROM tblEmailNotifier Where RMA1=True") If rs.RecordCount > 0 Then rs.MoveFirst Do If Not IsNull(rs!Employee) Then strEmail =...

Silly me!! I didn't have the object library selected in references!! My bad!

Getting an error on this line. Not sure why. Dim rs As Recordset It says User-defined type not defined. :confused:

Thanks for the reply! It is in the table mentioned, but it is part of a dropdown. It is the second column in a dropdown with the employee name in the first column. This is the only way I could come up with to make this work, perhaps you have other ideas. I have a linked table with all employee...

I have a table with employee, email, and a checkbox field. If the checkbox is checked I want to add the email to a string so I can send out an email to multiple recipients. I have tried this code with no success. What am I missing? I am still struggling with recordsets. Dim strEmail As String...

Ha!! Got it! It does work, another portion of my code was not working. but once I figured that one out then it inserted fine. Thank you to everyone who prodded me in the right direction!

This is what I placed into my code, but I can not seem to get it to work. Any ideas? What am I missing? CurrentDb.Execute "Insert Into [tblIncoming](RMA_Number) Values ('" & Me.RMA_Number & "')", dbFailOnError

So, possibly to clear things up better. I have one table and form that tracks our Customer Returned item. This table is all of the details concerning the returned item (customer, date shipped, problem, etc.) The second table and form is the incoming information. This includes everything we check...

Sorry, I don't mean to be confusing. I have two tables with that one column in common along with the ID column which is the key for the separate tables. There is more data in these two tables, but I want to copy the number to the other table so that when the user clicks a button on the form...

Yes, it is bound to one table.

I have managed to do many things with this database, but this has definitely kicked my butt! I found this option you are talking about, but I could not get it to work, so I am not sure which piece of the puzzle I was missing. If you know how to do this I am all ears! :D

I have a database with two tables, and a form that is bound to the 1st table. I have a duplicate record button on the form. One of the functions I want to happen is when the duplicate button is pressed, one value is copied from the form and added to the 2nd table. The tables are basically set up...

They are both of the same type. So, this is the only method for copying from one table and adding a record to another table? Basically the steps are, pull from one table the value I want in the recordset, then copy to the other table from the recordset? I think I am getting this, but not sure...

My bad. The number is not an AutoNumber, this number is something I enter. I use a separate AutoNumber for the ID in both tables. So all I am trying to do is copy one number and basically add a new record to the other table as you stated.

I am having difficulty figuring out DAO recordsets. Supposed to be easy, but I am guessing I am a little dense when it comes to these. Here is what I am trying to accomplish. I have a form and it has a field with an AutoNumber. When I hit a command button, I want to copy that number to a...

Hmm...Using the on click command for both images, just making the other image visible and hiding the clicked image and reversing the checkbox. Hope I understood your question well enough.

Yep, that seemed to do the trick!! I put the checkbox behind my two images and when I click one image the other shows up and the checkbox is checked, and vice versa, then I just read the state of the checkbox on the form load. Took just a push to get me going. Thanks!

I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind...