Search results

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

I have a form that on open checks whether an Excel file on the server is open or not, be fore certain other functions occur. If the file is open I get a message, if the file is not open then the queries run. What I would like is to know who has the Excel file open. Can this be written into the...

Hi All, I have a linked table to an Excel file held on the company server. When I open a specific form, I have a delete query that deletes the contents of my table kmnow_tbl and then I use an Apppend query to update the table kmnow_tbl. The kmnow_tbl stores the current mileage for each train in...

Thanks for help, without I will be back, if not about this then something else!

ok, thanks again, will work on it, thanks

Thanks Minty, Forgive me, do I now use DLookup in the reports to look at this second query and I will need another 31 similar queries for all 32 axle positions on a train

May have been me confusing the descriptions; axle and wheel are the same thing. I will refer to them as axles in future. 4 axles fitted to a carriage, 16 axles fitted to an odd or even unit and 32 axles fitted to a train. 4 axles belong to a carriage, the position never changes, only the serial...

Thanks for your time Minty, As wheels get too small to machine they are removed and sent away to have a new tyre fitted, much like a car tyre. In its place a another wheel is fitted which has a different serial number. The wheel that was sent away, will in the future be fitted to another train...