Search results

Problem is no longer a from issue: - Has been moved to : - http://www.access-programmers.co.uk/forums/showthread.php?p=441477

Hi, the thing is i am not using the crosstab at all now, apart from to make the table. I can open up the table and write to it fine. But when i put the table that has been made into a query it locks. How come i can write to it when its not in a query?

is choose a function, or a built in function?

Ok the table and there data types are: - Line Address: - number -PK Site - Text 6 - double 7 - double 8 - double 9 - double 10 - double Data would be 21 kilmarnock 97.64 28.64 25.84 59.46 89.40 Hope this helps k0r54

no, In the table i have 6 7 8 9 10 representing months. I have got a make table query making the table every month but everything month the table will grow and have 7 8 9 10 11. For this puticular query. I only need the last 3 months, but every month it will change. I know i cant call a field...

Hi, I have a query and in the field i have Expr1: FieldName(Format(DateSerial(2005,Month(Date())-1,1),"mm")) This will run the function below with the number 10 in (this month anyway) Function FieldName(MMonth) FieldName = "[" & MMonth & "]" End Function The problem is, instead of then...

Hi, Ok as a work around i have done a make table query from the crosstab. When i open the new table (tablea) i can type in it. All the data i want is there and its fine. I can also type in tableb which has some other data for my form. However when i then link these two tables in a query (just...

what i have just noticed that is very weird, even when i change the link through the link manager. It does not change ?????

Hi all, Ok i have modified the code a little and come up with this: - Set dbs = CurrentDb dbs.TableDefs.Refresh For Each tdf In dbs.TableDefs With tdf If Len(.connect) > 0 Then If .Name = "tableA" Then .connect =...

Sorry to be a pain but.... is some comments possible so i understand it :s Thanks for all your help k0r54

mmm, is there a way i can source from two queries without having them directly connected?

formated_monthly_cleansed_oct_05.csv Thanks k0r54

Unfortunatly i can not use a sub form, because the fields within the crosstab query change all the time.

Hi, I have a folder with CSV files in. I have a table ("tableA") which links to one of the CSV files, to be more persice oct_05.csv. Now how can i get vba to when i run the function change the link of tableA to nov_05. I know how to work out the month and ect.. the only thing holding me back...

Ok, i will have a play. Thanks

Yes, But none of the fields within the crosstab are being edited

Hi, I have a form and its source is a query. There are only 5 things on the form that can be modified, the rest is just displayed. the 5 things are within a table b. In my design view i link up table b with the already made crosstab query. (everything within the crosstab query are just for...

:mad: such an annoying quirk, ok thanks for the tip i will have to try a work around :)

Hi, Ok, firstly i have search google and this forum from top to toe and no-1 has an answer that works for me. I am running a query, now i have completely simplified it. The query is now just picking up a field called recommendations. Recommendations is a memo field with no formating or index...

Hi, I have a very strange query. I have two fields a and b. a is a text field and b in a number set to double with 2 decimal place. I am doing a query to group the text field and find me the average of field b. This works ok. my problem is that i want to find everything in field b that is...