Search results

Need some guidance from experts on what could be causing my issue with #Error displaying in text box control on MS Access 2010 report. I have a bunch of underlying querries this report is built on. These querries use the Nz function to display 0 "zero" instead of Null. I have triple checked...

Having issue using DoCmd.Close acReport if report already open to then open it to get it to "refresh" and could use some advice. Using Access 2010, Main Form opens with defaulted parameter values, users can change values, etc. Then have some buttons to run/open various querries/reports. I am...

Using Access 2010 and ODBC connections to pull data from 3 sources (SQL Server 2008, a customized Documentum application, and Windows AD accounts). Problem is user_login_name is sometimes recorded as lowercase, sometimes as propercase, and sometimes as uppercase depending on which table or...

We use MS Access 2010 with Linked SQL Server 2008 tables. I have few reports working 99% of what Management wants/needs. I am currently testing to get reports to run if user(s) has no data. When I declare function arguments as Strings, the MLM returns #Error for Medians and the Level2...

Need help with Median function not totally releasing control back to the calling Access query. When I run query that calls the DMedian function results are display in Access and then Access seems to freeze if you click anything. I believe the VBA code is somehow not fully/completed stopping...

Why am I receiving #Error when running my median query? Below are the code for 1) UserMedian query, 2) VBA MedianG code, and 3) visual of query results (once I end/sto debug "Run-time error '3061': Too few parameters. Expected 4." msg that appears. This median function and median query runs...

I have a MedianG VBA function in a local test dbname.accdb that I call from a query to get Median for User1Line1, User1Line2, User1Line3 ... up to User1Line10. Works beautifully in test db. Today I copied VBA function/module into our live front-end dbname.accdb. I then took sql from...

Need help implementing way to obtain Median grouped by 2 columns and filtered by date in a Crosstab query. We use Access as front end reporting tool with linked tables to SQL Server 2008 backend db. Management wants a time analysis report of each performer by median (in seconds) per PO lines...

Newly registered member. I am located in USA (Eastern Time Zone). Have worked with Access off/on for many years but has been awhile. Consider myself with intermediate knowledge/understanding of programming. Forsee need for help and advice with current projects I got going on working with...