Search results

  1. S

    Import Word Form Data Issue

    No, they are both just text fields. The tmpSIRs table is temporary table I use to pull the data into before I insert it into the primary table. As such, I just pull the text. One correction to my post, the "-1" only happens when the user selects "Yes" on the Word Form. If they select "No"...
  2. S

    Import Word Form Data Issue

    I am using the follow code to import data from a Word form into my MS Access 2010 DB: Set dbs = CurrentDb Set rst = dbs.OpenRecordset("tmpSIRs", dbOpenDynaset) With rst .AddNew 'Incident Date/Time ![sirIncidentDate] = Format(doc.FormFields("sirIncidentDate").Result, "Medium...
  3. S

    Query Outlook Folder Issues

    Hi All I am working on a form that has a list box that display's emails from an Outlook 2010 Inbox. The record source for the list box is set to a query. With this query, I am using the following connection string: Outlook...
  4. S

    Output XML with Nested Loops

    Where I am connfused on is how to the write the recordset statements for the loop for the Persons table and the nested loops for the addresses and schools. Here is what I think I need: Dim MyDB As Database Dim MyRS As Recordset 'Recordset for Persons Table query Dim MyRS1 As Recordset...
  5. S

    Output XML with Nested Loops

    I need to output a table and its related tables to a xml file. I am using output/Print # method to do this. My problem is I need to loop through the primary persons table (tblPersons) selecting records that have been flagged for export (chbExportFlag = True). What I can't figure out is how to...
  6. S

    Charater Counter

    All... Looking for some suggestions. I use the code (below) to give users a running count of the text they have typed in a field. It writes the results to an unbound text box called CharCounter. It works just fine. However, I've got dozens of text fields (60 altogether, actually) that I...
  7. S

    XML Export using XSLT

    I didnt post the entire xml structure. For reasons that I can't go in to, I can't cut and past it so I would have to hand type it in. I just typed out the first few lines.
  8. S

    XML Export using XSLT

    Yes I did try the wizard. However, it does not come out in the correct syntax. Renaming the fields wouldn't work either given the complexity of the xml schema I need to go to. I know I can code the xml using the print command in VB. However, that is a very tedious process. I assumed that...
  9. S

    XML Export using XSLT

    I generally don't just ask very general help questions but I am at a loss. Using 2007, I need to export a table/query to specific xml format. The vendor has provided an xsd file. However, I need to transform the table in Access into the xml format required. From what I understand, I need...
  10. S

    Printing Pictures from an Oracle BLOB

    I need to development a report that prints ID cards in Access 2003. I have a OBDC link into an Oracle Database (11g) which works fine. The pictures for each person are stored in the "PICS" fields as OLE Objects (BLOB). However, I can see them from within Access on Forms, or on Reports. How...
  11. S

    Multiple Email Attachments

    Thanks darbid. I saw this code. However, the attachments are stored within the database--that is the pathway to the file is stored in the system, the files are stored on a network share. What I want to do is pull up a list of the attachments for a record with a checkbox by each attachment...
  12. S

    Multiple Email Attachments

    I am using the follow code to send emails from Access 2003 to Outlook 2003. It works fine. Now, however, I need to be able send to multiple attachments that the user selects from a sub-form. Does anyone know how I modify this function to attach 0 to many attachments based on the input from a...
  13. S

    Error # 0 was generated by

    I am idiot. I was so focused on the code that I posted that I didn't bother to look at the modules that it used. The sendemail function didn’t have an "Exit Sub" command so it was looping through the error handler and was forced to display a error message notice when there was no error--hence...
  14. S

    Error # 0 was generated by

    I've inherited a db with a function that imports information from a Word form, permits the user to check the data and then submit it into the database. After it has submitted into the database, it generates an email with a Word file attachment to send back to the person who submitted the form...
  15. S

    AutoNumber Column Question

    Sorry two last questions: 1. For full indexing, you need a primary key field for each table. Is there any value in keeping the non-clustered indexes once you have created the catalog file? Or should I just drop them? 2. In my data set, I have a field that is just time in the this format...
  16. S

    AutoNumber Column Question

    The later is the case. We need to be able to search multiple weighted words, and words derived from a root. Is there a way to determine how big the full-index catalog file will be?
  17. S

    AutoNumber Column Question

    I do have access to mangement studio. What about full-text indexing? The problem I am dealing with is that I have a huge amount of data that needs to be searched in a number of different ways. While I could create indexes for everything, it seems that full-text indexing might be better. What...
  18. S

    AutoNumber Column Question

    SQL Server 2005.
  19. S

    AutoNumber Column Question

    Okay, would the code look like this: CREATE TABLE PEOPLE_TEMP ( people_key BIGINT IDENTITY, other columns... PRIMARY KEY (people_key) ); To copy the data from people to people_temp, would I use a BULK INSERT command, or is there a better way to do it?
  20. S

    AutoNumber Column Question

    It was a data dump from an old system we have. Actually, this is the smallest of four tables. The biggest has over 950 million rows.
Back
Top Bottom