MS Access Interactive Topic Unanswered Threads

I have 2 tables, one (tblLOCProfile) is a list of locations, start day, and end day (LOCATION, StartDay, EndDay).  The other table (tblDailyData) consists of a list of locations and a temperature reading for each day of the year (LOCATION, DayofYear, TEMPERATURE). What I want to do is get an average of TEMPERATURE for each location based of the Day of Year range (StartDay, EndDay) from the first table.  THe kicker is the StartDay and EndDay may be different for each location. Any ideas of how to go about constructing such a query? Thanks,

{Too Long!}

I am almost sure that I saw the answer to this on one of the message boards or in the archive but I cannot find it. So, if someone could help me solve this problem, I would appreciate it., , In Access 2003, in the query function, and then when you request "show tables", is there anyway to make the box that contains the listing of the tables larger?, , All the names of the tables begin with the same "Active Clients 2004 at CCHC with . . . " but the box will not let me see past the "with" . . . , , I hope I've explained this well enough and if anyone has a solution so I can see the whole name of the table, I would appreciate it., , Thanks, kc

I have my help file compiled, (helpfile.chm). Now I want to somehow be able to compile that help file along with the Access file using the Microsoft XP Developer Packaging Wizard. , , Anyone know if this is possible and how to do it?

Hi,, I have a report containing sub reports. One of the sub reports contains just two fields but I want the output to extend across the page to match the layout of the other sub reports (which have more fields) for tidiness. Is there any way to "wrap" the output in this sub report so I get four columns in it using just those two fields, withoug repeating the data - eg, ID Name ID Name, , Any ideas?, , Many thanks,, , Pauline :)

{Too Long!}

I have a form with the same values of the Word document. Can I make the fields of the form fill in the blanks of the Word document? This way, I'd like to have a print command on the bottom of the form and when that happens, it would be nice for it to launch the already made Word document, fill in the blanks, and then print the document. Is this possible? If so, how?

High Kudos to whoever can figure this one out..., , I'm printing out a form that fits in a half sheet of paper's area. I need to be able to fit this form in4 an 8.5 x 5.5 area, but when I look at the paper sizes, only your average default sizes are available (letter, legal, and various envelope sizes). I see that in Word you're able to specify what size of page you want, but can this carry over to Access? Can you make a document template in word and have that be accepted as a paper size?, , Thanks in advance...this is all that stands between me and letting the boss play with the database proper!

Hi and hello..., , I'm in the process of making a database to handle service calls. Currently my setup is such that after the user fills in the form he prints off the current record which goes down to the printer in the shop for their perusal. , I'd like the ability to, after the user enters the data into the form, create a *report* with that form's info that could then be shipped to the printer. Currently I've got a macro created that will print the *most recently completed* form, but returns a blank report when I try to print a form that I've finished but haven't advanced to the next record yet. Any ideas on how I need to reword the macro would be greatly appreciated. Thanks in advance!

Has anyone used Access XP(2002), What do you think of it?, any cool features?

Axxess 97 used as a front-end for an SQL2K Database, , I can select the records I want from the SQL2K table into a recordset in Axxess 97. I want to display those records in a form, either straight from the recordset or by putting them in a table., , SOLVED! By dynamically creating a pass-through query in code, containing the variables from my form, and then opening the pass-through query.,

CAN I RUN A UPDATE QUERY BY SELECTING A VALUE FROM A COMBO BOX. USING AN (IF AND THEN STATEMENT) IN THE AFTER UPDATE PART OF THE PROPERTIES., , ,

I have a form where a user can either enter a new claim type or change an existing claim type. If they change the claim type code which is the key and there are related records in another table, they currently only get the standard error message "The record can not be deleted or changed..." when they tab to a new record. I also have a close form button on this form and I need for that button to have a similar error message attached to it so that if they make a change and then hit that button they are informed that their change is not going to go into effect. We do not want to allow cascade updates so they just need to see a message letting them know they need to change it back. Can anyone help?

{Too Long!}

(Newby). I can create a table using ADO and add fields with particular data types, such as adDate., How do I now format these fields to be dd/mm/yy and hh:n ?

I have an Access form which contain a button to "Find" a record. When the Find and Replace window pops up I would like the field that asks for a Match: to default to "Any part of field". How can I do that?

We appear to have a problem with Access 97 graphs in NT4., One of our databases produces graphs in reports. The graphs work fine in Access 97 on Windows 98, and Access 2000 in Windows NT4., However, when producing the same report in Access 97 in Windows NT4, the reports either contain truncated graph elements, or no plotted data at all., , Because this database is used by a few different companies, we need it to work in these various combinations., , Can anyone suggest a reason for this happening?, Thanks.

Developing a manufacturing system. a report is generated and printed automaticaly., Each item needs to be printed based on a value in the prntqty field., The prntqty value for each record can be from 1 to 10. (eg 10 - i need to print 10 copies), i will have more than 1 record and the prntqty value will be different for each record.

I created a Form that has a sub-form. I then created another sub-form based on the first sub-form. In order to make the second sub-form update when selecting a record on the first sub-form I used a requery in the current event of the first sub-form. This does the trick. My problem is that once someone does 3-4 "Find"s on the main form the form freaks out and sometimes crashes Access. Does anyone know what is causing this to happen and how can I fix the problem?, , Thanks for the help in advance., , James R. Meehan, Information Systems Specialist, Public Citizen, 215 Pennsylvania Ave SE, Washington, DC 20003-1155, 202.546.4996 -- Work [URL=http://www.citizen.org]www.citizen.org[/URL] , jmeehan@citizen.org

I guess the quickest way to the problem is to give the scenario., , I have created a small ACCESS app to track confidential data about clients., , I need to be able to do 2 things:, , 1. I need to limit who has access to this program (i.e. via a logon name and password verification) and , , 2. I need to track who had access and when the person had access (i.e. date and time)., , Only one user on the network will have access to the app at one time., , I could do this in Paradox but I am not able to do this in ACCESS. I have tried a couple of "things" (i.e. with forms / look ups, etc.) with no luck., , Anyone have a suggestion?, , Thanks, KC

We are in the process of upsizing our Access 2000 interface and database to SQL server., Our interface involves a fairly complex query which contains 33 tables., To use SQL server, we need to change the DISTINCTROWS clause in the query to DISTINCT, and a reference to 'False' to '0'., The query itself now runs fine in SQL server, but cannot be run from our mdb, returning an error of 'Query too complex'. Initial investigation seemed to point the finger at a 16 table limitation of ODBC V2, but having used the same syntax in an Access-Only environment, the same error is returned. This seems to suggest that the fault does not lie with ODBC, but with the syntax instead., Has anyone had any problems with the DISTINCT clause in an Access/SQL environment?, , Thanks,, Paul

I've built a form to feed data into a table. But for each form entry after the first I would like some of the fields to be filled in from info fed in on the first form. , , Plus, I want to make the cursor default to say the third field., , How do I do all this?, ,

Is there any way to make a query dynamic using a drop down or list box? I am aware of manually entering data using [Enter Text] in a query...but is there a way to elimiate user errors?