Recent content by Sydcomebak

  1. S

    Open a new record if a matching one doesn't exist

    [resolved] Now I just need to get some of these fields to populate onLoad...
  2. S

    Open a new record if a matching one doesn't exist

    Hey gurus! This works only if a record exists in the Contracts table where the Listing_ID equals the ID of a record in the Listings table: Private Sub Command44_Click() Dim sWHERE As String sWHERE = "Contracts.Listing_ID = " &[Listings.ID].Value DoCmd.OpenForm "Contract_Info"...
  3. S

    Only show records older than 6 months

    Re: Solved Needed a similar filter myself. Thanks! -Dave
  4. S

    Should be simple: Click a button, all checkboxes become selected in a table

    strSQL = " UPDATE Listings INNER JOIN Houses ON Listings.Lot_ID = Houses.Lot_ID SET [Lot_Selected] = -1 Where [Garage] = " & Me.Check124 CurrentDb.Execute strSQL, dbFailOnError I think that's probably close, but I'm getting an expected end of statement error. yup: strSQL =...
  5. S

    Should be simple: Click a button, all checkboxes become selected in a table

    OK, In my "Listings" table, I have a checkbox [Lot_Selected] which I want to be checked in all records if the checkbox on the form [Check124] matches the value of a checkbox [Garage] in table "Houses". (This is all executed on the click of Command120) The "Listings" table and "Houses" table...
  6. S

    Should be simple: Click a button, all checkboxes become selected in a table

    Better image and my current select code: SELECT Listings.*, Houses.*, Models.*, Models.[Model Name], Houses.Garage, Listings.Lot_Selected FROM Models INNER JOIN (Houses INNER JOIN Listings ON Houses.Lot_ID = Listings.Lot_ID) ON Models.ID = Houses.Model_ID;
  7. S

    Should be simple: Click a button, all checkboxes become selected in a table

    See attached image for my structure and spelling of fields.
  8. S

    Should be simple: Click a button, all checkboxes become selected in a table

    Spelling all looks to be good. Does it matter that [Garage] is in the "Houses" table? The tables are joined in the form with the button executing the command, does it have to be joined in the sql statement too?
  9. S

    Should be simple: Click a button, all checkboxes become selected in a table

    RT Error 3061 Too few parameters. Expected 1 Dim strSQL As String strSQL = "Update Listings Set [Lot_Selected] = -1 Where [Garage] = " & Me.Check124 CurrentDb.Execute strSQL, dbFailOnError
  10. S

    Should be simple: Click a button, all checkboxes become selected in a table

    Thanks, guys! Too bad there isn't a Paypal donation button for me to drop 99cents everytime someone gives me a working line of code! Totally worth it! -Dave
  11. S

    Should be simple: Click a button, all checkboxes become selected in a table

    Error: Too few parameters. Expected 2 CurrentDb.Execute "UPDATE [Listings] SET [Lot_Selected] = -1 WHERE [Garage] = Check124.Value", dbFailOnError
  12. S

    Should be simple: Click a button, all checkboxes become selected in a table

    PNG, the DB from 2008 never panned out, and that was actually a PHP/html project. This one is Access.
  13. S

    Should be simple: Click a button, all checkboxes become selected in a table

    Everyone gets thanks, and Pbaldy gets the blue ribbon!
  14. S

    Should be simple: Click a button, all checkboxes become selected in a table

    OK, forget the new form. Private Sub Command120_Click() UPDATE[Listings] SET [Lot_Selected] = 1 End Sub Can you type up a sample of what you mean that I can work with? This is my first DB.
  15. S

    Should be simple: Click a button, all checkboxes become selected in a table

    Private Sub Command120_Click() UPDATE[Listings] SET [Lot_Selected] = 1 DoCmd.OpenForm "Market_Review_Report", acNormal, , sWHERE End Sub Nope! Gah! -Dave
See more
Back
Top Bottom