If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Data not refreshing on form
Hi Jeanette
I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#12
|
|||
|
|||
Data not refreshing on form
You need to go to the next new record.
The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#13
|
|||
|
|||
Data not refreshing on form
The Navigation buttons are set to yes (its default)
I don't seem to have as an option "save and open in normal view" or "go to a new record" in the Format tab.. I checked the All tab too... "Jeanette Cunningham" wrote: You need to go to the next new record. The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#14
|
|||
|
|||
Data not refreshing on form
Save and open in normal view - I really meant - you have finished changing
the form. Close and save it. Now open it in normal view. Test to see if it works the way you want. Jeanette Cunningham "Joy" wrote in message ... The Navigation buttons are set to yes (its default) I don't seem to have as an option "save and open in normal view" or "go to a new record" in the Format tab.. I checked the All tab too... "Jeanette Cunningham" wrote: You need to go to the next new record. The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#15
|
|||
|
|||
Data not refreshing on form
Strange. When I hit the save button, the form looks the same, no changes took
place. Its only when I move my mouse wheel forward that the form became blank for me to put in my next entry. I was under the impression that when I hit the save button, all values in the form will disappear. I am not sure if all my users have a mouse with a mouse wheel. "Jeanette Cunningham" wrote: Save and open in normal view - I really meant - you have finished changing the form. Close and save it. Now open it in normal view. Test to see if it works the way you want. Jeanette Cunningham "Joy" wrote in message ... The Navigation buttons are set to yes (its default) I don't seem to have as an option "save and open in normal view" or "go to a new record" in the Format tab.. I checked the All tab too... "Jeanette Cunningham" wrote: You need to go to the next new record. The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#16
|
|||
|
|||
Data not refreshing on form
Joy wrote:
Strange. When I hit the save button, the form looks the same, no changes took place. Not strange at all as that is exactly what you should expect. Its only when I move my mouse wheel forward that the form became blank for me to put in my next entry. Because the mouse wheel will navigate the form to different records. When you are on the last record and navigate forward you end up at the new record position. I was under the impression that when I hit the save button, all values in the form will disappear. Don't know where you would get that impression. Access forms have never behaved that way. I am not sure if all my users have a mouse with a mouse wheel. The mouse wheel is not the only way to navigate. Hitting or * in the navigation buttons will do the exact same thing. As will pressing PageDown or using Records Go To - New on the menu bar. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#17
|
|||
|
|||
Data not refreshing on form
If you want that behaviour,
change the code behind the button to this: On Error Resume Next If Me.Dirty = True Then Me.Dirty = False End If DoCmd.GoToRecord acActiveDataObject, , acNewRec Jeanette Cunningham "Joy" wrote in message ... Strange. When I hit the save button, the form looks the same, no changes took place. Its only when I move my mouse wheel forward that the form became blank for me to put in my next entry. I was under the impression that when I hit the save button, all values in the form will disappear. I am not sure if all my users have a mouse with a mouse wheel. "Jeanette Cunningham" wrote: Save and open in normal view - I really meant - you have finished changing the form. Close and save it. Now open it in normal view. Test to see if it works the way you want. Jeanette Cunningham "Joy" wrote in message ... The Navigation buttons are set to yes (its default) I don't seem to have as an option "save and open in normal view" or "go to a new record" in the Format tab.. I checked the All tab too... "Jeanette Cunningham" wrote: You need to go to the next new record. The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#18
|
|||
|
|||
Data not refreshing on form
Hi Jeanette
THANKS SO MUCH!!!! It works. Thank you for your patience! Cheers Joy "Jeanette Cunningham" wrote: If you want that behaviour, change the code behind the button to this: On Error Resume Next If Me.Dirty = True Then Me.Dirty = False End If DoCmd.GoToRecord acActiveDataObject, , acNewRec Jeanette Cunningham "Joy" wrote in message ... Strange. When I hit the save button, the form looks the same, no changes took place. Its only when I move my mouse wheel forward that the form became blank for me to put in my next entry. I was under the impression that when I hit the save button, all values in the form will disappear. I am not sure if all my users have a mouse with a mouse wheel. "Jeanette Cunningham" wrote: Save and open in normal view - I really meant - you have finished changing the form. Close and save it. Now open it in normal view. Test to see if it works the way you want. Jeanette Cunningham "Joy" wrote in message ... The Navigation buttons are set to yes (its default) I don't seem to have as an option "save and open in normal view" or "go to a new record" in the Format tab.. I checked the All tab too... "Jeanette Cunningham" wrote: You need to go to the next new record. The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
#19
|
|||
|
|||
Data not refreshing on form
You're very welcome.
Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette THANKS SO MUCH!!!! It works. Thank you for your patience! Cheers Joy "Jeanette Cunningham" wrote: If you want that behaviour, change the code behind the button to this: On Error Resume Next If Me.Dirty = True Then Me.Dirty = False End If DoCmd.GoToRecord acActiveDataObject, , acNewRec Jeanette Cunningham "Joy" wrote in message ... Strange. When I hit the save button, the form looks the same, no changes took place. Its only when I move my mouse wheel forward that the form became blank for me to put in my next entry. I was under the impression that when I hit the save button, all values in the form will disappear. I am not sure if all my users have a mouse with a mouse wheel. "Jeanette Cunningham" wrote: Save and open in normal view - I really meant - you have finished changing the form. Close and save it. Now open it in normal view. Test to see if it works the way you want. Jeanette Cunningham "Joy" wrote in message ... The Navigation buttons are set to yes (its default) I don't seem to have as an option "save and open in normal view" or "go to a new record" in the Format tab.. I checked the All tab too... "Jeanette Cunningham" wrote: You need to go to the next new record. The easy way to do this is to set up the form to show the navigation buttons. Open the form in design view, on the properties dialog, on the Format tab, set the property Navigation Buttons to Yes, save and open in normal view, down the botton of the form will be a set of button, to go to a new record, click the button with the star or asterisk on it. That button will automatically save the current entered data and take you to the next new record. Jeanette Cunningham "Joy" wrote in message ... Hi Jeanette I just realised that refreshing according to Help files functions to " updates the data that already exists in your datasheet or form". What I really would like (not sure of terminology) is that when I hit the refresh button on the form, current data disappears, form is clean for a new entry. Could you pls help me.. Thanks Joy "Jeanette Cunningham" wrote: Joy, to use unbound form to do this, you need to create an append query that will add the data from the controls on the form to the whichever table or tables you want the data to go into. Place a save button on the form. Code the click event of the button to run the append query. It is much more work to use unbound forms - you have to write code for everything. If you use bound forms, there is a lot of built in stuff that automatically saves records. That makes it quicker and easier to use. Bound forms are one of the main benefits of using Access. How did you go with creating that bound form we discussed yesterday - are there still some things that need fixing to make it work properly? Jeanette Cunningham "Joy" wrote in message ... Hi, A beginner with Access who needs lots of help.. I've a form for users to enter, the fields are not bound to a table. I would like to create a refresh button so that user can do another addition. I've tried coding with Me.Requery on the Refresh button but nothing happens. The current data stays. I've also tried If Me.Dirty = True Then Me.Dirty = False End If What else should I try? Thanks Heaps, Joy |
|
Thread Tools | |
Display Modes | |
|
|