How to delete records in Access 2007 Runtime

[alex]

Hello,

I created an Access 2007 Runtime application, and I run it with the /runtime
option. I do not see a possibility to delete a record.
1. How can I delete records in Access 2007 Runtime?
2. How can I make the menus concerning manipulation, filtering and sorting
data available in Access 2007 Runtime?

Best regards,

Alexandros

[AccessVandal via AccessMonster.com]

Will the delete key in the keyboard do?

if not, create a button on the form to delete the record.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-toolkits/200912/1

[alexandrospappas]

Is it not possible to have the standard toolbars available in Access
2007 Runtime? It is not only the delete button, that I would like to
have. It is also the sorting, filter, cut and paste buttons and
generally, I would like to have all the data manipulation
functionality in Access 2007 Runtime.

[Rick Brandt]

alexandrospappas wrote:

In every other version you have none of the built-in menu items in the
runtime. All must be replaced with custom ones created by the developer. I
assume 2007 is no different in that respect.

[AccessVandal via AccessMonster.com]

Yes, you can create the Quick Access Toolbar but I'm not sure how it will
turn out in Runtime.

Or you can create a Ribbon. Look over here and you also can do a google
search.
http://www.accessribbon.de/en/

--

[alexandrospappas]

I would like to have exactly the same ribbon and toolbars as in plain
Access 2007. Isn't there a sample application for that? Why do I have
to create my own ribbons when they exist already in Access 2007?

[Douglas J. Steele]

As Rick pointed out, the standard default menus were never available in
previous versions of the runtime: why would you expect the default ribbons
to be available in the Access 2007 runtime?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

"alexandrospappas" <alexandr...@gmail.com> wrote in message
news:3d9b92ae-7353-4d31...@r1g2000vbn.googlegroups.com...

[AccessVandal via AccessMonster.com]

As Rick and Doug points out, you can't (create) have the old Toolbar in 2007.
If you like the Ribbons as it is, than you don't need to create a custom
Ribbon. But sometimes the Ribbons may hinder your application, in this case
you may want to remove some of the buttons or even remove the Ribbons.

If you want to use the old Toolbar, try the QAT. Go to Office button - Access
Option - Customize - left combobox - select All Commands - in left Listbox -
select the commands you want and click the "Add >>" button so that it will
appear in the right listbox. In the right Combobox - select your database
Path, example "C:\MyFolder\MyDataBaseName.accdb", this will create a default
QAT whenever you open this database. And click Ok when you have finish with
the selection.

--

Please Rate the posting if helps you.

Message posted via http://www.accessmonster.com

[alex]

But in the Access 2007 Runtime unde the Office button, there are only two
options:
1. Print
2. Close database

There is no option customize in Access 2007 Runtime.
Is it so difficult to have the same ribbon in Access 2007 Runtime as in
plain Access?
Are there some sample applications for Access 2007 Runtime?

[Rick Brandt]

alex wrote:

The runtime has always been intended for developers to use for distributing
full-blown developed apps, not just for sharing Access files with people who
don't have Access installed. Fully developed applications normally include
their own custom toolbars and menus.

It is true that creating your own such items has been made more difficult to
do with Access 2007 than it was in older versions, but you simply have to
learn how to do that if you want your app to be usable in the runtime.

You would build these on a machine that has a fully licensed version of
Access 2007 on it and then run them on machines that only need the runtime.
No version of Access has ever let you build customized menus or toolbars
using the runtime.

[AccessVandal via AccessMonster.com]

As per Rick's reply.

You can't have a full blown customization Toolbar in Runtime Version. On the
QAT, maybe I have confused you with the Full version of Access 2007 instead
of the Runtime version. QAT will only work with the Full Version of Access
2007 but not the Runtime.

Have search the site I posted? See here if you didn't.
http://www.accessribbon.de/en/index.php?Access_-_Ribbons:Menus___Toolbars
This one tells how to import toolbars in 2000/2003 version into 2007. But I
think that's not what you want.

Runtime version is meant for deployment of your application where the users
do not have the administrative function or menu to modify your application.
It's where you want to prevent unauthorized changes and you deploy it as a
ACCDE. In other words, you cannot have Toolbar customization in Runtime.

So far I don't any links to any sample with customize Toolbar in a Access
Form that will work with Runtime. Creating an application with a customize
Toolbar is possible but you gonna need lots and lots of codes and if it still
don't work, you might as well give up. Look into Access Help for commandbars
if you really want to do it.

--

[alex]

I probably have to ask differently:

How can I have the delete, filter and sortig buttons found in plain Access
2007 under the Home menu, in Access 2007 Runtime?

I think, these are basic functionalities, that a user wants to have in
Access 2007 Runtime. Isn't there a sample application providing these
functionalitie in Access 2007 Runtime? If not, I urgently ask Microsoft to
make one, because, without these functionalities nobody will accept an
application for Access 2007 Runtime.

[AccessVandal via AccessMonster.com]

If you need the functionalities, you have to install the licence edition of
Access 2007 instead of the Runtime into each users PC.

It by design.

The reasons of disabling sorting or deleting is because of the
event/subroutines/modules or even the Enforce Referential Integerity Cascade
Deletes/Updates. Failure of deleting a record can cause Runtime to shutdown
and even a possible corruption to the database.

Even if you request MS, they will most likely to give you the link to create
your own customized Ribbons. See here.
http://msdn.microsoft.com/en-us/library/aa338202.aspx

I can understand if your database is a very simple spreadsheet design like
Excel but Access is not Excel. In Access, if you don't have any reasons to
delete records, you leave the records alone in the Tables. We use the Forms
to hide the old records, so there's no need to delete any.

--

[Rick Brandt]

AccessVandal via AccessMonster.com wrote:

> If you need the functionalities, you have to install the licence edition
> of Access 2007 instead of the Runtime into each users PC.
>
> It by design.
>
> The reasons of disabling sorting or deleting is because of the
> event/subroutines/modules or even the Enforce Referential Integerity
> Cascade Deletes/Updates. Failure of deleting a record can cause Runtime to
> shutdown and even a possible corruption to the database.

I'm sorry, but WHAT?

None of these abilities is in the slightest way unavailable in the runtime.
All that is unavailable is the built-in menu that provides one way to access
them.

One can invoke any of these from code or macro and if you want them to be
available from a menu, toolbar, or ribbon you just have to build a custom
one rather than relying on the ones that are built in.

Nothing at all to do with RI, cascading updates/deletes or shutting down the
runtime.

[AccessVandal via AccessMonster.com]

Rick Brandt wrote:
>I'm sorry, but WHAT?
>None of these abilities is in the slightest way unavailable in the runtime.
>All that is unavailable is the built-in menu that provides one way to access
>them.
>One can invoke any of these from code or macro and if you want them to be
>available from a menu, toolbar, or ribbon you just have to build a custom
>one rather than relying on the ones that are built in.

I believed that the OP doesn''t want to create the custom menu or Ribbons. He
want it avialable in Runtime so that there's no need for a full licence
edition. We have already explained that to the OP.

>Nothing at all to do with RI, cascading updates/deletes or shutting down the
>runtime.

True, but a question that will remain in limbo.

--
Please Rate the posting if helps you.

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-toolkits/200912/1

[dave]

"alex" <al...@discussions.microsoft.com> wrote in message
news:2D3299F9-CA1F-4F4A...@microsoft.com...

[James Ford]

I do not see possibility to delete a record..... mmmm?

"alex" <al...@discussions.microsoft.com> wrote in message
news:2D3299F9-CA1F-4F4A...@microsoft.com...

[James Ford]

I do not see possibility to delete a record..... mmmm?

"alex" <al...@discussions.microsoft.com> wrote in message
news:2D3299F9-CA1F-4F4A...@microsoft.com...

[Jakob Ashley Megan]

"alex" <al...@discussions.microsoft.com> wrote in message
news:2D3299F9-CA1F-4F4A...@microsoft.com...

[Jakob Ashley Megan]

fdbicrosoft.com...
> Jakob
> Alexandros