Search results

OK, I will try to be very detailed. My original problem was that I needed to know how to increment one of my fields, in a table, by 10 for every record entered. For example, My table has a primary key called Family ID. I need for the Family ID to start at 100 (which it currently does) and...

Thanks for the replies. I have not made it work yet, but I am still working on it. The IF Then End If seems to keep things from working. If I take that out of code then I get feedback. It is incorrect feedback, but none the less, feedback. Is there something wrong with the IF Then code? I will...

WHere would I put this? This would not change the the Family ID in the table, right? If not then this would occur: Family ID = 100 TextBox = 110 Family ID = 101 TextBox = 111 Family ID = 102 TextBox = 112 Family ID = 103 TextBox = 113 This is not what I am looking for. OR AM I...

HHMMM, I do not have any code. I created a table with a Number attribute, created a query, and then appended this table to the table containing the Family ID. I followed this procedure because my table were already populated. I found this procedure in the Help section of ACCESS 2000. (search...

I have a Family ID, which is my primary key, and it increments for each new record entered into the database. I want the records to start with Family ID = 100 and increment by 10 for all records entered after. example: Family ID = 100 Family ID = 110 Family ID = 120 Family ID = 130 Family ID =...

That worked great! Lets see, about 15 hours to get this to report properly. HMMM, Thanks again.

Yeah, my systems was frozen so I hit refresh and I gues that did it. SORRY Thanks for the example

could you give and example of the syntax for the WHERE clause in the docmd.openreport? Thanks

could you give and example of the syntax for the WHERE clause in the docmd.openreport? Thanks

Ok, HERE GOES I need a report created. The report is going to contain all attributes of one record from a query I have made. I would like to achieve this by having a drop down list on a form. Now, how can I do this? I have a drop down list(Combo box) and I can chose a record from the query...

Does this query look right/make sense? WHERE ((([Family Information].[Family ID])=("[Family ID] =" & [Me].[Combo6]))); What is the ME? I see it often.

OK, I can now get the Family ID on the report. BUT, I also need some other attributes and I am not sure how to get them in the report. How would I do this? This is what I have been trying. I created a query by Family ID. I want to select Family ID from the drop down list and then press a...

I have a form that has a combo box with all the FamilyID. After I chose the FamilyID I hit a command button that prints a report. My problem is getting THE ONE FamilyID on the report. Right now it does not matter what FamilyID I chose, once I hit print all FamilyID's are printed. I cannot figure...

OK, combo box is in place. How do I get the information for the particular FamilyID to print?

I will give it a try. Thanks

How do I query a table for a particular field that is specified by user input. Ex. I have a form that has has a text box and the user is suppose to enter the familyID that he/she wants to print. I can query for all of a certain feild but I need to have this work with a user specified FamilyID...

Thanks guys, I went back and fixed my SQL statement to include the field from the other table. Thanks again

I quess another way to look at it is: How do I add a field from another table to the Field List of a particular form?

No they are two different fields. Field A and Field B. Field B is in another table and I need a text box for this field in a form that contaions fields for a different table.

O.K. I have a form that has text boxes for fields from one table. I enter data into those text boxes and my table is updated. NOW, I need to place another text box on this form, but the field is from another table. How do I accomplish this? I can do this by recreating this form and placing the...