Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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