Search results

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