Search results

Please could you define 'parameters', i don't quiet understand. regards, thunderbolt

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...

Im doing an A-Level in Comuputing. I am using access to do my project, but i am pushing it, as accesss is not renound for its use of programming languages/ techniques. I have to use large amounts of visual basic code for my project to be acceptable. I advise you to take a course in computing...

I just remembered. I will be making a counter, using a recursive procedure. By demonstrating a recursive procedure I hope to gain extra credit for my system (A-Level project).

Thankyou both for your help. If I have time I may add the extra code to make the logon more advanced. I had thought about a counter and your code shows me how to implement this so that is helpful. Regards, Thunderbolt

Thanks a lot, that was exactly what I hoped to achieve!

progress In this example =DLookUp("[Title]", "Employees", "[LastName] = 'Callahan'") the statement shows how to look up a value from a table with criteria 'Callahan' Can the criteria be a value in a text box, on a form. If it can, how would you go about doing this in code.

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...

I'm on it, I probably need to specify a problem more clearly, I am at the design stage of my project; I am designing the interface and considering the use of a calendar control. I will have a look around to see what I can do with it. Thakyou for your time, i'll get back to you with further...

reply i didnt explainmyself very clearly, sorry. I was wondering weither it is is possible to attach 'on click' events to the invidual buttons of a calender, on an access form. So i have a calender on the form, e.g i click on the button marked '11th' of , december,2003. is it possible to add...

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.

it was the 'rem' statement interfering with it, i erased the 'rem' statements and it worked, phew! thank goodness! Thanks for the help guys, efficient as usual!

The 'rem' statements are annotations,the ':'areneeded to signify that the rem statements are not part of the working code. I took the end if out but now it just rejects all values i enter on the form??

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...

Its ok, i am working it out, i did use a wizard yeah, but i have managed to work most odf it out using the help! Thankyou for your suggestions though :)

I'm docementing my programme, and need to annotate the code. its ok though, ill have a look on help.

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...

o rite coz me m8s done his project in delphi and it does um automatically in that, ill just use the "rem" - ... thing to add sum notes and i good olf fashione dhighlighter pen! ta though, i spent ages lookin for an option to do it, at leats i kno now it cant be done automatically!