Search results

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

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

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

First off, let me say that I would not even have a DB worth publishing if it weren't for many people on this site freely giving of their time to help me when I ran into roadblocks with code, layout or normalization. My DB is for a real estate company and right now it is fantastic for on-site...

This works: Private Sub Command127_Click() DoCmd.SendObject acSendReport, "MLS_Report", acFormatPDF, "", , , "", , True End Sub But I end up with a 53 page .PDF of all 53 listings. I only want 1, but I don't know where to put the filter... Private Sub Command127_Click() sWHERE =...

I would like to make a dropdown that populates with the current year and the 3 previous. In other words, the contents would change from year to year. I also need to dropdown to pass the value as a number. combo37.value=2012 I've tried everything I could think of and cut and pasted several...

Select the following in a form: Person_Drop Color_Drop Place_Drop 1 - Man 1 - Red 1 - Store 2 - Woman 2 - Green 2 - Beach 3 - Clown 3 - Periwinkle 3 - Monster Truck Rally On the report, I want to create a text box that says something like...

Assume: Table "Confusion": ID Old_Name New_Name 1 Augusta Augusta 2 Barbados Doral 3 Cape Cod Doral 4 Doral Doral 5 Eagle Jefferson Table "Models": ID Model_Name 3_Bed 1 Augusta Yes 2 Doral No 3 Jefferson Yes Table "Homes": Lot_ID...

I live in TX, my dad lives in FL. I am writing him an Access DB and just recently attached the latest version to an email. He DLed it, and got right to work populating data and printing reports... but... He needs a new form, which I have now created. I want to send him this new report (and...

Given: - a text box on a form "Text476" with the contents: =Format(Date(),"yyyy") - a dropdown where the values of A, B, C, D, or E could be selected - a table "Lease_Rates" Structured: ID Lease_Year Class Rate 1 2011 A $200 2 2011 B $210 3 2011 C $220 4...

Consider the following pair of checkboxes: - Garage - 3Bdrm I would like to sort & label my report the following way: Non 3Bdrm, Non Garage … … 3Bdrm, Non Garage … … Non 3Bdrm, Garage … … 3Bdrm, Garage … … This is my first attempt at this, and I'd like to use the access GUI for...

I'm currently working in a gated community and I have a question about the structure of a database I want to build. I want to create a database of cars, residents, guests, contractors, etc. The idea is to eliminate paper logging altogether. I've played with MS Access in the past, but I had...