Search results

Yes, I would like to limit file sizes to 250k.

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

Crap, now I'm noticing that everything inn't populating from the Report_Load()... That makes the button useless...

I have a button in a continuous form "Listings - Edit" than onclick: Private Sub Command127_Click() DoCmd.SendObject acSendReport, "MLS_Report", acFormatPDF, "", , , "", , True End Sub In the same form, to view the same report and paper print it, I filter by: sWHERE = "Listings.ID = "...

So I already need to be in the report that I want to send? I can't send it from a continuous form?

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

*Bump* Linq, I'm having issues, please email me: my username @gmail.com

Linq, please PM me. I'd like for you to remote in and look at this monster. It's easier to show than describe.

If I drag it right off of the available fields, I thought it was automatically bound? I'll double-double check, but I thought it was bound properly...

missinglinq: The code worked to populate the value into the TextBox "Rate" but any updates/changes do not overwrite the stored value. I don't know if this means anything, but the navigator at the bottom is showing me that I am on record 1 of 325 on load. Edit: I guess it sort of is...

Mr. B. Perfect. Simply perfect. Modified to this: Private Sub Form_Load() 'declare a string variable to hold the list of values for populating the combo box list Dim strValueList As String 'dim a variang type variable to hold the current year 'and the "cntr" variant type varialble to use as...

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

Can't access that site on the work network. Let me complicate things a bit... it wasn't obvious, but the numbers refer to the ID value of the table that the dropdowns pull from. Then store the selected values in a large table we'll call "Story" Table: Story ID Person_ID Color_ID...

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 have successfully split the DB and things are working great! Sometimes, We're having issues after I send him the updated FE/DB. None of the forms work until after I go through a full recompilation. Not a huge deal, but why would that happen?

Found this: To split the database in Microsoft Office Access 2007, follow these steps: Create a new blank Access database. On the External Data tab, click Access in the Import group. In the Get External Data dialog box, click Browse to locate and select the database that you want to split...

Dad's not tech savvy, and The DB is probably 20+MB by now so sending it back and forth is pretty time consuming and fills his outlook boxes. How do I set up a FE/BE Split? Is it easy to split apart a 1 part DB into this arrangement?

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