Search results

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

Hi Rich, its gives me runtime error 438 Object doesnt support this property or method when i do that ?? Bella

Hi ppl, can someone tell me the correct syntax for saying: "If checkbox1 is selected" do blah Else blah... i read its meant to be somthing like If chk1.Value = 1 then blah but, my checkboxes do not bring up the Value property? Bella :confused:

Hi :) How do i say "If a the text value i get from a textbox is blank THEN DO whatever" in vb?? something like IF Me!txtLO1 = "" Then ... but this doesnt seem to be working?? Bella

:( Hi guys, thanks for your code, but its still not updating LO1_ID, LO2_ID, etc to the Learning Outcomes Connector Table...cos its not reading those int values into the recordset that stores the IDs... This is the line that isnt storing a value (its telling me that rstLC!LO1_ID = 0 which...

Wayne Hi Wayne a really weird thing is happening to my code. I declared multiple recordsets in my sub, and used them, and somehow it suddenly all worked properly. Then, all of a sudden, it decided not to load the recordsets anymore. eg. the following code gives rstLC!LO1_ID an integer value...