Search results

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...

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...

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...

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...

Premise: It might be useful to take a collection of forms that work well together and "wrap" them in an outer form that is nothing more than formatting and navigation. I have tblFirstName and tblLastName tblFirstName and tblLastName exist in a 1 to many relationship. tblFirstName is the one...

I have lots of forms which all look the same as they are based on a template. They look like a website with a header bar, a sidebar on the left for navigation and a body section with the logo in the top left. It may sound silly, but I need to place the colors of form elements (header...

I have login form (frmB) placed as a subform on a parent form (frmA). When a user logs in, the login subform (frmB) opens another form (frmC). I then want form (frmA) having (frmB) to close. frmC opens OK, but... DoCmd.Close acForm, "frmA" does not close frmA. Why not? I'm using...

I'm not a guru developer (I'm probably an advanced intermediate), but I know folks and have had to turn down a few assignments because I'm too busy. I guess they like me because I charge so little. I'm worried that if I say no too many times, they'll forget about me. Anyway I got the idea of...

Does anyone know of a Access database for tracking laboratory or clinical samples/specimens? There are stand-alone programs, but I prefer it in Access. It would have to accommodate multiple storage locations (freezers, refrigerators), print barcodes and provide for instances where one...

Folks, I have a database that maps students to their schools. I set up a junction table relating students to schools so there is a many-to-many relationship between students and schools. One student can attend many schools and any one school can serve many students. The tables are nicely...

Folks, I made a sample database of authors and books (after getting a bit of help from this forum). It seems to represent the classic many-to-many relationship. It works, but I am under the impression that I did not use the current "Best Practice" in making the form. For example, I used a table...

Folks, Where might I go to see a collection of really great Access VBA event procedures, macros and widgets? I read a great Linux book called, "Wicked Cool Shell Scripts" and I thought, I bet there is a similar resource out there of Access event procedures and VBA code snippets. Where should...

Folks, I'm new to the forum but I have a problem that no one seems to know how to solve. It seems like a basic thing to me, but everyone I talk to seems to avoid it. I have a database of books and authors where one author can write many books and each book can have many authors (classic...