Search results

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"...

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

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

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

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

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

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.

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

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

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

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

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

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

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

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

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?

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

SQL Server 2005.

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?

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.