Search results

With the built-in Filter By Selection tool on the ribbon/toolbar, you can filter by selection on PART of a field. In this example field [THE BIG BLUE HOUSE] With the Filter By Selection Tool you can search for BIG or BIG BLUE. However, naminder's code works by filtering By Selection of the...

That's what I was looking for jdraw, Many Thanks

Thanks jdraw, nice video, but I'm looking for a sample database.

Could some point me to a database(s) in the "Sample Databases" section that demonstrate Many To Many relationships (with link table(s)) in action. Thanks for looking.

Great link on decompiling/compiling Steve. Thanks

I had a badly corrupted form in a front end DB. Compact/Repair didn't work. Importing everything into a new DB didn't work .... the db crashed access. I imported everything except the dud form into a new db and everything was fine. I copied all the fields and controls into a new form. When it...

IsNull is noted for future reference .... Thanks again

That works brilliantly RuralGuy. I'd never have worked that out myself (especially the "") ... Many thanks. Incidently, the box goes around a button which opens a popup form to view extra information, when it exists. No box .... no extra info ... so no point in clicking. By the way, was my use...

I've got a memo field on a form where the name is TextEXTRA The Control Source for TextEXTRA is EXTRA. I've got a box called BoxSHOW (Visible = No) As I browse through records or find records, I want the box to become visible when there is something in the EXTRA field and become invisible when...

I only spotted your posts today as I had no email alerts for this thread. How about basing your form on a query that has all the info(fields) you need and then create a split form. http://office.microsoft.com/en-gb/access-help/create-a-split-form-HA010075994.aspx...

Now that is a good reason ... Thanks

If a database has only one user on one PC, is there any advantage in splitting it into front/back end DBs

I've been following your main thread with interest. You certainly have taken on a complicated db as you very first enterprise! Suggestion .... have a look at the structure of some of the sample databases on this forum. http://www.access-programmers.co.uk/forums/forumdisplay.php?f=64 To quote...

An excellent, and well explained analogy plog.

Here is a link referred to earlier in the thread http://www.vbulletin.com/docs/html/vboptions_group_datetime

Read the second Commandment Of Access. http://access.mvps.org/access/tencommandments.htm

This should do most of what you want ... You will see the total number of back orders and you cannot leave the field blank EDIT:: Delete that field with the #Name? error .... I forgot to!

Fair point - majority rules ... Please consider an extended date format at some point in the future.

At this point I would recommend that you post a sample database with all personal info removed and some sample data entered. We will then have a much better chance of understanding and resolving your problem.

I'm resurrecting this thread rather creating a new one. The site is .CO.UK So why not stick to the proper UK/Irish format and not that illogical, non-intuitive US version ..... Failing that use unambiguous extended date formats (US or UK)