Search results

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

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

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 :)

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

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

Hello folks I've really started to embrace Stored Procedure and thought it would be good to validate within them too. I'd normally validate in a VBA function but I like the approach of having rules and business logic stored centrally within SQL Server. I shall have tables used within...

Hey, does anyone know how to determine an Outlook mail items date received property? Its nothing obvious like mailobject.received. Also, how can we find this out ourselves? There must be a reference library somewhere so I guess I'm not using the correct terminology. Thanks for any help :)

I'm thinking about printing labels, 8 to a page - 4 rows 2 columns. Am I right in thinking this is beyond Access's ability? Cheers folks

Hey folks, it's been a while but I'm back in the development game again :D I'd really appreciate your thoughts... What really is the best way, programming-wise and user experience-wise when presenting records in a form: 1) Use the form with sub-forms to show records. Add new records via a...

Hey guys, I need to change the design of my table and make a field Indexed, both with or without duplicates. I think maybe TableDef is used but cant figure out how :( Im using 97 If anyone has any code that would be great. cheers Ian

Hey, I dont suppose anyone can recolect any software that performs as an interface for many access front ends? I basically allows you to create create small Access databases as Objects, and bring them together via an interface, thus making large database over multiple user groups easy to manage...

oops, see Multiple Database Interface :D

Hey guys, here's one for ya, hope you can help. I have code that is very repetative and could easily be put into a loop, but, it is the control that is changing. As far as I know you cant concatenate strings and variables to form a control name...or can you (and reference the control)? :D For...