User Profile

Collapse

Profile Sidebar

Collapse
Ragonz355
Ragonz355
Last Activity: Jul 24 '15, 10:47 AM
Joined: Jun 5 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Ragonz355
    replied to Type Mismatch (Run-Time error '13')
    in Access
    Code runs perfectly in a non-upgraded database.
    Error is apparently on this line

    Code:
    Set rstqry = dbs.OpenRecordset(stDocName, dbOpenDynaset)
    See more | Go to post

      Leave a comment:

    • Ragonz355
      started a topic Type Mismatch (Run-Time error '13')
      in Access

      Type Mismatch (Run-Time error '13')

      Recently upgraded a database from 2007 to 2013 and now a section of VBA code does not want to work. What could be the problem. Code is below

      Code:
      Private Sub cmdFindNow_Click()

    Dim SelectSQL As String
    Dim stDocName As String
    Dim Response
    Dim dbs As Database
    Dim rstqry As Recordset
    
    If IsNull(Me.txtFindString) Then
    Response = MsgBox("No search
      ...
      See more | Go to post
      • Ragonz355
        replied to Form problems - One record works, whilst another in the same table does not
        in Access
        I'm afraid I have no idea how to do any of that :/ The only reason I have been given this is because I'm the "IT Guy"

        I was given a working database, added in the 3 bits below following the working format already present

        Code:
        .Selection.GoTo wdGoToBookmark, Name:="InvTot1"
        If Not IsNull(grst![InvTot1]) Then
        .Selection.TypeText grst![InvTot1]
        End If
        .Selection.GoTo
        ...
        See more | Go to post
        Last edited by Rabbit; Jun 8 '15, 09:29 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.

          Leave a comment:

        • Ragonz355
          started a topic Unique random number on opening form for first time
          in Access

          Unique random number on opening form for first time

          Have created a section in some code that opens a pre-existing form so that users can input new data. However I'm stuck at this point, basically there is a field in there called invoice number which they need to type in an invoice number (this can be anything, they just have to check it doesnt already exist)

          What I would like to happen is when they click on "Add New Enquiry" a unique invoice number is generated and put into...
          See more | Go to post
          • Ragonz355
            started a topic Form problems - One record works, whilst another in the same table does not
            in Access

            Form problems - One record works, whilst another in the same table does not

            So have just been asked to take a look at an access database that has been dropped on someone who is not particularly access-literate.

            They asked me to add the subtotal values, VAT and Total into the word document that gets generated when they click the Crete invoice button. Now I worked on this last night and had it working, when that create invoice button was pressed a word document would open with all the details in it pulled out...
            See more | Go to post
            Last edited by Stewart Ross; Jun 6 '15, 09:50 AM. Reason: Merged your two posts together
            No activity results to display
            Show More
            Working...