Recent content by apbamike

I have an excel spreadsheet that contains several check boxes. Everything was fine until we applied SP3 for Office XP. Now when if the sheet is printed or print previewed the boxes on the form shift to the far left. The same condition happens on several machines and user codes using Windows...

Outlook XP blocks certain attachment extensions, this link provides a work around http://www.slovaktech.com/attachmentoptions.htm

Does Excel have an field euqivalent to SaveDate in Word?

If IsMissing(parm_name) then....

Yes you can execute a stored procedure! Create a SQL Pass-Through Query and enter EXECUTE (stored procedure name) Run it just as any other query

Try the following link. We use it with Outlook XP and Windows 2000. [http://www.slovaktech.com/attachmentoptions.htm]

How are the fields in the SQL table defined. Are null perimitted in the fields that you know are null in the update?

Go into design table and add a field named something appropriate like current_month_record, set the type as yes/no, type Yes into the default value under the general table. Now any new records will have a value of "yes" or true in the field current_month_record. Existing records will...

How about adding a boolean that indicates a new record. You could make the default true. Then after every month's run of the reports, set the boolean on all records to false. Just select only true in your query/report.

the only other thing I can guess, is an uninstall of Outlook Express and then again install Outlook 5.5 (IE 5.5) good luck

I had this happen on one '98 machine and only solved it by upgrading from IE 5.0 to IE 5.5 and included Outlook Express as part of it.

What is the OS on the computer you are trying to install on? SQL 2000 Enterpirse requires NT 4.0 Enterprise.

You can create command buttons with images. First you need to create an image linked to your bmp, etc. Next create a label with the back style property set to transparent. Then enter your text and write your appropriate event code. Size the label to be the same as the image and move it over...

View the "picture" property of the form. You can type the path of your image or wallpaper there. Stretch mode works the best for the entire screen.

Nulls can be avoided by putting "Is Not Null" under the Validation Rule making the field Required "Yes". Nulls tend to cause quite a bit of logic errors, I would bypass them whenever possible.