Recent content by rdandrade

The Access Runtime edition is a free download that allows you to fully use the database as an end user. It does not allow design mode changes which it sounds like you'll be doing. So you need a full version of access, and all of your users use the free Access Runtime. You can get that from...

If there person was able to logon to windows, they already proved that they are who they are. When they open access, you can see the username and see what groups they are in. Asking again is redundant. It would be like Outlook asking for a password again after you've just logged into windows...

Try using a derived table like below. Should still work fast. SELECT EmpActive.EmpNum, EmpActive.Status, EmpActive.ssno, SUM(EmpAll.current) AS current, Sum(EmpAll.MTD) AS MTD, SUM(EmpAll.QTD) AS QTD, SUM(EmpAll.YTD) AS YTD FROM Employee EmpAll INNER JOIN (SELECT EmpNum...

Use Group By to summarize, and add up all of the numeric fields. Use ISNULL in case any of the numerics are NULL, it doesn't skew the results. Something like this. SELECT SSN, SUM(ISNULL(field1, 0) + ISNULL(field2, 0) + ISNULL(field3, 0)) AS Total FROM Employees GROUP BY SSN I don't know what...

A little code below to open a web browser, and navigate to a page. sPageContents is a string variable containing what the web server returned. Is this what you are looking for? Ray D'Andrade Bright Network - Custom Software Development Dim oWeb As Object Set oWeb =...

http://www.dart.com/ctl_dns.aspx That is a link to an ActiveX DNS control you can buy. If you're looking for free code, I don't see any out there. Dart also has a mail control. Here is one for cheaper. http://www.evansprogramming.com/emailexpert.asp Learning VB.net may be easier than trying...

I use Access 2007 for all of my developing and have a lot of clients using Access 2000, XP, and 2003. I have never had problems. The database format should be 2000. You can edit ADP file databases in the Acces 2000 format. If you are making ADE file before deploying, you'll need an Access 2000...

I have used a VB.net app to send out emails from Access. I setup the project as a COM Visible VB.net dll library. You can then use regasm /tlb /codebase mydllfile.dll to register it. You can then see it in Access, and call it to do this for you. It was so much easier to do this kind of action...

Good...glad it worked. I had a crazy day today and I wasn't paying attention to this site to get back to you earlier. Ray D'Andrade http://www.raydandrade.com

I just tested it out and that should work for you using the wildcard. You don't have to know the exact file name. This code will give it to you using the wildcard mask, one at a time in the loop. Ray D'Andrade http://www.raydandrade.com

It's NOT the Administrator account and it isn't listed in active directory. It is a hidden built in account. When you do things like give NTFS permissions, you can add System to the list. Ray D'Andrade http://www.raydandrade.com

How about this...in the form you are calling the report from do this: (untested, but should work) sub OpenTheReport() dim ReportName as string ReportName = "MyReport" Docmd.OpenReport ReportName, acViewPreview ' Wait until report is opened do until (SysCmd(acSysCmdGetObjectState, acReport...

use a do loop for each file. Do them one at a time. That's the only way. I haven't tested this, but it should go something like this: dim strTmp as string dim strDirectory as string strDirectory = "C:\MyDirectory\NU051108*.dat" strTmp = Dir(strDirectory) do Until strTmp="" [your code...

In the subform properties, general tab, Special Effect should be flat and Border Style should be transparent. That should be all you need to blend the two forms to look like they are one. Ray D'Andrade http://www.raydandrade.com

The easiest thing to do is to create a subform based on the 2nd table. You can remove the border and the sunken look and it will look like one big form instead of a main form and subform. This will be a lot easier. That's a lot of code to replicate something that is built into Access forms...