Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by rdandrade

  1. rdandrade

    Distributing an Access Database

    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...
  2. rdandrade

    Checking the credentials of users using windows (logonuser)

    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...
  3. rdandrade

    Summary Record

    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...
  4. rdandrade

    Summary Record

    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...
  5. rdandrade

    Email Validation , MX Lookup and Dummy Send

    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 =...
  6. rdandrade

    Email Validation , MX Lookup and Dummy Send

    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...
  7. rdandrade

    Using Access 2000 projects in 2007

    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...
  8. rdandrade

    Email Validation , MX Lookup and Dummy Send

    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...
  9. rdandrade

    Wildcard in file Import

    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
  10. rdandrade

    Wildcard in file Import

    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
  11. rdandrade

    What is the 'Local System Account'

    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
  12. rdandrade

    Open Print window

    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...
  13. rdandrade

    Wildcard in file Import

    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...
  14. rdandrade

    INSERT INTO Statement

    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
  15. rdandrade

    INSERT INTO Statement

    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...
See more

Part and Inventory Search

Back
Top