Search results

Is rptCoating a chart? Also, you may need to specify to Access that you're talking about the subreport of the main report, such as: me!rptCoating.Visible=true Access may think you're talking about rptCoating on its own. Here's info on Run Time Error: 424...

Ok, so ignoring my "big picture" post... Anyone care to take a stab at my initial question, being having an Access 2000 select query produce all dates in a date range into a field on the query?

Hmmm... Ok, lemme see if I got a handle on this: For each Student, you want to keep track of: 1) ...what Classes they're in, 2) ...what Module of the Class they're in, 3) ...where the Module is being taught. A) Each Class has a separate list of Modules. B) Each Module can be taught in a...

Too stale thread? I was going to add my two-cents to this post until I noticed it was a bit stale (Jan26'06). If you're still interested in your original content, reply here and I'll contribute.:p

I assume you have one table listing students, a different table for listing classes, and a third for listing what classes each student is in. If each class could potentially be held at a different location, I'd have a fourth table listing locations, and add a new field to the third table that...

I'd suggest reading up about how Access handles users and user groups. You could go into the security window and allow read-only access to the tables/forms/queries/etc. to those who should only have read-only access, and full access to others. I use it in all my databases. I have users grouped...

Hint Hmm... on the onOpen event for the report, you could probably go: if form!combobox=ValueIfGood Subreport.visible=true else Subreport.visible=false endif Technically, the subform runs, but is invisible. Just a thought...

"How" is it not allowing you to enter then Album Name? Is it giving you an error message? Is it not allowing you to type anything in the box at all? (good idea attaching those images... I'll have to remember I can do that)

More info please... Can you post a few records, just to get an idea? If so, include a few that you'd consider a discrete spill and a few that you wouldn't. This is what I understand so far: You have one field with a decimal value and you want to count how many records have a value greater...

Glad I could help. :)

Sweet!!!!!

Try this... This code will work IF: "Major", "Minor", and "Other" ...are the only possible choices for application type, and: >92 or <=92 and >56 or <=56 ...are the only checks for numberofdaystodecide. If you're going to add more later, then this code will have to be expanded...

TIME() function returns the current system time. Probably not what you're trying to do. My first thought is to try replacing your TIME() statements with format([CALL IN], "hh:nn") ...perhaps. If this doesn't work, see the DATEPART() function. DATEPART will let you compare the hours or minutes...

Doesn't matter... This is one part of a larger issue that I'm trying to work through. I am breaking this database down into smaller pieces, and this is one of those pieces. I'm currently using a table that lists 365 date records for 2006 but the query help I'm asking about in this thread would...

Find Unmatched Query Wizard Have you tried the "Find Unmatched Query Wizard"? Click the "new" button in the query tab to bring up a box to choose it.

As part of a larger issue, I am trying to figure out how to have an Access 2000 select query produce all dates in a date range into one field on the query. Assume at this point there are no tables in the query. If 01/01/06 (mm/dd/yy) and 02/01/06 is used, then it'd list all the dates between...