Re: Command button that deletes a field

[junior0090]

Hello I am new to all this and need help ,

I have a question that I have spent to much time researching. I want to add Pictures to my dbase and have found the solution on this site from this post "

http://www.tek-tips.com/viewthread.cfm?qid=1467575".

Now I

have 2 problems

1 the pictures will not update till I goto another record then come back to that one I would like them to update when I put the picture in

2nd I need to have a button to delete the picture to put a new one in basically delete a single field

Any help would be greatly appreciated thanks in advance

 

[CharlieT302]

Hello Junior0090,

I am not sure what you mean by "update" with respect to your first question. Although, a Refresh command may work for this. You can test this by pressing F9 after you update a picture. If it changes, you can place the refresh command at the end of the code used to update the picture.

As for your second,

right-click the button in design view and choose properties.
Using the on-click event, enter an event procedure.

Field.Value = Null
or
Field.value = ""

Where field is the name of the field you are deleting.

You can also place a command under it so save the record if you wish.

Docmd.runcommand.accmdsaverecord

Hope this helps you

 

[junior0090]

Thanks much CharlieT302 I will try it out I know I will have other questions and since I am a noob at this please bear with me if they seem not to bright