Search:

Masters,
I am new to VB and Crystal Report. I am currently creating a report. I got a problem in the DETAILS section of the report because when i drag a field (ItemCode) into the details section, it...

Doogle, i am sorry for being so hard..i do really appreciate your advice and am following everything that you have said. It's just that i am new with VB6 (more or less 3 weeks) that i sometimes...

doogle, if only removing the 'vbModal, Me' in loading the frmSearch inside the cmdSearch click event solved the problem, why is it that nothing happens in mine as what i am expecting..

please if...

doogle please..please..you will be a good help to me.. :(

doogle, aside from removing the 'vbModal, Me', what else did you do? Please help me..I am really desperate now :(
And can you please post here again an attachment of the project were you have edited...

doogle, do you mean i will remove 'vbmodal, me' in my search click event?


Private Sub cmdSearch_Click()
frmSearch.Show vbModal, Me

End Sub

i have to remove that 'vbModal, Me'???...

im going out now

please compile it in one folder

i chopped it into forms and modules..please compile it :(

ok..got no choice..i just dont want to spread this project because it's a confidential one..but i am desperate..i am going to attach it here..but can i delete it soon as we solved it?

but my...

would you like to see my whole code??? hehe

doogle, i remove the unload me..yet still the same :(

yes that's right :)
this is my code in double clicking my list view:
Private Sub lstRecords_DblClick()

If Not (lstRecords.SelectedItem Is Nothing) Then

frmMain.cmbLine.Text =...

exactly...that is what i am doing.i want ID 290 to be updated..so i double click the record ID 290. then it shows it's LineNo in the main form. then i'll change it to another line no. again, it...

nothing has changed? no..it has changed. i mean if i click a record having Line = M1, then i can change it to whatever i want. ex. i change it to M2..it successfully changed/updated but not on it's...

i still have 3 records in my DB. these are the ID's: 289, 290, 292
i put MsgBox SQL in my code..and it says: update tbldPSR set lineNo = "'M2' where (((ID)=289))
by the way, in my LineNo, it is a...

yes it's unique. i make it AutoNumber in my DB using aCCESS

it is still the same :( it overwrites int the first record again not the correct record :(

P.S.
In the first code above, i did not continue adding the subitems because it's too long.hehe

ok.
this is for calling my records in my listview from Search Form;


Public Sub ListRecords()
Dim rsData As ADODB.Recordset

Set rsData = DBConn.Execute("SELECT ID, LineNo, Shift,...

or email me here first if you dont want then i'll send it as a reply.
fatherBO@gmail.com

can i ask your email add? i will send it there..please

hehe it says "Inavlid Key"

and if i make

With frmSearch.lstRecords.ListItems(frmSearch.lstRecords.SelectedItem.Text)
it says "No element found"

doogle, i followed it but it says "Invalid Qualifier"..

can you please tell me how am i going to solve this?

Doogle, so what does that mean?

To Doogle:
Sorry if i make you confused.hehe..i am using a listview..not a listbox.sorry

To DataMiser:
I am really i am new to vb6. I dont know how to follow the "Debug Window in the IDE"..is this when i run my project and go to Debug Menu? sorry :(

To Doogle:
I think i am using a...

To Tyson:

What do you mean by Database not mentioned in my select?
And tblDPSR.ID is a unique. The name of my database is DB and tbldDPSR is my table.

To DataMiser:

I dont know how to use...

Masters,

I got a problem in updating my database..
This is the scenario:

I'll go to my search form, then i have a ListBox showing all my records. If i double click any record, it will go to...

Please help me..This is urgent if it's ok.
I already followed the forums in changing the icon. However, it appears to be "INVALID PICTURE" as i chose my icon. my icon is 16x16 and 32x32..both are...

Masters,

I have created my Crystal Report. And i want my "Print Preview" button to link to my report.



Private Sub cmdPrint_Click()

what code should i put here????
End Sub

I mean the values of my combo boxes are strings:

cmbLine: Line1, Line2, Line3, Line4

cmbShift: 7am-8pm, 8pm-7am

cmbPrepared: name1, name2, name3

This is my pseudo code:
If...

Masters,

What is the correct If Statement for this:
I have 3 combo boxes, (cmbLine, cmbShift, cmbPrepared).
If one or more of the combo boxes has no selection, it wont save in the db.
But if...

please help me with this..please tell what is wrong here..here is my code;
Private Sub cmdSave_Click()
Dim db_file As String
Dim statement As String
Dim conn1 As ADODB.Connection
Dim ctl As...

I have already used the .Value. Here is my code:

Private Sub cmdSave_Click()
Dim db_file As String
Dim statement As String
Dim conn1 As ADODB.Connection
Dim ctl As Control
...

Good day,
I need a help again vb masters..
I have a DTPicker named DTCalendar. Now I want to save the date in my database. But my question is what is the extension i am going to use.
Example, in...

oww oww oww..i got it already!!!
Thanks a lot INCIDENTALS and 4X2Y!!!

What I did was, I followed the UpdateData method. And I added .Clear in my combo box inside UpdateData.

Salamat again :)

To 4x2y,

I followed your suggestion. It did update. However, another problem exist!!! After i add new item in form2, the data in my combo box were duplicating..And it does so every time I add new...

please what is the code to repopulate the combo box?
i am still new with vb 6..
please help me :(