Recent content by Boo

Duh. How could I miss something so easy? thanks

I have a table with people names "one". I have another table with the people's children's names "many". I would like to get a list of all the people who do not have any children. I other words, I would like a query to show all the records in the people table who have not had any records added in...

First make sure you understand autolookup queries. If that is not the answer, Read up on DLookup function. Access help has good info on both.

Have you tried importing to Access from Excel? A junior member

If the controls are in a report: There is a text box control property to align vertically. Properties/Other/Vertical

I want to make something similar to the Google search box, although not quite as complicated. I would like to be able to type more than one word in a search box. I am only searching on 1 field [Title]. The query would show all the records with the first search word in the Title, plus all the...

You guys are awsome! Is there anyway to use Like in queries where the user could type in more than one word? I have a text box (search title), on a form (Search). On after update the text box, opens a query. The criteria in the query for the Title field is: Like "*" &...

I want to put 2 Dbs on a network server. Below are the groups that can get to each directory. Directory Students: Students, faculty, few staff Directory Staff: all Staff I will have a separate workgroup for each Db because each group of users is so different. Each Db will have all deselected...

Where do I find the users passwords? I looked in the workgroup file and could not find other's passwords anywhere.

I have a Db that is secured with a workgroup. If a user puts a password in for themselves, is there any way an Admins person can see it, or change it?

OK I took the excellent suggestion and used the shortcut builder. It works! You people are wonderbar!!!!!!!!!!!!!!! Well, much has passed. Here is the lastest for any of you reading this and learning. If your shortcut is on a server, the shortcut builder will not work totally. You will have to...

Trying to make a shortcut to join the workgroup and open a Db. I made a shortcut for a Db, the shortcut defalt target was: X:\RC-Office\RC_OFFIC\database\Projects.mdb I edited the target line to: /wrkgrp ”X:\RC-Office\RC_OFFIC\database\MS Access Workgroup.mdw”...

thanks for the idea. We already have a workgroup with groups and permissions that has been in service for 7 years. What has happened is we copyed a Db and the workgroup file to another server, tested it, it opened just fine, then deleted the new files on the new server because we were not ready...

Hi all, We are changing domains and are doing alot of bouncing around with passwords and such. Now all my users who are not in admins can not open our Db. We get a message 'Could not lock file'. Any ideas? thanks

Pat, You are so very kind to offer extra info that I did not even know I needed. I searched for how to format controls on a report, tried it, and it worked!! Not too surprised it was your posting I used. Many, many thanks to you, sweet person. Erin