Search results

I have designed my DB on my own screen resoloution of 1440 x 900, I know it will fit on ohters but what should the ideal be? Please bare in mind that this is for a number of differnt people and they all all use different screen resoloutions. So what should my worst case scenario be? I cant...

No, sorry thats not it, using this method you still get the grey access backround I want nothing except my form.

Yup, I want to hide the whole of the access enviroment, tiotally, all I want is the forms that I have created. I makes it all look much neater.

No, I can do that, I want to hide the whole of the access enviroment, showing only the form that is open.

Hi, my DB is just about complete and its now time ti distribute it. I know how to use the Access Packaging tool. But what I would like to know is; is there a way of hiding the whole of the access window and just showing the DB winsows that are in use? Hope this makes sense. Thanks

Afetr searching around for a while, I found this piece of codeIf Me.Dirty Then Me.Dirty = False End IfI put it in herePrivate Sub cbo_DatabaseOwner_AfterUpdate() On Error GoTo cbo_DatabaseOwner_AfterUpdate_Err If Me.Dirty Then Me.Dirty = False End If DoCmd.SearchForRecord , "", acFirst...

The code that Im using is in the AfterUpdate Event, so you maybe right but Im not sure what to put to handle it.

I have a form that I use to set the owner of the DB (so it only allows the user to create one record), with a combobox and a number of textboxes. The textboxes are populated by choosing a record from the combobox. I have found on occasion that I get the following error message: Update or...

Im sure this has been asked before but I cant find a thread. I have a form tht has an Unbound textbox on it. I need it to show the total records in a table (not the table that the form is associated to). I know I need to use the count functio but cant find a simple explanation of it. I guess...

Worked a treat, thanks for all your help. I can apply it to all my other buttons accordingly now.

Heres a stripped down version theres no tables or anthing. Open up the form frm_AddToList and tehn click on Add Contact. Thanks

Yup, I copied and pasted in your code. I will strip all out my DB and post the two forms so that maybe you could take a look, hope you dont mind!

Ok, did that but when the new form comes up I get a Message as follows: ControlTip() Microsoft Access cannot find the referenced form 'frm_AddToLists'. With an 'OK' button

Thanks for that, I've put it all in place except this piece: Private AddContactClicked As Boolean where do I put this?

I have a form with a button on that closes the current form and opens a new form Private Sub btn_AddContact_Click() On Error GoTo btn_AddContact_Click_Err DoCmd.OpenForm "frm_Contacts", acNormal, "", "", , acNormal DoCmd.Close acForm, "frm_AddToLists" btn_AddContact_Click_Exit...

I have a button on my screen that makes a hidden label visible, the label is just a little 'help' label. It dissapears again when the mouse is scrolled over it. The label appears behind some of the controls on the form but I want it be always be at the front. I cant find anything in...

Figured it out thanks anyway!

I've made my little Custom Message Box form and I have set it as a Pop Up. Which I think is the right thing to do. The problem is that I can still access the controls on the form that the MsgBox form is relating to! Is there a way I can disable everything anywhere else until the MsgBox...

Thanks guys, as I suspected, but always worth asking

Is it possible to create custom message boxes, so rather than vbYesNo, could I have it say BackFoward, or would it be easier to make a small form!