Search results for query: *

Ok..nesting the third form into the subform instead of using a command button to access it does work and provides the Parent/Child link I was looking for to autopopulate the SYMTPOMID field. I also changed the control source of my forms to the tables intsead of a query since I agree I can't...

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...

Did some further research on old posts and found a solution on the Reports forum. Instead of using DCount to sum my option group records I can use an IIF statement instead. So, for example control sources with DCount expressions such as this...

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...

Yes, Steve that is correct. The relationships are optional and there may not be an associated record in each table to the Patient ID. I have been following your thoughts on rebuilding the form and have just completed a second form which at the moment appears to meet my purpose. The original...

Thanks Steve for the good suggestions. I verified that the field on the one side of the join was uniquely indexed and the fields on the many side were indexed. I tried to add a new record from the query directly and found an interesting situation. Let me explain: Patients Table is the primary...

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...

Thanks for the response beetee. I will certainly do the search and read up on the decompile issue. Meanwhile based on some other posts I did create a blank database and imported all my objects from the original. What I can now determine is that the source of my problem appears to be a subform...

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...

Thanks Gord I tried a variation of your suggestion and it worked. My database is split and even deleting and recreating the Switchboard Items table in the backend.mdb did not work. I had to create a new Switchboard Items table in the frontend and then pasted all the data from my copy into...

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...

Ok, here is what I did based on the suggestions from both of you. I did not want to create a save button since additional data must be entered on the main form after viewing the subform data. What I did was attach the following to the "On Click" property of the LastName field which...

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...