Search results

Resolved: I changed the report text box control expression to the following and now it works as expected. I am not sure why this resolved it though. Couple things I can think of is I was already displaying each user's Invoice Number Errors (e.g. [qry_CR02ClassifyInvNumErrors].[FName1 LName1])...

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

This is resolved (not sure how to mark thread). All I did was close out of Access compacting db and reopened and now it works just fine (report closes if it is already open, then reopens/refreshes and if not already open, report opens). I had been working on a bunch of various stuff for...

My bad, here is correct code for the run report button. I had the "End If" out of place as I was showing co-worker in my text editor. Private Sub cmdRunCR02Report_Click() On Error GoTo cmdRunCR02Report_Click_Err If IsReportOpen("rpt_CR02ClassifyEditValidationLevel2ErrorRateReport") = True...

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

Thanks mdlueck! I'll take a look at your other post to see if it kicks off any light bulbs regarding the use of QueryDef. Thanks!

Thanks Gemma! Performer field is defined as 255 character although longest value in either table (MLM or Level2) is 24 characters. I reduced 255 down to 25 and still get same results. The NUM_LINES field is defined as Number (Long Integer). I'm wondering if 1) I need to declare the 2nd...

The underlying source querries for the MLM and Level2 querries above that call VBA median function simply use temporary localized tables (make tables) since I never could figure out how to implement QueryDef within the VBA function code.

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

Ah boy o boy what a lesson learned. Turns out 80+ percent of my issues was caused by ODBC connectivity inconsistency with domain I connect from and our production servers being on different domain and primarily a timeout issue caused by Access's default 60 seconds setting. This thread is...

Just wanting to close this loop and sent a thank you to DCrake for his/her posting I found in thread on this site about Public Variables. I was able to resolve my issue. Thank you, DCrake!!!

Is it possible to dynamically set a query parameter value in VBA code by referencing a control on a form? Or does that tie back to the Expression Service ("the bit that interprets Access-object specific things for SQL") not being available for VBA code to use? I still need to figure out how...

Yes I read it but since I have no idea what "ppl" is or what Expression Service is I didn't understand what you were saying. Upon re-reading your previous post and this one mentioning "QueryDef" I get the idea. Thank you for clarifying! And yes the TEST Access file does not mirror PROD file...

Pretty sure it has to do with parameter query even though I've changed that to feed parameter values from form. I'll keep digging ...

Thanks. And yes that is what I'm fixing to do - debugging as well as comparing to TEST db which runs just fine and give me exact results I need. I've also been in contact with server admins and DBAs as I've been getting ODBC connection failures this week which may or may not be contributing to...

Reviewing Immediate window after Debug Run-time error '3061': Too few parameters. Expected 4 message comes up, has all the individual Performer/Line Select Stmts I need. Furthermore, when I grab any of them and bounce back into Access it runs just fine. I don't get it. As always I will keep...

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've gone ahead and created parameter form to eliminate parameter value prompts when qry_MLMStatsLineCountTimeDurationDetail10Lines is ran. However, I am still receiving, "You tried to execute a query that does not include the specified expression...