Re: micro

[microkaren]

Re: micro

I have problem with the command button, I don't know what Actions should I put in the Embedded Macro , I want to put an Edit Button so that I can edit the form that has been locked after I saved it

 

[GinaWhipp]

Re: micro

How are you locking the Form? Because you could just use...

Me.AllowEdits = True

 

[HiTechCoach]

Re: micro

If Gina's suggestion does not work for you, please post more details on how you are locking the form.

 

[microkaren]

Re: micro

It Works Thank you

 

[HiTechCoach]

Re: micro

Thanks for the update.

Glad to hear you got it working.

 

[microkaren]

Re: micro

I have another problem, I can't find the code for it...I am in another form and I want to put a button which when I click it, the other form will appear,,a blank form..Some help Thanks

 

[GinaWhipp]

Re: micro

Try....

DoCmd.OpenForm "[B]Your Form Name Goes Here[/B]", acNormal, , , acFormAdd

 

[microkaren]

Re: micro

I've tried that code and it goes to the other form but it already has details ..I want it to be a blank form .Thanks

 

[fvdb]

Make an onload event on the form you opens and put

Docmd.gotorecord ,,acnew

 

[GinaWhipp]

Re: micro

Going to Form Add should be blank or maybe I am not understanding what you mean by *blank*?

 

[HiTechCoach]

Re: micro

I've tried that code and it goes to the other form but it already has details ..I want it to be a blank form .Thanks

To help you figure out the issue it is very helpful to see the exact code you are using. Please copy and paste it here.

If using a macro, please state that and post a screenshot of what you created.

The more detail you can give, the better we can help.

 

[microkaren]

Re: micro

It works now,the code you have posted above Thank you so much GinaWhipp

 

[microkaren]

Re: micro

Why is it the code above that I have used, worked earlier,but now everytime I click the button it says that "there's a problem occurred while Microsoft Access was communicating with the OLE server or ActiveX Control" .
here's the code:

DoCmd.OpenForm "Your Form Name Goes Here", acNormal, , , acFormAdd

I really need your help .Thanks a lot