Search results

I am currently working on a report which i am hoping to use as a mailshot, The issue i am having is i have 9 text boxes containing address details in a letter format as shown below. If one of these boxes is null then i am left with a gap in the address which is not ideal for a professional...

I have tweaked the code you gave me and i have had success, Thankyou for your assistance and i have pasted the code that worked below, Cheers again =DCount("[Premise]","[D - QrySelect100]","[Name 1/Last Name]='" & [Combo0] & "'")

Right still nothing i am getting An Automation object error with the statement Me. Unsure as to what this is but i do know it still gives me an error wheras my original code just gave me 0 and nothing more.

all names are correct but the fix u have given me gives me an error in the text box which it is using as a control

I basically have 2 questions, First question is can Dcount work based on a query as opposed to a table and then if it can work on a query could someone let me know why my following dcount code is not working or if i am just being a little simple, Basically i am trying to do a count based on a...

Cheers that worked great

Sorry i really didn't explain myself very well previously, Is there anyway i can have this done on open via vba coding for the form itself ifso do you know how the code would look?

When u say movesize does it?, sorry bit of an access newbie here can you explain pls?

At current i have a form which has an action taken combo box, on the selection of a specified action taken it opens a new form to be populated but..... and here is where my problem lies, The form it opens it opens in the center of the previous form wheras i need it to be opened in the right hand...