Recent content by Nmex Ron

RG, I had a misstatement saying "form" instead of "report" -- I should have said: When the user is finished viewing the report they would like to enter new parameters (Beginning and ending dates) for the report (without closing and reopening the REPORT) I installed a command button, which...

I have a report that works from a query with parameters that are entered into a small popup form. When the user is finished viewing the report they would like to enter new parameters (Beginning and ending dates) for the report (without closing and reopening the form) I installed a command...

Move to the last (or next) record in a subform. This one worked for me with only one subform: Me.YourFormNameHere.Setfocus DoCmd.RunCommand accmdRecordsGoToLast Actually I modified it to go to the next record: Private Sub Form_Current() Me.YourFormNameHere.SetFocus DoCmd.GoToRecord , ...

Records do not show in subform - Fix The only thing that finally worked was deleting the old form and creating an entire new subform, and inserting it into the mainform. Believe me I tried everything. Weird but that's computers. On the other hand this was the only glitch from conversion of...

Records do not show in subform. After upgrading to Access2007 from Access97 the entries in a subform do not show, on the form -- neither previous entries, nor those that I now enter. I have messed with relationships and the Link Child Fields and Link Master Fields properties of the subform...

boblarson, Wow, that was too easy! Thanks for the quick and accurate reply. It worked great. For others who may try this, I did have to select all the controls in the group, otherwise the unselected controls jumped/moved into the control area that I was trying to separately resize. Thanks...

In Access 2007, after creating a form using the wizard, all of the text boxes created for entering data are the same size. When I try to adjust the width of one, they all change width. How can I unlock or change this feature? I have deleted a box, and then re-added it. This sometimes works --...

Password Thanks for the reply. The discussion on the link (that boblarson supplied) talks about setting a password on a Switchboard menu button. However, in Access 2007 you can always go the "Navigation Pane" to get to the form, which would by-pass the password. I have found a method to...

Passwords Okay, you can't set a password for a form. What about the rest of my question? How to set a pasword on a form.

I am using Access 2007. How does the above code apply to A07? Here is what I am tring to do: I would like to set a password for a database in Access 2007, and also set an additional (or different) password for a particular form and table that contain financial data, that I don't want all users...

Problem solved – I did not know (and no one said) that these commands must be put into an “Event Procedure”. As soon as I did this everything worked. Probably taken for granted, however I am first a retired soldier, then a rancher, and somewhere down the line I attempt to develop Access...

Additional information about this combo box issue. I was using a datasheet form, now I tried a “one record at a time form” and entered the same line into the After Update event of the existing combo box “EnvNumC”: me.Parishioner=me.EnvNumC.column(5) I get this error message on the new form: “If...

I have tried for hours to get this to work with no success; nothing ever appears in the Parishioner field. I renamed the field “EnvNum” in the main table (instead of Envelope#) and “EnvNumC” in the table I am using the form to fill (the envelope number can change from year to year so I need the...

I entered this in the afterupdate event of the existing combo box. me.Parishioner=me.Envelope#.6 It accepted the entry, but nothing happens. Likely I am not constructing this correctly. "Parishioner" is the field I am trying to get it to fill. (one of two) "Envelope#" is the apparent name of...

In Access 2007, I would like to select the data from one combo box, and have it placed simultaneously in three fields on the same form. I have the form and combo box constructed, and can see the data in the combo fields -- but (as normal) it only fills in one field. The data in the combo box...