Search results

Ack. Will do :)

I'd just want to do a follow up. This has been resolve. Thank you very much for all the help received!! And very special thank to arnelgp for taking this one on :) .

Sorry mate, but I don't understand your approach. Do yo want me to discard the VBA code proposed earlier : Function ClearString(strIn As String) As String 'Remove rightmost numbers With CreateObject("vbscript.regexp") .Global = True .Pattern = "(?:[^A-Za-z]+(\s*))*" CleanString =...

Do I add this code in a Event procedure of the combobox ?

Gotcha. The suffix is a set of max 3 numbers from what I recall. No space, No hyphen, No special caracters. Just like this : company123 ...where my objective is for the combo box to show just company and disgard the suffix.

You are correct. When I laid the initial scenario I missed out the fact that with a select fonction we could isolate the company name, but unfortunatly it is not the case :/ Its a case of different company name (7 in total). All enteries are starting with one of the company name, that is for...

There are indeed some variations on how someone would write his Company nomenclature. There are 7 company. We have to assume that each company has a different name, sorry if I was miss leading in my initial post. One thing is for sure is that when an employee write its entry he/she writes in a...

There is not alot of company ... maybe 7 in total Is there a work arround if I create a seperated table that contains just the list of the company? ... but then how would the cascading combo box be working ?

Hello, Sorry for the noob question, but I’m trying to build a cascading combo box where the user gets to select a company (Company A, Company B, Company C). The main table contains the issues for each of the Company but it includes the sections as well which makes it complicated to work with...

This ^^^^^ Is working!!!! Thank you !!! Thank you!!! Thank you !! :) Sent from my iPhone using Tapatalk

As requested, this is the code I'm using. If anybody can help finding the mistake that would be appreicated. Option Compare Database ------------------------------------------------------------------------------------ Private Sub OptionGroup1_AfterUpdate() Select Case True Case OptionGroup1...

I know what you are refering to, but I think my struggle is that the the textbox is not refreshing if the user is selecting another option. Textbox is showing only the first selection response. If user changes its options the first response remains in the textbox ... Sent from my iPhone using...

Thank you for the assistance. Unfortunately by doing so only the first combination is working and this is only true if I replace : Private Sub Form_afterUpdate() By Private OptionGroup1_Afterupdate() ... but then what about OptionGroup2 ?? Also when I select another button the text in the...

Hello, I’m currently putting together on a form 2 option groups with 5 options each. The result of the selection of the radio buttons produce a statement in a text box. A radio button have to be selected in each of the option group. Therefore there is 25 possible statements. I’ve associated a...

Hello, Still noob in construction of DB, but looking forward to learn more and share experience. My programming skills are average, but I did sone vba stuff over excell a few years ago. Thank you :) Sent from my iPhone using Tapatalk