Recent content by Davidekreed

Thanks :)

When generating a report, can I set any memo field to be resized according to how much text is actually in the box. This will help cut down paper! If so, can you please give me step by step instructions so I can set it up. Much Thanks! :)

Thanks Steve, but no matter whay I do it still returns the value of the SuburbID and not the Suburb name. PLEASE PLEASE I need your help! The problem seems to occur only in the Label Wizard. Please reply, many thanks, Dave

Hi, I have Post Code Table which lists ID, Post Code, Suburb, State etc. In a form, I use a combo box for suburb which then automatically returns the related values for post code, state etc in the form and back in the table. My problem is, when I do a mailing label and pick up the 'Suburb'...

Yeah thanks Travis, I have done that and it helps the user select the right one. However, for a fast data entry user that might not be myself, I would like him/her to be prompted to make sure a suburb that has duplicates in many states is the right one. This is because when you type in the...

I have a combo box which selects the suburb names and then automatically fills in state, region, post code etc. However, there are duplicate suburbs in different states. Q. When the user enters a suburb name on a form which may be in more than one state, how can I then prompt the user to...

Hi, Thanks for your quick reply Where do I put that code? I already use the 'afterupdate event' to automatically insert address info based on the data entered. I tried putting your code at the end, but it of course left the field blank before I could save it. thanks David

Thanks Jack...I'll check it out!!!

Hi, I have a contact db with Combo boxes for the Suburb and Post Code fields which automatically look up info in a table and inserts state, country etc into the form. However, when I go to enter the next record, the two combo boxes have the info in them from the previous record. How can I...

Thanks Jack for your speedy reply. I made it work on a small test database, and now I will try it on the main database. You might like to have a look at my question posted today in the forms section. In simple terms, when entering data on the form for a post code or suburb that is not in my...

I have two combo boxes in a form, one for post codes and one for suburb name which automatically fill in details for state and the remaining field, post code or suburb (whichever was not entered) The code looks like this, where Combo20 is the name for suburb, and combo 22 is the name for post...

I am in desparate need of help with creating a short cut for entering data, particularly wrt addresses. I, like many others would like to enter EITHER a post code number or a suburb name in a form (whichever one I have), and have the city, state, region and remaining post code/suburb field...