Recent content by kleky

listbox recordset values null Awesome Roy, thanks! Treva didn't say what his solution was, so, 6 years later I won't keep you hanging on any longer...Roy's solution fixes the initial problem: A custom ADODB recordset built on the fly will attach to a list box's Recordset property but each...

Thanks Galaxiom. I did what you suggested and it works a treat! For others: 1- Create a function that initialises an ADODB recordset in a module Global g1Con As New ADODB.Connection Global g1RS As ADODB.Recordset Public Enum rrCursorType rrOpenDynamic = adOpenDynamic 'Uses a...

Can anyone think of a reason why my records won't lock, even though the form record locks property is set to Edited Record? A form is bound to a linked SQL Server table, not a view or query, and when I edit the same record there are no conflicts. When the same field is being edited at the...

To get around this I just permitted SQL Server access to authenticated users

So when I run the code, it tries to change the table connection from: dbo_vewOrgsAll ODBC;DSN=Organisations_sql8;UID=xx;PWD=x;APP=Microsoft Office 2010;DATABASE=Organisations to... ODBC;DRIVER={SQL Server Native Client 10.0};DATABASE=Organisations;SERVER=ra_sql8;UID=xx;PWD=x; ..but it...

Hi Folks, having a nightmare here I hope someone can help. I usually link SQL Server 2008 tables in Access 2010 via DSN for development, then make it DSN-Less via VBA code (see below). I've now decided to make the connection SQl Server authentication, rather than windows, as I want anyone to...

Thanks Lagbolt, I put all my code for using a recordset in the initialise event and now it works. I just thought I needed to declare libraries to use them. Happy days :)

Cheers, I'm just starting out with classes! Don't suppose you know how i'd use another class from within it, such as ADODB? I've added "Implements ADODB" but that throws an error Ultimately, I'm trying to create a class that deals with security, in that it obtains the logged on user ID and...

Does anyone know how you automatically initialize a newly instantiated class? So when you create a new instance it will run a procedure to set attributes. Cheers people :)

Thanks David, I did try that and all worked fine. It was a complete mystery; but as I found out, it was due to the cursor setting

Balls balls balls!!! I've just fixed it. The one simple darn thing I overlooked was setting CursorLocation to Server Side (although I'm sure microsoft said to use client side.) So...set CursorLocation to client. :mad:

I've spent hours on this and I'm perplexed as I've tried everything, yet I can't make edits with ADODB recordset bound to my form. Access 2010 linking to SQL Server 2008. Simple form bound to a single table. Connection string works fine. Code is as below (cursor etc is set using enums btw)...

Yes you're right, I think I'm just looking for ways to create a class so I can practice :) Indeed, auto-number shall be used but must be in conjunction with this one too.

Just trying to think what is the best/cleanest way to return the next primary key value which is in the format yyyy-### These are case files for the current year, ### being 3 digit number incremented by one for each new case. I could use a function that finds the last one, checks the date...

No need to pay for it, though. Find it free here (official freeware): www.TechSpot.com If you get a required file for AdobePDF.dll, just search your entire c:\ drive for it. I found it on Win7 here...