MY FORMS ARE NOT SAVING 1

[prodcontrol]

NONE OF MY FORMS ARE SAVING...HELP


PRODCONTROL

 

[gusbrunston]

[tt]
Hi:

Do you mean that the data you enter into your forms is not saved in the underlying tables? Or do you mean that indeed after you design a form, name it, and "save" it, that it does not appear in the database window, when you select "Forms" from the list of objects?[/tt]

[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]

 

[prodcontrol]

I mean after I built my forms I added buttons to the bottom (save,new record and exit) I perfected the macros for each button but, when I enter something into one of the fields it not only doesn't save what I entered but it also does not give me the option to go to next field.

prodcontrol

 

[prodcontrol]

sorry, I meant it does not give me the option to go to a new record!!

 

[gusbrunston]

Going to the new record might depend on how your options are set in TOOLS=>OPTIONS=>KEYBOARD.

In your command button for saving a record, take out the macro and put this code in the OnClick event:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

for example.

Or, post the settings here that you have for the "save" macro (for instance).

[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]

 

[prodcontrol]

I am not using the keyboard when I am saving and trying to go to a new record, I am using the mouse. And do you have another suggestion for my save (command button) it still is not saving information on my forms.

prodcontrol.

 

[prodcontrol]

also, I am trying to link all of my forms to one table and allow dups. Can you help?

prodcontrol.

 

[gusbrunston]

Hi:

When I said "Going to the new record might depend on how your options are set in TOOLS=>OPTIONS=>KEYBOARD.", it had nothing to do with whether you are using the keyboard or the mouse!

In the menu at the top of the page in design view, click on Tools, then click on Options, then click on Keyboard. You'll see what I mean.

And if you followed my first suggestion about the code in the On Click event of your command button, and that did not work, then you must have some unique quirk in your application.

What version of Access are you using?


[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]

 

[gusbrunston]

.
There should be no reason you couldn't save duplicate records, unless you have "No duplicates" set in the one of the field's properties. There should be a primary key designated in your table design, and there should be no duplicates in that field. But record 20 could be an exact duplicate of record 19, except for the primary key field which must uniquely identify the record.

[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]

 

[prodcontrol]

I think it is Access office. I am not sure because I am at work.

prodcontrol

 

[prodcontrol]

On the whole TOOL/OPTIONS/KEYBOARD thing, I did that and nothing looked out of the ordinary to me. Maybe, I am going blind.

On the linking with dups to one table: On my primary keys I need dups ok! Roy-Vidar gave me a code to allow me to do this but, I can not get it to work. Or i don't understand it, one of the two.

prodcontrol.

 

[prodcontrol]

it is time for me to leave work! Can I contact you tomorrow at this site for help? You have seemed to be the most helpful so far.

prodcontrol.

 

[gusbrunston]

[tt]
Hi:

You probably should go back to the original thread where Roy-Vidar gave you some code, and tell him you couldn't make the code work. Roy is patient, kind and gentle, and knows 5 times as much as I do about Access and about helping people.

Or, if you prefer to post a new thread, post it in the VBA coding forum.

Good luck,[/tt]

[tt]Gus Brunston - Access2000(DAO)
Skill level based on 1-10: 7, on the way to 6, and beyond!
Webmaster: www.rentdex.com[/tt]