Search results for query: *

Hello, I have tried to search for a solution on this, but haven't found exactly what I'm looking for. Hopefully I am not duplicating this question here. I have a MS Word 2003 document that I have added Option buttons to (Option 1 and Option 2). I need the user to choose one and then...

Hello all, It's been awhile since I have been here. I am in the process of creating a new DB on information that is coming from Excel. The data is getting converted over to Access permanently. I work for a child protection agency with children who go in and out of foster care. Currently...

Hello, I have a database that has a LastName field. The last name field can contain several last names. Here is how a typical LastName is entered: Smith xx Johnson xx Russell Now, I would like to filter records in the database to pull up say all Johnson files. When I attempt to use the...

Hello all, I have created a report which I will base on a query. I want to be able to select a number of records based on their File# (not an autonumber field). I would put criteria in the query, but there isn't any specific criteria to use. I will be picking a list of File#'s and there...

Hi there, I have a Tabbed Form (with subforms) on which I have placed a Print button. The Print button is linked to a Report. How do I get the Print button to print 3 copies of the specified Report? Thanks in advance, Sherry

Hello everyone, I have a label report which prints out file labels. Sometimes I print only say 10 labels on a sheet of 30. Is there a way to choose which label I begin printing on the next time around so that I don't waste half a page of labels? As it is now, the label report always starts...

Hello, I have a table that records family information (last name, file number, etc.). The table which is linked to it is literally a child table where the family child information is stored. Each child's first name and date of birth. The table currently shows the ChildID, FamilyID (from the...

Hello, Is it possible to have a text word as a default in a date field? I have a table that records a date of birth in this format d/m/y (3-Aug-04). I would like to have default text that says "Unknown" in this box until a date of birth is known. Is this possible and how will that be recorded...

Hello, I am hoping someone can help me out. I am looking to add a button to my Switchboard to run a label report. Now here's the hard part (at least for me :-) ). To get the info for this report I have to run a make table query to get the info from particular records (there are parameters...

I currently have a form that includes a subform showing data related to the client on the main form. I have added a button on the main form for data entry. However, I would like the information that shows up in the data entry form to default to a particular record in my tables. How do I go...

I am hoping someone here has an easy answer for me. I have a database that tracks families and their children. One of my main tables (Family Table) records the Family's Last Name, File No., etc. The other table (Child Table) records the name of each child in the family (there can be 1 or 10...

I have a form which has a button for selecting individuals from a list. When I click the button it brings up a form with the alphabet buttons (the list of individuals is very long, so it's easier to go by letter groups). When a letter button is pressed the appropriate list is viewed (lets say...

Me again! I have created a report to make file labels. The labels include a family last name, file number and then the various children's names in the family. The report I created makes a label for each child in the family. How can I get this to print one label including all the children's...

Me again! I have created a report to make file labels. The labels include a family last name, file number and then the various children's names in the family. The report I created makes a label for each child in the family. How can I get this to print one label including all the children's...

In my database there is a main form for entering information on a family. When users open the form they search for a particular record and then prepare to edit it. I want to have the records "locked" while they search and then have them use a button on the main form to...

I run a database that tracks families and their children along with other data. I have a main form which records the family's last name, file number, etc. There is a sub form on the main form which records the children's first names and dates of birth. There are two tables that this...

How do I set the focus to a specific field on a subform which is located in a tabbed form (the second tab). I would like to have the focus set to a specific field so that when I go to the second tab on my main form, the focus is set to a field on the subform on that page? Thanks, Sherry

Ok, my inexperience is showing again. Please bear with me. I have created this report based on a query. The report totals a number of different fields from the query. I have two issues happening: 1. The report produces a page for each record that I am counting. So for example, if the...

Ok, I am still working on this report. I have a section where Age Groups are counted for individuals. For example: We have 10 clients whose ages (according to date of birth) range from say 15 to 35 years. The age groups would be say; 1-15, 16-20, 21-30, 31-35 years. Sometimes we don't have...

On my main form the user selects an item from a list. On my report I need to calculate how many times the user selected one of the options. For this I have been using the DCount function. However, in a couple of categories on the report, I need to calculate how many times the user selects 2...