Recent content by bella

Hi I have very basic SQL knowledge and would appreciate any help. I have a query which asks users to enter an ID - based on that ID, a Report is generated that gathers student information and produces a subject report for that student. The ID refers to a subject that a particular student is...

Hi guys its been ages snce i posted, and i am stuck again :( ive copied a bit of code down, can u tell me whats wrong with it? the error message i get is : Rub time error 3061, Too few parameters, expected 1 when i go to debug it it highlights this line: Set rstSSC =...

Hi guys, Can anyone tell me how to write from a query to a textbox? Say I have a Query behind a button that outputs some data (String1, String2, String3) Then I have a few text boxes on a Form, that need to display the values retrived from the Query: So TextBox1 should display String1...

thanks :) Bella ps. Guess where - here's a hint, its 12.43am right now and we're in winter :D

HI - another question- im on fire tonight :) i have this situation in a form, where the user needs to click a command button which enables 4 TEXTboxes . The 4 textboxes are initially not enabled (so greyed out) then, if the user clicks YES, they all get enabled. Otherwise the user clicks no...

This is my code which still doesnt work :(:(:( If Nz(Me.chkOldLP) Then rstLP!LP1_ID = 1 rstLP!LP2_ID = 2 rstLP!LP3_ID = 3 rstLP!LP4_ID = 4 Else: blah ?

hey yeh, very very sorry, i made a typo, i meant to say checkboxes... with reference to your code Rich If Nz(Me.Check0) Then MsgBox "Test1" Else MsgBox "Test2" End If End Sub what is Nz referring to? is this a VB thing? Bella

checkbox

No they aren't bound to a table. (Should they be?) - if so, how do i bind them? the purpose of my text boxes is if the user selects chk1, one set of values get updated to a table. Otherwise another set of values get updated. Bella.

Rich It says Object will not support this method

um, sorry if this is another silly q, but whats a stand alone module and whats a forms module? i have all this code behind a command button which is on a form... does that mean nything to you? :confused: Bella

ok, so my control name is chkOldLP so how come this line wont work for me? :( :( :( Bell

whats a control name and wots a field name? if i right click the checkbox -> properties -> select All -> Name = chkOldLP is that a control name? sorry if its a silly question - im very new to vb Bella

Here's the code: ============== ' Build string to fill in the [Learning Outcomes Connector] strSQL2 = "SELECT [Learning Practices Connector].SL_ID, [Learning Practices Connector].LP1_ID, " & _ "[Learning Practices Connector].LP2_ID, [Learning Practices Connector].LP3_ID, " & _...

Behind a command button