ACCESS Form does not show all records when Subform is present
Hi All! I'm suffering a strange quirk with my Access forms/subforms. Whenever I set up a form / subform combo the form does not show all the records it should be showing. I have 3 tables. Table_1 holds the company data. When I select one ORGANIZATION (I have 7 right now) from the yellow dropdown ACCESS should populate the CONTACTS I have in said ORG and show them as a continuous subform (CONTACTOS). I get the list should nor be longer than whatever fits above the next subform (maybe 20+ at the moment?). But it's only showing 2 (out of a possible 33). The lower subform shows all Interactions (call, visit, email, etc.) I had with that person (presently 1) that I selected in the CONTACTOS subform.. Notice there are 33 records in CONCTACTOS, but ACCESS is only showing 2. If I scroll down I can see all 33 just not at the same time. If I remove the last subform or push the window up or down or pull the first form's background up or down the number of records shown grows or shrinks. Any ideas as to why it happens and how I can fix it? I'm sure I'm missing some parameter somewhere in properties but I haven't found it yet. Can I force ACCESS to show a certain number of records? Please help! Miguel
Labels automatically resizing in form design - Access 2019
Hi, Not sure if it is just me not seeing a setting somewhere. In previous versions I cannot remember this happening but it is rather annoying. When in design mode of a form, if I change the text in a label, the label automatically resizes. Is there a global setting to turn this off? This is only relevant AFAIK to Access 2019, I use 2016 on desktop when in the office or using company laptop and do not have this issue. Basically my use is within a suite of database front ends I have developed, they all have the same type of form design so I can copy a form which does a similar function from one of the databases when building a new one to add into the suite. All my labels are nicely sized so everything is uniform, but when I type a different text into the label (e.g. change from Order Number to Employee Name) the label resizes itself and I have to then resize the label again so that it fulfils the requirement of my OCD. Added a couple of example images. In image 1 I have taken a form which is used to add employee skills, made a copy and now changing this to add in an absence. Changing the label text automatically resized the label meaning I have to then go manually resize it to what it was previously. Hope that is enough info. Sensible answers only please. I could write VBA or use Access 2016. I only require a response if there is a way to do this or not, and if possible how to prevent it from happening. Thanks in advance.
Specific Form
Hello, I want to create a Form for data Entry but what I need special from this form is to get list from a specific query. Example: I made a Query 1 (Available Worker) from Table 1 (Workers) with specific criteria lead me to know who is eligible/available to work, then those beneficiaries of the Query 1 I want to create a data entry form for them in order to provide or fill the Working date and Time in/ out (Which is doesn't exist in the Query 1 or even the main table) then I want the result after the fill of each entry to move to Table 2. Please advise me.
