Search Result

Hi,

I have 11 tables each with a large data set. I then have have one query for each of the 11 tables (11 queries) that pulls the person ID and the data effective date for each line in the respective tables, using a <= prompt criteria.

This results in a reduced data set showing all of the records that started on or before the prompt date. For each of these 11 queries I then created a new query that pulls the maximum...

I have developed an MS Access Application that has many users on different versions of Office. It has custom menus that are built via vba code every time it is started. The menus and their contents vary based on the user permissions, which profiles they are using, which backends are currently attached etc. I do my development using MS Access 2000, so that I can be compatible back to that version. The distributed version is an mde. This application,...

I have a distance formula that works in excel but does not work on msaccess because some of the functions are not available like ACOS.

dist= Acos(Sin(lat1)* Sin(lat2)+Cos(l at1)*Cos(lat2)* Cos(long2-long1))*6371

What formula can i use to replace this and make it work on ms access?

In my small application (msAccess VBA), I don't want to criate group users, but would like to protect the tables, so nobody else can see them or even import the information.
Is it possible?

Best Regards
Ricardo

Was wondering to know if could somebody tell me how to get the mac address of the computer that has started up the msAccess.

Also, If I'm using the msAccess in a central virtual machine using Windows server 2003, I'd like to have the mac address of the physical machine that is using the msAccess instead of the machine that is serving the Access.
Not sure if was clear enough.
Thank you.

I have created an msACCESS database with a report and subqueries. As I am developing it I am able to print to a printer.

I have now copied the database and the new database does not print -- Says printer not found -- and the original database no longer prints.

I have been able to duplicate this 5 times so far.

How can i fix this ?

Hallo,

I have a table Routes that contains a route name and when the route runs. I would like to calculate the difference between the last run Day and the one after it. This will populate in the RunDateDiff field.

My table: Tbl_Route

RouteName RunDate Stop RunDateDiff
A 12/1/2009 Clinton
A 12/3/2009 Townsent
A 12/3/2009...

Hello,

I'm using Access 2002 to create a text box that will contain the following information in this format:

Name
Title
Company
City, State
email

I entered the following expression in a text box:

=[FULL_NAME] & Chr(10) & Chr(13) & [TITLE] & Chr(10) & Chr(13) & [COMPANY] & Chr(10) & Chr(13) & [CITY_STATE] & Chr(10) &...

the character map that comes with windows only gives keystrokes in unicode
and not ansi (i.e. alt+####) what gives. How can I use those codes to insert
special characters. Also, why cant I copy an paste all of the characters
from the character map. I tried several selections from the windings set and
a different character appears....