Search results

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...

It all works now. Thank you! In case anyone else could use the help, here is what I ended up using for the code... Private Sub StatusCheck_Click() TimerInterval = 1000 TimeCount = 300 Me.txtCounter.BackColor = vbWhite DoCmd.OpenForm "Main_Page", , , , acFormAdd Forms!Main_Page!FunctionKey =...

That makes sense. Thank you. Do I need to change my DoCmd statement? I am thinking that I will need to put an additional DoCmd statement before my If Then statement to Open the form?

Here is my zipped database...I hope.:)

Mark, This is code on form Timer1. When I push the button on timer 1 I want it to enter data into the Radiolog table through the Main_Page form. Maybe I should skip going through the form and enter it directly into the table. Hmm. Let me figure out how to post the database. I am sure that will...

It is not recognizing any of my fields on the Main_Page form. This form does have subforms attached. Will that make a difference? Also, I have removed the Labels above each field, but the fields are still named appropriately. So, I don't think this is the problem, but I am putting it out there...