Search results

Hi, the above code that JHB supplied has been working perfectly in access 2007 i have now upgraded to 2010 and the code is bugging out at the rst.edit Please see code below. Sub CreateFieldNameTable() Dim dbs As Database, rst As Recordset Set dbs = CurrentDb dbs.Execute ("SELECT '' AS...

No its not split, multiple users are opening it from the same file (location).

yes, i've checked the tables and any data that was entered whilst2 or more people have been in the database appears to save when checked after entered, but then it is not there when the database is closed and reopened. (after all users have closed the database). thanks

Hi All, I have a problem with a multi user database (access 2007) and the data disappearing from tables. This is happening when there has been 2 users in the database. One person is updating a tablel through a form, (data has been then checked it is there in the tables). However, the next day...

Thanks for explaining this. I thought there might have been something within the query or report. But this makes sense now. Much appreciated. :)

I have a button on a form that runs 1 report, i'm trying to apply a filter for selections made prior to the button being selected. TO allow for many options within the one report. I have read through many forum pages and can't find exactly what i'm looking for. I can get one filter to work...

Hi, i'm after a little more help to understand something. In my questions i asked However when I filter my report down if there is no data for a SP i receive a runtime error. 3070 - The microsoft database does not recognise '[SP11 (2012)' as a valid field name or expression. I would like...

Thank you very much JBH. It works perfectly. Thank you to everyone who offered assistance. i have learnt so much from everyones responses.:D

Thank you JHB that has all worked perfectly. very much appreciated. Although I don't understand all of the code, i do understand some of it, i'm learning.... Thank you. I do have another question about the database. Currently I update the tblSPList manually each month, I update the...

Thank you so muc JBH, your attached file looks great. I'll try it this week on my full database. I'll let you know how i go.

Thank you for your responses. I'm still not having any luck. I have made some changes in my database to allow me to post it. Mr.B and ChrisO your both on the right track of what I'm after. I have 2 issues i would like to resolve. Firstly to make my report dynamic. Ok just to clarify what...

Thanks Mr.B, i'll give your code a try this week, i'll get back to you soon. Much appreciated.

Hello! I have spent hours researching and trying different code, to no avail. Now I need to ask for some help. I have a report which runs off a crosstab query. Basically I have 2 row headings, Metric and Centre. I have 13 column headings, these are for data covering a period of 4 weeks...