I have a report list has outlined text boxes which are all lined up nicely to also show the total and the VAT etc. The list of items on the report have which auto resize when the item description increases and decrease.
Dim numDescHeight As Integer
numDescHeight = txtDescription.Height...
I want to open a form to a specific record with two where conditions. I have it working with one but just cannot get the syntax correct to join the two together. I have tried using AND but just cant get the quotes in the correct place.
These are the two conditions I would like to join together...
Is there a way of replying to a specific email from an Access application?
I have a module that will generate an email with a specific subject line and body with variable references as well as attach a pdf however is there a way of replying to an original email that is already in your outlook...
I am currently building a small application to create quotes for customers. I have place all of the data in a separate linked backend Access database containing several tables with the sales data, customer data and supplier data as well as some very small lookup tables. There will be a maximum...
Ive spent far too long trying to work out why this code doesnt work. This should be so easy and its not even Friday.
I want to programmatically create the RGB for the header backcolour on a form by looking up the values in a table based upon the status
The table is called 'tbl_Status and...
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...
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?