Search results for query: *

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

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

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

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

I have a (3) column table that I'm using for my report: Category Description Subtotal -------- ----------------------- -------- Balance Previous Balance $100 Balance Amount Received 50 Fees 1000 Fee X...

I have a subform that has a datasheet for a table that am clearing with a Delete Query and then setting new values in the table with "DoCmd.GoToRecord , , acNewRec." It works fine, except that after running the Query, Datasheet view of the table looks like this: Category...

I have a Form that indexes a table of invoices ("tblInvoices"). My invoice form has a subform corresponding to a scratch table ("tblInvoiceScratch") for generating the invoice report. I'm currently doing all of my invoice calculation in VB in "frmInvoices," and...

Is it possible to change the background color of a button? when I select buttons, the Paint Bucket Tool gets greyed out. Also, the only color options I see under Format Properties are foreground color properties. I can change the background color of the form itself, but can't for the life of...

I have a report that I am building that is based on a table with three columns. At the moment I build the table using an Append Query, but since I don't know SQL very well and build all my queries using Design View, its getting a little intractable. I currently do all my calculations in VB...

I want to use the GoToRecord action with acGoTo to make the a specific record active in my table, but am clueless as to how to find the index to that record. I can easily extract data from the record I want using DLookup(...) but what is the prefered way for finding the index to the record in...

I have a popup time card Form that is the only form in my database. When Access starts, its startup options are set to bring up this form. From the 'Form_Open' handler I call fSetAccessWindow(SW_HIDE) (downloaded from http://www.mvps.org/access/api/api0019.htm) which hides Access, leaving only...

I have a table the lists employees, e.g., Mary Joe Sue Brian Beth And a second table that lists how many hours they each worked that week, e.g., Brian 8 Sue 8 Brian 4 Joe 7 Sue 3 Brian 5 I want a Query to Sum the hours for the week. So, I...

I'm putting the finishing touches on my simple Time Card database. I shut off all of the startup options I could so I get a stripped down application window. I also maximize my one form at startup so that my form fills the application window, which is nice. The creme de la creme would be if I...

I have a Time card form that has two subforms. One subform, "HoursSubform," contains the table that contains the hours, e.g., Job Mon Tue Wed Thu Fri Sat Sun Total ------- --- --- --- --- --- --- --- ----- Smith 6.0 8.0 5.0 7.0 26.0 Jones 2.0 8.0...

I have a Query that totals up the columns in my Time Card Table. My TimeCard Form looks something like this: Job Mon Tue Wed Thu Fri Sat Sun Total ----- --- --- --- --- --- --- --- ----- Smith 8.0 8.0 8.0 24.0 Jones 8.0 8.0 16.0 8.0...

I have a query that attempts to delete all the records of a table that have fields that match those of a second table. I had this problem before and someone recommended that I was trying to delete records from more than one table. Before I figured out a way to eliminate the reference, but in...