Search results

  1. M

    How do I save/overwrite a SQL Union to a table?

    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))...
  2. M

    Solved Same Database. two different results on two different machines

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

    Limiting access to Add / Edit last/current record

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

    What Event Procedure Parameter do I want?

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

    Send to Back / Send to Front Wierdness

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

    Label generated from Form - Single record

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

    making a "for..next" loop to export to excel

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

    Icons in Access

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

    Hello to all of you (to whom I will later refer to as gods)

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