Search results

this was an excel data entry b4. i tried defining field2 at table level as a drop down but that gave little wiggle room when i tried to add the conditionality at form design field1 field2 anything anything Customer DropDown repeats down form

If I have a form based on a table with 2 fields. If field1 = "Customer", then I want field2 to show a dropdown list from another table with 1 field in it, else no dropdown list should apply. Not quite sure best way to approach ?

I can't say for sure, BUT, I believe you have NAILED this down COMPLETELY now!!!

Did U modify the logic? This looks like it worked very well - even on multiple pages !!

Just copy and paste some more records into the Table - until it goes to multiple pages ... And try again ...

Where exactly where wud I code the image reference and how should the image be saved and loaded and referenced ..

There is an issue if there is more than 1 page - not working correctly.

NO, I DO SEE IT NOW!! Nicely done! What do I do get the other vertical grid line to show too ?? Thanks !!

yikes !!!

This has to work in Print Preview/Print. I did not see anything different?

Rarely, but possible to have many pages for very long/large construction jobs.

Here it is

How do I post the only the Table and the report ?

If I change the height of the Detail vertical lines, then the detail section just stretches way down the page for each detail line record. Some kind of modified code is needed in the Dummy Section.

Just tried that and no good.

They are lines drawn on the detail report section ...

[code] Private Sub DummyGroupFooter_Format(Cancel As Integer, FormatCount As Integer) Dim footerPos As Long ' Dim countspace As Long ' countspace = countspace + 1 footerPos = 7.6 * 1440 'desired position of footer in inches * 1440 twips per inch) If Me.Top < footerPos Then...

Thanks. Does the emoji have to be a stored field (what data type) in the table ?

Is there any way to print/include an emoji on an access REPORT ?

SO far, nothing is looking that good. On the app I have working now, I copy and paste from a web page. I'm wondering if the way to go is to convert the pdf to a "same looking/ formatted" web page from which I can copy and paste as I do in the app I have now ?