I have a combobox that is pulling pallet numbers from a pallet lookup table.
Once the user selects the pallet number from the combobox, it flags the pallet number from the pallet lookup table and sets it status as used.
The next user only sees available pallet numbers.
Here's my problem if they accidently select the combobox and delete the value listed they cannot select it again unless I reset the status to available.
I know in VB there is a drop down list that is read only. Access only has a drop down list for dataaccess pages.
What I want is once they have selected the correct pallet # then they cannot delete it from the text box area until they have finished scanning. The they click End Scan button and it resets the combobox with "".
Unfortunately you can't lock a combo box in Access. But you could change how the combo box gets it's recordsource data. Create a subroutine when you open the form to do the following:
Dim db As ADODB.Connection
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear? Sometimes you may have an additional problem: where the devil did they go? If you last had a popup form open…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…