Recent content by FRO

Thanks Again David, You've been a ton of help. I will keep looking into the entry issue. The rest of my issues have been solved. I'll let you go for now.

Thanks David! The form now behaves the way I want other than the double click entry problem. I deleted the mask, saved the form, and re entered the mask as per your instructions, and it did not change this behavior. I will continued to play with this. For my sake, I have to questions...

Where do I try: Me.CntrlFileName ? I tried: Private Sub Form_Current() If Me.NewRecord Then Me.CntrlFileName.SetFocus End Sub Still getting the "Compile Error"

Its getting late in the day, and I'm sure your tired of this. So I copied my db, eliminated names, and zipped it (attached). If you would be so kind, what I would like to have in the end is to be able to open the Form, and have the FileName field be ready to accept new data. This includes...

Does the order of the Events (as seen on the Code page) make any difference?

I've figured out the Form_Current thing ("the black box in the upper left..." took me awhile). However, when I enter: Private Sub Form_Current() If Me.NewRecord Then Me.FileName.SetFocus End Sub after I save it, I try to close the Code View, I get the following error: "Compile error: Method...

Confirmed that I don't have a Current property. I manually added: Private Sub Form_Current() If Me.NewRecord Then Me.FileName.SetFocus End Sub It would not run and prompted that Form_Current() does not exist.

The "FileName" box does not have a Current property option. See Attached. The first option is On Click. Running DMax returns the most recent entry into the FileName field "2013-07-09-140000" Running the DMin returns the first entry: "2011-05-15-080000"

For the first question, I cannot perform this test because the FileName is also my Primary Key, and I cannot close the form without completing it. It "Cannot contain a null value". Even if I delete the mask, something has to be entered. For the second question, where is the Current event? I...

Unfortunately, the db has peoples names that I shouldn't post. Here is the code for the FileName box: Private Sub File_Name_Click() Me.ActiveControl.SelStart = 5 End Sub Private Sub File_Name_GotFocus() Me.ActiveControl.SelStart = 5 End Sub Private Sub Form_Load() DoCmd.GoToRecord...

David, I used your SetStart code in the Got Focus and OnClick events. As a result, when I open the form for the first time, it does exactly what I want. However, after I enter data and click the "New Record" box, a new record page opens without any mask or cursor. Again, if I click in the...

I completely see your point with regards to the "2013-" mask. However, I believe there is a missing piece here. The "File Name" field, receiving the input mask, is not an actual date. It is a text, and formatted as such. This "file name" is generated from a piece a equipment we are using...

Thanks for the help. Working backwards, yes the "2013-" part is in the mask. I just change it to "2014-" when that occurs. How would that be any different than setting the default value to "2013-", then having to change that? I am not a programmer, and do not know the syntax rules perfectly...

Hello Access Forum, I am trying to force a form to display the "literal" portion of my input mask, and place the cursor after this portion. I have attached two screenshots to help demonstrate what I am looking for. When I click "New Record", a new record is created with the "File Name" box...

Hello, I am a Biologist, not a programmer. I work for an agency that can best be described as a dinosaur when it comes to anything IT, so I have to figure this stuff out on my own. Hopefully, I can get some help here. Thanks.