Search results

It's in lvprop in msysobjects which is binary so you'd need to work out the format to do anything with it. e.g. Private Sub Command0_Click() Debug.Print getproptxt("table1") Debug.Print getproptxt("query3") End Sub Function getproptxt(obj As String) As String s =...

A subform is not a form. It is a control that contains a form. Most controls have events that you can use to run code when something specific happens. Subform controls have those events, but you aren't interested in subform events, you are interested in form events. Whenever you want direct...

You can catch the events of the subform and handle them in your parent (main) form using withevents 'IN THE PARENT FORM ' declare subforms Private WithEvents subfrm1 As Form Private subfrm2 As Form 'Withevents allows you to catch events raised by the subform 'The subform must have the...

I hadn't properly read your code before I posted last night. I had assumed that you were opening a recordset on a sql server connection. But it looks like you are opening the database. (?!) I didn't even know this was possible. And if it is possible I can't think why you'd want to do it or what...

Text31.InputMask = String(150, "C") Shows exactly how many characters remaining and doesn't require any further code.

Drag the form to the forlder; that will create a type of shortcut.

Regardless of your opinion; if a drive is a network share you should use UNC. Of course you should SAVE the mapping as UNC, not try to convert S: to UNC after the fact.

Normalise the data.

Since mCurrSqlDb is static it won't go out of scope and be disposed. And everytime you call sqlDB you will reconnect it. You get 'open exclusive' errors with ADO; not sure what you're using... Link the tables and use DAO.

Application.FollowHyperlink "file:\\S:\myfoldername", , True

As far as the control is concerned the url is the display text. The href isn't used. Becuase the address is invalid it gets removed. <a href="http://www.somewebsite.com">www.Click_here_for_your_link</a>

Agreed. I do like a weird bug though.

No. If the SQL was how it was originally the OP wouldn't be posting here. The SQL is invalid!!! That is all we know. You cannot save SQL like that in Access. Either it is being displayed incorrectly!!!? Which is very unlikely!! (weird bug) ... Or the query(s) are being corrupted. By...

That is (invalid) SQL. If you tried to save it, Access (w)(sh)ouldn't let you. SELECT DISTINCTROW TOP 7 FROM TABLE ...

Because there isn't one in the SQL the OP posted and SQL IS the query design.

The query should error anyway. "SELECT DISTINCTROW TOP 7" isn't valid SQL because there is no table selected. So I'm more intrigued by how/why Access is saving this SQL at all. edit+ Of course looking at the actual definition would be good but you could also debug.print the sql from the...

Also, the queries could get changed if they are based on tables that are dropped and recreated and 'auto rename' is on.

To look at the actual definition for a query called 'query1' you could use sql like SELECT * FROM MSysQueries WHERE objectid = (select id from MSysObjects where Name="query1") If you saved that as a query and look in MSysQueries, the 'Expression' field would be objectid = (select id from...

Well, you've hard coded them, but it's still a better option.

I don't know where to start... ;)