Search:

Thank you all for your help. As John posted, I posted this question on another forum where they found the solution I needed. I appreciate the time and thought you gave to helping me.

Thank you, Patt. I showed your suggestion to the user and he doesn't like it. He said data entry will take a very long time with this format. He liked the format I used in the original because he...

I talked him into dropdowns! Now I am having issues getting the thing to work so we have 1 form that has the date at the top, subform for the sites for that date, and subform on the sites for the...

I agree 100%. That's why I was stumped when Access doesn't act like Excel. He really doesn't like the drop downs. He is hung up on having a data entry screen like the spreadsheet. I thought that this...

Thanks, Wendell. No, they can't take a laptop. I already asked that.

The boss doesn't want dropdowns in the data entry form. He wants it to look just like the spreadsheet. He said they enter...

I'm stumped. Maybe I've lost my mind, but I cannot figure out how to design a database for the attached. My coworker has 5 people who visit our rec sites daily, several times throughout the day. Each...

Thanks for the responses. But, that doesn't really solve the whole issue. I can get the other person's contacts to show in the contacts view. But, when I create a new mail message and click the To...

Yep, Gary. It is. Didn't occur to me, but users now have restricted access - not administrator rights. Our IT Dept says they can't make changes like User Information, File locations.. some of the...

Yes

This same issue just started happening with us when our I.T. dept switched users to roaming profiles. Would that have something to do with it? I checked the settings under security, and the 'remove...

Can you share a non-default (custom) contact list? I can share the main default contact list, but I want to share another one I made.

Thanks.

Awesome! Thank you!

I have three .csv files that need to be programmatically converted into one excel spreadsheet with a tab for each file. Can you help me?

Thanks

A coworker wants to compare data in 6 columns, and if the cells match, she wants them marked somehow (probably just a background color will do).
For example, columns D, E, and F compared to columns...

Not sure if this is happening to anyone else. She is the only one who works on this file. I will, however, have her check the settings you mentioned. Thanks for the suggestion. I'll let you know if...

I have a coworker who has created a spreadsheet with links to an external website. They links keep breaking. She opens the file, makes an edit (not to a link), re-saves the file, and closes it. The...

I have a user who can only open Word and Excel files if she opens Word or Excel first and then opens the file. If she browses to the file via explore, and double-clicks the file, a blank word or...

thanks!

I'm trying to use datedif to calculate the difference between two dates. It seems to be missing from my function list. I have the analysis toolpak installed. hmmm any ideas?

What I want to do is...

Thank you, Hans!! As you figured out, I was picking the wrong table for the row source. Dang. Thank you so much!

I saved the db as Access 2003, Hans. Would you please take a look? I tried following your instructions, but I still am missing something because it didn't work. Thank you sooo much.

You're right, as usual, Hans. But, how do I change the report? You said use a similar combo box, but I've never used a combo box on a report before. I tried changing the field to a combo box, but it...

Well good grief. Yes, it does work, THIS MORNING! I swear, for days it has been giving me errors. But, maybe just compacting/repairing it to prep it for sending to you fixed that. So ok. Gulp.
...

I feel like an idiot. I should know this, but I've done something wrong and I can't figure it out.

Attached is my database without data so you can see what I'm doing.

I have companies that...

One of my co-workers asked me how to do this and I don't know.

She has a database to track employee security clearances. From our HR dept, she imports a temporary table of employee data (first and...