Search results

You need to create a table to copy deleted (archived) files into that mirrors the target table where the data is stored. Then an append query needs to be created using the table with the stored data in being copied to the newly created table. You now need to attach this append query to a...

I have now attached the append query to my delete button but it appends all records instead of just the current record that's open. Does anyone know how to specify a specific record to be appended?

Thanks, I've created my append query successfully but am not too familiar with VB code so I'm not sure how to attach this to my delete button. Do you have any ideas please?

I don't know if anyone can help but I have created a "delete record" button on my form and I want to be able to store that deleted record so that I can restore it at a later date if required. Does anybody know of any way this can be done in Access?

I think you took my message the wrong way as I was actually being sincere. I didn't refresh the screen, thus didn't see his reply when I sent the thank you message. I wasn't referring to rshultzs reply being more professional as I didn't try it that way as you replied first! I

nice one!

I'm having trouble displaying my form so that it is centred and is a particular size. This happens all though I have set the autocentre property as yes it still defaults to a maximised screen. Has anyone got any tips?

Thanks a lot pal, much more professional!

I'm want to be able to attach code to a button so that when the button is clicked, the new form opens and the old form (with the button on)closes. Can anyone give me any help please?

Try using #'s instead of 0's. eg- (0"####") "######"

Thanks a lot pal, I need to brush up on my SQL!

A very easy question for you guys probably, but what is the format for the "Order By" property for forms? I want to order my records by date. Any help is appreciated.

Can anyone help me to create a "Clear Fields" Button on a form please?

Thanks, quite simple really.

My search is actually based on a table, so the "Unique Value" property is not available. The field I am searching on has many different records associated with it so its not the table values that need to be unique, just the drop down list based on the table... anyone!?!

I have created a search menu with a drop down list of all data for a particular field from records i've entered. However some data is duplicated and I wish to have just one occurence of this. Can anyone point me in the right direction please???