Search results

I am fustrated by this section of code. I keep receiving the following error message when attempting to run the following code: Private Sub Confirmbutt_Click() Dim Db As Database Dim R As Recordset Set Db = CurrentDb() Set R = Db.OpenRecordset("propertyIDSearch") Me![PropertyID] = R(0)...

Private Sub Quantity_AfterUpdate() If [Quantity] < 1 Or [Quantity] > 3 Then MsgBox "Invalid Number Of Labourers", vbOKOnly [Quantity] = Null [Quantity].SetFocus End If End Sub The SetFocus command doesn't seem to work. I want the cursor to be set in the "Quantity" test box, but it...

I am developing a simple framework for a logon script. I have a simple table with two fields: Username and Password. I have a form based on the table with the two fields and a button entitled 'logon'. Can anyone tell me how to go about using an OnClick event for the button to reference...

This is simple, but it has stumped me today. I am adding code to the onclick event on a button, on a form. The button needs to delete the current record and then display the record prior to that on the screen. I would like to have a "are you sure" option and so far i have managed to complie...

How do you add code to the individual date buttons on an activeX calender as when u go on th eonclick event it does not relate to a specific date.

Private Sub Grade_A_AfterUpdate() If [Grade A] <= [Grade B] Or [Grade A] > 100 Then: Rem Too low MsgBox ("Invalid Grade Boundary. Please Check And Try Again.") [Grade A] = Null: Rem Clears box [Grade A].SetFocus: Rem Places cursor...

I need to translate this visual basic code intoc ommon english, sort of like a description of what is goin on at each command. The code is used to go to a record that has the same value as the value selected from the drop down list (a search function on my form really): 89. Private Sub...

I need to number and anitate my Visual Basic Code so when it is printed off i can refer to specific parts of it easily eg. code on line 12 shows... Does anyone know how to tackle this problem! Any feedback most welcome!! Regards, ThunderBolt :(

i just wanted to know ether it is possible to number lines of vb code in ur project so u can make reference to them when they are in the form of a printed document. If anyone can help i'd b grateful, ta regards, ThunderBolt