Search results

  1. D

    emulating a stored procedure

    If you plan to use Access and Excel to do this you are going to utilize network bandwidth unless the both the front-end and backend are off the network. Unlike SQL Server that has a service running which does all the heavy lifting on the server side, Access has no such service running, the...
  2. D

    Post XML to a URL inside Access

    I agree with spikepl, if the response is very simple it would be easier and faster to just extract what you need from the response text, if however it is very long and complicated with multiple embedded structures/nodes, then loading it into a navigator of some kind might be useful.
  3. D

    Post XML to a URL inside Access

    You could use a DOMDocument object to parse the XML. http://stackoverflow.com/questions/11305/how-to-parse-xml-in-vba
  4. D

    Post XML to a URL inside Access

    Lots of questions here, and a lot to consider. 1) This looks like a viable way to send/receive your data. 2) The Response = objXmlHttp.responseText is where you are going to get the formatted response, you would need to load that Response into an XML document, or parse it yourself. Here is a...
  5. D

    Question Changing SQL user pw causes ODBC connection issues

    This happened to me on an older version of SQL server as well, I deleted the DSN and re-created it, that worked for me.
  6. D

    Question Database Placed in a State

    This happens to me anytime code changes have been made, I think Access elevates the lock permission to exclusive and won't release it until the database has been closed and re-opened. At least that always works for me, not sure if your issue is related.
  7. D

    Mobile access of Access

    Any objects you create in Access, forms, reports, code, would require some version of access to be installed on the host system. To my knowledge only the windows CE platform has a mobile version of Office available. Now that's not to say you couldn't create a web based database as others have...
  8. D

    Open App to spesific size

    that code is C#, here is the MoveWindow API in VBA. To get the handle to the program you will need to use the FindWindow API to locate the window and get the handle to the program since the Shell command doesn't return a process or window handle. Private Declare Function MoveWindow Lib...
  9. D

    Working on an SQL Insert / Update combined

    There is no one query type that can do what you want, you need to run 2 seperate queries as you're doing, one for the update, one for the insert. If you don't want duplicates either key the table to prevent them, or join the table to itself in the insert query and only insert records where the...
  10. D

    Synching Access 2010 database for Remote Users

    Well ultimately they need to access something that has access to your network share. Web database is probably your best route, another option would be to build a seperate database for the end users, and have them (or the program) export data and email / ftp it to a place where a process on this...
  11. D

    form checking to see if another form is open

    This function will = 0 if the form is closed, 1 if it is open. syscmd(acSysCmdGetObjectState,acForm,"FormName")
  12. D

    Automatically updating/relinking certain references?

    Apparently the code is trying to compile before you're able to check or change references, it would seem this can't be done through VBA on a remote database that has a missing reference.
  13. D

    Automatically updating/relinking certain references?

    Maybe try a simple approach to start Dim ref As Reference Set ref = a.References![Office] a.References.Remove ref
  14. D

    Automatically updating/relinking certain references?

    It's not a BuiltIn reference is it?
  15. D

    Automatically updating/relinking certain references?

    Maybe try this. x = 1 For x = 1 to a.References.Count If a.References.Item(x).IsBroken = True Then set myref = a.References(x) a.References.Remove (myref) Else Debug.Print a.References.Item(x).FullPath End If Next x
  16. D

    Automatically updating/relinking certain references?

    I would think application.References.Remove
  17. D

    Automatically updating/relinking certain references?

    Well it may not be possible then to programatically update just the path, you could try removing the references then remotely using the AddFromFile method of the reference object. Bottom line though this is dodgy business and I am not surprised it is difficult and perhaps not possible to do...
  18. D

    Automatically updating/relinking certain references?

    In this case it doesn't, references is part of the application object, not the database object. You need to declare a Access.Application variable then set that equal to your database.
  19. D

    Automatically updating/relinking certain references?

    many options there, but if you know the old path and the new path I might try something like If Application.References.Item(x).FullPath = OldPath Then Application.References.Item(x).FullPath = NewPath end if you could throw that into a for next loop, or use any other method you'd like.
  20. D

    Automatically updating/relinking certain references?

    Hmm, if you have an autoexec macro or form set for startup that is more difficult, you can look at using API's to simulate holding down the shift key, but aside from that I don't know of a way to disable that code from running.
Back
Top Bottom