Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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

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

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.

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