Recent content by clinresys

Base your crosstab on a query with functions that return what you want.

I have a select query with a user-defined function field. The function takes required args, some of which are fields in the query, plus some that I don't want in the query. (The query is 1/2 of a union query, and I don't want to have to pad the other select query with fields it doesn't need.) I...

Oh Yeah! You'll probably have to hold down the Shift key to bypass the start-up module to be able to see the default menus. This works from the most-recently-used list or from a shortcut.

from Microsoft Access Help topic --------------------------------------------------- Connect an Access project to a Microsoft SQL Server database You can connect a Microsoft Access project to a Microsoft SQL Server 6.5, Microsoft SQL Server 7.0, or Microsoft Data Engine (MSDE) database. If the...

'here's a template I use often 'A quick way to get the SQL statement: 'create a saved query, and paste the SQL view 'for the cmdSQL.CommandText Dim cnn1 As ADODB.Connection Dim rst As ADODB.Recordset Dim cmdSQL As ADODB.Command Dim grArray() As Variant Dim grCount As Integer Dim int1 As Integer...

Do you have a stored query? You might try using the Pivot Table Wizard with a couple textboxes added to the form it makes for your start and end dates input.

'Check help topic "Quotation Marks in Strings" 'strings in strings are a pain in domain aggr functions Private Function strUnique() As String 'concatenates unique integer with a default string 'to create a unique identifier 'example uses "_default" for default string...

I ended up using a separate table of default values and a dictionary object(like a perl hash)for collecting textbox updates. If a certain textbox IsNull on SaveRecord, MsgBox asks the user if they want to save as new defaults. If they do, the record currently being used is flagged false, and...

thanks SBendBuckeye. I recall I did have the target form open in design mode the one and only time the changes persisted.

My plan is to expose only certain fields to the end user of an mde for setting default values (no design views allowed)at the form level. Textboxes in the form to be used to set defaultvalue in the target form have their own defaultvalue set to the defaultvalue of the target form with an...