Search results

HI thanks for the reply. Forgot to mention that I had already done this and the query selects the particular record correctly. But when I then try and open the query through mail merge it prompts me for the identifier (in this case 'client ID') and when it is not entered cannot open the mail...

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 Neil Thanks for your reply. I dont have a huge number of records but I need to store changes made to client's insurance details. How would I go about storing them in the same table as I currently have the client ID as PK in this table thus only one record per client would be allowed? I want...

Thanks for the reply SJ! I have done as you said and this has got rid of the primary key violation problem. But now when I run the append query it just adds *all* the records in again! I need to be able to make the query run and store just the update for the particular record I am working on...

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...

Hi Ken! Well initially I am thinking of internal intranet use. So for that a max of 10 users. But eventually I would like to be able to deploy a not too disimilar system on the internet. As regards no of hits (well actual use of the database for making enquiries etc) I would think they would be...

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...

Yes! Its still driving me mad!

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...

re recordset not updateable Ahhh thats interesting...I presume you mean records that dont have a full set of variables...like an item not tied to a client in my case. As I do *have* those records in my database. I am puzzled though as the 'live' version seems to work fine yet when I copy it to...

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...

Thats great Uncle Gizmo thanks for that. I have tried that and it works brill but it still results in the same problem. I get errors where there is no postcode present in the database. Is there a section of code I can add to that that deals with 'missing' (or null) postcodes in the table? Or...

As an update to my own problem I have got the original query to work. Now I have created a query with my original query (that strips a full UK postcode down to its first one or two letters) and my table of possible postcode starts. I have asked the query where the abbreviated postcode = a...

Uncle Gizmo I tried and couldnt open your Pcodeanswer1.zip file. It said the databse was unrecognised? I am running access 97 so that maybe be the problem.

Update: Update to my own problem. I have created a query with my original query (that strips a full UK postcode down to its first one or two letters) and my table of possible postcode starts. I have asked the query where the abbreviated postcode = a postcode in the table to display the postcode...

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...

Whoops sorry I have got it now! I am an idiot. Many thanks for your help and also to sportsguy for the original code! DD