Search results

This doesn't work for this. It doesn't print a header and footer for each client, just the "Header- All client records- Footer. I have these two reports that are printed at end-o-month for each client. They are actually controlled documents. One of them has three sub-forms and the other one...

Can you send a report directly to the printer? We have Clients with multiple Contact Notes, by multiple Clinicians, each of these are separate tables. Every month we print two reports for each client that had at least one contact in that date-range. Usually 200 clients, takes a lot of time. My...

I have a form & related report that works best for the end-user, to open first in ReportView so they can still sort it, and then still go to PrintPreview before printing. On the report I have a print button with the following code, "Docmd.RunCommand acCmdPrintPreview". it opens PrintPreview...

That works perfectly. Now I just need someone not partially color blind to pick the right spot on the custom Tab for me:-) Thank you Alan

Hi, I have to create a control on a form that will be able to change to one of ten colors, some of them are subtle shades. I will be doing this from vba on the control. I know how to do all of this except defining the colors. I keep seeing the 3 part RGB(xx, xx, xx) etc. but I can't find the...

I have three Access back-ends in a db I've developed in 3 phases. Two of them fall along functional lines. One group of users works mostly out of Phase1, though not exclusively, and another group works mostly out phase2. Eight people are now in the db a majority of the day. One of my backburner...

I also say thank you!! I spent 2 hours messing with checkboxes not printing before finding your post. Any idea why that is like that?? Alan

Thank you Gemma'. I am in process of applying your suggestion over the holiday. Will let you know

Well, the form your referring to as Main is actually a sub-form itself so this new one is a nested sub-form. Also, I need this nested sub-form to repeat on each record of the subform. I have attached a screen shot of it in pdf form. In the first sub-form there is a control called Type. This is...

Every time I mentioned multi-value fields I get the same input, don't use them. So I am trying to replace this field with a junction table. This will have multiple records for each record in the original subform. The only problem is that the original subform is set to continuous view and now I...

Thanks! I understand. The other columns would be Attendence, Level of participation, Homework given.. I think that it fits exactly what you were saying, it does take both FK's to define it.

I understand, I was trying to justify why I need a Junction Table. I went to that first link you gave for Rogersaccess... and read the multiple Normalization posts. I'm half way thru Entity-relationship Diagramming. Thanks for the help

Yes, I am talking about a Junction table. I was using FK for foreign key and PK for primary key. -Table1 has all of the Classes that we have during a week, 50 total. It has the Class Name, Desc., Day, and Time. -Table2 is the Client table and has all relevant Client info -Each client can be in...

I am starting on a Join table in my database. I know I will have; a FK from Table1, a FK from Table2, a PK in the Join Table, and I need a date field at least in the Join Table. I would like to place 3-5 fields additionally in the Join Table. Should I add these fields to the Join Table or not...

Well I got it working. Subform2 had a form query with a nested query within it. The nested query ran a "SELECT DISTINCT" that I needed to run on field Initials_Clinician in Subform1. I thought the report generator might be having a problem making the nested query calculate so I changed the...

I have a report with 2 subforms. The Main report is Client info. Sub1 has ContactNotes for each client. It is in the detail section of Main, is in continuous mode, and is related to Main thru key ClientID. This prints good. Sub2 is a signature block for the report. It is unrelated. It looks at...

Thank you. I am going to try one of those. Appreciate the help

I have been developing a db in AC2010 for a non-profit org. Now some other similar organizations are showing interest in it. So... What about revision control, bug tracking, etc. Are there any free or cheap app's out there for helping in this area? What else do I need to be planning for? (other...

Thank you for the help. I was able to talk them out of that, holding the idea about a separate table as a future option. Alan

I have a split database where the front-end links to tables in two different back-end files. (access 2010) Then, there is a lookup field in back-end#1 that looks-up a field in back-end#2. It's all been working. But... The customer wants to be able to store multiple values in that lookup. I went...