forms in combo

[wort0987654321]

is there any way that i can select forms from my combo box or even macros, or is there another way that i can make a drop down list for speedily opening forms

 

[Mile-O]

If you've prefixed all your forms with frm then you can build a query with this SQL:

SELECT Mid(Name, 4) AS FormName
FROM MSysObjects
WHERE Left(Name, 3) = "frm"
ORDER BY Mid(Name, 4);

 

[wort0987654321]

this brings up the error message

underfined function "mid" in expression

 

[Mile-O]

Then that sounds more like a MISSING reference than anything else as MID() is most definitely a function.

Open a module, goto Tools -> References to check if there is a reference missing.

 

[wort0987654321]

i am missing the nodemgr 1.0 type library
and the
ITIsyscheckpbject 1.0 type library

is this where my proble lies and if so how can i fix it

 

[Mile-O]

Can't you just check the box beside them?

 

[wort0987654321]

the boxes where already checked off

 

[Mile-O]

Okay, well I don't know what objects these references apply to so it's down to you...

Have you had any non-default objects in your database that you have since deleted? If so, try and restore them.

Have you upgraded the database to a new version i.e. 97 -> 2000 ? If so, seek the latest version of the reference.

And that's the sum amount of what I can think of.

 

[ghudson]

What about this SQL to filter all forms prefixed with 'frm'?

SELECT MSysObjects.Name, MSysObjects.Type
FROM MSysObjects
WHERE (((MSysObjects.Name) Like "frm*") AND ((MSysObjects.Type)=-32768))
ORDER BY MSysObjects.Name;

 

[wort0987654321]

refering to mile o philes answer,

i began by typing your code into the computers at school which are crap, i then typed it in again when i got home and all of the form names are brought up like i wanted. but when i click on the names of the forms i want them to be opened.

is this at all possible or am i still doing something wrong here

and is it also possible for me to only have a select few forms that are visible in the combo box other than changing all of the frm's to something like afrm