Search results

Hi Ian, This came up recently have a look... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30118&highlight=mouse+pointer GHudson's post may be the most helpful. Rich

yourcombo.column(1) is what you want, if you only have one column visible. VBA automatically takes the number (.column(0)) if you don't specify the column. HTH Rich

Yes you can do it on a form and it probably isn't too complicated. For starters you could have a combo box to select male, female or both. You could add other combo boxes for other criteria that you do or don't want to check for. The combo box selection can be gathered in the query criteria...

The code would probably look like this. I suggest you use it in a form rather than a query. You might be able to make it work for the query, do any of the 'experts' know how this is done??? Private Sub yourCommandButton_Click() ' Dim MyString As String Dim MyLen As Integer Dim...

You can use the InStr function to search for a particular character. So say if you were searching for the letter a, you would do as follows InStr(0,YourString,a) 0 represents the start (if not specified it will automatically start searching at the first character. Look up InStr in help. But...

What's wrong with the AllowOnly function that PCS suggests? I'm pretty sure you can get this to disallow spaces. If you don't trust it remember you can use Trim[$] to strip the string of leading and trailing spaces first. Then do Len(yourStringExp) to check if it is too long. Rich

Mark, Dunno if this is the best way, but here goes: Private Sub Combo1_BeforeUpdate(Cancel As Integer) If Me.Combo1.Column(1) = Combo2.Column(1) Or Me.Combo1.Column(1) = Combo3.Column(1) Then MsgBox "same" Cancel = True End If End Sub I think you'll have to reference...

Open the relationships window, it's a symbol on the toolbar with three linked tables or Tools|Relatioships. You must define relationships for your tables. If you haven't done this before none of your tables will be linked, so 'show' your tables that need to be linked. Join your tables that...

Hi John, Remove the tick from the 'show' field in the query for [Expr1] year. The criteria will still be used but the column will no longer be shown.

DAFTY!!! CH08.mdb probably stands for CHAPTER 8 of your book, so it's gonna be on the CD that came with the book! hee hee

Here's a thread for a similar question, which will help you http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=30988&highlight=date Rich

Hi! If you've got things like " for inches this shouldn't be a problem as the Val function only stops reading the string at the first character that it cannot recognise as part of a number. It also strips blanks, tabs and line feeds from the argument string. eg the following returns the value...

Rick, Something like this might work... Private Sub yourField_Click() Forms!yourMainForm!YourTextboxOnMainForm.SetFocus Forms!test1!YourTextboxOnMainForm.Text = yourField.Text End Sub so the code goes in the click event of the field in your SUBFORM. When you click on the field...

Hi Shula, Can you post the code as well, then it might be easier to see what is going on and someone else may help

I think there's a couple of ways. Do you mean that you have two tables with identical fields and do you want to add records from the second table into the first table? You can do this with an append query. Create a new query add the first table to the query change it to an append query and...

Just checked selStart, seltext and SelLength are in VBA, search in help if you want to know more about these functions. Rich

Hi Chris Try this, Private Sub yourtext_GotFocus() Dim textlen textlen = Len(yourText.Text) yourText.SelStart = textlen End Sub It counts the length of the text, stores it and then sets the cursor starting point to the stored value. I tried it in VB, hope it works in...

"i havent used a query to populate my prescription forms...i have just bound them to the table that the info needs to be in! I am thinking that this is a bad thing??" It's always better to use a query. You might want to make the query select everything in your table for now. But further down...

This sounds like your operating system is set up wrong, rather than being an Access problem. Go to the start menu, then select settings and control panel followed by regional settings. Select the currency tab and change it to £'s. I think it's the same on most of the operating systems, is on...

OK, Someone had the CHEEK to beat me to it, while I was typing!:mad: :mad: