Search results

Hero Status.

Thanks, you are always my hero. An Excel sheet needs to link to this for now ( I know I know but don't have time to migrate everything into Access) so I need a table for now. I don't know the SQL syntax to turn the above into a make-table. I think I am being dumb, however nothing is obvious...

This has to be easier than I am making it. This union works fine but I am lost as to how to save the unions to a new table, say eoy2020. Thank you to anyone! SELECT * FROM eom0920 WHERE (((eom0920.[Row]) Is Not Null)) UNION ALL SELECT * FROM eom1020 WHERE (((eom1020.[Row]) Is Not Null))...

Hello, On one computer I open a database with NO external links, tables, etc. All self-contained. I copy the 9 meg database over to an identical laptop and only the first three of six rows display in a table. It's exactly the same database. The underlying tables in the database all contain...

You know, you are correct. It all comes down to training.

Thank you to all the unsung heroes here who are responsive and so very very helpful. I have a subform in datasheet style that I need to allow an end user to Add AND Edit the last record before they print a corresponding label. It appears that once they move away from the record anywhere else...

I have a form with with two subforms. All works well and an Event Procedure tied to Double Clicking an event procedure (Forms![SkidTime]![WorkorderSkidTrackingQrysubform].Form.Requery) works well. What do I would like to do is have it update as soon as I change one control. None of the other...

ah yes. Thank you

I have a two-tabbed form, for now the second tab is (supposed to be) empty. Two of the fields from the first tab are showing up on the second tab. If I move those two fields to the back, they go behind the first tab. If I force grab all fields and first tab and send to back, they will show on...

This has to be simple. I have a form generated from a query with a linked subform and some calculated fields. I want to print a label from THAT record but when I create the label, it wants to print everybody and their cousin's labels also. How do I select that record only and where is the...

Thank you, again. Funny because the example they are showing is example what i am using it for. Appreciate it!

Hello, On a form with [name], [color], [poundage] and [rolls] My need/want is to export to a new excel spreadsheet based on [name]: a heading row with: name color poundage rolls and then the SAME name, color and poundage for the number of rolls there are so if Name is Mike, Color is...

Bingo. Had not been to this site. Thank you for the fast reply.

I've learned a lot in the last week and this site and Google have been kind to me except for this: How do i find, call up or download images / icons/ bitmaps like the one that seem to be on a lot of default forms? (Attached) I've downloaded .ico and .png and .bmp files but they are "blocky"...

small g, lesser gods, like Snoopy, Ironman, Cold Beer. :)

I am the operations Manager at a place that makes filter material (think Covid-19 and N95 masks). Took the job and Covid-19 hit and company growing quickly. Created a large database project to track inventory and have been googling my way through it and the help I have pulled from this site...