Visual Basic and Access

[Dinamita]

I am trying to do a simple program in which the user enters a location (latitude and longitude)into some textboxes. This information should go into the database and create a table. What I mean is, when the user hits "Save", the info should go into the database and get erased, so that the user can later enter a new location. Is there any way that this can be done? Someone told me that the information can go into a specific place in the database and when the user inputs new information into the textboxes, it will overwrite the previous info., which is what I don't want it to do. Thanks in Advance...

[JHausmann]

It can be done, you just need another field. Something like a sequence number. You can accomplish that with an auto field.

The rest can be done rather easily with two text boxes, a command button and ADO or DAO coding.

[SmithVoice]

Hi:

Could you clarify this a little? You say "the user hits save and the data gets erased" Which would make the button confusing to me.

Also you say you want to create a "table' for every lat/lon entry? Do you mean a record in a table?

I believe your solution will be very simple (databases are simply places to hold and return data from, and you can do the processes any way you want) but first please give a little more obvious functionality for us to go on.

-Smith

------------------
http://www.smithvoice.com/vbfun.htm

[JHausmann]

1) Dinamita wants the data to be written to the database and the *form* to be cleared, after the button is pushed, to facillitate more data entry.

2) Dinamita ( I'd use a pronoun but, unfortunately, American English is a bit short on singular, gender non-specific ones) wants a record for each time the button is pushed.

3) S/he (see how awkward that is!) has not indicated what should happen to the data once it's entered.

[Dinamita]

I would like to make the data to be a log of latitude and longitude, which the user can open later and see (It would basically be a read log once it is in Access). Just in case, it is a He for the pronoun.......

[LordCallubonn]

You could use a grid to display the data & have a print button to goto access & print off the report.. Would look nicer & be very functional as well..

------------------
~\*/~ Thank you....

[Dinamita]

How can I do that? Is there some code or an example of code that I can use to guide myself in order to do that grid and to print the info out into access???
Thanks

[jritchie]

Dinamita,

Ok this is so simple l caren't believe the email it has generated, send me your email location at jritchie@genauto.com and l will send back an example project on how to do this, complete with grids and print options.