Search results for query: *

Hello all! As usual, the powers-that-be think that I can produce a rabbit out of my hat in less than a week. Here is my problem (sorry it's wordy, but it's necessary): I have a database that tracks projects that come in from different school districts throughout the state, each with their own...

What would cause a query to only allow SQL and datasheet views, but not design view? I have a query, based off of a Union query, that, at one time, permitted me to see all views, in fact, I developed it in design view. Now, after correcting some errors in the union query and some Excel...

Hi, Without getting into the long, sordid story as to why, suffice it to say that I have a data entry form that contains static data from a union query. Linked to the main form are two subforms linked to one of the two queries upon which the union query is based. Before the form loads, the...

Hello all! I have a db that has two data entry forms, which, due to changes in the law (we are in State gov't.), are based upon two different tables (there is no way to put them both in the same table). The user wants to be able to switch between the forms, without having to close one and open...

Hi! I've had the code below work beautifully until we upgraded to Office XP, now I can't seem to suppress the standard Access message "The text you entered, blah, blah, blah." I copied it exactly from a previous form, but now it doesn't work. Does anyone know if...

I have a checkbox that I would like to be checked automatically when a district that is found on a particular query is selected from a combobox. I'd written code on the AfterUpdate event of the District Code, but I'm not referring to the query correctly and can't seem to remember the correct...

Sorry this is so long! One of the directors in our office asked me to help him with the problem below, but I'm stumped as to how to get the specific information he is seeking. I'm submitting his question to me as written - if you need clarification, please let me know. Thanks in...

Hi there! First, I'd like to say thank you to everyone on this site - you have helped me where other forums have failed and I appreciate it greatly!!!! This is now the FIRST site I go to when I need answers! Okay, back to the matter at hand... I've inherited a database (Access 2K converted...

Hello all! I need help in writing a code that will calculate the dates of referenda based on the Year and the Month. This would be fine, except on each of the five months that referenda are held, the day differs. Here's what I mean: on January, referenda are held on the 4th Tuesday of the...