Search results

  1. Snowflake68

    VBA to set height of text box on a report

    It error at this line numDescHeight = txtDescription.Height but I will try your other suggestions to see if any of them work. Thanks
  2. Snowflake68

    VBA to set height of text box on a report

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

    Solved Open form with multiple where conditions (Text Fields)

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

    Outlook reply to an existing email

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

    Backend Access database on OneDrive - Can this be done

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

    RGB backcolour

    Thank you, this has put me on the right path now :)
  7. Snowflake68

    RGB backcolour

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

    Function - AttachDSNLessTable

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

    Function - AttachDSNLessTable

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

    Function - AttachDSNLessTable

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

    Function - AttachDSNLessTable

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

    Function - AttachDSNLessTable

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

    Function - AttachDSNLessTable

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

    Function - AttachDSNLessTable

    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?
  15. Snowflake68

    Function - AttachDSNLessTable

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

    Solved Access to Excel column formula

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

    Solved Access to Excel column formula

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

    Solved Access to Excel column formula

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

    Countdown Clock

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