Search results

Hi I wonder if anyone can help? I have looked through prevous posts and cant find any answers that fit what I need to do. For reference I am using Access 97 and Word 97. I want to be able to have a client record open in a form and click a button and for that particular record to merge with a...

Hi all I have a database that stores customer records and their associated insurance details. I need to be able to archive any changes made to that record. Currently the user selects 'record change' whenever anything is changed in the details. So I have created an append query for the...

I have been working for a couple of months now with an old access 97 database. I have managed to make necessary adjustments but its been at times a struggle. I have now been commissioned to construct an entirely new database and I would wish this to be as 'all singing and dancing' as possible...

Hi all I have a database that stores customer records and their associated insurance details. I need to be able to track any changes made to that record within a set time period ie if details are changed fine it is reported next time report is run. But if details are changed more than once in...

This seems like a very silly simple question and I am sure I am doing something very easy wrong.....but.....I cant get my subreport to display on my main report! I have tried everything I can think of. The subreport opens fine by itself either in its entirity or when I filter it using client ID...

I have made some alterations to my company's database so that variable rates are calculated on postcode area. This is currently been expanded from a query which featured 12 IIf statements to one which now features 48 IIf statements. The basis of the IIf statements are as follows: 1...

Please help this one is driving me mad! I have searched and read all the topics on the error message I am receiving but none seem to apply to me! I have quite a complex query linking all parts of my database together doing final calculations etc. This query when run (through the form) comes up...

I have recently updated my database to include a postcode recognition function. And to perform calculations based on that recognised value. The query that makes all these calculations is very large and takes a good while to run (up to a minute?). (But I need all this data in one query so it can...

I have a query that strips the first identifier part of a postcode off the whole postcode. I now need to compare that identifier with a postcode table I have and for it to give me the corresponding area code. ie I have postcode AB456DG my first query strips that to AB and then I want to compare...

I am trying to isolate the identifying area codes from postcodes and want to extract the first one or two letters from each postcode. I have created a query that uses: SmallPostCode: IIf(Len([PostalCode])>=2,Left$([PostalCode],2),"") to extract the first two characters of the postcode. But...

I have a system that rates clients based on the first two letters of their post code Background table: 'Postcode' (first one/two letters) and 'Postcode ID' (an area code 1 - 5) are fields in table 'Postcode' Also a client details form one field of which is 'postalcode'. How could I take the...

HI all hope you can help. I have a combo box on a form displaying a list of postcodes. These postcodes are split into 5 different areas and so have a corresponding 1 - 5 ID code in the underlying table (table has postcode and postcode ID only). Problem is when I select postcode and 'submit' to...