Replies

Thanks RG,

Why would you have to put a DISTINCT on the query to make autofill work? Never had to do this before.

Did some more testing and the results are totally bizarre. And totally inconsistent.

I’ve repeated the following 8 times now with differing results.

Without modifying the original form, I create a new form (unbound), use the combo box wizard to add a combo for the Bank Account.

This creates a combo with a query that has an order by but not distinct.

Sometimes autofill works on the resulting combo, sometimes not. But if it does, then the autofill in the combos on the other form start working. without any modification.

Can someone explain that?

I then made a copy of another database that works OK, imported the forms that didn’t and they did.

John’s spot on about NEVER letting users access tables direct.

Select the table, then on the ribbon goto Create>More Forms> Datasheet.

The resulting form still looks like a table but you can easily lock the contols on the form to prevent editing or set the form’s allow edits, allow additions and allow deletions to false.

Interesting about the fields missing when their names have a space. Especially when you see so many sample apps, even from MS that use field names with spaces.

Installing the 2007 runtime is a piece of cake and the Package solution that comes with developer extensions works really well too.

It even has an option to install the runtime to make the whole thing really easy for the user to install.

I’ve been using this for my clients (without Access installed and running MDBs) and it’s been great.

No harder than a vb.net application where you need the .net framework installed.

John, you are a genius. Works like a charm.

Yeah, I tried setting focus to the main form first as well, didn’t help.

Nearest I can get to acceptable behaviour is to use the after update, but if the user is trying to move to a different record in the subform they get a bit of a surprise.

I’m not an expert but I do know you can export the macros as XML that you can import into another database.

I played with macros in the beta but found too many issues and haven’t had another go since the RTM.

Unless I want to publish to the web and a Sharepoint server then I’ll stick to VBA.

With the issues I came accross in the beta I decided that if I wanted to publish to the web then I’d probably go to VWD instead. It’s more like Access than 2010 macros and sharepoint.

First thing I’d check is that the record source is updateable.

If you are using a query as the recordsource rather than just a table,

go into the recordsource query and see if you can edit directly into it.

Yep that works, thankyou.

Hey John – nice tip on Bullzip. They have some great stuff.

If you want to get really fancy – here is a little procedure I wrote (or stole and rewrote to be more accurate) that will hanldle exceptions to just captitalising the first letter of each word.

It handles names like O’Connor, MacDonald or McDonald but also allows you to enter words in a table for specific exceptions like Mackenzie.

It can then also be used on lists other than names like Product codes where you may want to retain XXL or USA

I’ve now uploaded the missing file!

Neat trick -thanks John, I’d always had to go to single view for the first subform.

You can nest a subform in the subform in exactly the same way.

You should have three tables –

tblIssue (with IssueID being the primary key),

tblResolutionActivitiy (with ActivityID being the primary key and IssueID as the foreign key that establishes the relationship with tblIssue)

tblActivityNote (with NoteID as the primary key and ActivityID as the foreign key that joins to tblResolutionActivity)

So just as you used IssueID to establish the Child / Parent relationship between the first subform and the parent form, you would use ActivityID as the Link Child and Link Master fields.

Enlightening, thanks Andrew.

There was something else going on as well. Some kind of corruption with the form.

The where clause wasn’t seeing the filter control.

Created a new form, kept the Like and all is now well.

You could should check the the event properties for macros and maybe the hyperlink properties. Althought the later is more probably the case with command buttons.

Thanks John, the article explains how to use the classes contained in the database but without the database it’s totally pointless. Frunstrating!