Recent content by s0me0nesmind1

I've actually had someone reccomend me the User Defined Function and laying this out into an array first. Is it possible for someone to check and see if I am doing this right? Private Type AccessDBRecord ID As Integer Level As String ElementOrAttribute As String Occurs As...

Thank you so much - but damn that is confusing me quite a bit. So strFASRule (by the way, what is FAS Rule?) is testing if "FASRule" exists, otherwise it returns Null? My other point in here is my lack of knowledge on reading in the Table. I'm used to reading in Excel sheets into database...

No - we are looking to not have all the tags that have NULL and instead only write the XML tags that do have input value. I showed only part of the table - in total we have over 200 possible inputs/values/elements/attirbutes. As far as using the vbNullString in conjunction with reading the...

Right, so I have practiced with setting these with MSXML 6, an example of my code is below - my issue is with the writing of a loop to detect if the user inputed a value and if it's an element or attribute - if they did input a value write the MSXML. Private Sub WriteXML() Dim objDom As...

Hello everyone :) Looking for some help. We have a table that describes input/values that the user will select. The user will input the possible values, then they will be coded in XML based on VBA. I'm in need of some help in coding this on running a loop to check all of the fields to 1)...