| Thread | Last Post | Replies |
|
| Criteria in a query to exclude one record. | 27 Apr 2005 06:09 GMT | 3 |
I have a membership database in which the email address is used as the unique field for reference purposes. I run a query that seeks to remove email addresses from a mailing list if they do not appear in the database.
|
| Next Number is... | 27 Apr 2005 05:50 GMT | 2 |
I am a beguiner, I have done a couple of things in Access not a bi deal, but now my boss wants something I have no Idea what to do, thi is the scenario - A database 12 fields.
|
| Multiple Users | 27 Apr 2005 01:43 GMT | 2 |
Can Multiple Users input Data into an Access table at the same time? I have designed a new Database, and I am trying to determine the best way to rapidly input data for new records (The information I need is currently all in paper files)
|
| Help!!!! A specific Database will not open??? | 27 Apr 2005 01:43 GMT | 2 |
Please Help even if its bad news!!!! When I open database "inventory" I automatically get a microsoft crash that wants me to send the detail report. It states: AppName: MSAccess.exe AppVer:8.0.0.4122 ModName: VBA 332.dll ModVer: 3.0.0.7019
|
| advice for form and table design | 26 Apr 2005 22:14 GMT | 2 |
I am working on transerring a database from Panorama into Access. The form deals with donations from donors for up to 5 different funds. In Pan. each donor has a donor # (Primary key). When the donor gives to more than one fund, they previously made a new record, using the ...
|
| Using Access as a background database for Word | 26 Apr 2005 22:06 GMT | 1 |
Is there a way to make a field to fill out an address field in word and have it linked to an access database. So that if you start typing it brings up the address or maybe an drop down list of addresses to pick from?
|
| toolbox greyed | 26 Apr 2005 21:33 GMT | 3 |
I can't use my toolbox because it is greyed out?? I am in the design mode of my table.
|
| Combo boxes producing error message | 26 Apr 2005 21:32 GMT | 3 |
I'm a newby in need of assistance. I'm creating a form based on a query which includes two table-based combo boxes: one from an ID#[CityID], with a city name field [CityName] and city population field [CityPopulation]; and the other from an ID#[CountyID],
|
| Adding tables in SELECT query, messes up Sum calculation | 26 Apr 2005 21:16 GMT | 5 |
I have a multi-tab subform where on one page I am summarizing data from other pages on the form. Because I am using calculated text boxes, the record source for the form is a SELECT query as follows: SELECT tblEstimateMaterials.*, tblEstimateHoursEpic.*,
|
| Query export excel: save format | 26 Apr 2005 19:42 GMT | 1 |
I have created a macro (Action: OutputTo) to export a query to excel. However, the file is always exported/saved as if the "save formatted" box is not checked when doing the export manually. How can I change that? Thanks in advance, Thore
|
| Saving a form to move to another computer? | 26 Apr 2005 16:59 GMT | 5 |
I've created a new database form in Access 97. Now I want to save that form "template" and take it over to another computer where I will actually input all the data. I have a floppy in the drive to save to.
|
| How to keep id number though each table | 26 Apr 2005 16:24 GMT | 9 |
I have my first table with an IdNumber as a field that is input. Then I have another table with questions that the IdNumber answered how do I get that same IdNumber into the 2nd table so I know what IdNumber the data goes with.
|
| prevent changes | 26 Apr 2005 15:34 GMT | 1 |
I am looking for a very simple way to prevent users from changing the data contents in a database. Basically I am the only user who edits the entries, all the others should be read-only (+executing macros in order to export queries).
|
| access.lockfile.9 | 26 Apr 2005 14:40 GMT | 1 |
I've created a database which has a front end / back end setup. It sits on a server and colleagues use it for logging calls etc. The problem is that I cannot edit the file because it claims to be locked by another user. This is borne out (I guess) by the fact that there is a ...
|
| Access97: Functions cannot return Null??? | 26 Apr 2005 10:50 GMT | 5 |
I am writing a function that returns a TableDef, and when there is no TableDef to return, I try to return Null. Problem is I get a "Object required" error when I try to assign Null to the function name.(actual error message is in Japanese, sorry if the error message is not exactly ...
|