Search results

Hi all, On one of my forms I have a post code finder. You type in a postcode and click search. I have a piece of VB code which queries a web server for all addresses within that postcode. The web server returns a result and then the VB code parses the result and returns it to a format...

How can I instruct access to select an item in a dropdown combo box automatically? Also, is it possible to make a combo box drop down automatically? Thanks

I'm getting this error when I run the following code: txtMyTextField.SetFocus txtMyTextField.Text = "Hello" Run-time error '2115': The macro or function set to the BeforeUpdate or ValidationRule propery for this filed is preventing Estroli Data Input v1.1 from saving the data in...

Is it possible to make two events run the same sub routine? eg. Private Sub cmdGo_Click(), txtInfo_Click So if you click the cmdGo button or the cmdInfo button access would run the same routine.

Hi, I have a form in which users input credit card applications. Each application is an A4 page, therefor each record is an A4 page. I have created a report that will print out any record and this works fine... but Ideally the user would key in the data in the form and then choose 'Print' and...

>LL00 0LL This input mask does not work because some post codes have only 1 numeric value at the start. eg EH3 8BJ instead of EH33 8BJ Is there a way around this?

Thanks but the values have to be held in one field. Here is exacly what I'm trying to do. I have a serial number which always starts with 0770375 and then the last three numbers are different for each item. It would speed up the data inputing process If I didnt have to input 0770375 for every...

I have a form with two text fields. I want to be able to enter values into both of them and these two values would combine and be added to one table field. eg. If I have a text box for Firstname and one of Surname, the values for these would be added to just one field in the table called Fullname.

I have multiple records and I need to run a query that will filter postcodes beginning with BS and LS. Any ideas what criteria I would use for this

I have put that into the AfterUpdate even for the text field but is doesnt seem to have any effect

Hi, I want to have all text trasformed to uppercase when a text field is updated. I know that =ProperCC() with put the first charecter of each word in uppercase but how to I make all text uppercase auatomatically?

Oh aye, I figured all that out now, Cheers Mike :D

Mike, Can you explain what roll the txtData box has? Could you explain the code briefly? Option Compare Database Option Explicit Private Sub chkLock_AfterUpdate() If Me.chkLock = True Then Me.txtData = Me.txtSurname Else Me.txtData = vbNullString End If End...

Hey folks, I'm trying to lock values in my form so that they dont have to be retyped or reselected. Does anyone have any VB wizardry they could throw at me? The lock check boxes are just dummies right now

Yeah, that works fine but not for text boxes unfortunately

Hi all, I have a table with a list of about 50 employees. In my form I have a employees value. Is there a way in VB that when I enter the first few letters of the employees name it will predict (from the employees table) what I am about to type? This would save me alot of time. I assume that...

Please read - thanks! http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=47627

I currently have the following code for the add record button:

That sounds about right. The check box does nothing at the moment as Im not great on scripting

If I enter in a name in a form field like: jonh doe can i get access to automatically change it to John Doe - like the PROPER command in Excel.