Links to Find, Replace, Add etc

[thewelshman1943]

Hi
I have built a hobby database for myself and friends. I am hoping to be able to use install shield or something similar to make it a stand alone as some people do not have access on their PC. My questions are:

How can I use the Logos and Link to the following from within the database (Where data is filled in etc)

Find
Add New Record
Delete Record

All these are on the top task bar but I want them showing on the database window if possible

Thank You

Tony

 

[Galaxiom]

Hi
I have built a hobby database for myself and friends. I am hoping to be able to use install shield or something similar to make it a stand alone as some people do not have access on their PC.

Welcome to the forum. Your post does suggest you have a very big learning curve ahead. Great you are taking the best step possible by coming here.

The forms in Access have a version of what you are looking for in the Record Navigator. Next step up we have buttons to trigger these commands.

However you should probably tell us more about your data structure before we go any further because this by far the most important thing for new developers to get right and it is easy to make life very hard unless it is done right.

 

[thewelshman1943]

Thank you but can anyone tell me where I can Find the "Record Navigator Button"...It is definately not in the Toolbox. I am using Access 2003.Thank You

Tony

 

[Matoco1]

Hi, welcome to the forums

It sounds like you are only using the tables within access I have uploaded a very basic DB with a navigation form and input form for the tables.
The wizards will guide you through most things like creating an input form. To create a navigation form you simply create a blank form (not linked to any table) and add buttons to it. Again the wizard will help you. have a look and see how you get on.

 

[thewelshman1943]

Hi Matoco1

Thank You for your reply and attachment. I have tried to work from but to no avail....Sorry

Perhaps if I send an attachment of an image of what I am trying to achieve might help

Although I class myself pretty good with Expression Web and Excel....Access is completely new to me

The way I have done some tables is using the import Data facility from excel...saves typing out thousands of records

I have Office97 Developer...Office XP2002 Developer Edition. Office 2003 pro and Office 2010 pro

all picked up on EBAY....I am used to Office 2003 but the idea of creating some databases to help people (Train & Aircraft Spotters) which came from a full database done in access97 developer which I bought

So I now have to decide which is really the best and easiest office to use

Thank You Once Again

Tony

 

[boblarson]

Well, it looks like you have 3 options.

1. Access 97
2. Access 2002
3. Access 2010

The reason? Because you would need to be able to deploy the Access Runtime to the users that have no Access installed. They would need to be able to install the runtime and the only versions that you have which can do that are the ones I mentioned above. Office 2010 is the one (2007 can too but you don't have it) that has the FREE runtime. All previous versions 2003 and earlier need the developer edition to be able to install the runtime.

 

[thewelshman1943]

Hi Bob

Thank you for the advice...does 2010 not have the free runtime?

Would it be worth purchasing 2007 or stick with 2002 or 97

The train spotters database I bough a couple of years back was all done in 97 and it is this database that I would like to emulate and freely distribute it

Mine is for UK Buses, Lorries and railways.....I have all the fleetlists in Excel and thought it would be relatively easy to transfer (I Thought). I am 68 and disabled but I would really love to do this and give something back to all the people that have helped when I am out Spotting

There are a couple of issues I hope members can help mw with but I think I will purchase Access for Dummies when I find out which version to use

Cheers

Tony

 

[boblarson]

Hi Bob

Thank you for the advice...does 2010 not have the free runtime?

Umm, that's what I said - that it DOES have the free runtime.

Would it be worth purchasing 2007 or stick with 2002 or 97

The train spotters database I bough a couple of years back was all done in 97 and it is this database that I would like to emulate and freely distribute it

I would be wary of creating anything in Access 97 format. It is going to be getting harder and harder to support it as Windows evolves. If you want it to last longer for people, and not have issues with loading on newer machines, then Access 2010 is probably the way to go.

 

[thewelshman1943]

Hi Bob

Got a bit mixed up on the 2010 and 2007.....I will take your advice and start using 2010 (Another learning curve)

After all I have joined this forum for advice , help and learning.

Thank You Very Much

Tony Maguire

 

[Galaxiom]

For broadest compatibility I would consider designing in the 2010 program but using the 2003 format (mdb) as the database file.

The free 2007 Runtime (and I assume 2010) will happliy run mdb databases. By sticking to this format, others that have earlier versions of Access can still contribute to your design.

 

[thewelshman1943]

Hi Galaxiom

Thank you for the advice. I think my mistake is doing everything by import into table then building the form (Very Very Easy)

I have been informed that I should be working with relationship type structure (Not very good at reading books and taking it in so it has to be Access 2003 and Access 2010 plus Access VB for Dummies) pretty cheap on ebay LOL.

your advice is appreciated

Tony