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 derfloh 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: *

  1. lldevel

    Create a shortcut on the desktop to Access (runtime)?

    Kaiana, Try this format: "C:\Program Files\Access 97 Runtime\Msaccess.exe" /excl /runtime "C:\Program Files\Sample\test_db.mdb" LLDevel
  2. lldevel

    How to create scheduled Livelink export?

    Hello, We need to create a scheduled task (daily, weekly, monthly) to search for certain documents in our Livelink 9.x system, and export them to a file system for interface to separate application. We want administration of this task from the Livelink Admin pages. I have two questions: 1. Is...
  3. lldevel

    Multi-Column Report

    cOhOnes, I did what you suggested, combined with a bit of Detail section VBA coding to get it to work. Works great. Thanks for the tip! LLDevel
  4. lldevel

    invalid field name or expresstion

    If the above doesn't resolve your problem, the following MSKB article helped me with a similar issue in Access Reports. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q209778 LLDevel
  5. lldevel

    Multi-Column Report

    Hello, I am trying to create a report that shows 3 columns, in landscape format. The first two columns need to show data (different record each), and the third column needs to be a fixed set of labels. So it is basically 3 columns 3" each, with the first two being data, the last being a...
  6. lldevel

    Switchboard Set Focus

    Hello, I am trying to create my "Main Menu", or switchboard, that sits in the background of Access, and never lets anything go behind it, even if you click on the detail area of the switchboard. Essentially, I am trying to make it behave like a desktop, so users can click on links to...
  7. lldevel

    Calendar Report, How To Create?

    thank you, I did not find that thread when I searched.
  8. lldevel

    Calendar Report, How To Create?

    Hello All, I need to create a report that looks like a calendar, with all of the days and weeks, except shows data on the appropriate days, such as an event. Does anyone have any examples of doing this? I have a query to determine day, week, cell, etc., but am unfamiliar with the reporting...
  9. lldevel

    Monthview Value Problem

    Hi Rgbean, Thanks for the tip. What I also found is that you can only set that value (for the MonthView OCX control anyway) on a Form's Load event. It wasn't working on the Open, or Activate events. Anyway, it's working great now - thanks. LLDevel
  10. lldevel

    Monthview Value Problem

    Hello, I am having a problem setting the default value for a monthview control. I want to set the default date so when the use clicks on the monthview button to pick a date, it defaults to a date in another control, but I get an active x error when setting the .value property of the MonthView...
  11. lldevel

    ODBC Connect Properties/Remote Table Mods

    Hi All, I have a front end MSA97 db, that links to a backend data database, also MSA97. When a I deploy a new version of my front end db, I need to do some upgrading to older versions of existing back end db's, specifically, I am changing the autonumber field of a primary key field on one of...
  12. lldevel

    Order by doesn't work

    Smarty, Ensure that your OrderByOn property has been set to True on the form, otherwise your sort will not take effect, even if the string has been populated. Also, in some instances, I've had to use the tablename.field name ASC format to effect an orderby clause. I generally call a routine...
  13. lldevel

    How do you reset Startup properties???

    IssyMarie, I encountered a similar problem setting the application's title and icon. There is a method "RefreshTitleBar" that I used to update the startup Application Name & Application Icon properties, and have them take effect immediately, instead of waiting for the next time the...
  14. lldevel

    Converting Recordsetclone property to RecordSource

    This went unanswered for several days, and I suspected it may be in the wrong forum. LLdevel
  15. lldevel

    How to convert MSAccess Form RecordsetClone to report recordsource?

    Lozere, Thanks for the tip, worked great. My form is in memory only (dynamic form), so I took your example, and used variables to pass in the 3 necessary parameters and had report on_open behave accordingly. I had to have the report also toggle the Reports OrderByOn & FilterOn properties based...
  16. lldevel

    Converting Recordsetclone property to RecordSource

    Hi, Doe anyone know how to convert a datasheet's recordsetclone into a recordsource usable string? I want to allow the user to filter, sort, etc. the datasheet using the built in menus, then invoke a report based on that filtered recordset. The only way I know of is to set the report's...
  17. lldevel

    How to convert MSAccess Form RecordsetClone to report recordsource?

    I need to take the current recordset of a datasheet form (after user has filtered, sorted, etc.) and run a report from the form's recordset. After filters/sorts are applied, the only property that I believe contains the filtered/sorted recordset is derived from the recordsetclone method...

Part and Inventory Search

Back
Top