Experts Exchange - Top Solutions

August 30, 2008 02:17am pdt

1. LSMCons... 134,175
2. boag2000 133,590
3. capricorn1 113,175
4. DatabaseMX 76,689
5. peter57r 70,551
6. harfang 41,526
7. jimhorn 38,854
8. matthews... 34,872
9. hnasr 18,075
10. GRayL 16,347
11. MikeToole 15,650
12. LennyGray 14,955
13. RgGray3 14,896
14. jefftwilley 14,700
15. frankytee 14,550
16. JDettman 13,352
17. clarkscott 12,710
18. wiswalld 11,200
19. kelvinsparks 10,760
20. Arthur_... 10,550
21. nexusnation 10,400
22. eghtebas 10,000
23. omgang 9,375
24. jmoss111 9,150
25. koutny 8,675

1. LSMCons... 199,290
2. capricorn1 156,183
3. DatabaseMX 152,047
4. boag2000 141,565
5. peter57r 113,005
6. matthews... 63,206
7. jimhorn 62,872
8. harfang 60,506
9. jefftwilley 60,468
10. GRayL 36,779
11. JDettman 33,627
12. frankytee 31,442
13. MikeToole 29,650
14. dqmq 22,560
15. stevbe 21,852
16. kelvinsparks 20,260
17. mbizup 20,200
18. rockiroads 19,250
19. hnasr 18,075
20. puppydog... 17,545
21. LPurvis 16,625
22. LennyGray 14,955
23. RgGray3 14,896
24. Arthur_... 14,650
25. jmoss111 13,750
25. adraughn 13,750

250 organizations, including eBay, Ericsson and Lockheed Martin, now work smarter with Corporate Accounts. Save up to 42%

MHenry

Welcome! If you have any general questions about Experts Exchange, feel free to ask me.

Top Access Architecture/Design Solutions: 26 - 50 of 81

Hiding toolbars in Access 2007

Found part of my answer in the following answered question: http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_23333891.html?sfQueryTermInfo=1+2007+access+secur It says to o...

need someone to tell me some access fundamentals..

Hi there. I have a situation that can be described as the following: I am developing a .net 3.5 winforms application for PC that interfaces with an access database. Ideally I'd like to u...

Survey database - Access 2000

I am looking to create a survey type database. There are 7 different surveys some with the some of the same questions. At times some of the questions will change but went to keep the histo...

Show most recent at top of form?

How can I show the most recently added tasks at the top of the form?

mdw file for an mde Access database

I want to setup an mde file with user level security. I have made the mdw file for the mdb database but how do I make the mdw file for the mde database? I have used the user lever security ...

Access 2007 logging 'activation' / 'deactivation' of a record.

Access 2007 table question. Taking the form out of the equation for now... I need I need to keep track the date and time for every time any record in the attached table is activated / deac...

Help system for Access: is it worth it? Easiest way?

We have a project management tool written in Access; it is complex enough that we have a training document, with screen shots and explanatory text. It would make our lives a lot easier if ther...

Normalization - early in db design

Hello, I am fairly new at Access relationship building. I know forms and reports quite well though. I hope I dont confuse with my explanation as I dont understand proper relationships that...

How do I convert an ACCESS 2003 (.mdb) database to a ACCESS 2007 (.accdb) version?

I have a database that was created in ACCESS 2003 (working database). This database works off linked tables in another database. We recently went form ACCESS 2003 to ACCESS 2007. The linked...

Add a "timer" for starting and stoping of regular tasks until end-of-day. Access 2007

How can I add a timer for starting and stopping of regular tasks until the end of the day. Timer for any given task would start over the next day. Also mbizup zip did such a fantastic job ...

When using OpenArgs as part Open Form command do they have to displayed in order transfer data.

I have passed OpenArgs between Forms but I always displayed them in a disabled and visible txtbox. I do this to "see" all of the OperArgs transferring. Is this necessary in order to trans...

Relating two records in one table to each other

I have a table called Document containing various info on each different document (primary key is an autonum DocumentID). I want to link two documents to each other to be known as Like Docume...

Retrieve lowest value form multiple fields in Access Table

I have a Dart League Database I have inherited... My question is I have a Query, based on the PlayerStats table that is supposed to return results of the lowest PPD (Points Per Dart) in a sin...

How to create custom shortcut for Access database

I have created lots of Access databases and I want to create custom shortcut for each database. Can anyone recommend some good software or templates for cutom shortcut? Thanks

Working out relationships in tables to make an Access DB cascade update and delete accurately

I am working with Access 2000 and I don't think I have the relationships set up correctly, maybe I do. But I need these tables to Cascade Update and Delete accordingly and they aren't. Maybe...

Microsoft Access Macro over Citrix Error

Our HR Database is currently experiencing issues whilst running over Citrix. This is the application location command line in the Citrix Program Neighbourhood: "M:\Program Files\Microsoft ...

change Name of Query

How can I change the name of a query to include 'qry' at the beginning (i.e. qryName) without breaking it's dependencies? I have this crop up all the time. I find myself wanting to change ...

Tables Structure/Design

Hi, I need some help with designing my database. Tables: UserDetail, Searchable, Message UserDetail has a detail description of each user. Searchable table is used for the user to bloc...

Setup a specific date for Access 2003 Query

I would like to setup a criteria in an Access Query with a specific date range. Here's some sample data in the different fields. C1 C2 C3 C4 1/1/08 Name ...

Tie text box to *new record in table

How do I make a *new record entry into the table by entering a new Task into the center of the form? I want to do this by clicking enter and not by having to tab to an enter button if possi...

Upsizing an Access 2003 Database

I have a pretty fancy Access 2003 Database that I've created, with all those fancy forms, reports, and what have you.... then I learn about the user limitation of the Access backend. Apparent...

TABLE RELATIONSHIPS IN MS ACCESS

Hi, I am having difficulty in relating 3 tables in Access; with only 2 it is not a problem. What i am trying to do is the following: PRODUCTS.PRODUCT_ID RELATED TO ORDERS.PRO...

Query using OR Logic With Two Fields in MS Access

For a report I'm trying to generate I need to pull records based on criteria two fields. Example: A Date field for a birthday. A Date field for an anniversary. I want all birthday an...

'Name Autocorrect' object names in a split database

I have an Access 2000 database which I have been progressively been developing in our office over a number of years. The database has long been split into a frontend (forms, queries, modul...

Can and how can I have a split form open filtered and then click on record in datasheet and have single record open in a form?

Hello Experts, OK... this is a multi-tiered question. I have a database that needs to filter down to single record and I have provided a rudimentary example. The progression needs to work th...