Search results for query: *

I have a SP list called Advisors that holds council member information. The unique identifier is the ID created by the list. I have SPD workflow that runs when the Advisors form is edited and the mentorship field is set to active. The workflow copies over the ID and member name to the Mentors...

I am connecting to a SQL Server from a 2003 Access database using a User DSN which uses SQL authentication (login ID and password). Is the password encrypted in the connection information in the registry?

I am trying to move a database (.accdb) from Access 2010 to SharePoint 2010. I go to Database Tools to Move to SharePoint. The dialog box comes up asking me for the SharePoint location. However, I do not see the checkbox for saving a copy of the database to SharePoint. This is referenced at...

This is the approval workflow provided in SharePoint.

I have workflow set up in SharePoint 2007 to approve a task. The title of the e-mail is Service Request Approval has started on Jane Doe. The workflow is picking up on the Requestor's name column. I need it to use the Request Title column in the e-mail title. How do I change this?

Duh!!! My only question is why didn't I get an error, instead of a whole number?

I have looked through previous threads, but can't find an answer to my problem. I have a query with a currency field and a datediff calculted field resulting in a number of days. I need to create a new calculated field that shows currency\days. For example, $32,000\364 days. My query gives...

I just ran into this same error message converting from Access 2003 to Access 2007. It was caused by navigation buttons I had put on a form that opens through the Autoexec macro. I removed the buttons and code underneath and the error went away. I put them back and the error came back. Turns...

I have records being imported and entered manually. I was hoping to leave the import date blank for the manually entered fields.

I have a command button that imports an Excel spreadsheet using TransferText. I need to add the import date to each record as they are imported. My code is DoCmd.SetWarnings False DoCmd.TransferText acImportDelim, "IP for DM Import Specification", "tblPatients", Forms!frmImport.txtFileName...

Is there a way to programatically detect if a user has the runtime or the full version of Access 2000 installed?

Perfect! You are the man...

I have a calculated field in a query: HoursMins: Format(Int([TimeOn]-[TimeOff]),"0\:") & Format([TimeOn]-[TimeOff],"Short Time") It returns: Time On Time Off HoursMins 1/3/2003 6:00:00 PM 1/3/2003 4:45:00 PM 0:01:15 My problem is that my user is now asking...

No. I still get the error. I think I need to let this issue go. Charts are not necessary to this project. I was just trying to add an extra for them. I appreciate your help and I am sure you could have gotten me where I needed to go, but I am out of time.

I have a table with lab tests. There is a date the test was done, the test name, and the result. The result could be a numeric or text, so the data type is text, so that is why the error. I ran the original report through the wizard, so it set things up for me. Thanks for your help.

Hi Dhookom- I tried changing the Value column to all of your suggestions and they all produced the same error.

I am creating a number of charts that trend lab results over a number of days. One lab test per chart. I used the first chart as a template (created with the wizard) and then just copied it and changed it's Record Source and Row Source to reflect the correct query. This was working okay, but...

Kudos. I think I tried everything, but that!

When I try this I get an error that says can't find the field PtInfo. stDocName = "APPEND Lab-Eval" stDocName2 = "APPEND Diag-Eval" DoCmd.SetWarnings False DoCmd.OpenQuery stDocName, acNormal, acEdit DoCmd.OpenQuery stDocName2, acNormal, acEdit DoCmd.Requery...

I have a form with a tab control. I have a number of pages, each with one subform. On subform1 I have a button that when clicked runs a query and populates the form. It also runs a query that populates subform2 on another page. It then requeries subform1, so the users can see the...