Recent content by aids2

I need a query that sorts data into 14 day blocks and then displays the results in a stacked bar chart? The data is continuously updated so I require the query to constantly sort the data without any changes to the original query.

Thanks for all the help, it turns out the , had to be replaced with $.

Thanks for the heads up, I have created 2 fields but keep on getting a syntax error using the statement below Sort1:Left([TI-NUMBER-TM] , InStrRev([TI-NUMBER-TM]],'/')) The error is with the first comma.

Thanks for the reply, I do have the report based on a query but there are 25000+ records and they dont all start with the same prefix, however the common trait is that the numbers I need to sort on are all after the second slash mark. e.g. AD/DHC-8/1 or AD/Gen/51, so the question is how do I...

I know there have been questions on this subject previously however the fix doesnt seem to work for me. I have data in a field like AD/DHC-8/1 and AD/DHC-8/100, when I print the report from this data the items are not listed sequentially like I need. I cannot edit the data as its imported from...

I have a document that is over 300 pages long, each page contains a unique page number. I need to link these pages back to a page at the begining of the document. Anytime I change the page status I would like the front document to be updated automatically. If anyone can help it would be greatly...

Sorry for taking so long to get back. I must apologise for not giving you all the answers you asked for. The field is bound to a table called document register and the field is called Updates. So I require the Audit trail data to be inserted into the table document register and the field...

Hi That is correct it is not being written to the table. I need the data visible in the table so that I can use it in reports and queries. If you can give me some pointers as to what I need to do it would be appreciated.

I have just set up a basic Audit Trail using the code shown below. However when I go to the underlying table the data isnt visible, I need a function that will allow the users to print the data from the underlying table if required. Any help would be appreciated. Here is the code used: Public...

Thanks for the information. I will try that and get back to you with an answer to see if it worked. I wasnt sure about the mdw file. I figured that I needed to move it so that I could join it later. I must assume that all of the people that use the Database need to do exactly the same thing and...

Sorry for not explaining myself properly. I can set up the security permissions on my PC but when I move the .mdb file to the network the database wont open becuase the security was not set up on the network. What files do I need to move to the network apart from the mdb file, in order to get...

This may seem to be a simple job but I cant seem to get it to work. I have a database that is used by aprox 10 users. I wish to place this database on a network and implement full security. However when I move it to the network how do I set up the security levels. I have the system working on my...

I have created a pop up form that is related to the main form. However when I add a new record to the main form the subform does not automatically get updated. The Main form has a field called serial number, and I have created a relationship with the new table for the pop up form that has a...

I have created a database that has ole objects embeded into it. However when I try to open the files on my computer I get the following message. A problem occured while ms access was communicating with OLE server or active x control. Close OLE server and restsrt outside of MS access then try the...

I am having problems with making a subform visible or not depending on the selection of a check box on another subform. I have a master form calle frmEO and then a subform that has a check box, check27. when the form opens if check 27 is selected then another subform is visible. The master form...