Recent content by Capilano

Solution Found Hi... I finally located a solution on the MS website to my problem. Here is the syntax: DateSerial(Year(Date()), Month(Date()) + 1, 0) Problem solved! Pat http://www.access-programmers.co.uk/forums/images/smilies/redface.gif :o

Hi... Years ago, in MS-97, we used to be able to calculate the last day of any month using LenMonth. LenMonth(1stDayOfMonth) would give us the last day of month. Recently, I have been asked to design a new system and I have not been able to identify whether Microsoft retained this feature in...

I have briefed both DoCmd.TransferSpreadsheet and DoCmd.OutputTo. Both have their strengths and their purpose. DoCmd.OutputTo Method is great if one is transferring a single Table or Query to a spreadsheet. However, I need to export several Tables to different worksheets in the same Excel...

All of my apps are written in MS Access XP (2002). All Functions work perfectly. One of my customers purchased new computers for all his staff. All have WindowsXP (with Patch 2) and MS Office 2003 Professional (w/Access 2003). None of my functions work! I have opened up the program and...

Resizing of Chart or Graph I am still experiencing the problem, although to a lesser degree. I have found that the problem is more persistent if I have the chart expanded too far onto the page. Double-click on the actual chart. Then click on the chart background and size it considerably...

My suggestion would be to create a Command Button that opens the Report you want to print/Preview. Base the report recordset on a query that displays the records you want. Defining the parameters for this query can happen two ways. If the parameters are static, then simply have the...

Hi... Using a very straight forward SendObject acSendReport statement in an Access 2002 function, I have successfully created a Rich Text File (.rtf) ready for e-mailing. All works very smoothly. My dilemma, however, is that often times the information being e-mailed is sensitive and must be...

Hi... Yes Keith... you are correct. I searched for them after I had posted my question. The search turned up a couple of starting points but the best information I subsequently found was ... Microsoft Knowledge Base Article - 278379 Thanks for your assistance. Case closed. Pat

Hi.... Quick question. Is there a way to disable the Mouse Wheel feature when using an MS Access Database? It is frustrating when you are entering data on a specific record... accidentially move the mouse wheel... suddenly you are entering data in a completely different record. I have...

Hi... I am trying to design my first Data Access Page and I have a really simple syntax question. I need to know the proper syntax for Microsoft Script for the following: Ser = chr(34) & "LogicalCubeName=" & LogicalCubeName.value & chr(34) This script works perfectly well if LogicalCubeName...

In all of my databases, I typically have 1 Main Form with 1 Unbound Subform. I then have an Option Group w/Toggles placed on the Main Form. Based on the selected value of the Option Group the Sourceobject of the Subform is defined. I find this works really well with good performance. I am...

Recommended Reading List Yes, based on the recommendations from readers on the Amazon website, the Access Developers Handbook that you refer to is better. However, I live in a city of 3/4 of a millon people with several good book stores, yet none of them had the Developers Handbook in stock...

Recommended Reading List Thanks... Actually visited the Amazon site yesterday and I picked up a book called "Microsoft Office Access 2003... Inside Out" by John Viescas which seems to be pretty good. I have only briefed it combining this with all of the historical posts from this site, I...

I have been programming in Access since 1992, but I have never done anything with Access Data Pages/ASP/.Net etc. There are hundreds (if not thousands) of good books on MS Access available but most are very weak on creating and linking Access Data Pages to a website. Can anyone make any...

Big Hearty Thanks Thanks very much Travis... I used the sample code and the Remote Object opened perfectly. I just had to pass the file name correctly and it worked like a charm. Thanks once again Pat