Search results

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

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"...

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

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 =...

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...

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;

See attached image for my structure and spelling of fields.

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?

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

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

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

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

Everyone gets thanks, and Pbaldy gets the blue ribbon!

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.

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

If I add a "Compare" checkbox to my listings table, I could onClick test all of the listing IDs to see if they match the criteria given in the first form. If so, I can set the "Compare" to true. In the 2nd form where you narrow down the values, I can then remove some compares that are...

Gemma (Dave): Nope, this is how it is done. The models set base values for what roomsare in the house and their size. Houses are models, but they can be stretched in various places thus altering room dimensions and total square footage. Also, models don't have garages or carports, that is...

The attached file is a REALLY basic idea of what the 2nd page will look like where you select the homes to compare on the report.

I have attached a few pics so you can see where I'm coming from: On the home form, you enter 2 pieces of info - Square footage, and whether the house has a garage or carport from the dropdown. The square footage is a looooong formula that I have calculated in the attached image of the query...

Thanks to the contributions of experts on this site, the database I have designed is running without a hitch and my dad could not be happier in his real estate business! Thank God we got him off of those 200+ tabbed Excel spreadsheets! What I'm trying to do now is set up a form where someone...