Recent content by Rank Am

Hi, Am planning a bit of an update on our client server front end, prior to switching the backend over to SQL server from access. I want to do this prior to starting the switch so that we don't have to revisit the backend after it's set up, a few tweaks of the front end will be much easier and...

I don't think bob sounded condescending at all, but I do know where your coming from with the corporate paranoia over third party software. Our Corporate management are quite happy for me to get developers in on short term contracts as some sort of "Systems Maintenance Consultant" as long as its...

If you don't want to be tied to licensing third party products for use in your applications I would definitely check out the Access 2002 Desktop Developers Handbook. It has the neat bits of code you are looking for included on a cd All the code and documentation for implementing class modules...

Not sure, been a while since I've messed around with moving and sizing access reports in code but off the top of my head you could try adding: me.refresh after the code in the reports load procedure Also is there any reason that the report has to be opened in dialog mode rather than...

This may be of some use to those who encounter ADO Connection Object instancing issues I managed to track down the error yesterday and am pretty sure that it is Visio 2010 on the same client machines as the 2007 access front end using ADO connections that's causing the problem. I installed and...

Hi, I have this intermittent but highly irritating issue that causes access to crash - the untrappable and generic "Access has stopped working" I haven't found much on msdn forums or here. I was wondering if anyone else has had this and how they permanently fixed it. The system is set up using...

My broker provides a free XML / RSS feed - I used the following blog as a basis for building an access db that collects it. http://blogs.office.com/b/microsoft-excel/archive/2010/10/12/pulling-rss-data-into-excel-or-using-excel-to-search-craigslist-part-1.aspx Works well

If you want to manipulate XL, your best bet is to add the Microsoft Excel library in the vba editor (tools menu - References) and define Excel as an object in vba - this allows you to control formating, fonts etc from Access. First step is to create a recordset (either DAO or ADO) Second create...

If the Function IsMemberOfSecurityGroups is not in the forms module don't you need to add basXXXXX.IsMemberOfSecurityGroups(arguments) - or it will give the described error?

Trying to emulate user and group security with VBA in accdb/e which doesn't support this is going to be a lot of hard work and probably not going to work. Your best bet would be to have an authorisation class module,use the windows logonuser api call which is what we do or use an MDB database...

Hi This is a function i use to check whether a table exists when I have a need to. if the table doesn't exist in table defs access returns and error - this is trapped and the function returns a false. The DoCmd.RunSQL Syntax may be wrong (not used it for years) and also I assume the name of your...

I tend to use Excel and word as templates and always populate a new workbook from the template with data via automation from from Access, so there not an issue with files being left open, you can have as many as you want. Public Sub OpenXLT() Dim objXL As Excel.Application Dim objWKBK As...

Is the code in the subform afterupdate event or the afterupdate event on a control in the subform. If it's in the subform it should work - unless your delete button is running SQL or something and deleting it directly from the control source (table or query) rather than the form - add the code...

Glad you got it working - apologies, getting Syntax right first off is not my strongest attribute However I can see one potential pitfall. If the TA2 is not the last entry the form it will still revert to no on the main form. A simple work around would be to declare an extra variable and update...

As long as the the TA2 is assigned in tblCoursePeopleRoles and the subform is only returning records for the course selected in the parent form (doesn't have the word filtered in the navigation buttons) A really crude but easy way to set the value would be to place a checkbox on the parent form...