Search results

I have a query in Access 2007. It's worked fine for months, but I'm suddenly getting a "the recordset is not updateable" error. Thinking an error must have been caused by a recent change, I went back to archived versions (that definitley worked) - they're all chucking out the same error. The...

All sorted, thanks.

Actually, it turned out to be NewData I was after, but thanks.

Hi, I've got a drop down list, but I want people to be able to add to it. I'm using the NotInList event to do so, but when I try to grab AccountantCombo.value (the ComboBox value), it only accesses the previous (in list) value, not the value I've just typed (which triggered the NotInList...

Hi Spikel. Date was set as Text rather than Date/Time. That's sorted now. *facepalms self*

I have two versions of the same form, one for creating a new record, and one for viewing it once it's created. Both forms have a textbox called Date, which are identical except for one is Unbound and one is bound to the Date field from a table. The Datepicker only appears on the Unbound...

I have a Form with a (Continuous) Subform that lists the results of a query. There's a header within the Subform that has several elements you can click on to programatticaly change the OrderBy of the Subform then refresh it. An example of the code I use is here: Private Sub...

Hi, I've used Allen Brown's advice on how to create multiple instances of a form (can't post a link as have too few posts, but a quick google will reveal the page I'm talking about), and it's working great. Now I need to reference an element on the form, but on an instance of the form, not the...

Hi all, I'm using a DLookup in a report called Sub Report - Client Extra Fields - it works fine, but when I include it as a subreport in another report, it stops working, just churns out #Error. Any clue why this would be? Code I'm using is =DLookUp("[Value]","[Report Query - Value...

Can't believe it was as simple as using the wrong wildcard characters, but apparently it was... *facepalms self* :rolleyes: Many thanks for your help.

Hi all, New to the forum and fairly new to Access 2003, please help... "Not Like" is refusing to work in my query - but "Like" works just fine! What would be causing that? I'm trying to filter out any client records from my database that have ZZ in the Client Code. If I filter with Like, it...