Search results

I know this should be easy, but how do I hide a field if there is no data in that field? I have a field called "other" in my report that I do not want to show if there is nothing in the field. Thanks for your help.

I am needing to attach pdf documents to records in my database. I have looked into the Attachment function of 2007 database, but it actually stores the records in the database, thus enlarging the database. Surely there is a way to have a link to any pdf documents I want to attach to a...

Any ideas on this one? The selections I make need to be highlighted in some way if I open the record later for editing. I'm sure there is a way to do this, but I cannot for the life of me remember how to accomplish it. I must be getting old.

I believe my database is pretty well normalized. I don't want to update all records of 'name of equipment', just selected ones.

I have a database that has an equipment table. Several of the pieces of equipment are the same, i.e. hospital beds. The question from one of my users is.... is there a way to add a comment to several pieces of equipment at the same time. For instance, I would need to search for hospital bed...

Here is a screenshot of what I am working on.

I load the selections from another table, but the control source of the listbox is set to the field in the main table linked to the form. For instance, let's say you have a form to keep track of people and the states they've been to. You have a multi-select listbox to list the states, which is...

I meant to type 'extended'. I have the control source set to a field in my table, but it doesn't want to save the selections to the table. Is there something I am leaving out? This is an Access 2007 database.

I have several enhanced listboxes in a form, but they are not saving the data selected to my table. Any ideas why?

The program we use does have an acknowledgement message, but I have suppressed that so the folks who use the program don't have to see a message every time they send a message. Even with that, though, it isn't very descriptive.

Does anyone know of or how to create a menu program for databases. I used to have a little visual basic program that would list all my databases and I could just click on it to open it. It doesn't work with 2007 databases, however, so I apparently got rid of it. Any ideas on this?

I have a database that sends emails to a certain maintenance worker depending on which nursing unit the request comes from. The program we use is a little free dos-based email program. We use Groupwise as our email system, not Outlook. Does anyone know of any other reliable email programs as...

I do see that there are no menus and such in the rt version. You can, however, export it to a PDF, so I was just wondering if anyone out there knew if you could export it to Word.

So what you are saying is it can't be done?

I have some users who have the runtime version of Access 2007. They are needing to export some reports to Word, but I cannot seem to find how to do this. Am I just overlooking the obvious?

We use Groupwise.

I appear to be having a problem with the SendObject command. We do not use Outlook as our mail client. Could that be the problem?

Well.......I guess that's where I should have started. I have never emailed a report from Access in the first place. Is there an easy way to accomplish this?

Is there a way to email a report from Access 2007 runtime?

Ok, Bob. I am officially an idiot. I did indeed have the tag property set correctly on each combobox......however, I had the dang code to check for the tag property in the requerycombos code instead of the clear button code. Amazing how things work properly when you actually put them where...