Recent content by cheftim

It Works! Thank you so much! This will make things go so much easier. I made some modifications for Access 2007 by changing "Office" to "Office12" and changing the extention to "accdb". I was unable to get it to work with my original location (perhaps because there were spaces in the name of...

Hey folks - Is there a way to open a different data base from within another? I would love to have a command button that closes the current database and opens a second. (My project is growing and it would make things much easier if the next several sections would be on their own - esspecially...

Rabbie Thanks so much - I didn't know that was in there. It works great!

Hello, Please help me get my mind around this problem. Although I have read most posts in the forum over the past several months, I can't even understand how to search for this topic. I have two tables: Events and Payments. EVENTS Event_ID Event_Name PAYMENTS Payment_ID Event_ID...

I think that I read somewhere about a macro command that pauses and waits for an action, then resumes the macro. Now that I've gotten to the point where I need this function, I haven't been able to re-locate the post regarding it. Can anyone help? My goal is to open my "Current Event" form...

Thanks, Doc Man Thanks Doc, Your replies seem to always be well tought out and well written - that makes so much difference - esspecially to a newbie like me. Good information. I have never created any batch files, but seems like this may be the next step in my studies. :) Thank you, t

Hello folks, I am searching for a good method of creating automated backups of my DB. Is there a good method within Access for this or is it best to look for a seperate backup program? I am working with a small non-profit company and they do not wish to have the on-going expense (albeit small...

Thanks Bob Thank you Mr. Larson, BTW you are one of the key people I mentioned above with my thanks. There were others and I wish I could name them all, but reading your posts (both to me and to others) has been extreamly helpful. Thank you. t

Hi folks, Thanks to the many of you who have helpped me get this far. I am finally ready to deploy my database! I would not have gotten this far in just a few months if it were not for your helpful advice. :D One of the final stages is to place the database on the organization's server and...

Thank you Thank you Thank you! I think that's just what I needed. I'll try it first thing tommorrow morning! I need to research how to do this in VBA - I've only used IIF in Access, but it is the "Me.GroupHeader0.Visible = False" thing that I think I was missing.

There are other comments, etc. in the group header of the form. Things such as.... The [groupname] will depart today at [departuretime] Even if the infromation in this line is null, there will be a line printed. This is what I am trying to accomplish by making the Group Header invisible when...

Sorry, but I don't understand how that would turn off the Group Headers just by eliminating the nulls. Maybe I need to clarify. I have a DB for scheduling events. It includes a number of buildings and services. In my query I have fields for Building A, Building B, and Building C. In the...

Is it possible to set up a IIF command to change the visible property of a report? I have a query that has mostly null entries and I would like to only print the fields that are not null. I figured the best way to do this would be to use Group Headers on each of the fields and then print those...

Thanks again RuralGuy. Good information.

I'm just about done with my database and will be putting it on the user's computer shortly. How often, generally, should we compact and repair the DB? Is this something I should set as an event everytime the file is closed? Is there any disadvantage to doing it too often? Thanks, t