Search results

unfortunately the zipped file is too large to attach :(

mike60smart, thanks for the reply. After trying the options in the property sheet I still have not been able to remove the 0s and 1s from the chart. Its weird as I've created cluster bar charts before but had this issue. Any other suggestions would be welcome.

Good afternoon, I have a cluster column chart in a form that is displaying values below what I would call the x-axis, see photo chart1. This chat is based on a table, see table1 and 2. I wish to not display these values, but so far have not been able to find out to remove them. As a novice I've...

The_Doc_Man, many thanks for taking the time to reply. Its taken me a while to get my head round this, but still not there. I have created some formulas based on your formula and created another query to get the results I need query3. I'm struggling to create a line graph based on the results...

Morning guys, With plog's help my previous question has been resolved and I have been able to create the chart I was hoping for. I am now hoping, with some help, to create a table in form "forcast_planning2_form", that gives the number of rows in query "forcast_planning2" that are within a...

plog, many thanks for taking the time to reply. I will try and answer your questions as bet I can, 1, I am four queries away from the main data table. My database has evolved over time meaning it is by far from being the most streamlined database, but for now it works. 2, MaxofIDnumber was...

Good evening all, being a very novice user of Access I'm hoping for some help. I have a query, forcast_planning, which contains multiple rows of data for each number, 01 to 94, in column shortno. What I need is a query that shows two rows for each shortno, 01 to 94, one where Cartype is Motor...

I have a query which I need to email in an excel format to a changing list of recipients. The recipients are held in a query "email_lastturndata_qry" using the field "email_address" for the recipient email addresses. I have this code so far, Private Sub emailpostturndiameters_Click()...

Pat thanks for the reply. I have looked at your code and to be honest it’s pretty much witchcraft to me. It seems I am still grappling with the basics of dB design!

Thank you for taking the time to reply. My database did appear to be working how I wanted, but someone came up with a suggestion to improve data input that has meant the need for the joining of the two tables into one. For the time being I have used the following code: Function Resetno()...

CJ_London, the Excel file contains new and amended to existing records. As I say I'm still learning Access, would an update table allow addition of new records and the modification of existing records?

Thanks Pat for your reply, I'm an absolute novice with code, but will attempt to use your code.

I agree its seems a very convoluted way about things, but as I'm still a novice to Access it seems to work for me. table1 is the result of an imported Excel file and table2 is one where records can be added and mended. They are then brought together to give a complete history of all train wheels...

I have two tables, which are joined by a union query. This is then appended to another an other table, called joined_data_tbl. Before appending the data from the union query, I run a delete query to delete all the records from joined_data_tbl, this is because some of the data in the original two...

gpgb, thanks for your interest. I have now managed to resolved the problem by attacking it in different manner.

Unfortunately arnelgp, there is no chance of being able to modify the excel file to .xlsm, as I say I'm stuck with what I've got. Thanks

we don't have access to the server name, it could be opened on several machines by a minimum of 5 users. we can only see the path as F:\....etc we tried running the code but it keeps stumbling at For Each objRes In objFS.Resources when you try to open excel manually, it says to us...

Thanks arnelgp, problem is I haven't made it clear I'm doing this in Access, so your code stops part way through, Public Function WhoHasLockMyFile(serverName As Variant, fileFullPath As String) As String Dim varServer, varFile, objFS, varFoundNone, objRes Dim FindPos As Long ' first, get the...

Unfortunately I cannot do anything with the source excel file, Burst Report and have to work with what there is.

NauticalGent, thanks for your comments. I feel I may not have explained my situation clearly enough. I get the mileage, km, from the excel file Burst Report and using an Append query it is added to a table, as you suggest. The problem is, if the Burst Report is already open by another user on...