Search results

I am attempting to send an email via Outlook from an InfoPath 2010 form. It is working successfully except when there is more than one similar AccountID (generated by the Person Picker), such as "FacilityDoeJ". In the backgound, it will pull "FacilityDoeJ", "FacilityDoeJ1", and "FacilityDoeJ2"...

I am trying to mark the "qualifying visits" in a list of patient visits by putting "Yes" in a particular field. The qualifying visits are the 1st 10 visits during the time frame. BUT, only up to 5 of the 1st 10 visits can have a particular CreditDSSID (179). So visits 11 and 12 could count...

I have a lengthy report I must import into Excel from a legacy Dos-based program. I can import it just fine using column width, but many of the rows have trash in them I do not want. I want to remove rows with headers, page numbers, groups of "------------", etc. I have written this to delete...

I have a report in Access 2007 that is based on a query that has: ...in a Date field. The report has several subreports that are based on crosstab queries based on the original query. We used to tweak the date field of the primary query manually, but today I changed it to a the text above...

I have an Transact SQL query that returns a field with a date in it within a temp table. How can I get it to convert this date (in the temp table only, of course) to display ONLY month & year, no day... mmyyyy or yyyymm or some variation thereof. The resulting data generated by the query...

Here is a question for those of you "Across the Pond" from the Yankee side. The question is for Canada too, for that matter. You may be aware that here in the US there is a VERY big deal in the news now about whether the Federal Government should nationalize health care. Currently, most...

Our facility just updated MS Office from 2003 to 2007. I have an inherited database that has a new problem. There is a clumsy but functional report that consists of 57 subreports in the header section of an otherwise unaltered report. There is only the title, a date() field, a page number...

1. How can I make that darn security box stop popping up every time I run my Office 2007 database, and how can I do it so that other users will not get the same error message? It keeps asking me to "enable potentially harmful content" due to the VBA & whatnot in the database. 2. My database...

I have a database that worked fine in Access 2003. Now in Access 2007 I am getting this error when I try to view a query a form is based on: The field in the form WAS based on the following SQL: SELECT tblRoster.ActionID, tblDepartments.Department, tblActions.DateEnd, tblActions.DateStart...

I am trying to do what *SHOULD* be a very simple append query. The source query has 5 tables with NO key, indexed or required fields (although they DO have relationships between 4 of them to the main, 5th one that are internal to the query itself) The destination table has NO required fields...

I have been working on a database that has several tables that have relationships via "ID" fields populated using autonum. While I have been working, others have been using a previous version of the database to track data. I would like to transfer the data into the new & inproved database, but...

I have a simple form with a "search" button that opens the Find/Replace utility. Is there a way for the "look in" field to show ALL the fields in the form, not just the one that you selected before clicking the button. Thanks in advance!

I have a Motorola V557. It is a bit old, but I like it & do not want to replace it right now. Out of the blue a week ago, it started having a blank screen when you open it AND on the little screen on top. I have been experimenting with it. You can turn it off and on and the screen comes up...

I am trying to extract data from a survey that is buried in a patient note. The portion I am attempting to utilize is attached below. The database is normalized. Question 1 has a fixed ID of 52 with possible Answer IDs of 12, 15, 34, 49, and 75, for example. So when it is saved...

I have a form that has a button on it that opens another form (survey) that pulls information off the parent form, including an autonum ID number. The survey cannot "grab" the autonum until the record has been saved. So if I create a new record on the parent form and hit the button that opens...

I have a similar problem to the post here. I have a form that enters information on patient admissions and discharges. At the bottom of the form is a button that opens a survey so that a staff member can take information from a phone survey. I want the survey to display information from the...

I have created a pivot table of what I *thought* was very simple data...a list of dates with up to three different numbers (the result of a count) for each like this: 1/1/07___Count of A 23 ________Count of B 25 ________Count of C 19 1/25/07__Count of A 32 ________Count of B 15...

I am running Windows XP Media Edition that came with Sonic DLA for formatting CDs. It works just fine for CD-RW CDs, but it will not recognize blank CD-Rs. Nor will it allow me to format them or save to them. In addition, CD-RWs that have been burned using this drive are not "open" on other...

I am working on a report that calculates survey results. The data is normalized, with a query called "qryResults" that pulls together all the results based on numbers from various interrelated tables. My report displays the data based on headers SurveyID Header - Identifies the survey being...

My boss's Word autoformats a whole section of text (paragraphs, or even pages), rather than just making the one sentance he selected bold or colored. Any idea how to get it to stop doing that?