Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: sqleptical
  • Content: Threads
  • Order by date
  1. sqleptical

    Access 2010 Web Form on SharePoint - How to output data on button click

    I've got an Access 2010 Web Form (published to Sharepoint 2010) that the user will fill out at the time of an interview. When they click the Access Form Control Button, I need it to output the form data to something that the user can copy/paste the output text into another application. The...
  2. sqleptical

    Access 2010 Web Form - How to output data on button click.

    I've got an Access 2010 Web Form (published to Sharepoint 2010) that the user will fill out at the time of an interview. When they click the Access Form Control Button, I need it to output the form data to something that the user can copy/paste the output text into another application. The...
  3. sqleptical

    Deploying Office Web Apps on SP 2010 without using SkyDrive

    We want to enable edit in browser on SP 2010 like we were able to do on SP 2007. Apparently, in order to edit in Browser with 2010 we must deploy Office Web Apps, but I read it utilizes SkyDrive. Cloud services like SkyDrive are against our Security/Confidentiality Policy. Does anyone know if...
  4. sqleptical

    See a list of replicas from the master

    In Access 2000, is there a way to get a list of the Replicas that have been created from the Master?
  5. sqleptical

    Making a template for Outlook Calendar

    Is there a way to modify the Calendar template in Outlook? I'd like each day of a shared calendar to have a list of employee names where they can type next to it whether they are in/out/in a meeting/lunch etc....like an in/out whiteboard for the staff, only electronic.
  6. sqleptical

    Sending Outlook Appts. w/o scheduling in sender's Calendar

    I'm using VBA to send appointments to recipients through Outlook (from an Access form). The problem is that the appointments being sent are also written into the sender's calendar, eventually clogging up the calendars for the clerical worker - forcing them to go in & clear out their...
  7. sqleptical

    Adding custom buttons to Outlook

    I am looking to create three new buttons in Outlook, one for each acting like 'New Message', 'Reply' & 'Forward' - the only difference being that these buttons will include a confidentiality statement at the bottom of the Email. The users will use the old/standard buttons when a message is not...
  8. sqleptical

    "OR" in Excel formula

    I'm trying to use a formula to compare/flag the current time (B1) to the in/out time entered on Sheet1 (between Sheet1!B3 & Sheet1!c3 OR between Sheet1!d3 & Sheet1!e3). The following is what I came up with, but does not work. Any ideas? =IF(OR(B1>=Sheet1!B3,B1 <= Sheet1!C3,B1>=Sheet1!D3,B1 <=...
  9. sqleptical

    How to make hyperlinks work in MS Word Forms

    I am working on an MS Word 2000+ document that uses drop-down form fields. This document also has hyperlinks that the user needs to click on for help/info. The problem is that in order for the drop-down form fields to function correctly, the form must be protected, but once the form is...
  10. sqleptical

    Assign a value in a text box on a Word 2000 form

    I'm new to forms in Word & am trying to assign a value in a text box named Deduction depending on the value of the Combo Box named s1. The VBA code below does not work. If s1 = "Yes" Then Deduction = "B" Else Deduction = "C" End If Thanks!
  11. sqleptical

    Assign a value to a text box on a Word form

    I'm new to forms in Word & am trying to assign a value in a text box named Deduction depending on the value of the Combo Box named s1. The VBA code below does not work. If s1 = "Yes" Then Deduction = "B" Else Deduction = "C" End If Thanks!
  12. sqleptical

    Inserting a drawing frame into a form

    In Word 2000 or later, I'm trying to create a form that allows for the user to "draw" a genogram using the Drawing toolbar. I've tried inserting a table for this, but once the form is protected, you can't click into the panel, let alone draw lines, circles & squares, Can this be done? Thanks!!
  13. sqleptical

    Toggling Forms in MS Word 2000 or Later

    In MS Word 200 or later, I'm looking for something similar to Javascripts 'togglediv' that allows you to expand or shrink forms when clicking on a header? People use togglediv in .asp & HTML, but I need this to work in a Word Document. Sub Documents is not the solution, as I'm not looking for...
  14. sqleptical

    How to reference current user?

    I'm creating a form that users use to enter data into tables. Each user has their name & initials associated with each respective license of MS Access 2000. Is there a way to have the VBA code reference the user name when they hit the Submit button? I'd like to use this to track who made each...
  15. sqleptical

    VBA Merge from Excel to Word by variable instead of DataSource.

    Does anyone have a VBA code snipet that will assign a Word Merge field a value from the Excel sheet that the macro is ran from? I'm trying to skip the step of having to write the variables to a .csv file, as the values to be written are already known inside the macro (Cells(r, 6) should be...
  16. sqleptical

    VFP 7 .prg needs to read from SQL 2005 table

    I've recently switched from using VFP tables to SQL 2005. I am now looking for a way to point my VFP 7.0 .prgs to the SQL tables instead of FoxPro. For FoxPro, I simply pointed using the following command: use "L:\tables\cif2.dbf" share What do I need to replace this with to have the .prg...
  17. sqleptical

    Unwanted Carriage Return &amp; EOF Character

    I use a FoxPro 7 .prg to export .dbf data to a .txt file, however it always appends a carriage return & a black box as what I assume to be an EOF character () after the last line. Does anyone know a way to avoid this from happening?
  18. sqleptical

    Linking FoxPro 7 tables in Access using OLE DB Provider

    Does anyone know how to link a FoxPro DBF in Access 97 using the FoxPro OLE DB Provider? The FoxPro ODBC driver has not been updated by Microsoft since FoxPro 6 & does not work correctly with FoxPro 7 or greater. I am told that the FoxPro OLE DB Provider is the best solution. Thanks!
  19. sqleptical

    FoxPro ODBC driver = unreliable linked tables in Access

    All of my reports macros queries & forms are built in Access97, but all of my tables are in FoxPro DBFs. Everything was fantastic when my applications were based on FoxPro 6, but a software "upgrade" required me to switch to FoxPro 7 & I can no longer link to my DBFs in Access the way I used...
  20. sqleptical

    Linking problems to VFP 7.0 tables w/ more than 84 fields

    When I link to VFP 7.0 tables that have more than 84 fields from either Access 97 or 2000, and I try to make any changes to the data in the fields of those tables, I get the following error: ODBC--update on a linked table 'tablename' failed. When I click OK on the error, I get...

Part and Inventory Search

Back
Top