Recent content by DerekAOE

Glad to hear things worked out!

Looking at your code, if you get an error the function will exit without a message (and appear to do nothing). To debug, place a Msgbox line in the error handler so you can see if there is an error... Err_cmdEmailNotification_Click: msgbox "Error! " & err.number & " : " & err.description...

You don't say whether you get an error message of the fields are blank, or whether the fields are just empty. If the DLookup returns NULL you'll get an error assigning that value to a string variable. Wrap the Dlookup in an NZ to allow for this... strMyvar = nz(DLookup(....),"")

If you want to combine two queries into a single result set you might consider creating a new query that uses 'UNION'. Both queries MUST return the same columns for this to work. Note that UNION queries will not display in the graphical query desing window, you'll have to define it in SQL view...

I'm upsizing an existing Client/Server mdb app to ADP with SQL Server 2000. I understand that MDW security is not used with ADPs, though I have retained my local System.MDW file for existing user accounts for other MDBs on my PC. The problem is, when DoCmd.Transfertext is run in the ADP to...

Is there a way to force a user to enter an alternative file name when they click 'Save' on a Read-Only PDF? I want to prompt them for a file name, then automatically save the PDF using that name. The default message when trying to save to a Read only file is a bit meaningless.

I am using VB to automate conversion of Spreadsheets to HTML files using Excel 2000. Problem is, when I've created my (hidden) instance of Excel using GetObject (complicated story, but using Shell then GetObject is the only way I could load the add-ins I need) if the user opens an xls file by...

Since the relationship between Employee and Project will be Many-To-Many (Employees can have many projects as favourite, and Projects can be the favourite of many Employees). The table should have an EmployeeID field and a ProjectID field, with an arbitrary key field (say, an autonumber). When...

Hi I have also had these problems, and found that uninstalling BOTH versions of office, then installing 97 first followed by 2000 seems to work OK. I know of lots of people who had serious problems installing 97 after 2000. HTH

Either create a query which filters for the name you want, or use the Filter property of the Report by entering what would the WHERE criteria i.e. "[Name]='Bob'. You will need to set the 'FilterOn' property of the report to Yes, though.

Firstly ensure that you have referenced the Excel Object Library. In VBA window, select Tools - References, then tick Excel n.0 Object Library in the list, where n is the version number (n=9 for Excel 2K). Secondly, you need to fully qualify the objects you are referencing so that Access knows...

If you have set up a user in any Access DB on your PC, that user is saved in your system.mdw file, typically in the Win/System32 folder (though I have also known it to live in the Program Files/Common Files folder or similar). Just do a search for system.mdw. Any instance of Access you open...

You may have to apply different tests depending on the data type of the source field. I.e. for string fields apply your 'if=""' test, but for numeric fields I'm not sure that the test will detect the empty value. I would tend to use the Nz() function and apply the test after. For...

There is also a MonthName function in Acc2K which returns the full name of the month corresponding to a number (1-12)

It may be that you have to fully qualify the Isloaded function. i.e. Application.CurrentProject.AllForms("frmCity").IsLoaded then...