I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

April Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access Board   Print This     

What's happening now! All groups!

Home Updated Posts Unanswered Posts Online Today Who's Reading What

MS Access Interactive Topic Unanswered Threads

Interactive Access (creating forms, reports, queries, etc.).
 Show:
New Activity New Threads Oldest Unanswered Threads Most Active Most Read
  


24 Threads:

Add New ThreadRandom Thread

Thread 24 of 24
Thread Starter  

Wade.G
Query help (again)
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,
10 years ago
Nothing New Since Your Last Visit
2147
Hits

Thread 23 of 24
Thread Starter  

Wade.G
Query help
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
2906
Hits

Thread 22 of 24
Thread Starter  

craigh
upgrading Access97 DB to Access 2007.

I have a database that I wrote about 8 years ago in Access 97. I need to upgrade it to Access 2007. I know parts of the VBA code I wrote do not work. I need a frame of reference to begin to rewrite whatever parts of the code that are incompatible, but I don't even know where to begin. I assume some functions and stuff changed over 10 years.

What I was hoping was someone could give me a starting point - a resource of "how to upgrade" or "here's all the functions that changed", etc. Can someone get me started? TIA

12 years ago
Nothing New Since Your Last Visit
2594
Hits

Thread 21 of 24
Thread Starter  

KCRABBE
Show table box in query
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
16 years ago
Nothing New Since Your Last Visit
1932
Hits

Thread 20 of 24
Thread Starter  

SteveL13
How compile help file with Access (Developers Edit
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?
17 years ago
Nothing New Since Your Last Visit
1549
Hits

Thread 19 of 24
Thread Starter  

Pauline Warman
Wrapping columns in subreports
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 :)
17 years ago
Nothing New Since Your Last Visit
1406
Hits

Thread 18 of 24
Thread Starter  

Jocat
Data Entry Form
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
1936
Hits

Thread 17 of 24
Thread Starter  

vicha
fields on form applying to a document
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? Confused
18 years ago
Nothing New Since Your Last Visit
1401
Hits

Thread 16 of 24
Thread Starter  

Hoosiercomp
Half Sheet
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!
18 years ago
Nothing New Since Your Last Visit
1692
Hits

Thread 15 of 24
Thread Starter  

Hoosiercomp
Printing a report w/ using only the current record
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!
18 years ago
Nothing New Since Your Last Visit
1744
Hits

Thread 14 of 24
Thread Starter  

jdschram
Access XP
Has anyone used Access XP(2002), What do you think of it?, any cool features?
18 years ago
Nothing New Since Your Last Visit
1215
Hits

Thread 13 of 24
Thread Starter  

dmichael
Viewing a recordset? SOLVED!
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., Roll Eyes
18 years ago
Nothing New Since Your Last Visit
1386
Hits

Thread 12 of 24
Thread Starter  

rtaylor1
update 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., , , Roll Eyes
19 years ago
Nothing New Since Your Last Visit
1225
Hits

Thread 11 of 24
Thread Starter  

chemistwendy
HELP! How to get Close Form Button to recognize re
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?
19 years ago
Nothing New Since Your Last Visit
2143
Hits

Thread 10 of 24
Thread Starter  

chemistwendy
Trapping Input Mask Errors
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
1783
Hits

Thread 9 of 24
Thread Starter  

roger_anderson
format a field to time in code
(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 ? Big Grin!
19 years ago
Nothing New Since Your Last Visit
1625
Hits

Thread 8 of 24
Thread Starter  

SteveL13
Default for Find and Replace
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?
19 years ago
Nothing New Since Your Last Visit
1093
Hits

Thread 7 of 24
Thread Starter  

PMartins
Access graphs & NT
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.
19 years ago
Nothing New Since Your Last Visit
1862
Hits

Thread 6 of 24
Thread Starter  

ianmn
Printing reports (multiple pages)
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.
19 years ago
Nothing New Since Your Last Visit
1910
Hits

Thread 5 of 24
Thread Starter  

chris.d
Use Requery problems
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
19 years ago
Nothing New Since Your Last Visit
1538
Hits

Thread 4 of 24
Thread Starter  

KCRABBE
Tracking logons to a database / security
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
19 years ago
Nothing New Since Your Last Visit
1189
Hits

Thread 3 of 24
Thread Starter  

PMartins
SQL Distinct Problem
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
19 years ago
Nothing New Since Your Last Visit
3179
Hits

Thread 2 of 24
Thread Starter  

SteveL13
Default Values & Field on a Form - How set?
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?, , Eek!
19 years ago
Nothing New Since Your Last Visit
1136
Hits

Thread 1 of 24
Thread Starter  

jdschram
Drop Down Box for Queries
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?
19 years ago
Nothing New Since Your Last Visit
1126
Hits

New Thread

Follow PrestwoodBoards on: 


©1995-2020 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech