Search results

Thanks guys. I'm not worried about him become gender isolated, and Scott is probably right about not making him do it. I think its ok to make kids give something a go, but not to continue at it if they clearly don't like it. Seeing it all written down, its just as interesting to see how my...

Hi Bit of background - I have a son and a daughter, both go to mixed schools. That is, a school with girls and boys in the class. My son in a scout group. There has been a big push in recent years to bring girls into the scout group. My daughter is in the Girl Guides. There has been no push to...

Wow, that sounds like the trip of a lifetime. Enjoy!

That sounds good. The only green drink I've seen is Shamrock Shakes from McDonalds. Which are minty. Is the green beer minty as well?

Coming to this a bit late. I live in Cork, Ireland, so the parade is always a big deal here. The city has a parade, but most of the outlying villages and suburbs have their own little parade as well. Everyone has the day off, with the pubs being busy the night before as well as on St Patricks...

Further update on this. While posting a different issue on these forums, I found how to solve it. In short, the report will run quickly if a user has sysadmin permissions. See http://www.access-programmers.co.uk/forums/showthread.php?t=285326 for the other issue that was linked.

Thanks everyone for chiming in here. I've figured out the issue, and it ties into another problem I had as well. See http://www.access-programmers.co.uk/forums/showthread.php?t=284480 where I mention the report is running slow for other users. It relates to SQL security. If a user has...

No bother. I think I asked the wrong question in the first place. Some background first. In a standard mdb, you specify a Record Source for your report. For a report in ADP, its slightly different. As you can see in the attachment, you have to specify a Record Source and Record Source Qualifier...

The_Doc_Man - I don't understand what you mean. PrintLog won't be in the code window, as its just a View. Do you mean click on Tools/References in the Access code window?

Thanks Paul. I should have been clearer above - I'm not really concerned about that piece of code not working. Its more that it might relate to another issue I have. Some reports are running very slow in Access 2010. And I was wondering if having the dbo in Record Source would speed things...

Hi I'm using an ADP in Access 2010. I wanted to check the content of some tables, and added this code to a form: DoCmd.OpenView Me.txtView, acViewNormal, acReadOnly So if type PrintLog into the txtView text box, it opens the PringLog view. PrintLog is just an example view, this code will work...

Interesting post I came across today: http://www.pcreview.co.uk/threads/adp-slow-because-sysreferences-cached-on-first-view-or-table-open.3832564/ In that case, the ADP ran slow for the non Admin users. The poster reckoned it was because of Subdatasheet Name set to [None]. The solution...

Thanks for you advice on this so far. There are sub ¬ sub ¬ sub reports. There is still the kicker though - why would the report still run quickly for me? After all, the sub report issue would still exist, and I'm using the same PC/server. Is it possible that I set some SQL property or value...

I'll try the decompile option, had forgotten about that. The report does have around 20 sub reports, with the company logo as an image on the first page.

This seems to be a problem with Access 2010. I kept a PC with Office 2003. The report runs for users on that PC within 4 seconds. But if I log the same user onto a PC or Remote Desktop session with Office 2010, the report will take around 15 seconds. This applies even if using the original...

Tested this on one server, so that SQL Server Native Client 10.0 is the only SQL driver. Unfortunately it didn't solve the speed problem for other users. Likely a good idea to have the latest driver anyway, so I think it was still worth while. But now I need other suggestions on what to try...

The OS is Windows Server 2008, so the exe I system32\odbcad32.exe I've attached the screenshot. There is only one SQL Server driver, its version 6.00.6002. The SQL backend is MS SQL Server 2008 R2. So lets say I download the SQL Server Native Client 10.0 ( it seems to be under Microsoft SQL...

Its a MS SQL 2008 backend. How would I check the SQL client? Its runtime access, so I can't go into connection properties. If the version can be displayed using VBA, let me know the code and I could have a form display it. Thanks!

The is no AOR, all users can view all clients. To the best of my knowledge, there were no security changes to the underlying tables when we moved from Office 2003 to Office 2010. Unless the 2010 version makes a change somehow? The RDS settings weren't changed either. The one difference I do...

I just started yesterday. Hello from across the sea.