Search results for query: *

In my Docmd.TransferSpreadsheet line in the code below, I need the syntax or wildcard that will allow me to export this report to any user's desktop. I was told %username%, but that does not work. Does anyone have any ideas? '------------------------------------------------------------ '...

In my Docmd.TransferSpreadsheet line, I need the syntax or wildcard that will allow me to send this to any user's desktop. I was told %username%, but that does not work. Does anyone have any ideas? '------------------------------------------------------------ ' PS_Contract_Perf_by_Qtr '...

Thanks, but I don't see anything in there to change which tab you view, only toolbars, forms, other objects. It would probably have to be done through VBA accessing the Application Objects, but I'm not that advanced at coding.

My database opens and the module tab is always visible. How can I set focus to the "Groups" database object instead? I looked for a default view in Tools>Options but found none. Does anyone have any ideas? Thanks, lw

Thanks, works perfectly.

The contact field is text so Min didn't work.

Well, each record is already distinct/unique because the contact names and titles are different for each memID, so is there not some way I can use the RecordSet commands to move through the recordset and print only when it moves to a new MemID?

First is the actual 1st record shown for each memberID. I need the first contact and title listed for each member number.

Hello, I have a table that looks like this... memid contact title 12345 sheila brown admin 12345 tammy lewis CFO 12345 john fesh Director 22333 james smith Manager 22333 lois william Nurse 33444 lisa turner CEO I need to only return...

Thanks!... I think that will work!

Thanks leslie. Remou - that would work if the fields were truly null, but I've just discovered some of the fields contain spaces, so they aren't truly null.

I am trying to check 25 fields for null values is there a way to say... "iif([fieldeG] through [fieldZ]is null,1,0)

Thanks! Works like a charm

Can you give me an idea of how this is done in VBA? I'm pretty new to coding outside of the typical event procedures.

I have a parameter form that feeds the memberID to a query, the query result is displayed in another form. If the memberID is not found in the query the resulting form is blank. I would like to display a label (or message box) that says "Member Not Found" instead of just a blank form result...

I have a macro that runs a query that accesses a SQL server table. However when I manually run the query there are no problems, and no login/password is even needed...but when my macro or module attempts to run this query it bombs with 'ODBC-SQL connection failed'. Is there some sort of issue...