I created a report from a table and it is working fine.
I have a field in the report header called “Source” and now I need to add a field in that header based on the value in the header field “Source”. The new report field is called “Text32”.
I created a table, “Source_Name” that has two...
I have a VBA module that populates controls in an unbound form with data from a table. The module then opens the form which also contains a visible/enabled command button (Command1)that the user clicks to send selected lines from the form (user clicks check boxes to indicate which lines)back to...
I have a form with rows of data that I want to process one field at a time. When I built the form each field is assigned a sequential "Textxx" number e.g. Text1, Text2, Text3, etc. The form and fields are not bound and the form is populated by running a VBA module that retrieves the data...
Have a form that lists rows from a table; one row per form. Set form to continuous so multiple rows appears on a page. Put a check box to left of data from table to allow user to pick rows from the list to process/not process in the next step.
Problem: when I click any one of the check boxes...
I want to run an SQL Select query in VBA to fetch one field in a row from the table using the primary key in the WHERE clause then perform an validation as to whether the Select found the record or didn't find the record.
Is there a simple If statement I can use to perform the validation...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.