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

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?

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

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

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

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

I have a continuous form with a bound check box. This check box is used to choose records to be printed as labels. (I originally tried this as unbound, but it does not work on the continuous form). My question is, "how do I clear this check box for ALL records when the form is closed?" I...

I get this error when trying to open a table linked to Oracle from Access 2000: ORA-01013 user requested cancel of current operation. I did not cancel anything. The ODBC connection tests successfully. This worked previously, but since my DBA changed the dataset in Oracle I am getting this...

I have a report that is a form letter sent out to physician's offices regarding patients referred to them. The letter is usually one page, but sometimes can be two. I need the top margin on the first page to be 3", as the letter will be printed on letterhead. However, if there is a second...

I have a main form containing a continuous form subform. The user can filter the subform by double-clicking on a date field. My problem is that when the filter is removed the db jumps from the current record (main form) to the first record (main form). How do I get the db to remain on the...

Help! I have a strange problem. First, here is some background: 1. I work from home over a VPN connection. 2. I work with Access front-end/SQL back-end programs. 3. I make changes to a copy of an Access file on my laptop and then move it to the network at work to replace the file that the...

I have a form that contains a continuous form as a subform. The subform is a survey that has a number of questions for the user to respond to. For each record there is a question, status, and text field. The question field is the question number, the status field is where the user answers...

I have a main form with a continuous subform on it. I need to pull the value from a control on the main form and use it as a default value in a control on the subform. Thanks for any help.