Recent content by mfd777

If the PDF printer created on each workstation has the same default name (Adobe PDF), then one solution might be to amend the page setup on the report to use this specific printer. Therfore, no need to amend registry to set up a different printer as a default.

Thanks for your suggestion Zion7. To keep the function applicable to all forms, I need to programatically determine if a form is loading as a subform or a main form. Are you aware of a property on the form that I could read?

I am having an issue with implimenting specific security in a database. The requirement is that when a form loads, a function is called. This function runs through all the controls on the form and sets them to disabled based on information held in a user security table. The calling form passes...

Thanks for the advice guys. I was trying to avoid creating SQL Server objects such as views and Stored Procedures. Perhaps a paramaterised stored procedure is the way to go. This should negate any inefficiencies used by using ODBC rather than OLDDB?

Hi All, Can't find the answer for this one but it is probably staring me in the face! We are re-writing an application from Access 97 to Access 2003. The front end is access and the back end is SQL Server. In the '97 version we create pass-though queries as the recordsource for our forms, use...

There is a quick way but it is not Access code based. You can do a bulk extension change through DOS. The following would be the senario: 1)Go to DOS prompt. Click on start run and type cmd (for NT) or command for Win 95/98 2)Type in the following command: ren c:\mydir\*.jpeg *.bmp This...

Just a word of warning regarding compacting. Apart from the defragmentation of the database, compacting will reset any deleted autonumber values, where new records have not been subsequently created. For iunstance, some users may use a temp table to generate an autonumber, and periodically flush...

Right click on query and choose export. From the wizard that comes up you can select a fixed width file. Click on advanced and you can select options for delimiting dates and times. If you intend to export regularly click on "save as" in this advanced window to save the export...

Just a note on upsizing to SQL server. I agree that you should not need to. If you do, you export tables to SQL server and then link to these tables. If the linked tables have the same name as the native access tables, then your application code/queries etc.. should not change. This will not...

To set up SQL server link do the following: 1. Ensure tables exist in sql server 2. Open ODBC administratot (control panel, if using win2k then administrative tools section) 3. Create a new dsn type of your choice (user, system or file). Click on add. Select microsoft sql server driver...

A nice alternative was posted here some-time last year. It may not be what you need but I find it good. 1. Select all the controls that you wish to highlight 2. Set the background colour to highlight colour of your choice. 3. With the controls still selected, set the back style property to...

Following on from DonQuichotes' quote, you may be simply missing a reference in computer B. To fix this, open any module (or code in a form). Now click on tools --> references. If any are expected and are missing the work "MISSING" will prefix the offending reference. Click on this...

When I type in a command that would bring up the list box of available arguments, the list box disappears automatically. Also when you press space bar the space disappears. Anyone else come accross this before?

I have an access 2K database running in access xp. Recently, the database has decided to ignore any breakpoints I enter when trying to step through code. Has anyone seen this before?

Solved problem. Needed to prefix declaration of recordset with DAO