Search results

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

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

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

I know this is a simple procedure but I cannot figure it out. I need to insert a new column into an existing table. The column needs to be an auto number, starting at 1 and counting up by 1. In addition, this field needs to be a primary key for the table. Currently, the table has 150 million...

Using bookmarks, I am exporting some data from by database to a Word document, which is then attached to an email. The receipt of the email is suppose to respond the information contained in the document using text fields and five comboboxes and email back so we can automatically import the...

I am using Access 2003 as a front-end with SQL Server 2005 for a back-end. I need to store documents (pdf, jpg, doc, etc). How do I do it with SQL from access? I would like to store the documents SQL and not as a reference. Thanks.

Please help me. I have spent two days searching this forum and others looking for the answers to the following questions. This is driving me nuts. Environment: Access 2003 frontend with MS SQL 2005 backend Questions: 1. Using VBA, how do I use a server-side query to control a form? 2...

I have a one to many question. I am in the middle of converting an Access database over to MS SQL 2005. I am converting all of the queries into pass though queries. One of my queries takes a sub-table that has many fields related to the primary table and concentrates them into one field using...

I have looked at a lot of treeview examples and none of them do what I need. Basically, I want a user to able drill down to a specific office using a treeview. That office would then be stored in the tblMain under the "location" field. The treeview should be based on the table...

I have a main form (fmnMain) with a one to many sub form(sbfmnContactInfor). The main form is office buildings and the sub form displays contact inform for each location On the subform, I have an unbound list box that lists the current entries for that location. I would like to be able to...

I have a subform (sfmIncidentDetailsUpdates) with a field (TextDetails) with the following code in the on exit event: Private Sub TextDetails_Exit(Cancel As Integer) Dim strSpell strSpell = Forms![IncidentForm]![sfmIncidentDetailsUpdates].Form![TextDetails] If IsNull(Len(strSpell)) Or...

Hi All, I am using the following code (thanks ICEZEBRA) to spell check certain fields upon exit. Private Sub YOURFIELDNAME_Exit(Cancel As Integer) Dim strSpell strSpell = YOURFIELDNAME If IsNull(Len(strSpell)) Or Len(strSpell) = 0 Then Exit Sub End If With...

I have spent the last couple of days trying to figure out how to make this work. I have three tables. tblIntakeMain [IntakeMainID] tblIncidentDetails [IncidentdeatailsID] tblPersonnel [PersonnelID] On the main form I use subforms to link tblIncidentDetails and tblPersonnel to...

I have a form called "Search" on which there are a number of unbound text field. The idea is this: the user types in information on a subject (like first name, last name, Date of Birth etc) and then hits search. The form calls a query named qMasterSearch. The search results are displayed in...

I am working on a timesheet database. By date, you can select an employee and the shift that the employee will work. Shifts are defined by a start time, end time, and a specific color. Using an Afterupdate event, the background color, left property, and width of a textbox are changed to...