Recent content by MercuriAl

Hi Cronk Thanks for the reply. I was not trying to create two new fields. I have been trying different things and have eventually got it to work by deleting the ID field in the supplying table. It still seems strange to me but hey! it works. Thanks for taking the time. Cheers

Hi all I'm having a dim moment! I have two tables each with an ID field (autonumber/PK/No Dup etc). I want to append two fields from one table to the other table. I have set up an Append Query to do this but it won't work - I get the following error - "The INSERT INTO statement contains the...

Hi Trevor Thanks for the offer - I have solved the problem by re-installing Office! Regards Alec

Hi all I am absolutely stumped with this and has anyone else had this problem? I have created a new simple db in Access 2007. In the Reports, when I go to print preview or even print it none of the numeric characters are displayed. It does not seem to matter if the character is in a numeric...

Hi Dave Thanks for the reply. I thought to link individual monthly files so that the database size does not increase hugely (the monthly csv files are 5mb each) and that the queries do not end up running reaaaally slow! Cheers Alec

Hi Plog Many thanks for the reply. I think you are right with what you say. However, I may not have explained clearly enough - the issue is not in fact with the linked tables - it is more about being able to switch any table as the source for a query by selecting a table from a list on a form...

Hi all Firstly apologies for posting in the wrong forum and thanks for moving it. Secondly, does the lack of replies indicate that I am trying to find a solution to a problem that can not be overcome? If someone can confirm that what I am after is not possible that would be a s good to me as an...

Hi all I am developing a 2010 database which is split. In the back end I am linking to csv files - with a new file every month to link to. What I would like to do (and have not been able to find a way to do at all so far! :() is each month to add the new table link in the _be and to be able to...

Hi jdraw Thanks for the response. I use copies of the databases to try so that if the links disappear I still have my data safely secured away. Anyhow, I have managed to achieve it - I found another web post with instructions (which don't exactly work) that I was able to use to assist me. In...

Hi I am at my wits end with this one!!! :mad: I have two copies of identically structured databases (Access 2003). I now wish to combine them....however they each have the following table structure; Table1 linked otm to Table2 linked otm to Table3 and Table4 and Table5 Each table uses an...

Like many of you I have stumbled across this site from time to time and managed to get most of the answers I need! So a big thank you already. I thought I would join and if I can manage to assist I will try to do so. However, I have no formal qualifications although I have been on bog...