Search results

  1. A

    VBA Report Module Auto populate "save as" name

    Gasman and Buddha Thanks for your help... I will look into those videos...
  2. A

    VBA Report Module Auto populate "save as" name

    so a little background... the database will be used to track and report defects found while inspecting aerospace parts... this database needs to be controlled document per "Quality policies" the reason why we need to break it up into each WBS # having its own report is because each part can have...
  3. A

    VBA Report Module Auto populate "save as" name

    I did all that everything happened just like you said... after I pressed F5 and the file name was what I was looking for "the mix of the 2 fields" I clicked ok and got that same 2059 error
  4. A

    VBA Report Module Auto populate "save as" name

    strRptName should be a mix of 2 fields.... just like you have it there
  5. A

    VBA Report Module Auto populate "save as" name

    gasman- so when the code has the "strFullpath = Browsefile" argument I get error # 2059 if I remove it I get error # 3021 doing a little digging I think I need that argument in there
  6. A

    VBA Report Module Auto populate "save as" name

    Private Sub Command22_Click() Dim fileName As String, strFullpath As String Dim answer As Integer Dim fileName2 As String Dim strFile As String Dim intPos As Integer Dim strRptName As String On Error GoTo error1 DoCmd.OpenForm "Specific_Information_frm" 'filename for...
  7. A

    VBA Report Module Auto populate "save as" name

    and now that you brought it up.. I don't know what the browsefile is supposed to return... lol must of been a leftover of something I tried to fix this issue
  8. A

    VBA Report Module Auto populate "save as" name

    this is what I am getting now
  9. A

    VBA Report Module Auto populate "save as" name

    gasman- don't know where to start... don't know how to see what the actual error is.. I just know the database closes... I don't know how to do any of the things you mentioned. the export button sits on the "report header" section of the report. Like I mentioned on my original post.. I have 2...
  10. A

    VBA Report Module Auto populate "save as" name

    buddha- this does not do anything but close my forms... don't know what is really going on....
  11. A

    VBA Report Module Auto populate "save as" name

    Hi all, I need help with the following. I have a number of forms that have several fields, 2 of these specific forms are used for a report, report and subreport. I need the file dialog box for exporting the report as a pdf to auto-populate the report name based on 2 fields on these forms. so...
  12. A

    Question Excel Not refreshing Because Access is still open???

    hello everyone. I need some help figuring this one out. So one of my forms in my database has a button. when clicked it gathers the information from "query1" and places it on an Excel worksheet, where I then use some small formulas "vlookup" and arrange all that information into a report that...
  13. A

    null... Help Please

    so I googled that error and I fixed it... somehow the brackets were messing it up.. I switched the brackets for "" and it worked.... thanks Minty and Missinglinq...
  14. A

    null... Help Please

    thanks. minty I have no idea how to upload my whole database. It might not be possible since im doing this for work and the network here is pretty tight I wont be able to do it if I have to zip it.. however the immediate window is now giving me a "compile error: External name not defined"...
  15. A

    null... Help Please

    im sure all the names are ok... hopefully you can see the picture
  16. A

    null... Help Please

    thanks minty. so I deleted the code I only left the gotorecord,,acnewrec part I added the dmax to the default value and now the txtbox for the "Controlnumber" is displaying "#ERROR' thanks and sorry for the continuous questions and replies and by the way I don't know what was...
  17. A

    null... Help Please

    not ignoring your post, I cant find the "immediate window" I thought it was under "debug/windows"
  18. A

    null... Help Please

    ok so am making some head ay here I still need some help though. so if I take off the line where am adding a new record and the "if" statement, the code works fine. with it, it doesn't. I want my form to add the autonumber automatically when the form is loaded with a new record... this...
  19. A

    null... Help Please

    sorry all that look better before I posted it but anyhow.. there is stuff on that tbl... to be specific the numbers 123-129 are all listed under "ControlNumber" with the table having 7 different entries
  20. A

    null... Help Please

    thanks missinglinq... How, exactly, is the 'custom autonumber' supposed to 'automatically fill' when a new record is started? I thought this code was supposed to check to make sure the box is empty or null and when it is to find the biggest "ControlNumber" and add 1 to it...
Top Bottom