Search results

Hmm. This raises another unrelated issue. There appears to be a perception amongst potential business clients to whom I have spoken that Access is a bit "low spec". "Oh, no, our needs are too big/complicated for an Access Database, we need a 'proper' database in SQL Server". I suspect...

Thanks. The above line in red throws a "sub not defined" error. I presume that this is because Allen Browne assumes that one is using his error handling code as well?

Hello, I've been using this code to uncheck all items in a list box for ages (can't remember where I got it from - somewhere here, probably) - and it works fine. Dim varItm As Variant With lstWhatever For Each varItm In .ItemsSelected .Selected(varItm) = False...

The other one I picked up at about the same time is that you should never bind a form directly to a table. You should always bind a form to a query based on the table, even if the query has no criteria. Any justification in that one?

Whaaaaaaat?????:eek::eek::eek: I've only just got myself into the habit of doing that... :banghead:

When I first started writing VBA back in the '90s, some book I read told me that it was good practice never to use the information in controls directly, but use it through variables instead So, for example, whilst you can do : RS1!fldName = txtName (etc) You should do: strName = txtName...

Awesome :) :) :) Thanks guys. Working is absolutely good enough for me, but I have no idea how or why??? (I will pretend that it was something technical and scientific, but deep down I'll just carry on believing that Colin knew which ritual sacrifices to make to the Magic Query Fairy...)

Hi, Mike, I have a NavigationForm with bazillion forms and subforms for data entry. You asked for stripped down... :)

Database attached as requested. Its the qryAnnualReturnsByAssoc that I want to build an editable datasheet from - and, as you can see, it is uneditable.

In tblOrganisations, OrganisationID is PK I've made fldOrgID and fldAssocID into a joint-PK in tblOrgAssoc If I make fldOrgID in tblAnnualReturns PK, then the recordset is updateable. If it's just an Index, then it isn't. The problem is that fldOrgID can't be a unique value, because there is...

Thanks. Yes, I had already found that. Trouble is, if you don't really understand the language of queries, then it doesn't actually help very much. I can see lots of things that I'm pretty sure it isn't. I'm guessing it's this one: The fields in a JOIN are not indexed correctly: there is no...

Oh, lordy! I have been building my own access database for various work applications since 1997, but whilst i have taught myself to understand quite a lot of VBA in that time, queries have always worked or not worked purely because the magic query fairy says so... It is entirely my own fault...

If I change it and it stops working, after I have jumped off the roof, I will come and haunt you... :eek:

Oh my God! I've spent hours agonising over this - before I posted this message and gave up. I then went off and changed the colour of another control and now it's working??? I mean, good and everything - but wtaf? Talk about gremlins...

Can someone please tell me where I am going wrong here? I just can't see it and it's driving me nuts. I have an unbound text box [txtDualDefault], format = Currency, on a bound form. I am trying to set its default value on opening as the value set in my default values table (so that users can...

Subdatasheets on tables have sort of passed me by. I bumped into one the other day whilst mooching through someone else's database, having a looksee for interesting things. I have never used one and now can think of no reason why I would - I never let end-users anywhere near my tables … :)...

I know it's an old link, but my search for answers brought me here, unsuccessfully, so i thought I'd share what I found for the benefit of anyone else searching the same thing...

I have been struggling with this and have "discovered" something that isn't in the answer above. You (well, I, anyway) can't cut-and-paste straight into a virgin tab page. You need to "initialise" it by creating a text box or something on the new tab page first. Then the cut-and-paste will...

There's an errant space in the word "true" but this seems to do the job so far. Will have to wait until Jan 1st to find out if the 2nd half works though... :) Thanks.

Hello, I have a club where people start in positions of office on the 1st of August each year. I want to put a default date in fldStartDate of the following 1st August. I can almost do this with DateSerial - but I'm struggling with the year. From January to July, the start date will be...