Search results

Thanks. I think we're on the same page. Actually, Allen Browne provided the answer in his sample database. He provides a mechanism for cancelling or re-scheduling events using an accessory table linked to the read-only query. This accessory table is altered via a separate form. He used a...

Hey, I used Allen Browne's recurring events concept to create a massive database that needs a recurring events component. http://allenbrowne.com/apprecur.html It works! It was great because it taught me about Cartesian joins. The problem is that Cartesian join queries are by definition...

That's why I say I sympathize. The idea of a survey seems easy, but when you get into it you'll find it difficult. I attach a screenshot of the relationships window. I wish I could do more now but we're preparing for a hurricane here in my part of NC!

My sympathies. I do a survey database. One survey is linked to many questions and each question is linked to many answer choices. One question can be on multiple surveys and one answer choice can serve for many questions. Accordingly, I have a junction table between the survey table and the...

Sounds like a classic "drill down" design. One chapter contains many subchapters. One Subchapter contains many questions. Is that right?

My goal is to embed a tiny bitmap image (i.e. thumbnail) and then link to the actual large file. IrfanView would be a good tool for batch reducing a large directory of files to a small defined size for use as thumbnails. My problem is that I don't have code that will limit the size of the...

Imagine if you will a table of assets (tblAsset). Each asset record is associated with an asset type (tblAssetType), a location (tblLocation), a department (tblDept) and a status (tblStatus). Each record in tblAsset can be linked to any number of records in tblLocation, tblAssetType, tblDept...

Yes, Thanks John BB Warning: This reply may only be logical to those who have worked through your example. I guess it provides an incentive to have a look at your original post. It seems I can type in the phrase "1 Or 2" in the QBE grid and my query will reflect that I want 1 or 2 giving me...

Hey, I use John Big Booty's dynamic multiSearch concept which I found on this forum at: http://www.access-programmers.co.uk/forums/showthread.php?t=188663 It works well, but I want to extend it. How it works is a textbox (txtSearchFor) on a form (frmSearchForm) has a number in it like: 12 I...

Thanks Guus2005. Once I know which database file has the info I want, I have numerous ways of extracting it. What I'm after, however, is a way to search through a variety of Access database files on disk to find a bit of VBA code or the name of a control. I'm not really interested in the data...

I can use windows search to find a Microsoft Word document or a Microsoft Excel spreadsheet or a PowerPoint presentation using the built in search function that comes with Windows. I can search file contents using keywords and if I index the directory, it's pretty quick. I remember a sample...

Does anyone have a bit of VBA code that will iterate over all of the controls in all the reports in an Access database and if the control is a label change the fore color from "Text Dark" to "Text Black?" I can imagine such a thing, but it would take me hours to develop and test it! I'm told...

I've seen a number of posts about using where conditions and filters to filter reports prior to their being opened. What about filtering an OPEN report. I use Access 2007 and on my reports, I can right-click in a field and filter the open report contents any number of ways. You can also use...

What a novel idea...filters. Hadn't seen that one, but it's a good idea! I now have a dialog that comes up when my users click on my search button directing them to a short tutorial on the use of the binoculars. That search feature is very rich and if it's there why should I recreate the wheel?

This is obviously an old question, but for other users... You might want to take a look at a microsoft template. It's their Tasks database. It's a rather simple database of two tables but it has an embeded macro on the contacts form. You double-click on the email address and it opens up an...

MikeSpaans, I added it today. It's what plog suggested with a few additions. I hope it can serve as a template for you and others.

I proposed a books and authors database as an example of a many-to-many design. The issue was how to populate the required junction table with records from the established authors list without using table-level lookups. I also needed to add, update and delete authors from the current list. The...

The default search box that comes with Access forms works well enough for my users. The only trouble is that it's hidden down there at the bottom of the form and is rather small. A cosmetic problem. Is it not possible to add a control (call it txtMySearchBox) on a form and point it to the...

aha! The "full reference to the subform" is probably exactly the solution. I even used the expression builder to reference the field in the subform. The trouble is that I've tried various incantations of the vba syntax with the . and the ! and the [ and such and nothing seems to work as...

Thanks Spikepl, In your solution, the "wrapper" form would take on some new character. It would have an onload event procedure and also a means of storing the variable passed to it by the calling form. Is that right? One guy suggested that I place a hidden field in the wrapper form and...