Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: maxhugen
  • Content: Threads
  • Order by date
  1. maxhugen

    VBA FileDialog - InitialDir Missing

    In earlier versions of Access, I used the Windows Common Dialog dll (comdlg32.dll) to open the File Dialog. One of the settings I found very useful was the InitialDir property, so that the Dialog would open in a specified folder. This does not appear to be available in the VBA FileDialog...
  2. maxhugen

    Create Chart in Form/Report Using VBA

    Can anyone point me towards a VBA example on how to create a Chart object (MS Graph) in a form or report from scratch please? I need to do something like add two series, one with a trendline, etc, and have control over all the formatting options etc. One problem that I've struck is that I...
  3. maxhugen

    New Record, Default Values Disappear

    In A2007, I'm opening a form with the parameter acFormAdd, so users can immediately start entering a new record. A number of fields have default values. When the form opens, it displays those defaults. However, as soon as I start entering data in any other field, all the defaults disappear...
  4. maxhugen

    Change Office Button Icon

    Has anyone found a way to change the icon displayed in the Office Button in A2007? Having converted an A2003 app to 2007, it's very annoying that my app is now displayed as an MS Office app instead! Max Hugen Australia
  5. maxhugen

    Iterate Through Report Sections

    Does anyone know of a way to iterate through the sections of a report? Oddly, each section is NOT part of a collection, but is stored in the array "me.section" However, I tried to loop through this array, using UBound(me.section()), but that doesn't work either. I've even resorted to trying an...
  6. maxhugen

    Multiple Relationship Windows

    I've been using Stephan Leban's "Save/Restore the Relationships View Window". This has been very useful when I've had to rebuild a front end, as the layout of the View is lost when this is done. However, with a lot of tables, I'd really like to have different views, eg the tables involved in a...
  7. maxhugen

    Dir() and \\machine_name = Error 52

    I'm trying to do ... s = Dir("\\machine_name\myFolder\") ... but I'm getting err 52. Does anyone know if Access supports running Dir() on a path other than a mapped drive? Or am I trying this the wrong way? MTIA Max Hugen Australia
  8. maxhugen

    Print from Preview Without Print Dialog

    Does anyone know of a way to print a report that has been opened in Preview mode - but Hidden - using VBA? I'm using a function to output a report to a pdf file, in the process specifying the report name and the path it's to be saved to. However, I need to get the report's caption, as it is...
  9. maxhugen

    Get Printers via PrtDevNames

    Does anyone know how to get a list of the Printers and drivers etc, using PrtDevNames? I'm using types: Type str_DEVNAMES RGB As String * 4 End Type Type type_DEVNAMES intDriverOffset As Integer intDeviceOffset As Integer intOutputOffset As Integer intDefault As Integer End...
  10. maxhugen

    Close Properties Window via VBA

    Does anyone know of a method to close the Form/Report Properties window using VBA? MTIA Max Hugen Australia
  11. maxhugen

    Tagging Records in a Continuous Form

    In a continuous subform, I display records based on a DISTINCT query. Because it's distinct, each row does not include a record ID. Does anyone know of a way to add a checkbox (or similar), so that a user can select any of the records, which will then be used to create new records via code? I...
  12. maxhugen

    Subform GoToNewRecord Issue

    In an unbound form 'horse', I have 2 subforms, horse_list and horse_detail. The recordsource for horse_detail is: SELECT horse.* FROM horse WHERE horse_id=[Forms]![horse]![horse_list].[Form]![horse_id] Or horse_id Is NullThis is supposed to allow the subform to show the selected record from...
  13. maxhugen

    Manually Create Continuous Form

    I'd like to create a continuous subform, consisting of unique unbound controls, in order to present the user a screen that resembles a spreadsheet for data entry. Background: There is a contracts table called `sov`. Each contract has many items in `sov_item`. We need an invoice screen, to...
  14. maxhugen

    Go To New Record in Subform

    A button on a main form "invoice" is "Add Record". I'd like to move to a new record in a subform "invoice_item", but without necessarily setting focus to that subform, so I can't use: DoCmd.GoToRecord acDataForm, "invoice_item", acNewRec Any thoughts please? MTIA Max Hugen Australia
  15. maxhugen

    Access 2003: Not enough Memory Errors

    0 vote down star I'm using Access 2003 on a duo-core machine with 4GB of RAM, running Windows XP (Service Pack 3) [5.1.2600] Periodically, I get an error msg "There isn't enough memory to perform this operation. Close unneeded programs and try the operation again." A check of Task Manager...
  16. maxhugen

    Excel Doesn't Quit in MS Access VBA

    I'm running VBA code in MS Access to populate cells in an Excel spreadsheet. It works AOK, except that the Quit method doesn't work: Windows Task Manager shows an instance of Excel still running under Processes (although not under Applications). I start Excel with: Set appExcel =...
  17. maxhugen

    Set Number of Pages by Group

    In a grouped report, I would like to reset BOTH [Page] and [Pages] for each group. For example: Group A Page 1 of 6 ... Page 6 of 6 Group B Page 1 of 4 ... Page 4 of 4 Resetting [Page] is no problem, but as [Pages] is read-only, I'm wondering if anyone has a workaround that can be used to...
  18. maxhugen

    ICO or GIF Images for Buttons

    In A2003, instead of using my custom bmp images for buttons, I'd like to use either a gif or an icon file, so that it has a transparent background - required because the mdb is set to use Windows Themed Controls. In the Picture property of a command button, Browse gives options to select bmp or...
  19. maxhugen

    Output Extra Rows from Query

    I have a table `review` with column `rating` that holds a value of 1 to 5. I need to show the number of votes for each rating. I tried: SELECT rating , count(review_id) as rating_count FROM review GROUP BY rating ORDER BY rating DESC; The problem is I need to return a zero for any...
  20. maxhugen

    Get <Select> Display Value

    I have a SELECT, where the Value is `category_id`, and the `category_name` is displayed. Can anyone pls suggest how I can get the 'display' value for the selected option, ie the `category_name`, in javascript? MTIA! Max Hugen Australia

Part and Inventory Search

Back
Top