Search results

So....what's the question? btw...sounds like it should be 1 main form (Demographic) and two Subforms (Questions and Responses). Yes, that is possible.

Sounds like you are not storing the ID number of the record from the table that stores the new field. Instead, you are storing the actual text portion. For example, in the Algebra example, when the counselor types in Algebra, the combo box displays the word Algebra. But i'm guessing that the...

There is no need to have two separate tables for the same data. (Catgories and Catagories_1). Same goes for the Sub Catagories. Also, in your Organization Table, you have both Catagory and Catagory2. You said that each Organization can have two catagories. Can you say for certain that in the...

if that is how your table is setup the row source for your combo box should be: SELECT ID, FullName, StreetAddress From TableName; Also, is this combo box on a continuous form?

What bob is saying is that by storing the data in several places, the database is becoming de-normalized. If you are using the combo box to fill data into one table from another, you will run into issues later on. For example, what happens if Steve Smith moves? In order to reflect that change...

The other option is to pull the SSN and PIN number with a recordset based on the UserID. You can then compare them to each other and if one is wrong you can alert the user to what it is.

From VBA Help: Syntax for the Open recordset: [/I] When opening a ado recordset, the default for cursor is a Forward-Only. So you will need to specify the Cursor Type when you open up the recordset. Search VBA help using the keyword recordset. There is a topic on Ado recordsets that give...

Perhaps an example will help.

Count counts up the instances of the number of unique values of the particular field. So if you include the field ReferredToCoroners in the query twice (with the criteria set for the first column) and switch the Totals line to Count for the second column, the query would display one line. The...

After the selection is made, only the first column with a width greater than 0 is displayed. You can setup additional text boxes and have those text boxes display the other columns. In the After Update Event of the combo box you would put the following: me.TxtBox1 =...

use the docmd.transferspreadsheet command. Check the VBA Help for the correct syntax

Just set the criteria to Yes for the PM Ordered field. That should only show the paitents (can they be called paitents after they die? :) ) that were referred to the Coroner for a post mortem. If you are looking for just a count of total PM Ordered, create a new query and use the Count option...

You could display the filtered data in a listbox. This way, you could filter the results by PetType via a combo box. Then, based on the selection from the combo box you can set the criteria for the row source for the list box. edit: Quick little example attached

Use a Count instead of a Sum of the field

Well, let me start off by giving the token "Normalization" line :) The relationship between the Tanks and TankCovers is what is called a One (One Tank) to Many (Can have Many covers) Relationship. With that relationship, you should really have two tables. One for the Tank information and one...

The problem I see right off the bat is when Column2 is zero. You cant divide a number by 0. Now, if you didn't have a divisble by 0 error on rows where Column2 was zero, the sql would look like this: SELECT [col1]/[col2] AS Calculation FROM Table1; Not sure what exact percentage you are...

Is there any way for you to post a copy of your database? You can remove any sensitive data. Also, if you are using A2007, save it as a MDB file. Compact and zip to shrink the size.

From what I can tell, you dont need to use a dlookup. Simply add the Inventory table to the query and join the two tables together via the serial number.

*Points to Mr.Bs post* You wont have to rework code or anything. The linked tables will act as local tables as far as forms, queries and such are concerned. Well, the users have to have some place to store profiles and settings (A home folder). I would have a copy of the the front end put into...

My guess is that you are using a continuous form. Your code sets the control Monitor_type_txt equal to the dlookup value. Since in actuality there is only one control with that name, then it will display the same monitor type based on which record is selected. I'm guessing that this continous...