Search results

yes sorry. I have attached a sample of the SAVE macro. I found that it Saves only when the table is closed. Didn't do that before when I had the other code. However it still does not clear the page after I click on Save. Could you advise on what to add to make it do that please? The DELETE...

help! I used the button wizard to create my SAVE button but it is not working. It is not updating the table. My DELETE button clears the form but does not remove the record from the table. Could someone please advise what I'm doing wrong?

My control wizard was not working and I have figured out why. It was not enabled. I went to the drop down menu of the control group icon and clicked on "use wizard". Very basic but this is a big relief for me. If anyone is helped by this... then good.

Thanks vbaInet. I hope to be in your shoes someday. Helping others out with their Access 'issues'. I haven't even gotten to creating the query yet. I'm eating a horse before start that one!

I know I know. Nothing fires when I draw all over the place:o All this is making me hungry. If I wasn't annoyed with myself I'd go for lunch! Apparently, the Access I have on my machine wasn't fully installed. IT is going to fix that. Thanks again

hey vbaInet, I know it is very basic and I thank you for your patience. The wizard did not appear when I clicked the button control. I need that magic right now :mad:

hey thanks GinaWhipp:) The DELETE is to remove the entire record from the table. All the tabs will be linked to that one ID. If there is an error on the tab page, the user can correct it themselves but the delete button would be for a record that they don't want to be on the table anymore.

didn't know that but that's good since it will all go on the one record. I didn't create the buttons with the wizard. I just clicked on the button. I'm looking and can't seem to find the darn wizard.

thanks vbaInet and Plog. vbaInet just to be clear, are you saying that switching between tabs saves the updates on them...?

hi Plog, thanks for your feedback. Please bare in mind that I'm still fairly green with Access programming. I want to use this form to update a number of tables and thought it made sense to specify the table(s) associated with it...?

yes thanks plog. I did that and it worked. I came across this code: DoCmd.RunCommand acCmdSaveRecord. It seemed to work but does not clear the form afterwards. I need help with the VB code for my SAVE CANCEL DELETE and UPDATE buttons. Your help is much appreciated.

Hi, I figured it out. I simply deleted the ones that I'd pasted previously on the tab page and clicked a new button control outside of the Tab. Sorry for my ignorance but I'm learning a lot from this site already. I need help with the VB code for my SAVE CANCEL DELETE and UPDATE buttons. Your...

I have a tab control into which I inserted pages. These are what I was referring to. I moved the buttons OUT of the tab control box but it automatically extends to include the button:confused:

hi, I am still green and my VB skills are not strong. I have created a data entry form with many tabs. I DON'T want my save, cancel, update and delete buttons on each page. How can I make them universal on this form? Any help is much appreciated.

Thanks will do that

Good morning. Thanks for that vbaInet. Will I be able to use this Form for more tables then, even though I created it as a single-table form? If yes what attribute should I change for this?

the tables refer to different categories and are not related to each other. The point is to carry out independent analyses of them at some point. Right now, they are very normalised. Can I ask would you create a form having upto 20 tabs on it? Is that a good design strategy?

excellent! it worked. Thank you!! hm who knows why I chose that design, vanity maybe.:D Actually I have 13 other tables (plus forms) to create and populate so you just gave me an idea. The thought of going through this 13 more times is scaring me. P'raps I should just tweak this form and use it...

Hi vbaInet, thank you very much for the code. However I entered the code in the Combo Box's AfterUpdate event but it gave me a compile error.:banghead: Please see the attached and advise.

Hi vbaInet, yes they are listed in the same order