Search results for query: *

I have a click-button on a form that uses the form data to send an eMail. This is working great, however I have been asked if the eMail can include an image header in the message like the company logo. Is there any way to do this? I tried playing with pulling in an OLE table field with no...

I have added the code from faq701-4233 and created a query with the following code: SELECT tblEngagement_ClarifyData_Subcase.CaseNumber, Concatenate("SELECT [OwnerID] FROM tblEngagement_ClarifyData_Subcase WHERE [CaseNumber] =" & [CaseNumber],"; ") AS [Case] FROM...

I have a shared database where the back-end sits on a network drive and the front end is on each user's PC. For some reason the database is modifying itself to be a read only database. No changes are made it just changes to read only. The file properties do not show read-only, but when you...

I have a form with several subforms on it. Each subform is on a different Tab using the Tab control. I am pulling information from the first tab onto the second by setting the default value of the field to the control on the first tab...

I have data that is pulling into an Access database from another source. In this table there is a field called Tasks which is made up of four pieces of data separated by semi-colons. I do not have the control over the database or data to change how the pull is setup I can only query on the...

I have recently developed an Access 2002 database for our Project Management office. The database has a back end with two front end files; one for the administrator and one for the Project Managers. The PMO asked for network space to put the database where approx 150 users from three locations...

I have two tables; one that contains time spent on projects by resource and the second is a master list of resources. I have a query that relates the two tables with the Resource ID where it includes all records from tblListResources and the related records from tblProjectHours: Joe...

I am trying to use the FAQ701-4233 and am having problems. I have a query that I am relating two tables: tblEngagement_ClarifyData_Case strCaseNum (Key) strCaseTitle dtmCaseOpen dtmCaseClose strCaseOwner tblEngagement_ClarifyData_Subcase strSubcaseNum (Key)...

This post is related to archived thread702-396121. I used the code provided in the thread above to automatically generate e-mail messages to employees when they have an overdue task. The code is tied to a command button on my form. What I would like to do is have all of the e-mail messages...

I have a database where resources enter forecasted project work time for each month. I need a way to automatically calculate the available work hours for a given month. I will then subtract the available work hours for the month from the forecast hours entered to come up with the...

I have created a statement based on help from thread702-396121 (Thanks) to send an e-mail in Outlook using fields from my database. I have one problem, I would like to have the e-mail created but not sent. I would like to view the e-mail, in case the message needs to be edited slightly before...

Trying to create a Text Box on a Form that has a 10 digit part number. This number should be 10 digits total, however with some part numbers the actual number may only be 5 or 6 characters. I am trying to create a mask that will replace any characters I do not type with a zero. So if I type...

I have a database that lists projects [tblEngagementData] and the team members assigned to the projects [tblJoin_Engagement_ProjectTeam]. There is a one to many relationship between the Projects and the Team Members tables. I have created a report that lists each project with a subreport that...

I have table that has messy phone number data, the structure of the numbers vary so I need to strip out all of the extra characters; spaces, periods, dashes, asterisks, commas, parentheses and slashes. For example in one record the phone number is (###)###-####, in the next it is ###-###-####...