Recent content by JeanieGreene

arnelgp you are the KING! Thank you all who helped out. You are all wonderful!

Thank you for trying to help, but I am still having all records updated, except the one record with focus. I have attached my database, hopefully that will help.

I wasn't sure if you meant with moving the Set rs line, so I tried both ways. If I move the Set rs line, I still get the error that the object isn't defined. If I do not move the Set rs line it enters the number into all fields except the record with emphasis.

Then I get an error that the object hasn't been defined (rs).

Ok, I made that change, and it seems to loop, but now it is filling in all the records between the first clicked record and the last clicked record, but not filling in the last clicked record. It doesn't recognize the check box.

Hi again. I am trying to make a checkbox on a continuous form, bound to a query, update all the forms that are check with a given "case number" that is entered into a text box. I have the following code, but it is not looping at all. It will only put the data into the line that I clicked on...

Ridders, I can't seem to thank you again, BUT... Thank You! I did get it to work with Splitting. I will see if it still works when I do the same with the Vessels and Calls For Service. This is the code I ended up using... Private Sub Form_AfterUpdate() If IsNull(FunctionKey) Then...

This is for a Law Enforcement dispatch, and emergency dispatch center. Good idea about saving people separately. I will work/think on that. As a dispatcher, we will be putting a lot of information into the one entry point. This is the "Radio Log" basically all information that comes into the...

Thanks Ridders. That link is helpful. I know that I am not supposed to save twice, but the purpose of the database I am working on is to be a one point of entry for the dispatchers in a fast passed environment. Thanks again.

Is there a better way to accomplish my goal?

Ok. I guess I will have lots to think about during Thanksgiving day weekend! Thanks.

Forms!Vehicle!(Location, [Vehicle State], Plate) = Split(Me.Notes, ",",3) is intended to take the information from the Notes field on the Main_Page and enter it into the three fields (Location, Vehicle State, Plate) on the vehicle form.

Thank you for your help. This is supposed to be a self built Computer Aided Dispatch. I run a small emergency and law enforcement dispatch center, and I am just trying to make our lives easier. We must keep a log of all radio and phone calls that come into the dispatch center. In addition, we...

Ok, so I got my KeyPress figured out. No I am having problems with the splitting of information from my Notes Field in the Main_Page form into 3 fields in the Vehicle Form. Forms!Vehicle!(Location, [Vehicle State], Plate) = Split(Me.Notes, ",") I want to type in the notes field...

Hello all. I have attached my database. I need my entry on Main_Page to self populate into the form Vehicle on the press of the return key. The Main_Page is the data entry site for my "Radiolog" table. The point of the radiolog is to keep track of and time stamped all radio traffic that occurs...