All Questions
479 questions
Best practices
1 vote
7 replies
103 views
Loading XDP, in PDF with multiple subforms, already certificate signed
A smart PDF is given. Adobe LiveCycle Designer ES 10.0 PDF https://mfinante.gov.ro/documents/2552173/3124827/ALOP_DocumentFundamentare_V03.pdf It's even more special, it has 2 different sections A and ...
-1 votes
1 answer
71 views
MS_Access Use buttons to filter Subform
I am building a visual organizer for a bookcase in MS Access. I have a main form with a grid of buttons (representing locations like "A1", "B3", "D1"). On the right side, ...
0 votes
1 answer
45 views
Method or data member not found when trying to filter a table in a subform. MS-Access
I am trying to filter a list of production numbers based on the staff member who made them. I am using the StaffID in column 0 of a combobox to do this. When I try to run the code, I get a compile ...
0 votes
1 answer
104 views
Why cannot my forms/subforms become moveable
I am trying to redesign my database (Access365). I want all my forms and subforms to be moveable, but when I try to change the moveable option in the property sheet into "Yes" it is not ...
0 votes
2 answers
81 views
How do I set a filter on an access form using results from a separate query?
I currently have an access form that contains Assembly Part numbers and a subform that lists the components that make up the assembly. The user can easily look up any Assy Part Number and see what ...
1 vote
0 answers
63 views
Can LibreOffice Base expand a subform record with a click on the main record
MS Access allows a subform in datasheet view to appear by clicking on the + to the left of the main form record. Can Libreoffice base do this? Can we get similar functionality somehow? I know some ...
0 votes
0 answers
51 views
MS Access subform giving error "you cannot add a record because a record is required in table X
I have a form with a subform which I am trying to enter data into 2 tables: tblAnaesthesia and tblSamplesTissue. I have the autonumber primary key (called ProcRef) from tblAnaesthesia table which I am ...
0 votes
1 answer
114 views
Adding Subform fields to approval summary in zoho creator
I am creating an e-procurement application on zoho creator.When a material request is submitted.It should be directed to manager for approval. In the approval summary, I am not able to see the product ...
0 votes
1 answer
121 views
Auto populating a sub form based on purchase order id in zoho creator
I am new to Creator and building an e-procurement application. I have two forms - one for Purchase Order and a second one for Goods received. On the Goods received form, I have a sub form with fields ...
1 vote
0 answers
35 views
Why in subform2 the event Form_Current with a requery command is not fired when called by subform1
I have 2 subforms. When focus changes on sfrm1 I want to requery sfrm2 which is only to display data not editing. In sfrm1, event Form_Current I do the requery: Me.parent.Controls![ctlsfrmShowLos]....
1 vote
0 answers
101 views
Microsoft Access 365 - Combobox with dynamic values
I have a scenario where I'm assigning users and machines to a project. This is done through a form and subform. The user selects the project and a week commencing date on the main form and can then ...
0 votes
1 answer
44 views
Data entry for 2 related tables with form, automatically input foreign key into main table
Working in MS Access. I am developing a customer loyalty database and I have 2 tables: Customers Names Admission Creation_Date Expiry_Date Contact_ID John Smith Adult 01/02/2024 01/02/2025 1 Contact ...
0 votes
1 answer
61 views
Problem with Subform updating half way through typing the contents of a text box and then it deletes the text already typed
Please see below. I have a continuos form that I have added a command button to. The command button opens a pop form. The form contains a subform. I have set it so that the user can not edit or delete ...
0 votes
0 answers
88 views
MS Access: Link detail tables to master table and create a corresponding form
I am creating a database of products. Currently, we have one primary table called "Item" and several other tables containing details about specific types of products. For example, think Item,...
-3 votes
1 answer
152 views
How can you pass the state of a variable to a sub-form?
I have a form which contains a bool unitConnected. How can I pass the state of this boolean to a sub-form which I create and open at the press of a button? Main form code: // Global variable public ...