Search results

School boy error for the typo :banghead: However I have changed my code to that of the below but is giving the wrong results and just pulls back the name of the value for strPallet Dim strBox As String Dim strPallett As String Dim strBoxesPerPallett As Double strBox = cboBox strPallet =...

I have two combo boxes (both Text) which I need to use in order to lookup a numeric value in a table matrix. cboBox and cboPallet are my two combos I have the following code but I am getting an error "Invalid use of Null" Dim strBox As String Dim strPallet As String Dim strBoxesPerPallet As...

I'm using the Tag property (see attached image) on the Text Boxes and just putting GroupT and then referencing that. I have over 100 controls on the form so I dont really want to have to write code to check each one individually to see if it is enabled or not but I might have to if I cant find...

Yes thats correct, I want to limit it to just combo boxes so that I can deal with the text boxes separately because some of the text boxes are input ones but others contain calculations (which causes the error) hence needing to exclude them. However I have now used the Tag property to group the...

The user does not move through any other records on this form so this is not an issue. But thanks for the information as it may come in handy in the future. Also a BIG thank you for supplying me with the code and now works without errors. :)

I have tried everyone's suggestions and managed to get the code below to work. However it only works for combo boxes and not the text boxes. I think its because some of my text boxes aren't input boxes but I have calculations in the data source so I will check the input ones separately as I only...

My database is for creating sales quotes which can be retrieved to continue on where it was previously saved. So when I open the form to edit the quote I only want the controls enabled if they previous entered something in them and the others disabled until they then carry on selecting values...

You are a genius, this is so simple thank you so much. Works perfectly. I cannot thank you enough from a rescued damsel in distress. :D

I am still trying (in vain :banghead:) to get the set focus to work. The control i need to set the focus on is in the header of the subform of the NavigationSubform. I have set the tab stop to 0 but it doesnt get the focus until you click on the form. It seems that when you click the...

MsgBox Screen.ActiveControl.Name, 0, "Active Control" I only added this to test to see if the focus had moved after I click the nav button. I dont know what IIRC is. I do have the cboBillTo as the first tab control set to 0 but it does not get the focus until I actually click anywhere on the...

i cant get the builder to come up when in the visual basic window, how do I do this please?

I should also add that I have tested using the BrowseTo action in a macro and run that from a button from a different section of the main form and it all works ok with the cboBillTo control immediately getting the focus. Attached is the BrowseTo macro action which I dont know how to convert...

I have a main navigation form called frmMain which has with 6 navigation buttons each with their own form with the NavSubForm. One of the buttons is named navSection1 and a subform named DS within the NavSubForm. On the DS subform I have a combo box called cboBillTo which I am trying to set...

No worries I dont always explain things too well. When I say it 'appears' to disappear I mean that the bound value is still in the table but the description that relates to that code no longer appears in the combo box.

Attached is the app showing how I want the combos to work but I have bound column 2 to get it to work but I want to bound column 0. Perhaps what I am trying to achieve is just not possible?

I too always have the first column as the bound column and hide it with a width of 0 so I am doing something right them. I wanted to keep the lower level values and just highlight them when they are no longer a valid option but it seems that now the bound column and the displayed columns are...

This is correct and how I want it. The function the highlights the invalid selection prompting the user to change it. The table that joins the Department and Type doesn't contain unique values because a Type can be in several Departments and this is correct too. I have however review the Type...

Thanks for the reply. I have experimented with changing the order of the columns but still makes no difference. I have also tried to explicitly set the column widths as per the example below but that still does not show the the unbound column. If bolFlag Then...

Yes I did say that I changed the bound column and that I changed the column widths to hide the bound column. I understand this, but is there a way of retaining what was displayed in the combo box, I dont understand why it would disappear.

I could have sworn that I uploaded it. Sorry now attached