Search results

Basically this will be fine for probably 97% of the cases within the table (these being documents from various sources that don't abide by the same conventions. Some only use Titles for each paragraph rather than a numbering system which means the user is required to sort manually). I need to...

Hi Brian, Thanks for the link, it is certainly a much more elegant solution than the one I had in mind! I'm just having some troubles with the implementation - I've set up some code to assign the value of the fSortCode to a new field - "AutoSort Code" (which will be hidden from all but...

[Solved]: Sort separated numbers in a text field Hi all, In my database, one of the key records is identified by it's "Clause Number" as it appears in the document. Common convention is to number these as in the title example (7.15.1.2) however the number of levels of numbering changes even...

Some Slight Progress (I think). The error is no longer coming up on "frmName =". I've changed frmName (As String) = frmCurrentForm.name (where frmCurrentForm = Screen.ActiveForm and is set in the code for the Form On_Load). All previous references to frmName are now "Forms(frmName)". I can post...

Hi all, I've hit a problem that, based on reading through several forums, many people have had however I'm not having any luck implementing the solutions for my needs! Basically I've set up two modules within my database - one called User Permissions (to retrieve the level of access the...

@jdraw: I know and this is the basis of my fear, however I don't understand why the data appears inaccurate on the Clause table when it is correct on the form and on the other side of the relationship. To try and explain what appears in the Clause table a little more - it looks as though it also...

JDraw, you are correct with the relationship, I've taken an extract screenshot if you still need confirmation? My concern with splitting the database is because I've not split a database before and am not sure how exactly it is done other than basically Tables will be in the Back-end and all...

First of all, I am not 100% sure this is a problem as I've not seen anything like this before. I'd also like to try and get a 'solution' (or answer) without uploading my database since it is quite large and the 'problem' is in a small section of it; so here goes: The database is centred around...

Hi all, My name is Michael and I work in the Aerospace industry in the UK. My experience with Access is largely self-taught, I learnt the basics of structure and how to design them (in access - not been brave enough to build my own yet!) during AS Level Computer Studies, and I've been...