Search results

Ok Im an idiot... sorted it... For anyone in the future who needs it.. SELECT Distinct Location FROM Client ORDER BY Locaton

I have a client table with a field called location. On a reports form that I have, I want to make a combobox for all of the locations, so it could show all the clients from a particular location and also it would reduce the errors due to someone spelling a place name wrong. I could set the...

Yea yea I know, another one... But the way I see is that I haven't asked them all so its ok... :p Right basically, I only want to allow input of Y N or P into a text field. I thought it would be best to do it with an onkeypress event as I know of no way to block certain characters in a text...

ordinarily i would use an autonumber as a primary key but the client insists they want to use names, I have explained to them but they are digging in their heels and think they know best! Ill give what you said a try and we'll see what happens. Cheers Edit: Just tried what you said and it...

Have a form with three buttons saying for example... English French Spanish When you click the English button it does this... DoCmd.openForm "YOURFORMNAME", , , , , , "English" and for French... DoCmd.openForm "YOURFORMNAME", , , , , , "French" Then in the onLoad event of the...

I have a form with two tabs... Its record source is Person and Account. The main tab has a load of fields relating to the person and the other tab is meant to show the bank accounts that the person has in a subform. However if there is no bank account for the person then nothing will show in...

Just figured it out, in the query I was refering to the Depreciation form, as [Forms]![DepreciationSF] but it was a subform of [Property] so it should of been [Forms]![Property]![DepreciationSF] Rookie mistake!

Hi there, I'm trying to make a form which calculates the annual depreciation value of a property. I have tried using the PrevRecVal function and I even made the following query: SELECT Last(PropertyDepreciation.[Total]) FROM PropertyDepreciation WHERE...

Ok all sorted now.

Im assuming you're using a button or something to trigger the search? In the on click event of the button put an if check... for example if isNull(article.Value) And isNull(line.Value) And isNull(process.Value) Then 'If they're all empty then show a message MsgBox "Fill in the fields...

Hows this.... Private Sub cmdClose_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single) Command0.ForeColor = 255 End Sub Private Sub cmdClose_MouseUp(Button As Integer, Shift As Integer, X As Single, Y As Single) Command0.ForeColor = -2147483630 End Sub

OK heres the deal... I have a property form for keeping track of houses and buildings owned and then on that form i have a policy field for the policy number of the insurance called txtPolicy. Next to that field I have a little button which opens a form so it will show all the insurance policies...

no need for the sarcasm but thanks yea that worked :)

How about right clicking on the combobox and then clicking on the Row Source box and clicking the button to the right of it. Then make a query so it selects artist from the artist table where the Artist.RecordID = Forms!FormThatItsDisplayingIn!RecordIDTextField

Nope still doesnt seem to work, just sets the focus on the loginBtn. hmmm

How bout making an onclick event for weekly updates and putting something like... textboxHistoricalfield.Value = textboxWeeklyfield.Value That any good?

I have a login form which works fine, but I would like it so that when the caret is in the password field that if the user presses Enter it will do the loginBtn_Click event. This is what I've tried so far... Private Sub txtPassword_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode =...

Cheers, that works when you tab out of the text box or click out of it but i wanted the button to become enabled as i was typing in the search box, thats why I tried it in the onchange event. Any ideas?

I have a text box i am using as a search text box. I have a search button which I want to only become enabled when there is text in the search text box. I have tried the following in the textbox on change event but to no avail. if searchBox.Value = "" then okBtn.enabled = false else...

Thanks very much neileg, all done now! Sometimes it helps to just get a fresh perspective on things! Cheers