I have a database which records info about disabled people. One form is used to input comments about the the person and has several memo fields. The user...

I created an unbound form and used Allen Browne’s vba for “Limiting Report to Date Range�. This works nicely. But I want to use this vba to pull two...

I have a main form Containers with a subform ContainerSubstances. The latter has a combo box showing the substances in the Substances table. If the desired...

I'd like to find a case's end date when users enter information into the form. Text Box names denoted within . For Example Start Date = 4/1/06 (Cases start...

Using Access 2003, I have a subform in datasheet view which gets data from a query which sorts records in alphabetic order. The subform specifies vertical...

Hello! I am in a situation that I don't to see why it doesn't work. I have: 1 - T_AllData: Name, Date, Value, ... fields 2 - T_MonthYear: MonthYear field,...

I've imported a table with a memo field in which I've used "QQQ" to signify whare I need line feeds/carriage returns (there are lots, in lots of records!). I...

I have a subform linked to a master form. The subform is set not to allow additions. When the master changes and there are no records in the subform, the...

I am following the directions for creating a password protected form in access. I have copied and pasted the information into the module and also into the...

I need to have a Text control remain transparent during focus. I have overlayed this control over an image so the user can type text over the image. As soon as...

Good Morning all, I have been trying to create a sequence number with a unique last three digits. The number has a total of 14 digits. I can concatenate the...

Hi all, Ive asked this question before a different way but got no resolution. So here's my problem again, please advise on alternative workarounds or...

I'm doing a contacts db, and have a search form that contains a combobox for user to select the field (cboSearchField) to search and a text box for entering...

I have two objects on a form that I am trying to manipulate. The first is a combo box to select a credit card type (Mastercard, Visa, Discover, Etc.). The...

When I create an Option Group on a form, it seems I can only select a numeric value in the Option Value which files to the table. When I create reports I do...

ACCESS 2000 I have a switchboard that has serveral menus and sub-menus and I am finding it very excessive to keep making a MAIN MENU button. I have made a...

How do I Make fields or a field able to be left Null or required based on a prior fields combobox value or a check box selection. For example , if textbox...

I have a switchboard form which (obviously) opens other forms. My problem is that whenever I return to the switchboard from a form that was maximised, the...

I have created a form which I use to provide parameters for queries and reports. Upon opening the form three list boxes to provide lists of options for...

I have a database of training for each employee. How can I attach a photo of each employee to the query that looks them up by name?