i haven't tested this yet. but i know this will solve the problem

thank you guys.

Good day!

I just need some help/solution on how to prevent the user to resize the form when the width of the form is less than 8,220.

Thank you guys for giving time.

God bless

Thank you guys.this solves the problem. To make resizing smooth, just lower the interval of the timer.

God bless us.

Sorry for this delayed reply guys..I will keep this thread online today until i get this solve.

Thank you.

The lynxgrid resized at form resize event but the column of the grid does not resize to fit the width of the grid.If i execute my resize function columnresize() after the form resize has been...

Hi guys.!!

Good day.!

I just want to know on how to execute an event or function call after the resize event of the Form had been triggered!..

Thank you for giving time on this post.!

Good day!

Any body uses a lynxgrid control because it only accepts the navigation key to move between cells. Does it allow moving between cells by the use of tab key.?
If someone has an updated...

thank you.

but the use of two textbox in a form is hard to bind in any grid. In this case activex control wiil solve this problem. thank you very much guys. If you are willing to help me build the...

thank you for the idea. I have heard about sql server notification service which can also be done with transact sql. But i stil have not enough knowledge of how to do this stuff with vb6 to SQL...

after a 24-7 coding of this thread.i still not get the right solution. I have decided to create an activex control, to put two textbox that is borderless then i will overlap their 2 edges to make it...

Hi guys good day.!

I have two numbers(105 & 210). I want the 105 to be left align in textbox1 and 210 to be right align in the same textbox at form load.

Would this be possible.?

Thank you...

Good day.!

This will be my problem regarding on how to update the listview when one of the data in the field in sql server tables has been changed.basically, i have achieved the result by looping...

thank you for a hint. i will be posting updates until this problem will solve. i will not stop until i get the right solution.thank you guys for your support.

thank you for the responses and im sorry for late reply because of internet connection repair. But i still dont get the right solution.

I need to show the numbers and the operation on the combo...

Good day to everyone.

Im just able to finish my banking system with QB SDK integration. I just want to ask help, idea or any other way to make a mathematical operation in a single textbox.Like you...

Thank you.!Can anyone show some example about this API.?looking this forward.

hi guys.

I have succesfully loaded all the data needed to an excel worksheet.this works fine.But i want to show the excel on my own form like in form1 rather that displaying it automatically like...

May thanks for helping.Ive got to solve the problem for a long night without sleep.Codes below.:I dont know why it runs with the this code.But thaks God.

objCommand.ActiveConnection =...

Thank you. ive heard about parameterized query, more says its much safer to avoid error. Any idea how to use it clearly.?At the same time i also got problem deleting all contents of a table which...

Good day!

I am having problem inserting records to sql server. I have ten records to be inserted in database that is stored in an arrays(). When it reach to a value that has a quote or double...

[Good day.!

I need to bind a combo box in a list view.Once the user select an item in the combo box that has been binded, the combo box text will remain on the cell of the listview where the combo...

Thank you for giving time with this problem. Anyway ive got i very simpler solution with this problem.the code below. This works very well.



Private Sub Form_Load()
Dim lastdayofmonth
...

Good day.!

How to get the last day of the current month and store it in a variable.?


Thank you for giving time.?

thank you. API solves this.

Good day!

How to copy a file from one location to another.ex c:\ to c:\copied in silent mode.When i load the form it will copy the file automatically.

Ex. name.xls - the name of the file to...

Good day!

I just need to pull all the records in table named "cusname" in sql server to an existing excel worksheet which is located in the folder where my program reside.The name of the existing...

Thank you very much. It is much easier to count the records by counting it in a query. This problem was solved.!

See on next thread.!

Hi guys!

I have 10 records in a table in MS Access.! The table named is tbloan! I want to export to an existing excel spreadsheet the first three columns.! The spreadsheet name is "excelexported"...

Hi good day.!

Im so confused why my code to get the total records in a certain table in sql server returns false. Im already connected to sql server and set-up a table named "loanlist".This table...

Thank you.Just a little function to manipulate the string.This problem was solved.

God bless Guys

thank you for the reply..it helps me out to solve the problem.Ive found some solution in planetsourcecode. This problem was solved.

Thank you guys.

Good day.!



dim varname as string

varname="Nothing's"

Good day.!

I just need a code that will trigger the listview to put some color like(red) in a row/cell being selected.

Pls help..

Thank you for spending time.

Good day.!

I am getting stuck with parsing my xml data in order for me to display it on a listview. The xml data to be parsed is not constant. The the <NumRows> is changing. I need .bas or any...

Anyway ive already solved the problem..Just make the qoutes double.

hello guys.!

I just have 1 problem right here. I have a variable declaration below:


myVar ="Argie's"
"Select * from [my Table] where [my Field] ='" & myVar & "';"


When i execute the...

What server you are using with your mysql.?is it apache.? If it is then.? you have to create a virtual host settings on the apache where your database is located so that all other machines on the...

Thank you guys. This problem was solved.

Even if it is configured to listen to all connection it still gets an error. Howeve, can i use the ip address of the server instead of its name.?

Hi Guys!Good day!

Ive notice just this day that the user of the program Ive made can double execute the program. I want the program to behave that when the process(task manager) of the program is...