Search results for query: *

You may have a column in the Excel spreadsheet that has a blank value in the first row. Or you may have changed the column headers (field names). You will need to go into the macro Import command and reset it if the second suggestion is what is wrong. Sue Sloan

The problem is the printer driver, which is telling Approach that your default page is very small. Approach is trying to fit all the fields into that small page. You need to do design work with a printer that has regular letter or A4 page size as the default. Then when not doing design, use Team...

This is correct most of the time: age = Trunc((Today() - DOB)/365.25) When you subtract one date from another, the result is the number of days between the two. You can then divide by the number of days in an average year (leap years are 1 day longer). Sue Sloan

Unless there are duplicate "key" fields in the two, the simplest way is to open one of them and use File, Import Data to bring the other file's data into the current one. Sue Sloan

You can use the OPEN command in a macro to do this. Instead of putting a file name in the command, you can put "mailto: etc... " in the space. You can insert an email address from a field by putting the field name into the command like this: <<mydbf.email>> Sue Sloan

Condition your modification formula on a non-empty value in the other date field and in the "end date" field. Something like this: If(IsBlank("other field name",'',If(IsBlank("end date",Today(),"end date")) This will fill in today's date if the other field is filled in and the "end date" is...

Sometimes when you want to delete a corrupt view, it helps to go into design on a different view. Then under the View menu, uncheck "Show data". Then try switching to the bad view to delete it. Sue Sloan

Some things to check: 1) Printer driver. You must have a default printer set up on a system for Approach to work properly. If you have one, reinstall or update the driver for it. 2) You can copy the file apprchtx.dll from a computer that works correctly to the one where it fails. It is...

The latest version is 9.8.5 and I expect 9.8.6 to be announced in the next 60 days or so. The only source for this release is IBM since they do not make CDs for this release any more. But you may be satisfied with 9.8.1 which can be found at various discount software web sites on CD. Sue Sloan

This is not an "Access" discussion, but rather one for "Lotus Approach". Posting in the proper discussion will likely get you an answer. Sue Sloan

This is a "Lotus Approach" section, not "Notes". Sue Sloan

What version of Approach are you using? There was a fix for Approach 97, I think. If that is your version I can provide a link to the patch file. Sue Sloan

I would need to know the value of "On Scene" and "Received" and whether they are text or time values??? Sue Sloan

You can use a script to refresh the screen in that applicaton. The Sleep function lets you tell the script to pause a number of seconds. Then you can use SendKeys to send Ctrl+R to the screen. Loop the script. The only problem is that you will need to cancel the script using the Windows task...

The Microsoft mouse wheel has never worked in Approach as far as I know. But you can install a program named Flywheel and that will let you scroll vertically in Approach. www.freedownloadscenter.com/Best/flywheel-scroll.html Sue Sloan

There is a full explanation in the discussion area on XpertSS.com. It is much too much to retype here! Here is a link: http://www.xpertss.com/cgi-bin/WebX?50@@.ee8a45d/5 You will need to log in or register to get to this information on that site. I do hope the owners of this site do not get...

Use the Combine() function either as a modification formula on the third field, or define the combination field as a calculated-type field with formula. Something like: newfield = Combine(Cell1fieldname,' ',Cell2fieldname) Sue Sloan

There is a method demonstrated in a Free Downloads over on XpertSS.com -- Do a search for "picture" in the downloads database or for "apr-pic". Basically a script is used to display the content of an image file on a form view ( not in another program and not in a pictureplus field) and update...

You can look at some possibilities: 1) See if there is an update for your printer driver and install it. This has resolved spooling errors for some of my clients. 2) Try deleting the Print command from the macro and add it back. This will pull in the current default printer's properties, which...

One possibility is that you have your database on a CD, which by definition is "read only". Or that the folder the database files are in is marked "read only". Another possibility is that your database index is corrupt and "thinks" a password is required. You can test this option by opening the...