Search results

I have two fields in a form: month and day. When I select the month, I want it to narrow down the day to the appropriate number (eg I don't want 31 to be an option for months with 30 days). Is there a day of week function so I don't have to type out code for all months and the amount of days...

When I update a combo box to "Active," I want multiple fields to be enabled. I know the way to do it field by field. Example: If Status = "Active" Then Trial.Enabled = True Else Trial.Enabled=False End If Since there are several fields, is there a way to group those fields and name...

Originally I was working on a shared drive, but no other users. I had this error message a couple days ago, but only lost a little work. Then I switched to working on my desktop because it's much quicker than our shared drive.

When deleting a form, Access crashed. When I reopened it, I received the following error message: The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only if the VBA project is first deleted. Deleting the VBA project removes all...

From one form, I am trying to open another form to a specific subform. So from frmContractAffiliateForm, I would like to open frmContractForm where the COID is the same on the parent form, and the ContractID is the same on the subform. Here is my code so far (without opening the specific...

I thought I had tried that, but apparently not because it worked this time. Thanks!

I have two related forms: 1. frmContractForm (parent derived from tblCustomer) with the subform frmContractSub (derived from tblContract) and 2. frmAffiliateForm (parent derived from tblContract) with the subform frmAffiliateSub. I have a button on the subform of frmContractForm that I want to...

I am trying to create a combo box in a table that looks up values from a query. The table I am working in is: tblNotices. I want it to look up the query qryFirstLastName. In qryFirstNameLastName, each COID (customer ID) has up to three different RecipientNames. So in a record, I want the...