Search results

I have two forms, when the user has finished the data entry in the 1st form they click on a button which opens a second form, how do I save the data on the first form Onexit?

I have an ID field (Text Data Type) which has an input mask [00\-00\-0000;_ ]and a format [00-00-0000] but when I open the form the ID is displayed without the formatting. The formatting is applied only when I click the ID field on the form, how can i change this and set the formatting on the ID...

This is what I have and it is not working for me Private Sub ListSymbolSelect_Click() Dim varFieldName As Variant For i = 0 To Me.ListSymbolSelect.ListCount - 1 If Me.ListSymbolSelect.Selected(i) = True Then varFieldName = i 'do something End If Next i Dim ctl As Variant For Each ctl In...

ok great, Now I want Access to display only the controls that are relevant to the values selected by setting their visble property to true can I just enter dim varFieldname as variant For i = 0 To Me.ListSymbolSelect.ListCount - 1 If Me.ListSymbolSelect.Selected(i) = True Then...

thanks, how do I reference the values that are selected if there is more than one value?

how do I allow multiple selections from a combo box?

thank you so much!

I just need the correct syntax to reference the selected option on a combo box. something like: me.comboname.selected.value or me.comboname.value= "aa"

The Combo box is a filter only showing the controls on the form that are relevant to the selection.

How do I reference the selection made on a drop down control? I have a drop down control with values AA,AH,AP and more If AA is selectedthen I want access to show more controls for data entry relevant to AA ANd if AH is selected then I want it to show controls relevant to AH etc, the drop...

I have two forms which include fields from a table. How do I connect the data from both forms to one table with one ID? I also have two forms that are used for data entry, how do I connect the data from both forms so they enter their data into the necessary tables?

how can I send it to you without posting it here in this forum

yes of course I do, what are your suggestions?

I attached the relationships. each table has more fields the icon tables have many more nutrients and the symbols table different types of symnols

the main table is product information, then I have three tables for the icons displayed on the products. The icon table has 50 possible values and the user needs to select when the icon value is present and its location. I have not found a way to break the tables down.

i cannot split the tables any more

I have one table with 100 fields joined as 1 to 1 to three more tables that have 30 fields each

I have subforms because the table has many fields, I created the subforms to display the fields under categories

I have a form with a product ID and subforms with other fields from the same table. I enter the ID in the main form but am not able to enter data into the fields in the subform. I get an error that the PK cannot be a null value. How do I link the subform to the form so that the ID I enter in the...

I keep getting the "Property Value is too large" when I add a description to a field in an existing table. The same error was resolved on another table by cutting four fields then saving then pasting them back into the table and saving again. I tried importing the entire DB into a new file...