Search results for query: *

Is there a way to change the caption of a label in a report's PageHeader section while the report's ReportFooter section is being formatted/printed? My report's ReportFooter spans multiple pages. I want the label in the report's PageHeader section to be different for pages in the report's...

I need to replace the File Summary Information Title after its removed by the compact/repair process in MS Access. I need to set the Title to "MyAppName 3.52" I've looked through FSO, etc but its all over my head and I need a quick solution. I'm hoping someone has a bit of code that will...

Is there a way to prevent MS Access from displaying the Save dialog after a user makes formatting changes - such as column widths - to a query? Note that I use "DoCmd.OpenQuery QryName, acViewNormal, acReadOnly" but it only prevents data changes - still allows formatting changes and displays...

I need the same functionality available in the (internal to Access) Tab Order form. I need to present a list of items in a List Box and allow the user to drag items up and down the list, the same way you can drag field names up and down the list in the Tab Order form. I can't use third party...

I have a multi-record form and the records on the form represent physical objects, each of which has a width that is stored in a field called "SectionWidth". I need to have an object for each record that changes width based on the value in the SectionWidth field for that record. Of course...

First problem: Linking an Excel 2002 spreadsheet into Access 2002, I find that Access displays #Num! in fields that contain numbers only, but displays correctly when the cell contains alpha-numberic values. Interestingly, this only occurs with a link. Importing the Excel file results in...

I've seen code solutions for populating Combo Boxes and including an "ALL" selection, but I wanted to use a Select statement. I think I have a pretty good cludge here but I'm wondering if anyone has a better solution - ie: that doesn't require a table as my solution does. I made a...

I'm trying to embed an image from the clipboard (for example a screen snapshot) into a table. I have a table with an OLE field named "Graphic". I have a form that has a field to display the bound OLE object. I can paste a picure into the field and it displays correctly. However...