got it, thanks

At runtime I want to check if a certain form is open. I know how to check if a form is open.
I do it like this(where form1 and form2 contain the names of the form)

For Each fForm In Forms
...

what does that mean

When resizing the form, I resize the toolbar on top. When it gets too small for all the buttons on the toolbar to show I want to either
Split the buttons into two lines or
Add a button at the...

can anyone tell me how to use it?

which ones?

looks interesting

I want to show a form and on top of that form I want to show another form. I want to be able to access any of the two forms (so I can't use vbmodal) One of the forms is bigger than the other and...

Can a form have a different shape than just square or rectangle

is it possible to change the color of the form's border
usually when form is active it's blue and when inactive it's a little lighter
I want it should seem active even when it's not

how to keep a certain form always behind other forms

when user selects a cell, I want to highlight the whole row, how do I do this?

In the first column of my grid I don't want any lines between the rows(in the other columns I do want them) How can I do this?

Bau_id exists only in one of the tables(thanks for pointing that out), so I changed tblfrist.bau_id to just bau_id and now it works. I'm still not sure why tblfrist.bau_id should cause problems

when you call the form add vbmodal

frmmsg.show vbmodal

I'm getting runtime error 3265 -id doesn't seem to find the field bau_id,I don't understand why

Here is my code, it works when I leave away the line in bold, I can't figure out what's wrong with my line in bold, I've been checking my database so many times already, can you help me

let's call the adodc adologin,the table tbluser
'make connection to database
adologin.connectionstring = 'enter path of where your database is
'Select from your table the name and password entered...

Thanks,I got it. Just one more question, is it not good to do it the way I did (with two ado), and why?

what do you mean by connection object

yes, do you know how to use it?

adoreminder is adodc and it doesn't recognize execute. I have code that's working with two ado, I thought I can do it in one, but I can't get it right. Here is my code with two ados that's working....

Add to your components (right click on toolbar)
microsoft ado data control
do you have that?

the first gives me syntax error at runtime
the second gives me error already when I leave the row

Here I am again with my next sql problem. I'm not sure if I can use insert into for what I need. What I want to do is the following.
My tables

I have tblreminder with userid workid workdate
I...

add another form to your project ex.frmlogin
have two textboxes there one for username one for password
add two comand buttons one for login one for cancel
add adodc to make connection to database...

got my answer
if isnull()

I have a left join in my select statement which works
printing all the info from tbl1 with matching info from tbl2

I also want to print true or false depending on if there is any match for each...

It works thank you all for your help
this was the syntax that worked
ado1.recordset ("tblname.columnname")

ok, I guess that was my problem, I have in both tables a column with same name and when I try to get that one it gives me an error. I thought it's because the recordset doesn't point to that table,...

My problem is not the recordsource, it gives me all the records I need.
My problem is the recordset, it points only to one table and I need info from secondtable also

tbl 1 has fields id, name,address
tbl2 has fields id, date
tbl2.id refers to same id of tbl1
I want all records from tbl2 print the name address and date.
name and address are in tbl1 and date...

I have the following select statement which works, I need help to adapt it

adobau.RecordSource = "SELECT * FROM Liegenschaften INNER JOIN tblbau ON Liegenschaften.Rimo_Liegnr =...

I put the path in my main sub of main module and call it strdb.
In the code I always write
CNN.open strdb
this way when there is a change you change it in the module and not every time you used...

works great, thanks for your help

I have a frame, inside it a few labels and text boxes. At some point while the program is running I want to move that frame to a different position. Is it possible to move it with all the lables...

Is it better to use a hidden flexgrid than an array?

where are you getting the error?
could it be that
if check8.value = checked
should really be
if check8.value = vbchecked
?????

The way I understand it, is that rowdata and coldata can be used to keep some data for some specific row or column. What if I want each cell to have some data go with it, how can I do this? I need...

what about the difference of
msflexgrid and mshflexgrid