Search:

thank you very much
it worked.
what about this?

Another problem
I was using this module to populate VbFlexgrid V 1.4 and everything Ok
Now I upraded to 1.7 and I get error of mismatch

Public Sub CalendarFlexShow(Flex As VBFlexGrid, mvarYear...

Hi Krool
I wonder if there is an option to autosize the height of the grid based on the number of items in the grid.
I'm not asking about the row and column autosize but rather the grid height...

Thank you for such a wonderful contribution
The second loop did not work but the first one worked like a charm.
I modified a bit your code to meet my needs:

CT AS (SELECT DT.ID, DT.CalDate,...

Thank you for taking the trouble to help me and I 'm very sorry for my lack of concentration.
I tested the last code on a flexgrid and everything works like a charm.
But when running the code on...

I'm using SQLITE too and RC5

INSERT Into Appointments VALUES(1,1, '2024-04-17', 1, 20);"
INSERT Into Appointments VALUES(2,2, '2024-04-17', 1, 20);"
INSERT Into Appointments VALUES(3,2,...

Another issue is that
On my form , I have an array of 31 texboxes.
I need to display the number of appointments , the slot time or period and time remained on the corresponding textboxes.
the...

I greatly appreciate your help
However your code looks so advanced and I have a little problem to understand this part of the code:

DT(AppDate) AS (VALUES('2024-04-17'),('2024-04-24')),
The...

Hello again VbForums
I wish the appropriate forum for my needs is Database Development.
My application is intended to organize appointments for doctors:
The day is divided into 3 periods:...

Hello again VbForums
I got inspired by Sam's idea and I tried to put it into practice .
My application is intended to organize appointments for doctors:
The day is divided into 3 periods:...

Would you please provide a link for this precious work?

I know how to feed a flexgrid from database, but to fill a grid with appointments looks out of my reach

https://www.vbforums.com/showthread.php?330951-Drawing-a-Calendar-(MonthView)-using-FLEXGRID-RESOLVED&p=1961516&viewfull=1#post1961516



It is the image of the flexgrid.
I have just added some...

Hello VbForums community
I have found in this forum an excellent flexgrid that looks like a monthview.
I 'm wishing to use it as a calander to display appointments from database.
I want an expert...

Million thanks Olaf
it works like a charm

Thank you ChrisE
I 'll try it tomorrow

Thank you ChrisE
But as jpbro explained I want the first word of each row without numbers or dash..
In the database some data start are like this:
1- aaaaa bbbbb
2- ccccc ddddd
etc
Others are...

Could you modify the code using this technique?

Thank you very much gentelmen

INSERT INTO Tbl2 (Column1) SELECT CASE WHEN INSTR(LTRIM(Column1), ' ')=0 THEN Column1 ELSE SUBSTR(Column1, 1, INSTR(LTRIM(Column1), ' ')) END FROM Tbl1;
This code...

Arnoutdv and jpbro
Thanks a lot for you interest

INSERT INTO Tbl2 (Column1) SELECT CASE WHEN INSTR(Column1, ' ')=0 THEN Column1 ELSE SUBSTR(Column1, 1, INSTR(Column1, ' ')) END FROM Tbl1;...

Hello Vbforums
I'm trying to copy one column from one table and insert it in another column of a new table.

INSERT INTO Tbl2([Column1])" & _
"SELECT Clumn1 FROM Tbl1
But I need to...

Some years ago, I was able to send mails.
Now, I get errors using the same applications.

189924
189922

189923
189925
I'm getting either of these messages

Me too
but I no longer be able to send emails now

I tested all of them but I failed to make anyone works

Thank you Krool

Hello Vbforums community
I want to ask if there is a viable method for sendig email
I tested many demos that I found on the net but none of them is working.
thanks

Hello VbForums
I"m saving the path of my pictures in database.

E:\my pics\Pics\Image 10.jpg
Now I need to change the path of all my pictures to:

C:\Program Files (x86)\Log_pics\MyPics\...

thanks but I need a query like this:

SQL = "Select * From myTable Where Firstname = '" & Text1.text & "'"

Olaf
You are great
your query worked.
But for a spcial purpose I wonder if it is possible to use a a query like this.

SQL = "Select * From myTable Where Firstname = '" & Text1.text & "'"
I...

thank you all for your interest and help

Hello VbForums community
I'm using sqlite as database.
When I'm trying to retrieve some strings that contain apostrophe (') from database, the applcation freezes.
Is there a workaround to overcome...

During the process of installing the application I get a message error like:
impossible d'enregisrer l'objet com(ActiveX)
C:\Windows\system32\MSCOMCTL.OXC
echec dans Loadlibrary (126)

thank you all
But still no one told me why these ocx and dlls refuse to be installed on this special machine.
IS there a way to force windows to accept installing these dlls in system32 or ...

I'm not sure but I think it is 64 bit

I'm using Setup Factory installer

Hello VbForums
On one of my clients system (W10 professional) I was unable to install VB6 common controls on system 32.
I tried to copy them manually but impossible to register them by means of...

solved thank you

thanks but is it possible to check if a file is copied on the root of the drive ?

Hello VbForums
As the title indicates
Is it possible to know if a file is saved at the root of the hard drive?
I want the user to save the file in a folder.
If the user saves the file at the of...

What i mean by line is not row
My fielld is text_type
it looks like this:
le: xxxxxxxxxxx

aaaaaaaaaaaaaaa
bbbbbbbbbbbbbb
cccccccccccccccc
The 1st line begins with "Le:"
The second line is...