Recent content by vertue

jeremie_ingram Thanks for the reply but I was mistaken. I have the form opening in min mode. It was the form that was not opening centered and not the message. I can center the form with no problem. Geeze I am dim. Trev

jeremie_ingram Thanks - Understood

jeremie_ingram I did it in straight forward code. If MsgBox("Are you sure you want to exit?", vbExclamation +vbYesNo ) = vbYes Then DoCmd.Close

Are there any benefits in always building your forms from scratch straight in the VB program. Or is this like reinventing the wheel.

Wayne Thanks Wayne. You have now put me on the right road.

I have set a warning message to come up when an entry is about to be deleted. At the moment the message box does not come up dead center of the form, but more to the right. Do I have to set the X Y coordinates for the message box or is there and easier way? Trev

Explain You are all so good here at answering questions, that I should explain why I ask questions that seem not to matter. I am learning Access (as you know) and as I do something I come across a "what if" question. It is not really important whether the question is relavent, as I know most...

Re Using If I start to make an entry and then decide I did not want it the data base moves to the next ID. So I would want to go back and use the previous ID. ie if I started to enter on #16 then decided I did not want that entry the next entry would be #17 and therefore #16 was not used...

Thanks Wayne Thanks

Wayne Thanks for your promt reply. I was going to use the Autonumber as CustomerID numbers in my make believe database. I guess I will have to code them. One more question. If I delete a record are all the bytes from that record gone from the database or is the space still there but un-used? I...

When I delete an entry I would like the number to be used again. ie If I delet the entry number 17 I would like the next new entry to be given that number instead of the next one which could (lets say) be number 154. Is there a way of doing this automatiacally so that all numbers up to the new...

Hi I am posting this to show how new I am at using Access. I am building my first make believe database for practise. My problem is this. When I open a form to enter data. I have it going to a new record. I have two problems with this that could be mended with one answer. I do not want the new...