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!

Register Log in
  • Congratulations derfloh 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: kc27
  • Content: Threads
  • Order by date
  1. kc27

    Question About Automatically Signing In to Database via Excel VBA

    I have a database username and password written into the VBA code of an Excel tool that is used to generate reports. The correct functionality of the form is that the user clicks a button and begins making criteria selections to generate a report. To generate the report, the Excel tool needs to...
  2. kc27

    "Save Password" When Creating Links to Tables in Access

    I inherited maintenance of Excel tools that utilize Access databases. One of the Access databases contains nothing but links to tables in a SQL database. The SQL database administrator mentioned to me that the table names in the SQL database have changed. I am going into the Access database and...
  3. kc27

    Question About Code That Grabs Logged On User Name

    I have an Excel form that uses the code below to get the logged on user's ID. What is this line of the code doing? Is it subtracting a character where it reads "-1"? Is it removing a character? Private Sub Workbook_Open() Dim lpBuff As String * 25 ret = GetUserName(lpBuff, 25)...
  4. kc27

    Excel Attemps to Open File When Started

    I am running Excel 365 ProPlus. Last week I was editing an xla file in Excel. Now, whenever I start Excel, I get the message "Sorry, we couldn't find [path to xla file] Is it possible it was moved, renamed, or deleted?" I then click "OK" and Excel continues loading. Within Excel, with no...
  5. kc27

    Need Help Interpreting Excel VB Error Message

    I have an Excel file that errors with the following Visual Basic error message: Run-time error '-2147217900 (80040e14)': [Microsoft][ODBC SQL SERVER DRIVER][SQL SERVER]Invalid column name 'P1424'. The debug code excerpt is shown below. The last line in the code excerpt is highlighted when I...
  6. kc27

    Access Macro and Run-Time Error 3061 Error

    This macro has worked flawlessly, then this week it displayed "Run-time error 3061. Too few parameters. Expected 1" I understand this error indicates that this may indicate a field name problem. I have not changed anything on my end, but would like to figure out what needs to be changed. The...
  7. kc27

    Request For Advice on Editing an Application

    I installed Microsoft Visual Studio Community 2017 in order to make an edit to an application that was developed by a developer that is no longer with our company. The application executable is ap9.exe (details below) Assembly Ap9.exe Member of Custom Component Set H:\My...
  8. kc27

    Excel Run-time error '3151': ODBC Question

    Hello I have an Excel xlsm file in which users can pick options for a report, then generate a worksheet that includes data pulled from a database. When the user first attempts to generate a report (worksheet), the worksheet starts to load with some hard coded values, then should load with data...
  9. kc27

    What Is This Character?

    I copied a column from an Excel document and pasted it into Word. The numbers are all followed by a symbol. The symbol does not appear to be live text, because it cannot be highlighted or deleted. Maybe some sort of symbol that Word uses to signify a return? Does anyone know what the symbol...
  10. kc27

    Excel VBA Troubleshooting Question

    We have an Excel VBA application that has a custom button on it for users to add a new worksheet to their workbook. One workbook shows this error message when the new worksheet button is clicked: "Compile error: sub or function not defined". Code is displayed, shown below. I am looking for...
  11. kc27

    Need a Way to Reuse A Field and Get Different Data Each Time

    My report uses the fields: ad_info.ad_nbr, ad_info.ad_desc and ctlg_ad_comp.comp_ad_nbr An ad_nbr is a number used to track an advertisement, and the ad_desc describes the ad Ads can be stand-alone ads or they can have other ads assigned to be delivered with them (as in a catalog and other...
  12. kc27

    How Do I Switch a Value and Repeat an Action?

    I inherited an Excel file that interacts and copies data from screens of mainframe application. The mainframe application's screens were updated recently, causing a macro in the Excel file to fail. I know you cannot see the mainframe screens, but I was hoping someone could give me some guidance...
  13. kc27

    Error When Running A Macro

    When I run a macro on an Access database (using Access 2013), I get the following error: Run-time error '3061' Too few parameters. Expected 1. It then highlights the line of code shown in this link. Further complicating this issue is that I am not a programmer, and am not familiar with the...
  14. kc27

    How to Resize Advanced Search Results in Outlook 2013?

    I would like to adjust the size of the search criteria window vs the search results window. Hovering over the horizontal line between the two sections does not give me a resize tool. How do you do a resize?
  15. kc27

    Highlight or List Maximum and Minimum Dates

    My Excel 2013 worksheet contains many dates formatted like this: 4/16/16 (each of the dates I care about is in its own cell. I would like to be able to check the entire worksheet and highlight the cells that contain the minimum and maximum dates found on that sheet. The sheet should only...
  16. kc27

    Formula to Find Whole Word, Not Part of A Word

    If I use a formula like {file_info.desc} like "*ken*", it returns results that include words like kennedy or kent. How do I modify the formula to return values that just include the whole word "ken", and exclude values that have words that also contain those those three letters? Thanks for any...
  17. kc27

    Want to Set Up Parameter to Filter for A String

    I am using Crystal Reports 9 on a sql database. One of the fields in my report is bt_images.img_desc. The records in bt_images are photography image files. The field bt_images.img_desc is a description of the image. I would like to allow users of the report to enter an image description, and...
  18. kc27

    Report Includes Too Much Data - Filtering Not Working

    I thought I had this report working, but not yet. I did attempt to simplify it, but am still running into issues. It is configured like this: I am accessing three tables: CHECK_MRCH check_id merch_id check_type check_date check_ad check_vendor check_dest ad_merch merch_status merch merch_desc...
  19. kc27

    Need to Deterime Maximum Value of a Field Less One

    Hi Can someone tell me how to adapt the code below so that it returns a number that is the maximum value minus 1. For example if the maximum value is "35", I would want to display "34" {table.field} = Maximum ({table.field}, {table.field}) Thanks in advance for your help on this.
  20. kc27

    Want To Display First Record But Only If It Matches A Certain Value

    My Crystal Reports 9 report is set up as follows: GH1: Merch ID Merch Description D: Merch ID Check ID Type Vendor Destination Route No. Ad no. Date GF1: Their can be multiple rows in the details section. I have the section sorted by Check ID in descending order. In the...

Part and Inventory Search

Back
Top