Search results

  1. S

    wrong value for Pages

    I seem to have solved this problem. There was some code for the GroupHeader0 and GroupHeader1 on print events. When I moved it to the respective on format events, the page numbering corrected itself. Can't say I totally understand, but I'm happy that it's working!
  2. S

    wrong value for Pages

    Someone posted this question before, but there was no response. I have a field in the Page Header section with the following control source: =Page " & [Page] & " of " & [Pages] The report is 7 pages long, but the field shows "Page 1 of 6", "Page 2 of 6", etc. with the last page showing "Page 7...
  3. S

    Where is the custom menubar?

    Thanks! I hadn't looked in the Add-In section.
  4. S

    Where is the custom menubar?

    In a database I inherited, the main form has a custom menubar associated with it. (In the dropdown for that property I can see that there are three available custom menubars.) I'd like to change the menubar, but I can't find it anywhere. It's not obvious how to access it. Am using Access 2007...
  5. S

    form opens at very tiny size

    I'm not using Vista, but I did find a work-around problem with some resizing code. First of all, I found that the Auto Resize property has something to do with this. I changed it from No to Yes, and the behavior changed somewhat. With Auto Resize set to yes, the width of Form2 was correct, but...
  6. S

    form opens at very tiny size

    This is a problem I have in several applications. From button on a form, I open another form, like this: DoCmd.OpenForm "Form2", , , , , acDialog Form2 presents a list of records. The user selects a record then clicks an OK button. The logic on the OK button gets the selected record's ID and...
  7. S

    Adding items to a combobox

    Thanks! I needed to do this via code rather than setting the Row Source property, but your demo led me in the right direction.
  8. S

    Adding items to a combobox

    In an open event I'm using the additem method to populate a combobox. The items I'm adding are names that are formatted lastname & ", " & firstname. The embedded comma is causing two items in the list for each name, so my list ends up twice the length it's supposed to be. Does anyone know a...
  9. S

    Setting focus on a subform control

    On my main form I have a combobox with logic in the afterupdate event to add a record to a table. That table is the source for a subform. Here's what I'm doing in the afterupdate event: 1. Append a record to TableA. 2. Requery the subform (which is a list of TableA). 3. Set focus to a specific...
  10. S

    Altering linked tables

    I’ve developed an Access 2003 app with linked tables. It’s been deployed with Access RunTime. One of the linked tables is a “Version” table containing a version number for the data. In the program, there’s a global variable containing a version number for the program structure. At startup, the...
  11. S

    Counting lines of text

    I'd like to be able to programmatically determine the number of lines of text that will fit in an output print area, given the width (in centimeters) of the area and the font used. The routine would be called like this: lines = CountLines(someString, outputWidth, outputFontName, outputFontSize)...
Back
Top Bottom