Search results

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?

That seems to be the right direction, it's now saying run time error 13 type mismatch. YC_TAG is numeric in terms of the data itself, but not numeric in terms of the data type because it leads with zeros.

Runtime Error 2465: Access can't find the field '|' referred to in your expression

Thank you, now I'm getting an error that's associated with this line: DoCmd.SearchForRecord ([acDataForm = Me.Name, "YC_TAG", Me.Name = acFirst])

I've been messing around attempting to get a field in a form to notify the person entering information if a record already exists, and allow a quick link to edit said existing record. I'm having very little luck making everything work the way I believe it should. I have virtually no...

Thank you very much, I've tried replacing the filter with a SearchForRecord command, however I'm now getting the following error: Run-Time Error '2465': Microsoft Office Access can't fing the field '|' referred to in your expression. I really know virtually nothing about VB so I'm finding...