Recent content by NathanSavidge

Hi Bob, This is my point. Sorry if i didnt clear it up. I work for a global investment bank that need to roll my database out accross the Uk and then overseas. We have users who will just view and users who will view and update, so i only want the database to replicate when users have saved...

Hi Bob, Yes, completely agree, the only problem is the users are on the network, but the network where i work is ludicrously slow, so to query some data it takes about 30 seconds between forms, so i wanted local replicas to allow them almost instant viewing, and then a synchronise on saving...

Hi All, I have a networked DB that i want to replicate and have the users of it have a replicated copy on their C drive, and replicate to the master (Q Drive). So Q Drive is where all local changes are made to and the C drive versions are the ones the users will edit. Am i right in...

Hi, I am trying to use one access database, to do version control etc on a users database before opening it. If all is ok, i use dim objAccess as access.application Set objAccess = CreateObject("Access.Application") objAccess.Visible = True objAccess.OpenCurrentDatabase strUserPath &...

Hi, Yesterday i wrestled and finally got an OLE chart in my access form where it is linked to data from a query. I need to change the datasource to be the width of rst.recordcount, to get the data, as i am presenting by week/month/quarter. I have been messing about with...

Hi, I got it, thanks for your help it was me.OLEOBJECT.Object.Sheets(2). Thanks

Hi Trevor, Thanks for that. I was messing about with Excel Chart as this came in. The problem i have with it is, that when i link it to my datatable, it get the error The Operation on the OLE failed. Could you advise what this means, i have put the data in the excel sheet "Sheet1" in the...

Hi, Can anyone help. I am trying to put in an Open, Close, High, Low stock chart in an access form, but do not have the option on my chart types. Does anyone know of a web site where i can look to see how to set this up. I have the data ready, and it works when passed to excel, but cant see...

I am trying to find out the latest change in an audit table, by using the max function. However, it is not working, and i am having trouble with a sub query as i have 2 criteria, the task ID and the date changed. I want to know the latest change new_value in a task using task_ID, based on the...

Hi, Does anyone know a good place to look for SQL/Table structure to set up a tiered organisation structure. My table is as follows Team_ID, Sub_Team_Parent So with 1 0 2 1 3 2 4 0 5 1 I would like to see (thrown 5 in there as almost there, but this is where it fails with entries like...

Hi, I have a sub form, that has a control Volumes, which is where the user enters the volumes of a task they have done. When the exit this text box, if there is a value in the expected duration box, then it multiplies volumes by expected duration and places in total time. If not it will just...

Hi I have a database where there are several teams. Teams can exist on their own, or be a sub team of a team, or be a sub team of a sub team. Currently i am running at 3 tiers, so i can expect data like this Report Team A Member A Team B Member B Team C Member C Team D Member D In this...