Recent content by DocManDobie

problem with doing a macro to close it on the on close is there is nothing to say open another form. You need on click close on close / exit open form required to open so when you click a button it saying close the form and when closing open the required form.

you should not be using a macro, you need a code on click behid a button or field DoCmd.SendObject , , ,Me.E_Mail, "", "", "", "" me. Email being my field which contains the e-mail address

right, you will have obviously created a button to open a form from another. That button should have the on click event proceedure, go into that and copy the information. then go into on close and create an on event proceedure and past the data in, go back to on click and create a macro and set...

Insert active X Contron, find the gif one. Once the box is on the page, goto properties then ats the bottom filename and enter the location of the gif on your C:. People usually make the mistake of trying to paste or drop the gif onto the box.

Insert active X Contron, find the gif one. Once the box is on the page, goto properties then ats the bottom filename and enter the location of the gif on your C:. People usually make the mistake of trying to paste or drop the gif onto the box.

you cannot believe it? well you had better bud!, any ideas to what the code is, also what do you mean underlying database? What are you trying to acheive, if your going to post a question try to add as much detail as possible.

Right Download this database ftp://216.122.167.138/pub/candace/candace/email/email.zip – It can E-Mail multiple recipients and also forms etc. It is a table and form on the form there are drop down boxes which let you select either a report, query, table or a form and then another which...

or set the boder to sizable then when its open in the normal view drag the corner to the desired size doooo - hommer

THIS is the exact e-mail type you need, follow this hyperlink http://www.mvps.org/access/general/gen0010.htm The form gives a drop down to choose an attachment, ie, report, table, query or blank e-mail, then to, cc, bcc and a drop down which will display all your e-mail contacts. I reccon it...

well in fact you need to turn can grow and can shrink to NO hence stopping them from changing from the height and length set in design view

Yes you can import the form just delete the form in the main DB import it, if its an old copy it should work, as your data is stored in the table this wont be effected

just a couple of things to try,on the properties goto size mode and see if it is clip, also how are you puttin the picture on the form, try setting up an object frame from the menu and when the form is being viewed either insert a picture or cope and use Ctrl V. Also try to compact the database...

add a button but when the wizard comes up cancel. goto the properties on the button and goto on click, then add a Macro, call it FIND or something, then scroll down to Find Record. Then at the ottom of the screen goto Match choose any part of field.

not sure if it makes a difference but as above with acnormal DoCmd.OpenReport "your report", acViewNormal, , "[recordID] = " & Me![recordID] Put that behind the on click and it will print the report without opening it. I presume you dont want to see the report just print it. If you want to...

stLinkCriteria = "[MaleAnimalCode]=" & Me![Combo0] The above is wrong, the above should match ie stLinkCriteria = "[MaleAnimalCode]=" & Me![MaleAnimalCode] To link the two together the two have to match and cannot be different.