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
'...
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
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.