Search results

Try... If Me.NewRecord = False Then Me.AllowAdditions = True 'not entirely necessary Me.Recordset.AddNew End If linked to your Button,which I assume is located on the subform itself.

:) I managed to make it work in the end. I essentially redifined the field in the table and a new control on the form, and it now works. I think possibly had the incorrect control source although I did try everything initially...should get more sleep! Thanks for your input anyhow.

I'm sure its something simple, however I have spent 2hrs so far so thought I would post my question... I have created a multivalue field which allows me to select many names which form s a circulation list for a report. The multivalue drop down works ox in table view, however when I am in form...

Probably a bit late for your original query, however I have also been trying to resolve this issue and in the end came up with my own "fix". It may be of help to you... In essence I take the decimal hours figure say 10.5 (10hrs 30min) and use the "fix" function to give me the 10 (i.e the integer...

One solution would be to ensure all your forms are hidden to start with, i.e on startup , hide the navigation menu and auto exec the login form. Then on successful login make a series of command buttons visible on the form,or alternatively open a menu screen. You can then make reference to the...

Hi all, just registered. I have used this site as a visitor for one or two years now and thought it best to join as my knowledge was getting better and my questions were getting more difficult to find answers. I'm what you would call a novice access developer, however my databases are becoming...