Search results

Good idea to have a 'partners' page or 'solutions' page where each participant is listed. And short BIO. Like any other corporate partners page. Gotcha is how the leads would get distributed. By region, by industry, round robin, or random :) ??? I would prefer by region to best serve the local...

10% of the project. I received a lead from someone and gladly gave him $1000 for the lead. It was a verbal agreement. I said I would pay a referral fee if the project completed. There is an extra incentive to be 'honorable' -- Since we are both in the same programming group, I would like to...

Creating a text box TOTAL with recordsource=nz(sum([LineItem])) should work fine. Just make sure it is in the Form's footer (turn on page header footer by selecting from access menubar: view...Page Header/Footer)

It has been a while since I've posted or answered q's at this forum. Wishing all a great New Year! I already searched the forums before posting this thread but did not find exactly what I want to do. PLEASE HELP! I inherited a DB and found records becoming corrupt. while editing a record, the...

I created a similar report of a grade sheet for a semester where all students need to be listed. Some students already had a grade, others did not. Naturally, When they did NOT have a grade for a course, there were no rows stored in the database. To produce the report I used a query for getting...

Take a look at the attached two column example. Now try adding plain 'ol text boxes to the header section. Any luck?

You should check the underlying query to the report. It sounds like it has parameters which need to be defined. They are probably set by a form. Look at the criteria section of the query. If you don't know which query. Click on the upper left corner of the report. Turn on or make sure the...

Move the headings over to the left (before 3.5" mark). Then go to the far right side of the report. Click and drag the report to the left so the entire report is 8". Change your page setup margins left & right to .5" If you can't click and drag the right edge of the report. Then you probably...

Make sure you put the header information in the "Page Header" section. Then double check to ensure the detail section is not running over the width. For example if you want 2 columns, make sure everything in the detail section fits into the first 3 inches. You may be able to push it to 4" but...

I doubt it was the filter which messed up the report. Take a look some of the fields you messed with. Did you change the record source in any fields? Perhaps from "JobCosts" to "Job Costs"? Maybe you put an extra space in? Perhaps you changed the underlying query to the report. Or calculated...

I'm not sure, but it sounds like the header info is in the detail section of the report. Yes? Just move the headers one level up...To the page header section or the group level section (if you have one). If you don't see a page header section, click on View and see if page header/footer is...

nice complex example Wayne! My report is running fine. Using some 'higher math' subtraction and a few invisible fields. I was thinking the header section would be 'initialized values' vs. the footer. But all fields sum up the same in both sections. Therefore, I have to conclude the header...

Thanks for the directional...I'll try the header section, maybe more fun :) I also found by putting fields in the footer with value = sum(xxx), I never use the runningsum property. Only in one report I used running sum for enumerating students. I tried on another report to mess with loading...

I have a report which is summarizing every semester. I have to display "Past credits" which are the credits sum'd up to that semester. Is there a way to reference the summation field of the previous detail section. Or put an invisible summation field in the header?? :confused: quick example...

Thanks Wayne, The watercooler is great! Thanks Boss for the example. I may try to combine some of the code with Mile's code to loop through field/text box names. I don't want to hand code every field name on these forms. I have to put this one on the back burner for 1 or 2 weeks as priorities...

I haven't messed with DAP yet... But how 'bout lazy HTML-- Creat text fields with html tags in your report. Surround the data fields you wish to format. for example: <B> Textfield </B> and save the report to disk.

Thanks for the assistance. I found a thread which loops through the catalog for query names, I'll just modify it for forms and see how she works. "just use the editor" - Good idea about the VBcode, I wasn't sure how complex it would be to tackle that object. I know Keep it Simple Stormin

Good idea. Any code samples or hints on how to make the change permanent vs. that session?? And what color combos have worked for your users? I already cut & paste some codes from other threads on the topic. Still seeking some concensus on what has worked vs. subjective favorite colors.

Some users don't mind the grey, others want blue. I'm thinking of creating a form with four choices, user selects this, writes the value to a datafile or registry, then vba routine changes all background colors on startup. Seems to be a lot of effort for little gain. Any coding examples...

I found a nice 'glitch' in the original table structure I inheritted. Two date fields are defined in different tables. Same data, just duplicated. I wish to consolidate this info and clean house. How can I find ALL queries, reports, and forms which reference these fields? Thanks in advance...