Search results

  1. V

    Filtering Forms on a checkbox

    Hi Vlad, I originally had this as a filter on load, but i recently opened my form and it seams as though it does not work. I have tried it as a filter on load, in the record set of the form, SQL, and as a toggle filter. There is data that supports the field as a no/false; however it does not...
  2. V

    Filtering Forms on a checkbox

    Hello everyone, Im currently working on a database, and im trying to filter on when a checkbox is marked as false; however the filter only works on true. When changing to false, it gives me a invalid call procedure. This is my SQL if it helps: Any help would be appreciated!
  3. V

    Using DoCmd.OutPutto to a PDF on a shared drive

    I dont have the DB split, and with the way the db is going to be used it will be rare that someone will be saving the same PDF but i did try earlier and i received an error saying the document already existed.
  4. V

    Using DoCmd.OutPutto to a PDF on a shared drive

    Yes of course, here's the code: Private Sub Command325_Click() On Error GoTo Command325_Click_Err DoCmd.OpenReport "RPtCB", acViewReport, "", "[PO#]=" & [PO#], acNormal DoCmd.OutputTo acOutputReport, "RPtCB", "PDFFormat(*.pdf)", Me.PO_ & "-Price", False...
  5. V

    Using DoCmd.OutPutto to a PDF on a shared drive

    Hello, I have an access databases where am saving a pdf of the report in a shared folder; however, it looks as though the most recent person to have saved the actual DB to the shared person is the one whos PDF's go to the DB, other wise it goes to your documents folder in your computer. Does...
  6. V

    Using a button to open a report off a specific form's record

    Thank you!! It worked.
  7. V

    Using a button to open a report off a specific form's record

    Here you go.
  8. V

    Using a button to open a report off a specific form's record

    There is no option for Debug/compile--this is the error: the expression after update you entered as the event property setting produced the following error: invalid outside procedure. the expression may not result in the name of the macro, the name of a user-defined function, or [event...
  9. V

    Using a button to open a report off a specific form's record

    Paul, I've tried using the VBA, and it is coming back with a Invalid Outside Procedure error. This is the code: Private Sub Command465_Click() DoCmd.OpenReport "rptCB-S", acViewPreview, , "[CB(S)ID]=" & Me.[CB(S)ID] End Sub
  10. V

    Using a button to open a report off a specific form's record

    Hello, Im currently trying to create a button on a form that would open the record in a report, and one that would eventually print said record. I currently have the button working; however, its asking for a parameter. if any one has any suggestions it would be helpful. My current macro...
Back
Top Bottom