Search results

Thank you so much for pointing me to this. I believe that this is the actual cause of the issue but I am investigating it with my IT company to establish what version and update has been applied. Thanks again

Thanks I think the issue all comes down to the 365 office bug but I am investigating that with my IT company to establish what version and update has been applied.

The code has been working for 2 years so I was just wondering if the SQL side of things has changed to prevent the dbo prefix in the table name. However something has broken either in the app itself or with a windows update. Here is the code that calls the function (I have hashed out the...

Thanks, thats where I put it but nothing happens. I cant see the immediate window as when I open the form it runs the code and the VBA window is behind the form. Yes its a loop but its entwined in a lot of other code but this is the line that calls each table in turn but I have discovered that...

I will ask my IT department to double check it. Thanks

Dont think the tables are open as the relinking is carried out when launching the application. I will continue to investigate but the issue only started after a windows update.

Yes the tables already exist but the code used to delete the tables successfully and then relink them again so it has to be something to do with the deleting them as you say. Can you advise me which line I need to insert Debug.Print td.name please?

I have been using code that I obtained from the Microsoft Learn site and have been using this in one of my customer applications for quite some time now (maybe two years). The application opens a form that runs code that uses the function below to relink several SQL tables (it deletes and...

many thanks for this, it worked although I just had to change the line to this xlSht.Cells(xlRow, 18) = "=I" & xlRow & "*N" & xlRow

thanks the it needs to be automated for the end user.

I have modified some code that I have found on the web so that I can export a query from Access into an Excel template. In the template I have a formula that calculates two columns but I want to generate this in the code so that the formula is only there when there is a row in the Excel file. I...

I have got this working on my main form by making the main form refresh when the Next Refresh hits zero but I also want to be able to stop the refresh from running. So if they select 0 it stops the timer event. This isnt working and if I select 0 it just keeps refreshing in a constant loop that...

This is exactly what I am after, thank you so much. I will incorporate this inside the forms I have. Hopefully I will get it to work.

I am doing this, I dont think I am explaining well enough for people to understand me. I need to add 10 seconds to the last refresh time but it just adds 10 days and I cannot figure out how to add just seconds to a date and time. And then I just need to count down the seconds to the next refresh.

I already do this to get the date in the legible format like this but I want to convert it back to total number of seconds first. =Format(Now(),"dddd") & " " & DayString(Now()) & " " & Format(Now(),"mmmm yyyy") & " " & Format(Now(),"hh:nn:ss")

Thanks I will take a look at this later today and let you know how I get on. Much appreciated.

I have a form that automatically refreshes after a set time which is set by the user. They can set the refresh rate to anything from 5 seconds to 120 seconds using a dropdown box on the same form. This all works and I also have a text box displaying the date and time of the time the form was...

All of them but Ive sorted it for now as I got the customer to send me an Access database with all the linked tables to the correct database that I need and then I imported the rest of the objects into that. Not ideal but its up and running at least. I am going to try and do a DNS less table...

So the simple answer is then, I cant do it in the version that I have. I thought I had 365 but perhaps I dont then. Attached version information if you are able to advise me please.

Thats not what I get in 2019 hence my post because I dont have the Edit button in the version of Access that I have. I believe 2019 is office 365 which is what I have but it appears this dialogue box has taken a backwards step.