in
All Tags » VBA » function (RSS)

Browse by Tags

  • Create Custom Project Number

    We need to generate a custom customer number with the following criteria: Project Number 4100501 4 = Use until we run out of numbers (don’t know where or why 4 was and is used) 10 = Calendar Year 05 = Current Month 01 = Auto Number (How many projects in May of 2010) What is the best way to generate this...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-11-2010

  • The best way to extract a number out of a string of text?

    I'm looking for the most efficient "FindNum" function. I'll post some I've found and the one I'm using now. I'm using this in MS Access, and I use it in a query as a function, where the query goes through 50K+ records at a time. Using this funtion in a make-table query can...
    Posted to Access Coding/Macros (Forum) by microsoft on 05-04-2010

  • Execute a function in vba where the function name is a variable

    Hi, what i want to do is have a table that has the name of a function in one of the fields, i want some VBA code to read this table and load the list of function names, i think they will be strings at this point, then i want to call each of the functions in this list. Getting the table and the list is...
    Posted to Access (Forum) by microsoft on 03-31-2010

  • excel function to get value of another cell

    image: http://img215.imageshack.us/img215/3725/20100314235127schedule2.jpg I hope the image can explain what I need. :) Problem 1: Get the date where it is the first value in the row Problem 2: Get the date where the value is 100 (actual excel file is also attached, if necessary)
    Posted to Visual Interdev (Forum) by microsoft on 03-22-2010

  • Controlling Excel with VBA across several functions

    I am populating a workbook in Excel and drawing 30 or so graphs via Access. Everything is working fine except I get an error exactly EVERY OTHER time I run the function. 438 "object variable not set" It has a couple nested functions that work with the spreadsheet, so each function has separate...
    Posted to Access (Forum) by microsoft on 02-26-2010

  • Using A Variable In VBA SELECT Statement

    I have a function that is called from my form. I am hard coding a variable into the function simply for testing will implement after the SELECT statement syntax is correct. I need help with the syntax. I use the following below and I receive error "Too few parameters. Expected 1" The important...
    Posted to Access (Forum) by microsoft on 02-10-2010

  • VBA - Multiple outputs from one function

    I have a function, say MyFunc(), that outputs a value from a worksheet. For ease, let's say the function is as follows: Function MyFunc() 'A whole bunch of other work that finds D1 MyFunc = Cells("D1") End Function Now I want to have another function that displays the cell directly...
    Posted to Excel (Forum) by microsoft on 02-09-2010

  • VBA functions Trim, Left and Right not working

    I'm developing code offsite, on a stand alone machine. The users have recently upgraded their machines so my code would run at their offices. We all have Office Professional XP, and I downloaded the libraries for them so we'd all have the same references, namely Visual Basic for Applications...
    Posted to Access (Forum) by microsoft on 01-02-2010

  • Tooltips for VBA functions

    Good evening Excel-Experts, Let's say I have a simple VBA function which I can use as follows: =Margin(CostPrice,SellingPrice) How do I make it such that as soon as I type =Margin( a tooltip appears in a yellow-filled box as follows: Margin(Cost_Price,Selling_Price) Patrick
    Posted to Excel (Forum) by microsoft on 11-09-2009

  • Item Code Conversion

    Hi, In MS Access 07, I have forms that require the end-user to type in the cost CODE (acquired cost) of the product. What I want is that once the end-user types in the cost code, MS Access 07 recognizes the code and converts it to numbers in the other forms that only the management can have access to...
    Posted to Access Forms (Forum) by microsoft on 09-24-2009
Page 1 of 3 (29 items) 1 2 3 Next >