Search results for query: *

I have a main form EVENTS which has a subform SYMPTOMS. These are linked as a Parent/Child relationship with the EVENTID being the common linked field. Within the subform I have a command button which opens a third form called VITALSIGNS. The common field between these two forms is the...

Hello All, I have a data entry form that contains memo fields which have the "Can Grow" property set to yes. After data entry is completed the form is printed for each record. Normally the form prints correctly on 1 page per record. When the memo fields contain an unusually large...

I have a summary report based on a form. The report uses a Dcount function as the record source on MANY controls. The report is based on a query and that same query is referenced in the Dcount expression. Because I will need to run this report with quarterly summaries I decided to change it...

Is there a limit to the number of right outer joins you can have in a query? I have a form based on such a query. The Add New Record command button works correctly until I attempt to add the 4th table to the query. At that point I get the message "You can't go to the specified...

Ok I created a subform with a bunch of controls and calculated fields. Saved it and then found I could not open the form containing the subform at all. Could not open the subform itself in design view or any other way. Could not view the code for the main form or the subform. They both dont...

Ok...I have a strong idea what might have happened but can't figure how to fix it. Using Access 2000 I was creating a new form based on an old form which already had controls tied to event procedures. I did the old "Save As" and just renamed the new form. I then Renamed the control...

Hi all, My co-worker is working on a small Access database which has 2-3 tables with simple queries and forms. All has been working as designed, however, just the other day she went back into one of the tables to view data.....and the table appears BLANK? Shows over 900 records....but no data...

Hi All, My Switchboard Manager cannot find the table "Switchboard Items" even though it plainly exists under the tables tab. I have been working between two copies of the database and have copied tables, forms back and forth between the two. Now I cannot get the Switchboard Manager...

Hi All, I have a main form which is tied to the subform by employee ID. Main form is used to enter schedule variances for the employee. The subform displays the employee position and shift info from the employee detail table. Problem is when I enter the employee ID in the main form, the...