Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: coder30
  • Content: Threads
  • Order by date
  1. coder30

    Need code for generic user in Docmd.TransferSpreadsheet??

    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? '------------------------------------------------------------ '...
  2. coder30

    Need Access VBA code for generic username??

    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 '...
  3. coder30

    Need to set focus on "Groups" database objects upon .m file open???

    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
  4. coder30

    Need code to obtain the first record for each memID!!

    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...
  5. coder30

    How do you specify a range of fields in a query??

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

    Parameter Form, Query and display form - checking for null value??

    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...

Part and Inventory Search

Back
Top