in
All Tags » VBA » type (RSS)

Browse by Tags

  • VBA User Defined Types

    I'm developing a system in Access 97. I have some user defined types declared publically and used in several form code modules. I would like to be able to pass an instance of these types between forms but if I try and declare a public function in a form object module with the UDT as a parameter I...
    Posted to Access (Forum) by microsoft on 09-13-2009

  • Spreadsheets created from TransferSpreadsheet method

    MS Access version 7 -- VBA code: When I use the TransferSpreadsheet method, the created spreadsheet has field type set to 'general' rather than the types I would like it to have. Question: while in my button - how can I get the spreadsheet filed types to be what I need them to be (e.g. 'text'...
    Posted to Access (Forum) by microsoft on 08-21-2009

  • type casting using VBA

    Is there a way to convert a string to an integer using VBA? I have written some nested If's inside of a loop in order to find the next available extension to use while creating a work breakdown structure.....(not important) The code follows: For n = 6 To r If Cells(n, 4) <> "--" Then...
    Posted to Excel (Forum) by microsoft on 08-20-2009

  • Type mismatch VBA CurrentDb

    Newbie here - please be gentle. Why oh Why do I get a type mismatch at runtime when i do this: Dim db as Database Set db = CurrentDb ' << I'm running Access 97 on Win 98 Thanks anyone who can help!
    Posted to Access (Forum) by microsoft on 08-06-2009

  • URGENT!!!!!  Compile Error: Requested type library or wizard is not a VBA project

    URGENT!!!!!!! I have an Access 97 accounting package that uses several MDEs for it's coding. Some of the MDE's reference other MDE files. I am frequently making changes to the MDB files and then recompiling to MDE format. However, I have 1 file that continually gives me problems when I try to...
    Posted to Access (Forum) by microsoft on 08-05-2009

  • VBA: Compile error "type mismatch: array or user-defined type expected" on my string array code

    I get the error in the title in my code below. I've been scratching my head for 15 minutes and can't figure it out. What am I doing wrong? Sub t() Dim x() As String ReDim x(1 To 2) x(1) = "abc" x(2) = "def" dumpStringArray (x) ' End Sub Sub dumpStringArray(s() As String...
    Posted to Excel (Forum) by microsoft on 07-10-2009

  • VBA Split Function Help

    Hi, Can someone help me Split a variable. I am trying to split it and place the results in the caption part of a label. Whenever I try this though I get a data type mismatch error. The code I am trying to use is; SaveAsForm is a predefined String? LabelTitle.Caption = Split(SaveAsForm, "frm"...
    Posted to Access (Forum) by microsoft on 07-06-2009

  • Excel VBA values change

    scenario: user enters a value in a formfield - .005 code takes this number and eventually enters it into a cell - as .010. The value is consistent UNTIL it goes in the cell. The variable type is currency - which can handle up to 4 decimal places. And, obv, it keeps the three decimals - but rounds it...
    Posted to Microsoft Office (Forum) by microsoft on 06-30-2009

  • Type Mismatch on VBA Function That Returns ADO Recordset at Exit Function or End Function

    This doesn't seem like it should be difficult. I want to return an ADO recordset from a function in VBA (as opposed to VB.net). Here's the code I've used: Public Function GetRS(NameOfTable As String) As ADODB.Recordset On Error GoTo HandleError Dim rs As ADODB.Recordset Set rs = New ADODB...
    Posted to Access (Forum) by microsoft on 06-24-2009

  • Problem: MS Excel VBA Type Mismatch Problem

    I have an excel function that is throwing a type mismatch exception. THe line that has the issue is the Debug.Print I tried and neither work tmpDate = rngRawScore.Offset(i, 3).Cells tmpDate = rngRawScore.Offset(i, 3).Cells.Value ''''''''''''''''''''''...
    Posted to Excel (Forum) by microsoft on 06-05-2009
Page 1 of 2 (12 items) 1 2 Next >