Recent content by ssmithri

Adam... just what I needed, thanks! I had to tweak a little (rs.Fields.Count - 1 should be rsOLD.Fields.Count -1) and I had to add some IntegerTypes, but other that that it worked like a charm. Thanks so much. Stu

Perfect... except that the cost is $299. I can't get my company to pay for it... I already went down that road. I know the msysobjects table contains the table names... I can loop through that with no problem. How do I reference the fields in each table, then loop through a query (to count...

I have, but there are hundreds of tables and thousands of fields... I am sure it is just a loop from the right objects... anyone?

I have searched a great deal and have not found a solution. I seek some vba code that would allow me to insert table, field, and field property information from the msysobjects table into my own "Data Dictionary" table. I am trying to document/organize a mangled database "implemented" by a...

I have been down this road... In my case, the query had a "manual" parameter applied. If you go to design view in the query, then to Query (on the toolbar), then Parameters, is there anything entered? If so, delete it... and the parameter message should never appear again.

I do not believe that this is something that can be "adjusted." When you click on the drop-down, do you see the full table names?

Thanks Thank you for keeping guard over the forums. When I do as you suggest, I am returned countless results containing no answers, just posts suggesting that I use the search function :mad:

Or, perhaps something like this? SELECT tblCoActivities.CompanyID, Min(tblCoActivities.ActivityTime) as firstactivity FROM tblCoActivities WHERE (((tblCoActivities.StatusID)=1) AND ((tblCoActivities.ActivityDate)=#9/15/2005#)) GROUP BY tblCoActivities.CompanyID ORDER BY firstactivity;

This may be way off, but if I follow your code correctly, I do not believe you will ever get to "1". Let's say you have 10 records in the table "recset" Counter increments all of the way up to 10... where your formula will result in 10-10=0. The next loop around, counter increments to 11, but...

Thanks Neil... I overlooked different when I saw a column of data. I agree, the data needs to be normalized first. Stu

Scott, Yes... create a select query, and then click on the summary button (looks like a Greek E) on the toolbar. Drag the field you want down from the table, then in the "Total:" row, click and select "Max" This should do it. Stu

Fiona, I hesitate to post without seeing the query/data behind the scenes, however, if you build the form through the form wizard... selecting each field from each table that you need, the resulting recordset might be writable. I do know that I have never been able to input data to tables in a...

points:IIf([rank]=1,100,IIf([rank]=2,75,IIf([rank]=3,50,IIf([rank]=4,25,IIf([rank]=5,10,0)))))

Step 1: Create a new query and add "mytable" Step 2: Right-click on the title bar of "mytable", go to alias, type in "myt1", then close the property box Step 3: Change to SQL view and paste the following: SELECT myt1.customerref, myt1.date, (Select Count(*) from mytable Where [Date] <...

Jamie, Try this... SELECT Format([time],"Long Time") AS Timetxt, [Dec10/04].[customer name], [Dec10/04].yr, [Dec10/04].model, [Dec10/04].vehid, [Dec10/04].estdur FROM [Dec10/04] WHERE (((Format([time],"Long Time"))=#12/30/1899 16:31:0#)) ORDER BY Format([time],"Long Time"); Do not worry about...