User Profile

Collapse

Profile Sidebar

Collapse
minjacks
minjacks
Last Activity: Jan 14 '16, 09:42 PM
Joined: Jan 13 '16
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • minjacks
    started a topic Change NameSpace in XML Systematically
    in XML

    Change NameSpace in XML Systematically

    Hello.

    We have a .xml file where before we import it into our application, we have to change the NameSpace (don't get me started on that... but we just have to.)

    Is it possible to use Access to do it systematically? I know I can import and export XML in Access. So, is there any VBA code that I could write to change the NameSpace?

    Thanks!
    See more | Go to post

  • Thanks! Turning off the error handling was very helpful.

    The code you provided did stop the 'Object required' problem, however, it wouldn't open the form.

    This is what worked for me:
    (The frmetype "1" and "2" are the option values)

    Code:
     If frmetype = "1" Then
            DoCmd.OpenForm "frm_sec_menu", acNormal
            DoCmd.GoToControl ("...name of control
    ...
    See more | Go to post
    Last edited by Rabbit; Jan 14 '16, 05:25 PM. Reason: Please use [code] and [code] tags when posting code or formatted data.

    Leave a comment:


  • Opening Control Tab based on Option Group Selection

    Hello.
    In Access 2013, I have a control on one form that has 2 tabs. On another form, I have an option group with 2 options. I am trying to write it in VBA so that I select an option, click a button and based on the selection, the other form opens to the designated tab on the control.

    Here is what I have on the Click event of the button:
    (I build some tables upon opening the other form)

    Code:
    Private Sub cmdclose_Click()
    ...
    See more | Go to post
    Last edited by Rabbit; Jan 14 '16, 12:26 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
No activity results to display
Show More
Working...