Recent content by EnidtheDog

Try this: You will need a module with the following code: Function IsReportLoaded(strName As String) IsReportLoaded = (SysCmd(SYSCMD_GETOBJECTSTATE, A_REPORT, strName) > 0) End Function Then add this code to your Print Preview button on the popup form: Forms![frmPopup].Visible = False...

Hi all, We are running an access 97 db (split) over an NT network. The data mdb and system.mdw are held on a network drive and the application is installed on each client. This has worked fine for years, but recently I have noticed the mdw file bloating - it is now 4mb. It is easy enough to...

Laos - Luterguy explained in the first post that he has already written code to prevent use of page up and page down. I think its a safe assumption that this is a single record form :) Your point is still valid - I was just trying to explain that if you need only one record - then call only one...

Folks - I think you are coming at this the wrong way. The issue is not how to control what the user does, but how to control how the records work. If you have a form which will only look at a single record, then pre-define that record in the form's underlying query before it is opened. This...

Hi Dan, This may be more than astehtics as you are using unnecessary resources populating your search with unneeded records. There is an alternative... I have the search results returned in a listbox. Initially the listbox is unbound - it has no Row Source. The RowSource is set by an after...

Hi all, A very quick question.... Is it better to link a subform using the Link Master Field / Link Child Field properties in the parent form or by filtering the records in the subform's record source query eg "Select JobId, JobName, RaisedBy from tblJob Where RaisedBy=...

Hi all, I have a split database running on about 8 clients. The db was developed in A97 and ran on an NT server beautifully for some years. The client recently "upgraded" to a win2k server, mainly win2k clients but with 2 W98SE clients. They also decided to upgrade to Office 2000...

Yes on both counts Phil. First, which version of Sage? I do most of my stuff with Line 50... You can read Sage records in Access using ODBC. You can then export Access data to a csv file and import into Sage. Or, even better, use the SDO (which comes with V8 of Line 50). The SDO allows you...

Thanks for the prompt reply Steve. The server will host a half dozen external internet domains and will use AD. We won't be using it for intranet / print services but we hope to keep a small library of data on the site to be accessed via web page or public folders. I guess my main questions...

Hi all, We are a SME with about 30 users and have a single web server runing Windows 2000 Server as follows: Intel PIII 866 256mb PC133 Ram 2x 15 Gig IDE Harddrive 7200rpm 52 Speed CD 1.44mb Floppy Drive 2 "u" SSI Server Case D-Link 530TX NetCard Tyan Tomcat Motherboard We are...

Hi all We have an Windows 2000 server running Exchange 2000. Users accessing OWA using Win 98 clielts have no problems. But, if a user attempts to access OWA using a Win 2K Client they get asked for their password 4 times and finally get a 404 error. If they click on the refresh url in the...

Oops. I have "accidently" Denied all permissions for "Everyone" for the default (MAPI) Public Folder. There really was quite a good reason for this! But now the Public Folder Store will not mount (since no-one has permission). Worst of all the default Public folder has...

I am NOT a Novell expert, but I know its worth setting the network locks to the maximum allowed number. The default is much too small.

I would suggest upgrading to A97 at least. There's a great site www.ASP101.com with heaps of stuff on how to do this (but I would steer clear of the built in Publish to the Web Wizards!)

You could probably use an Input mask and Validation, but I prefer to use the Before Update event 'cos it gives more control...eg: If Not Right(Me![Text1], 5) = "I" Then MsgBox "Put the right information in you dozy $%^&!" DoCmd.CancelEvent End If