Search results

  1. R

    Remote Desktop Issue

    It’s been working for me for years too. Just suddenly stopped. It doesn’t matter which method I use as I’ve tried the methods you describe. The problem is, as it appears, no vba code will run for an open database when the remote connection is closed. As soon as I reconnect, the code starts...
  2. R

    Remote Desktop Issue

    I can create a task and it will open the database but the database won't run it's code. (From the on timer event on a form that opens with the database.) The code works fine whilst im in the remote session. But as soon as I close the remote session it seems VBA just won't execute. So possible...
  3. R

    Remote Desktop Issue

    Hi Again, sorry the late reply. Not been around for a few days. Unfortunately that doesn't work. Tried a lot, but really can't figure it out. So guess I'll have to try and think of another appraoch.
  4. R

    Remote Desktop Issue

    Thanks for the reply. I did already check the session time out setting and changed them to never time out. But that didn’t work. It’s as if when I end the session everything on the pc just stops. Well my code in my database. So maybe it’s an office or access update? No idea really. But unless I...
  5. R

    Remote Desktop Issue

    I have a stand alone PC that is connected to the local network. I have an access database that I use for running some update tasks over night. Basically I open the database, set a time for a form onTimer event to trigger and leave it running. Then I lock the desktop and it will run every night...
  6. R

    Send outlook reminders to multiple recipients

    Lol, not much no. :). I only had a quick look before. I think the main change was .Recipients To .To
  7. R

    Send outlook reminders to multiple recipients

    I use some slightly different coding to send emails to multiple users and it works fine. I didn't write this, I just did a google search and found it. But see if it works for you. You just need to make sure you've set your references in your VBA Module to include outlook 16 library. Dim olApp...
  8. R

    Correct way to deal with temp tables & bloat?

    Right, understood. Sorry had my mind somewhere else. Thanks for the help.
  9. R

    Correct way to deal with temp tables & bloat?

    Thanks for the reply. Sorry, I probably wasn't very clear. The update DB I have is in effect a side end. It is the side end that grows in file size, even with deleting the temp tables. The file size can only be returned to normal via compact and repair. If I want this side end to run...
  10. R

    Correct way to deal with temp tables & bloat?

    I have a back-end / multiple front-end database set up. I need to regularly update the BE with data from an external source. The tables in the external source are linked through SQL server. Updating directly from the external tables doesn’t really work as it is extremely slow and the tables...
  11. R

    Keeping file size to a minimum

    Thanks for the reply. A side end sounds like a good solution. There are a lot of other temp tables I could put in that which would help maintain the file size of the update database. Ultimately I’m looking for a solution I can just run without any manual intervention to compact & reset file...
  12. R

    Keeping file size to a minimum

    Hi All, I have a backend database that in itself doesn't grow in file size very much with normal use. However within the database is a table that updates overnight with a snapshot of various production information taken from an external source. The update runs from a separate database and...
  13. R

    Strange print problem!!!

    Hi Colin, Thanks for the tips. I'll try them out this week and feedback. Cheers.
  14. R

    Strange print problem!!!

    Yes I use the docmd.openreport DoCmd.RunCommand acCmdSaveRecord DoCmd.OpenReport "On Receipt Worksheet Rpt", acViewPreview, , "[ReturnID] =" & Me.ReturnID I am going to change it so it prints normal without opening the report first, see if that resolves it. But I just can't understand why...
  15. R

    Strange print problem!!!

    Ok, I am quite experienced with database, forms, vba etc. but have never come across this issue before. I have a form a user opens and enters data. When the user has finished entering data the user will press a command button the will print a report. This is hard coded using VBA, so I know the...
  16. R

    Sorting a Listbox with multiple columns

    Ah ok. Sorry I must have misunderstood. :) I’ve spent a number of days looking up ways to manipulate a multi select list box and the method I posted was the only way I found. So I am not set on any method other than what works :) But I have no idea how to add / remove items or move items up...
  17. R

    Sorting a Listbox with multiple columns

    Thanks for taking the time to post. Unfortunately I think you are missing the point. Your are using SQL statements to sort a list box which will have it's row source type set to Table/Query am I correct? So sorting that is easy as you say. I ONLY use SQL to populate the list box but the row...
  18. R

    Sorting a Listbox with multiple columns

    Below is the code I use to populate the first listbox. Each list box has 10 columns, the bound column is 1 and multi select is set to extended. Dim strSQL As String Dim db As DAO.Database Dim rst As DAO.Recordset Dim rstCount As Integer Dim Addline As String Dim rstWO As String Dim rstPart As...
  19. R

    Sorting a Listbox with multiple columns

    Thanks for the sample. I'm not sure how I can adapt it for multiple columns, maybe store each row source in an array as you've done in the sample. Anyway I will have a play around.
  20. R

    Sorting a Listbox with multiple columns

    Ok sure. I can't right now as I'm just about to go out. But will in a short while. Thanks
Top Bottom