Recent content by newcoder54

This is for documentation work. Dates could vary but the number of columns wont. Another way to put it is that put the field name of the third column of the crosstab table into a data row, of the field storage table, that has a field name of Field 3 etc etc. A one to one correspondence.

Hi Duane, Yes, good idea, Here is the output of the cross tab showing only 2 dates instead of all 7 so it fits the box here. The crosstab query will be run again in a week and those field names of dates will change Rep Minutes 5/1/2007 5/2/2007 LAURA 1554 120 119 LORI 2096 117...

Thanks a lot to both of you! Can't belive such a few lines does so much. Guess I need to learn a bit union queries - and maybe so know what I am after. Now, how do I put that back into a row with the top row going to field 1, row 2 to field 2 etc? The end result is that need the headers into a...

Here is the SQL Duane, TRANSFORM Sum(test1.Minutes) AS SumOfMinutes SELECT test1.REPNAME, Sum(test1.Minutes) AS [Total Of Minutes] FROM test1 GROUP BY test1.REPNAME PIVOT test1.MyDate; This puts out several date columns when run As the dates change in the fields change daily, I need to...

Thanks for the help guys. Maybe I should simplify this bit I scraped this up and it works fine but I need to write the output to a storage table with field names of field1, field2 etc. I will insure that the number of fields coming out out this ins less than my storage table. Hope that helps...

I need to keep an ongoing list of field names from a table that it created from a crosstab query. The crosstab is constantly changing as most fields are dates that roll in and out. I need to put the field names into a table and do not need the data. That way I can keep track of activity as dates...

How do I extract a list of table field names and put them into a different table?

I have a query which has a cross tab query as its source. So the "fields" change often. I want my query to just pull the field names and put them into a table. Over my head.

Hiya misscrf, This all helps me also in the thought process. This is stuff I only do when I get “volunteered”. User selects UniqueLastName in a combo box and then the rest of the form gets filled in. That persons first name, Title and address info will all populate. Selecting someone else in...

Here is a better way to express my problem. When a user selects the new record button, the focus goes to the UniqueLastName field. That is fine. Then the user picks the LastName which triggers the AfterUpdate. That should then populate some of the other boxed with address, title etc. That is...

Thanks misscrf, The tie on UniqueLastName keeping the two tables in sych works fine but, for example, when the user selects from a list of companies, it should update the data table with that selection. I understand the After Update but do not know the code that will do it. Something like...

I have two tables and one form. One table is the row source and the other is the data table. A common field UniqueLastName ties the two together. I have several combo boxes on the form. When the user picks a last name the whole form should populate with the persons other info and save it to the...

That and more caffine solved it - thanks

I get the error message "Control can’t be edited: it's bound to unknown field MyName" when I click on a choice in a combo box. Am at end of the rope on this. All the other controls work and are much like this. Just hoping someone can give me some ideas on this - Thanks - Larry

I have a combo box on a form. When the form opens, Set Focus is on the box. I want to require the user to select a name from the drop down or not be able to go to other boxes if they do not. Ideaa please. Not seeing what I need from older tips so far. Thanks