Search results

I am putting charts into a report in Access that draw data from a query. the query is a summary query that counts the total instances of each response, and the response value is used as the series for the x-axis in the chart, with the bar showing how many respondants their were for each one...

I am working on a database that users will use to enter data into forms based on pre-determined info. For instance, they will be rating a course on a series of measures which I will have entered into the database already, thus "creating" their response records, and they are simply completing...

Yes, that was the problem (corrupt version of Access on the first computer). Thanks again for your suggestions!

boblarson- the problem is happening with all of the reports in the database; not even the little hourglass appears, just nothing happens. KeithG- The printer installed is NOT a 4200 but I suppose we can try reinstalling the drivers to see if that helps.

We are operating an Access2003 database on WindowsXP and cannot get the reports in the database to open. No error messages appear, nor do the reports. -The database is stored on the C:\ and the user has full permissions on that folder AND the database -Network printer is installed -Reports DO...

We are working on an access2000 database that will incorporate various "tutorial" or "training" elements in the db on how to use the db (mostly links to outside PDF files, etc.); the training elements guide users on how to do various data entry tasks, report generation, etc. Is there a way, in...

That must be what's going on, even though there didn't appear to be any special characters, linebreaks or spaces, because when I re-type the values into the master table, they are recognized by the child table. Thanks for your help!

No, sorry, I should have indicated that: both fields are TEXT fields and have the same properties set

I'm experiencing an interesting problem with a database I have been working on. For some reason, when I tried to enforce referential integrity between two fields, whose values should have matched perfectly, I got an error that I couldn't because they didn't match. When I ran an unmatched...

We have a database that was created in Access2000 and when opened in (or converted to) Access2003, commas in the query criteria fields change to vertical bars. The query still runs OK, but when you try to modify it (by adding another table or something) you get an error message: "Invalid use of...

Yes, default open mode is "shared"

I have read through just about every post on this forum related to "Unrecognized Database errors" and have not found a solution to my direct problem. Stats: Database is running Access2K on all machines; db is on network location, no sharing issues or permission issues have been identified, no...

I'm not sure why this isn't working for me, but any logical event I attempt to attach this code to does not seem to produce any result, let alone the desired one. All other codes behind this form/controls seem to work just fine, so I started thinking perhaps something is wrong with what I'm...

Yes, I'm also an administrator on the computer (including the network drive where the database is located)

The error message appears EACH TIME any user opens the database (except me, the administrator). I am the only one with permissions for the db set to open exclusive. The only time it appears when I log on is when another user has the db open, then, as it does for others every time, the error...

Yes, as I mentioned, I am familiar with this error message and what it means, when it usually happens. The part that is confusing is that it appears even when nobody else has the db open, and it appears repeatedly.

OK, I've read through many posts here looking for an answer and can't seem to find one that really addresses my particular problem. I've had experience with the exclusive access numerous times before, so am aware of the "typical" problems and fixes. This one has me stumped, though. I have a...

I have a number of "Labels" reports (for mailing labels), which were originally created with the Access Label Wizard for pre-formatted labels. All of the address text fields were set to CanGrow=Yes, while keeping the detail section's CanGrow=No (so they don't overflow onto other labels). This...

I tried splitting the macro up at the place suggested, and putting the steps from SetValue (...ApplID=...ContactID) on the Before Insert event of the Applicants form but what happens is the Applicants form opens to a blank record. If I hit a data entry key (spacebar, or an alphanumeric key)...

Yes, that works, and it works if I type the ID number into the parameter dialog box. What I was hoping to accomplish, however, is that the ID field value would be detected automatically and used as a criteria for the underlying query instead of having my basic users have to find and type in the...