Search results for query: *

I am using three data combo's attached to 3 separate ADO Data Controls. When the first combo box has one of it's list members selected, this is passed as a parameter to the SQL which populates the second combo. However, once I click the original combo, the first value has been replaced by the...

OK thanks, I cracked it! I was just trying to call the value in my text control (in the higher group) incorrectly so your code worked fine! Thanks again, Chris

Thanks Paul, That kind of works but hides all group headers. What I am requiring is as follows; If TopGroup = 1 then show low group header otherwise if topgroup = 2 then hide low group header but obviously only within that top group. Hope this gives you a bit more information as to what I...

Is it possible to hide/supress a group header based on the value of a field in a higher level group?? Thanks in advance. Chris

Hi, I have some 40 controls that I need to call the same piece of code (a public sub created in a module) when each control loses focus. I was just wondering if there was a quick way to kind of do this once or do I just have to paste the sub's name into the LostFocus event of each of my 40 or...

Hi, Our company has a production database (sql2000) on a server in China. In the UK we run sql7.0. Is it possible for me to make a backup of the database in China and restore it to the SQL server in the UK, after transferring the backup file over a secure connection. If not, is there anyway...

Thanks Gary, I just set all of my forms to start invisible and this seemed to do what I required. Cheers, Chris

Hi all, I have an application with some 30+ forms. Based upon a security table that I have set up determines which menu buttons are available to a user. However, upon logging in the user can see all of these forms having there various buttons enabled/disabled. Is there any method of hiding...

Is there an equivalent to the MS Access IIF function in SQL?? TIA Chris

Cheers John, Thats a great help. Chris

If you use the Forms 2.0 controls, doesn't that mean that the destination machine for the client must have Microsoft Office installed? I could be wrong but I am sure I read that somewhere when investigating unicode controls within forms 2.0.

Hi John, The code you posted seems to have worked a treat, thanks. However, I don't understand what the code in the change events of the text boxes is doing. It is probably quite simple, but I just can't get my head around it. Don't suppose you could give a brief explanation. Thanks, Chris

Is there a quick way to determine whether a combination of three text boxes each have entries, i.e. 1&2 or 1&3 or 1,2&3 without using multiple IF statements??

Sorry, I should have made myself a bit clearer. In this situation, the same procedure is called by two text boxes when each loses the focus, therefore I would need to return to a specific control dependant upon the one which had just lost the focus. Not sure if I am being very clear here! Hope...

Hi If I run a procedure on a text boxes contents when the text box loses focus, how can I return to that control if an error criteria has been met? TIA, Chris

In the past (probably in DAO) I have used the following; with rs .edit !field1="xxx" .update end with Is there a direct replacement for this in ADO? TIA, Chris

Hi Sunaj, Thanks for all your help on this! It appears that the problem was occuring because I was using UniCode text boxes via the MS Forms 2.0 reference. Using standard text boxes allows it to work no probs and it also does exactly what I want. Thanks again, Chris [thumbsup2]

Sunaj/anyone else who can assist, I have tried using your code sample from your first post and this works without any problems. However, as soon as I replace Text1 in this line, ChangeText Text1, "hello" with txtComponent (the name of my text box, I receive the run time error (13...

Sunaj, sprBOMDets.text represents the text contents of a cell within my grid control, and it is this value that I want to pass to the text property of the text box X. Is there something very simple that I am missing here? Cheers, Chris

Sunaj, Please see my code below (missed some off before...sorry); Dim Disable As Boolean Private Sub DisableSpread(X As TextBox, Txt As String) Disable = True X.Text = Txt Disable = False End Sub Private Sub sprBOMDets_Click(ByVal Col As Long, ByVal Row As Long) If Col = 0 Then...