vbams-access
Field in DB Form display Index number vers content from field the bound table
Hello All, I'm copying records from one table "Abgabe_Unterlagen" to another table "Ordner_Liste" after a condition is met.
I cannot get the all the entries from the table "Ordner_Liste" to display the content in related Form F_Ordner_Liste e.g. "Mandant_Nummer" and "Art_Unterlage" display properly but Sachbearbeiter does not, it displays the index # instead.
Can anyone help ?
v/r Banyan
Solution
For those comboboxes, set:
- the column width for the index field to 0 (zero)
- the column count to more than one - to also include the description field
- How to make Colors Mixer in vba
- How to get HEX color value from cell color?
- VBA Macro doesn't work if the selection is only have 1 instance of the searched character
- Deleting a file in VBA
- Trying to late bind outlook to but getting type mismatch error after create object line
- Bitly API call using VBA Excel Macro
- excel vba projects not closing
- INDEX MATCH to also pull through notes
- Move formatted data in selection from Excel into Word tables
- Excel VBA function to remove letters at end of string
- Excel function to construct an array from values without VBA
- Alternative method to delete file with out having to add MS Scripting Runtime Reference
- How to implement joining muiltiple curves is Catia VBA?
- VBA: How to Loop IF Statement through a Cell and Chart Series
- Incorporating Checkbox to lines of code rather than Cell value
- How to write txt file at same file path but preventing window to update notepad display
- How do I remove a character from a column of data in Excel
- Loop to enter email address and attach applicable pdf
- Jump to an absolute page from the beginning of the document
- Excel VBA Selecting the files xxx_Before.log then xxx_After.log
- Run Time Error 1004 'Unable to get the PivotFields property of the PivotTable class' with Data Model Pivot Table
- How to find R_HOME with VBA Environ
- Append excel cell to end of a link and create a hyperlink
- How to Insert Double or Single Quotes
- How to get Reference plane from Sketch
- VBA create pivot with "data is added to the Data Model"
- Merge cells and add borders
- Need help about transposing rows to column
- how to check whether Scripting Runtime is available
- Optimize VBA code on lookup without using Vlookup