Search results

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

I have a number type field in a query called Answer. If the data in the field = 0, I want to show NA I have this is the query: Answer:IIf([Answer]=0,"NA") I get an error message: Circular refrerence caused by alias Answer etc I have searched this forum for examples, and mine seems to match the...

It works!!!!!!!!!!!!!!! You people are soooo wonderful. I have been working on this for a long time. Thank you very much. Happy

Fixed why I was getting nothing. Now I am getting 'Item not found in collection' 'bout to give up

I want to run a parameter query, getting the parameter from a control, on a form. Then I want to do an If Then I have the code below on after update the control. When I update the control, nothing happens. Apparently there is nothing wrong with the code, just the msgbox's don't happen. Anybody...

Dim db As DAO.Database Dim rs As DAO.Recordset Dim n As Integer Dim strSQL As String Set db = CurrentDb strSQL = "Select * from [Duh Query]" Set rs = db.OpenRecordset(strSQL) This code is on a control (controlA), on a form (FormA), on afterupdate. It works fine until I put a parameter in the...