Templates

A

Antonio

Hi, All

Does anyone know if there is anyway to get a template
to update a specific record?
Because when i try to update it always updates the last
record.

Tks In advance
António
 
D

Dave Peterson

It sounds like you're using a specific template. You may want to post the name
of that template (and where you got it).

It may help you get a good response.
 
A

Antonio

Hi, Dave

Using a template created by me, and it's saved on the template
folder + then i have the working template on an other directory.
If u which can send a copy of template + database.

Tks in advance
António
 
D

Dave Peterson

I'm not quite sure I understand. Are you opening that workbook as a template
and want something updated or are you creating a new workbook based on that
template?

I guess either way, I don't understand about what update a record means.
 
A

Antonio

Hi

I prepared a template that records information to an excel
database. Each time I do a save, have three options
Update existing record
Create a new record
Continue without updating

And each time I try to update an existing record, it replaces
last row filled in, and not the row I want. +

On the template have two diferent sheets, one to create new records
and the other one to visualize info from database.

Rgds
Antonio
 
D

Dave Peterson

I think you'll have to share some of your code (not the workbook).
Hi

I prepared a template that records information to an excel
database. Each time I do a save, have three options
Update existing record
Create a new record
Continue without updating

And each time I try to update an existing record, it replaces
last row filled in, and not the row I want. +

On the template have two diferent sheets, one to create new records
and the other one to visualize info from database.

Rgds
Antonio
Click to expand...
 
D

Dave Peterson

Maybe I assumed incorrectly.

I figured that since you created the workbook, you used code to update the
records.

How did you update the records?

ps. You'd find any VBA code by
hitting alt-f11
then ctrl-r to see the project explorer
then selecting your project and expanding those branches.

But if you didn't write any code, you won't find any in your project.
Hi

Where can i find the codes??
Click to expand...
 
A

Antonio

Hi

Created the workbook and database using template wizard, maybe it creates
a code. any idea where??
 
D

Dave Peterson

I've never used that template wizard. But try the alt-f11 to see any code
created.


Hi

Created the workbook and database using template wizard, maybe it creates
a code. any idea where??
Click to expand...
 
D

Dave Peterson

I just tried it. But I'm not familiar enough with it to offer any meaningful
suggestions.

Maybe someone who uses it can chime in.

Sorry.

Hi

Created the workbook and database using template wizard, maybe it creates
a code. any idea where??
Click to expand...
 
Top