Search results

  1. J

    Exporting table data from a form to xml

    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...
  2. J

    Question regarding exporting form fields as xml

    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...
  3. J

    Storing form history

    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...
  4. J

    Need some help to figure out what's happening

    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...
  5. J

    Need some help with my code/code syntax

    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...
  6. J

    Data Type Confusion

    I have a numerical field that's format is ##-#### much of the time the field begins with zeros, for example: 00-1234. My issue is that I've left the data type for the field as text because it allowed me to enter whatever I wanted, however I have a vb code that doesn't work with a text field, I'm...
  7. J

    Noob needs help badly

    I've been attempting to have a field within a form check whether or not a duplicate record exists and deliver a message immediately after you navigate away from the field. I'm uncertain whether the code I have is what I really need, it's the only code so far however that's produced something...
  8. J

    Duplicate data linking

    I'm pretty new to Access, I've been working with it for about three weeks now. My issue is that I have a form for entering assets and have set the primary key to a unique id tag we use for inventory, that's all well and good for preventing duplicate data, however I'd like to know if there is a...
Back
Top Bottom