Search results for query: *

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

When SQL is installed, some services are installed with it. The two main ones, MSSQLServer, and SQLServerAgent need to be logged in as a user account in some cases such as using SQLMail or backing up a database to a directory that requires permissions. For most installs of SQL Server, the local...

Do you have offline synchronization or something like that setup on these drives? That's the only thing I can think of. In IE, go to tools, synchronize. Check if the network drives are synching to the local machine. I could give you vbscript to unmap the drive, but it'll do the same as the...

esoft is a Windows app that creates a bunch of html pages for you to view in a browser. I have the software setup on a schedule to update the html files. I view all of the results in html. It sounds like you need more flexibility though. As an alternative, check out SQL Reporting services. I...

If you're looking for the most compatible authentication, check out forms based authentication and get an SSL certificate. It's secure and compatible with all browsers and most firewalls, proxy servers. Basic authentication is clear text, not encrypted. I wouldn't recommend this. In the...

On any PC with IIS installed on it, including Windows XP, Open admin tools in the control panel. You will see Internet Information Services, open it. Click action in the toolbar and choose connect. Type in the name of the hosted web server like www.mysite.com. Sometimes this works, other times...