Recent content by srodolff

User1 logs into Win 2000 Pro. The screen and already open programs are displayed in a certain format. User1 then moves, maximizes, minimizes, or closes any of the windows and then logs off. If another user logs in with User1, how can the original screen format be reloaded to reappear as the...

Roy-Vidar, I figured it out. Instead of putting DCount in the control source, I put it in Default Value. I then added a Forms! entry to the Save button that contained the DCount statement. Now the correct total appears when the form is opened and anytime the "Save" button is...

Roy-Vidar, Your suggestion was very helpful. I have one last issue: When I put the DCount command in the control source, the count is correctly reflected when the form is opened. I have a button on the form that is called "Save". This button 1. Clears the form by acNewRec. 2...

Is there any reason Dcount wouldn't work? Something like this: =DCount(&quot;[Memory Upgrade Complete]&quot;,&quot;Complete Data&quot;,&quot;[Memory Upgrade Complete] <> null&quot;) [Memory Upgrade Complete] is a checkbox. Please correct my syntax if it is wrong. BTW, what textbox function...

Greetings! I have a simple access database where each record contains a checkbox field. On a record lookup form, I would like to place a textbox that contains the current count of records with selected checkboxes. I would like to use VBA code for the textbox. Any simple suggestions? Thanks...

I have a textbox with a format of Short Date. The box is currently blank. On click, I would like to have the box fill with the current date. This should be easy, but I am having difficulty with it. Thanks in advance for your help. Steve

I have tried the following code: Private Sub Find_Click() ' Find the record that matches the control. Dim rs As DAO.Recordset Set rs = Me.RecordsetClone rs.FindFirst &quot;[Vehicle Shop #] = &quot; & Me![Find VSI] Me.Bookmark = Me.RecordsetClone.Bookmark...

I have a simple Access 2000 database. I have a form with an unbound field called &quot;Find VSI&quot;. I have a button called &quot;Find&quot; that, when clicked, should find the record where the field &quot;Vehicle Shop #&quot; is equal to &quot;Find VSI&quot;. Will this code work? Private...

Ginger, You are very helpful. I need a little more help. The form will be opened when the database opens. Secondly, on the new record command, how do I get the first field to be selected again? Thanks, Steve

No go. When I add this command to the save button, I get a syntax error. I added this command immediately after the save record command. BTW, I would also like to know how to return to the first record after the save record button is pressed. I couldn't add the command when the form opens. I...

I have two questions. 1. How do I get a form to open with the fields blank? 2. What command can I add to a save record button to get it to clear the form after saving? Thanks, Steve

Jason246day, I am trying to follow your example as I have the same issue. I have just enough Access knowledge to be dangerous. If I have a Table called (Data) and it contains 25 fields. I create a new form with a textbox and a submit button. What code goes into the textbox and what code...