Search:

By adding a button to frmform9 and calling RefreshData i get the message "You're either to the first or last record" meaning that rs.BOF = True Or rs.EOF = True. And still no update

Sorry for the delay, i was trying to combine your advises and code to make it work.
Still nothing even when i call the RefreshData sub.
But i've notice something really strange. After the update i...

No sorry, the problem is that the records are not being updated unless i open frmform9 and run the cmd_previous

Thanks anhn

The problem remains, even when the form 9 has not been loaded at all.

I performed the debugging. Everything seems to work ok. The form_load in form 9 is being executed, then the fillfields sub...

I've tried your code and it still doesn't seem to work.

The "unload me" in the initialiaze_prolog function never runs as long as the connection is ok an as long as it retrieves results. So in my...

Thank you very much for your useful advises. I' ll use them to improve my code.

As for the problrm it still remains even when i use



Load frmForm9


or

ok. tell me if you need anything else

It seems that i have a problem with the file upload limit. Is there any way i can send you the hole project

In the .zip file i post the vb code and the database. I haven't posted a .pl file thought because is not the part that i developed. So the programme is not actialy working this way. please tell me if...

I get now what you mean about the cursor type. I 've used adLockPessimistic so that should be ok right?

I call the form_load in oreder to open the specific table from the database.

When i...

When i update the record along with save i call the Form_load routine from the other form which calls the fillfields too but this doesn't seem to work.

I really lost you in the cursor type. Does...

Hello,

I am facing some problems with records update in a vb6 program which uses ado for the connection with an access database. To create this application i was based to beacon' s tutorial.
...

Ok! I ask because there are some greek characters in the code so maybe they created a problem or something (just quesing i don't have a clue).

I just want to ask is this possible, some of the...

I have a previous version but it is a little old. Is there maybe an encoding that i should select in notepad or another editor that will show the code?

I've done that but the encoding is a mess i can't read anything

Hello,


I have created a vb6 application and after a system problem i cant't open it in design view. The .exe is running ok but in design view only 2 of the forms are loaded and for the rest of...

Hello!

I've added the above code to my form everything works fine except from one frame that i have added to the form. Is there something special about scrollbars and frames?

I changed my code a little bit and now i get an error "Either bof or eof is true, the fuction that you ask for needs a record" Here 's my code:



Private Sub cmd_Save_Click()

i = 1
rs.Find...

i tryied the rs.find method

rs.Find "class='" & Combo1.Text & "'"
but now i get an error saying that an index or a primary key can't be null.
I used the above code with textbox and it works...

Hello,

I am using vb6, ms access and ado connection to my application. I have a combobox which is filled with the data from one table of the database. When the user selects one of the values of...

ok guys,

i've used array controls to resolve this one. the code i've used is the following



i = 0
rs.MoveFirst
Do While rs.EOF = False
If rs.Fields("true") = True Then

What i want to do is to be able to link each checkbox with a diferrent record from the dataset and i don't want to use a datagrid. Is there a way to create a loop to manage the checkboxes so i won't...

ok sorry, each checkbox represents a single record in the dataset

Hello,

I want to create some sort of calendar using vb6. The user can select from some hours from a database. I' ve used ms access and ado for the connection.
The selected hours can bee seen as...

Yes i think it works fine.

Now i will try to create queries to print complex data from different recordsets and to be able to write to specifiv lines of a text file so i can create a small prolog...

I also added


rs.MoveFirst

before i open the file so all the records will be copied

Never mind i post the code to the unload sub and it all works fine... or so i think

Where should i put this code?
In the initial code that i posted i added a new sub




Private Sub cmd_Copy_Click()
'code to create recordset
Open "c:\rooms.txt" For Append As #1

I have a question thought, in this way i have to move to every record if i want it to be printed in the file right?
Can i copy all the records of a table?

That was so much simpler than i thought!!!

Honestly i did a lot of research thought the web and i only found complicated code that didn’t even work. I must admit I feel a little bit stupid.
...

I think that i want both depending to each case.

I want to create small text files each one for the variables of the prolog program and after that i will connect then with prolog code so the data...

i have used the follwing code from a tutorial from this forum:



Option Explicit
Private cn As ADODB.Connection
Private rs As ADODB.Recordset
Private booIsAdding As Boolean

That is correct.

My database is quit simple. For instance I have the following data:

Classes
C1
C2
C3

Professor

Hello!

I have used vb6 to create the interface of a prolog program that generates a timetable.

I’ve used ms access to create a database that stores the variables of the prolog program and I...

Ok thanks a lot!!!

Hello,

I am using visual studio 2005 and i want to enable JIT- debugging. In earlier versions of visual studio i've located it under:
Tools-> Options
but in vs 2005 i can't find it there.
...

Hello,

I want to make a list grouped by the variable cicle.
I have the following code

function add( index, id )
{
var vid = getObj(id);

var el_li =...

You are right. I don't know php. :D

I will upload some files but i don't think they will help you much. Meny data are in greek.

It stores to archive.xml data more than once

Maybe it is my mistake that i haven't posted the copy course function. Here it is



function copy_course($source_file, $dest_file, $users_file, $cid) {
// Open the XML and XSL files
$source...