Recent content by Jdreyfus

I'm working with 2007 btw.

The data displayed on the form. I've tried the access export as xml option and it ends up creating an xml document with all the records from the table the form is working off of. I need only one at a time.

I'm curious if any of you have come accross a code that will output to an xml file the contents of a form? I found this: Dim oXML As New clsXMLExport Dim oRS As adodb.Recordset Dim oConn As New adodb.Connection Dim sSQL As String Dim oCmd As New adodb.Command Dim sConnString As String...

I tested out exporting a form as xml and it exported information from everything within the table, not sure how to limit the export to only the information in the currently active form.

I'm curious as to whether or not something is possible within the format that I need it. Our mailing center has a pdf form with an email but that once filled out forwards data entered in an xml object with the form information, unfortunately the mail center has been less than cooperative in...

Is there any VB Process that does something similar to "=ColumnHistory([RecordSource];"Location History";"[ID]=";0))" ? I'm thinking now that I really only want a record of the comments and past locations, I've been reading a bit about how =ColumnHistory works and it seems like it's very...

dkinley, thank you, I'll have to study your example more closely to see whether I can attempt something similar. missinglinq, I can understand how quickly such a process would balloon the db outward, fortunately at most there'll only be 5 users, and I really only want a record of about 7...

Didn't think the check the template I originally worked off of, fixed the textbox thing with: =ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0)) Still would like to know peoples thoughts on how to go about saving a record of any changes to a record within a form though.

I've searched around a bit and couldn't find any helpful information on storing a history of changes within a form. I'm wondering if anyone has any idea of what the possibilities are of storing a history of revisions within a form? In my database I have a form with a precreated tab labeled...

Thank you guys so much, I tried this: Private Sub YC_TAG_BeforeUpdate(Cancel As Integer) Dim stLinkCriteria As String stLinkCriteria = "[YC TAG] = '" & Me.[YC TAG].Value & "'" 'Check Assets table for duplicate YC_TAG If DCount([YC TAG], "Assets", stLinkCriteria) > 0 Then...

Thank you so much for helping me out, I can't make sense of it worth a damn

So is it very different in 2007? Or would the code act in a similar way? I'm wondering because I'm not sure which version the code was originally written for.

Thanks for your input, I don't know what SID is, it was part of the code that I found so I assumed it was something I shouldn't mess with. If it's not serving a purpose other than to confuse things should I just delete it? Thanks for that suggestion, I'll upload my db, so maybe someone can...

I've been fooling around with various VB codes to achieve the desired affect of restricting someone entering duplicate information, as well notify and forward the person to the original record if having done so. I played around with a few different ways to go about it with no real success, I...

I wasn't sure what the Me.Name was so I left it alone, what is should it be pointing to?