Recent content by rcoutts

In Excel, when the user starts typing in a Cell, if any of the other entries of the column match the characters typed, Excel will complete the entry with one of the matching other entries. Is there a simple way to mimic this behavior with the Fields of a Datasheet? Thanks! Rich

I have an invoice report with a few 2-pt. horizontal lines. The look great as a preview, but when I export them to Microsoft Word as an RTF file using "DoCmd.OutputTo,...acFormatRTF,..." I lose the lines. Does RTF not support lines? Thanks! Rich

I use Quickbooks Pro at work and tried for quite a while to figure out of to import/export to Excel with very limited success (I was amazed to learn that QB Pro has very limited Outlook syncronization capabilities, which is where a lot of users keep their client information, I would think). In...

I would like to add a switchboard to my database. According to the help file topic "Create and Manage a Switchboard form," the first step is: [code] 1. On the Tools menu, point to Add-ins, and then click Switchboard Manager. [code] But when I select "Tools > Add-ins" the...

Thanks for the posts. They make sense to me and I'm sure they will work. I just have one, embarassingly simple question -- how does one change the format of a text box in VB? I know how to call the code when the Event gets triggered, but what is the function call to change a text box's...

Your suggestion got me heading in the right direction. The "On Format" event gets triggered for every detail in my report. If I put in the line: MsgBox "Subtotal:" & lblSubtotal.OldValue Then every time my report opens it shows a series of dialog boxes starting with the...

I have an invoice that I want to have only the first and last dollar amount with a "$" and the other get none, e.g., BALANCE Previous Balance . . . . $1000 Amount Received . . . . 50 Interest . . . . . . 3 FEES...

I'm creating an Invoice Report that I want to look something like this: BALANCE Previous Balance . . . . $1000 Amount Received . . . . 50 Interest . . . . . . 3 FEES Hourly Fee . . . . . 2000 CONSULTANTS...

Found my problem. acFormatRTF is what I needed.

I want to export my report to Microsoft Word. When I run the command from VB: DoCmd.OutputTo acOutputReport, "rptInvoice", ".rtf", "MyReport" I get the error: "Run-time error '2282': The formats that enable you to output data as a Microsoft...

Ahhh...:) by "Section Footer" you're referring to the Report Footer? It does exactly what I need. Thanks for the help!

Robbo, Thanks for your posts. I think you may be reading a bit too much into my questions. I really have a simple report formating question. My Table has (3) columns, e.g., Column1 Column2 Column3 -------- ---------- ------- BALANCE Previous...

No. My (3) columns are: "Category", "Description", and "Subtotal." E.g., [code] Balance Description Subtotal ----------- --------------------------------- -------- Balance Previous Balance $100 Balance...

I want to export my report to Microsoft Word. When I run the command from VB: DoCmd.OutputTo acOutputReport, "rptInvoice", ".rtf" I get the error: "Run-time error '2282': The formats that enable you to output data as a Microsoft Excel, rich-text format...

I created a report that groups the three column of a Table under one Category and one Detail, e.g., Balance Previous Balance $100 Amount Received 50 Costs Supplies 10 Fees...