Search results

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...

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...

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?

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”...

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

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...

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...

I have a report with 2 fields: Grouped on [Name] Under Detail [Room] The output looks like this: John Doe Rm 100 Rm 200 Mary Jane Rm 100 Rm 300 Rm 400 Is there a way to make it look like this? John Doe Rm 100, Rm 200 Mary Jane Rm 100, Rm 300, Rm 400 I...

I have a date/time field on a form. I have a calculation that adds number of days to Date() and enters the answer in the field. Example:Date()+30. If the answer comes on a week end, can I get the date entered to be the next occuring week day? Thanks

Hi all you helpful folks, Can anybody tell my why the code below does not work? When I click the cmd button, the only msgBox that shows is the one that starts Didn't work. I want to be able to show the MsgBox stating there are no records. Help?????? Private Sub Command30_Click() Dim db As...

I want to run a query and do something only if it returns a record. so far: If <the query returned a record> Then Do something, I got this part figured out. Else quit doing anything End If

You people are so excellent! I have a query where I want to select records where the name starts with a range of letters. The criteria on the name field so far is Like "[A-C]*" So far, so good. Now I want to change the range to something else like D-G. I want the user to type that in and I do...

I have created a Crosstab Q. I have a Code field that I need criteria for. The Code field is also the column field, so I added the Code field again, set the Grouping to Where, and typed in my criteria. So far, it works. When I try to put a parameter in the criteria referenceing a text box on a...

Background: I have a table called 'Students' which is the 'one' table. The many table is called 'Term'. I am splitting the 'Term' table up into 2 different tables because I am importing term info into the 'Term' table, and there are 2 different times during the term that the data gets imported...