Recent content by ahmed_optom

  1. A

    Weird BrowseTo Runtime Error 6054

    Just for the sake of others, I never did solve this, and I confirm this is simply an access bug. If you write any perfectly working dlookup then use browseto command, you will get a rte. Either can work separately without issue, but not together.
  2. A

    Unbound Multi User DAO Recordset locking

    If your using an unbound form, you dont have to worry about multi user access issues. I take it this is for data entry? For example, when the user clicks your save/add button, then you will need to vba a new record and all data will be stored on the table at that instant. I used to have a...
  3. A

    Weird BrowseTo Runtime Error 6054

    Well, this bug is back again. Same thing happening, even though I havent touched the code from last time. Im beginning to think my version of Access is punishing me
  4. A

    Weird BrowseTo Runtime Error 6054

    Hi guys, Arnelgp, I changed all the dlookups to the format you suggested, and that has fixed it! thanks again.
  5. A

    Weird BrowseTo Runtime Error 6054

    Arnelgp, There are no errors when I do it my end, even with explicit. There is definitely something that is causing the browseTo to misbehave though, as if I comment that section out, the browseto works fine.
  6. A

    Weird BrowseTo Runtime Error 6054

    Thanks Arnelgp, I will try that and see if it helps. I have further isolated the issue. The code below always triggers the issue of breaking the browseto command. If Me.Check461 <> -1 Then 'want the email sent, box not ticked 'check if email is setup. If IsNull(DLookup("[EmailAddress]"...
  7. A

    Weird BrowseTo Runtime Error 6054

    Hi Arnelgp, no, im not using set in that manner, here is the preceding code Dim dbVideoCollection As Object Dim rstVideos As Object Dim fldEnumerator As Object Dim fldColumns As Object Set dbVideoCollection = CurrentDb Set rstVideos =...
  8. A

    Weird BrowseTo Runtime Error 6054

    There appears to be a weird issue with the browseto command. If I use it in isolation, it works as expected. If the same browseto comes after any vba that includes the use of "set", then it gives a runtime error 6054. my browseto code is as below: DoCmd.BrowseTo ObjectType:=acBrowseToForm, _...
  9. A

    Catch linked sql table errors?

    You cant open any records unless you connect to a database, the error prompts in my first post happen when attempted to connect and refresh the dsnless connections. So doing anything with any records is not going to help, as the problem happens before that. So its a real catch 22.
  10. A

    Catch linked sql table errors?

    I hear you Isaac. The issue was I was unable to find a way to ping a sql server which is completely locked down, eg all ports except the sql ports are closed, and I cant find a way to "ping" the sql port from ms access. The system I have developed doesnt connection on load, but when it does...
  11. A

    Catch linked sql table errors?

    Hi Isaac, Its not what I need. I need a way to either check the backend is reachable before attempting to connect to it, or suppress/catch the connection error. My googling has concluded the error prompts are not hide-able, and within access I cant check the server status unless I connect to...
  12. A

    Catch linked sql table errors?

    Thanks, Thats a different angle, I already have a vb.net updater, I could just add your ping check to that, and use it as a launcher instead of having a shortcut to the front end. It would then act as an updater, server status and launcher. Its a shame so much effort is needed just make...
  13. A

    Catch linked sql table errors?

    My code works fine, so I can connect to my sql server and access the tables stored there. My issue is this, if for whatever reason (no internet or firewall issue etc), the front end cant connect to the backend, then you get a horrible timeout message, and then next screen is even worse. It...
  14. A

    SqlAzure BE: possible to use native queries from the propriety sheet to populate controls?

    It will work fine. I use Azure/Sql BE, sometimes odd things need to be changed, like if you have more than one "sort" then it can throw a RTE. Luckily though going to sql/azure is largely a smooth process with plenty of improvements in terms of speed/security/stability.
  15. A

    Draw on a form?

    yes, I have been playing with it for hours. His method now also rte. I believe something in access or vba changed over the years that means the code is no longer correct. Dim v As Variant Dim b() As Byte Set v = Me.InkPicture6 b = Nz(Me.Signature.Value, "") ' b =...
Top Bottom