Search results
Results From The WOW.Com Content Network
Discussion forum for Microsoft Access users. AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute.
General Access questions. AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute.
AccessForums.net is a forum dedicated to Microsoft Access, if you want to ask any Access related questions or help other members out, please join our community, the registration is free and takes only one minute.
BOM database - Bill of Material. This must be a normal use of a database (individual part used in assy's - seems like the classic one to many relationship situation), but I'm not finding any samples/examples. I am looking to have a table that self-references - a part can be a component of another part (assy), which in turn can be a component of ...
Public Function Row_Number(varChangeField As Variant) As Long. If varChangeField = ReferenceGroupID Then 'the group by field is the same as previous, increment the row counter. lngRowNumber = lngRowNumber + 1. Else. ReferenceGroupID = varChangeField 'the group by field has changed, reset the counter to 1. lngRowNumber = 1.
Drop down combo box, text field (but a number field on the main form as that stores the ID)- relate main table it to a gender table with a one to many. or if you want it in the same table then yes - as there are only two options () you can make it a yes no a button that but that will only allow you to see if ticked male OR female depending on ...
Also Question on "Remove Filter/Sort". Using MS Access 2016. I'm trying to find a list of msoControlButton values to use VBA to create one or more custom shortcut menus. To make it clearer, I'm talking about the lines used in the code, below, for example ".Controls.Add msoControlButton, 141, , , True". The number 141 sets up the Find command.
There is a Rotate Image button. It doesn't alter the original photo at all - merely changes how it is displayed in Access. Photos are automatically adjusted so that portrait photos are automatically displayed correctly. As a result, landscape photos may not be but can be manually rotated 90 degrees using the button.
Query -- Extract string between two characters ("," and "~") I need some assistance with an **IN BETWEEN TWO CHARACTERS** query. Now, I figured out how to extract both the last name and rank title. However, I have NOT successfully extracted the variable length first name. I only provided these two examples (Tom, Ann); unfortunately, based on my ...
Multi-line textbox. I'm trying to find the multiline property for a text box and I don't see it. I need the textbox on my form to be multiline, word wrap and have scroll bars as needed. I could swear the text box in access supported this, but perhaps I'm thinking VB. I'm using Access 2016. Any help you can provide is appreciated.