Search results

This may sound silly but did you close up the blank space no longer occupied by the oriiginal-sized E-mail control? JT

Did you try using a query to fill the Combo Box instead of the Lookup Table itself ? HTH JT

One way I do that is make the control for E-mail address short (vertically 0.01) then set its Can Grow/Can Shrink properties to Yes. When it finds an E-mail address it'll print otherside the control will appear not to be there. HTH JT

Just a suggestion but have you tried running a Query on the Query Results ?? In other words can you use a query to limit to Project No then use its results in a subsequent query to maintain the grouping you desire ? HTH JT

Try a variation of this (substitute your control names): DoCmd.GoToControl "[ObjectID]" DoCmd.FindRecord .cboFindObjID, acEntire, False, acDown, False, , True HTH JT

The way I would approach this is to add a subreport to your main report based on a summation query, that is, create a Select query, use the Totals button (on toolbar, has the Sigma symbol) then using two fields: SERVICE and QUANTITY, Group the service and Sum the Quantity. Then tie to the...

I had a similar problem to this a few years back in Access 97. Could only narrow it down to a specific printer and it's low memory capability. Changed the report to print only portions of the alphabet (e.g. A thru G, etc.) then ran the three reports that were used to complete the set (then...

May be best if you attached your database for testing/evaluation purposes. JT

Likely because when you use that process: Office Links | Word you actually creating an .RTF document not a .doc document and Rich Text Format (RTF) strips off anything graphic from the resulting document. HTH JT

Sounds like you've done some valid investigation. Maybe you could attach database containing the report and subject data for one of us to try and resolve. HTH JT

If you have worked with ComboBoxes, you might want to look at the property RowSourceType, option Field List (rarely used choice) as a possible answer to your question. HTH JT

You must start with = "Applies to:" &[Forms]![FISReports]![Status] --- you missed the equal sign and the necessary quotes. Give it a try. HTH JT

Don't know if this helps but...I usually assign dynamic titles to textboxes on a report with something like this...Control Source property = "Applies to: "&[Forms]![frmQueryResponses]![WhichUsers]. HTH or sends your mind into adapting it to your situation. JT:)

If this is a one-time need and the data in the 'combined field' is not fixed length for each smaller field, you may want to export the data to Excel, do the parsing there then import the finished result into its three fields in the database. Excel has a parsing facility. Just an alternate...

Use a Concatenated, calculated field. Example... = [ASD]& ", " & [CIHI] . You can put whatever characters in the literal string (between ther quotes) you desire. HTH JT

Sounds do-able. Attach a copy of your db with appropriate objects, will have a look-see. JT

Might help to understand your problem if you attached a copy of your database with the necessary objects. JT

For the purists in the forum they'll probably not agree with this suggestion but here goes anyway. Build a macro using the RunApp Action, then the Command Line argument should be the location of your Excel.Exe file (use Start | Search | Files to locate). Sample command line is c:\Microsoft...

Maybe you could attach a dB with the Report(s), and what you're using to drive the report data-wise (query, table). Then someone can have a look at it. HTH JT

You know the odd thing about your request is that you created a second report with the same results. Usually this occurs when you've 'messed with' the report design and move a few things around causing that 'extra space' in the grid area that has no controls. NEIL's suggestion is generally the...