Recent content by dewsbury

Thank Micron and theDBGuy (especially). Despite my less than clear question you have resolved my issue.

Hi, I have a table called tbl_Period with ONE record and ONE field called [Period]. I also have a form that has a combo box called "Choose Period". QUESTION: How do I set the default value on the form combo box = [tbl_period].[Period] Basically, I am looking to put a default value into...

Hi David , Thanks for your response. I will use my access database to maintain requests that I may get from hundreds of outlook users. I.e. they email their request to me and it goes directly into my access table. I need a field on my access table to hold the email address of the sender...

Hi, Greetings from Ireland! I am hoping to resolve this with out the use of VBA etc. I have a single access table which I intend populating by the receipt of outlook emails from users. The automatic populating of the access table based on outlook emails seems to work fine. I would like to...

Greetings From Ireland ! I am joining two forms successfully (matching on names) and the wizard generated the code below. stLinkCriteria = "[surname]=" & Me![surname] However,I want to match using wildcards. E.g. "smi*" should match to "smith". How do I amend the syntax of the code...

Hi all, I have a single table database. The main form links to a subform. Both forms only display data from the table "main". I have a "Button" on each line of the continous subform which when clicked should set the [main].[group]=[main].[id]. This update should occur for the single record...

As the original poster I vote top marks to "RedNeckGeek". His code worked first time and while not very pretty (!) it did the job! You can all have a beer with RNG now! (I am sure that the other solutions worked as well)

Why denormalize? A bit difficult to explain. Here goes; I am stuck in the middle of 2 sets of users. I have been presented with the data in this format but a third party needs it in another format. It has to do with the printing of a mailing list - where some letters will be addressed to more...

I tried to sort this in work today but failed! It looks easy ..but?? TABLE1: Account Name 1001 John 1001 Paul 1002 Peter 1003 Joe 1001 Liam 1001 Cecil 1002 Oscar Convert the above table to; TABLE2: Account Name1 name2 Name3 Name4 1001 John Paul Liam Cecil 1002...

Thank you all. It's easy when you know how ! PLenty of useful info provided. My coding will be very simple so the debugging will be easy. Thanks again.

Hi, Beginner here with programming background. I have a few little bits of code that are activated on form properties such as "Before Update" or "On Double Click". These bits of code generally work well. However, now it does not! How can I debug my code? I have tried experimenting with the...

As suggested by the above post I am checking out the Jaro Winkler algorithm. I read about it on Wiki and it seems to be worth a try. Does anybody know where I could download the algorithm or similar? Thanks.

Thanks for your responses. I am working for a large financial institution who want to do a mailshot to clients. We do not have post codes in Ireland- which makes a big difference. I will research the algorithm mentioned. I was also considering looking for the word "county" and "co." and...

Hi, I know there are various software packages to assist in de-duplicating and cleansing names addresses. Aside from this has any body got ideas about how to do this for about 100,000 names & addresses in pretty inconsistent state. Obviously I need more than just a direct comparison of one...

I am trying to delete the existing table called "test". See the last 3 lines of the script below. (I am showing the full script in the unlikely event that it is relevant). The "drop table test" is not accepted as a valid command. It goes yellow in the editor indicating an error. Why ? Option...