A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Database Design Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
FORM OPEN only show the header by George McNichol
While working on a form design, all of a sudden if I use FORM OPEN I only see the header. FORM DESIGN shows the entire form. How do I fix this?
January 9th, 2010 05:23 PM
by Gina Whipp Go to last post
1 100
Need help with calculation if field is null by Barry A&P[_2_]
I am trying to populate a text box on a bound subdatasheet with the most appropriate value for the user to see.. Based on wether the component has a value...
January 9th, 2010 03:04 PM
by Ken Snell Go to last post
6 198
Allow Multiple Values check box not showing up by mschurter
I am trying to create a Multivalued Lookup Field. I am using the Lookup Wizard, but when I get to the place where is should let me choose to store multiple...
January 9th, 2010 08:31 AM
by Duane Hookom Go to last post
1 165
setvalue macro by MTSmith
I have a client record that when I push the events button I want a Events Form to open up and automatically set the ClientID# so they can start entering...
January 9th, 2010 04:19 AM
by Barry A&P[_2_] Go to last post
5 138
Updating two identical formatted tables with one form by Cynw
At present I have a membership database with all members held in one table. I have been asked to split this table into two tables - family and individual...
January 8th, 2010 05:57 PM
by Gina Whipp Go to last post
3 138
Lookup fields referring to tbls w/o relationship by Pamela
I created a db and in reading now about db structure, I've seen a lot of mention of relationships. My db started out very simple with the tables that I used...
January 8th, 2010 05:52 PM
by Jeff Boyce Go to last post
5 111
AutoNumber vs. Natural Primary Keys by Tokyo Alex
Dear all, As a relative newbie to the art/science of database design, I was wondering if there was any consensus view on whether it's better to use an...
January 8th, 2010 05:22 PM
by Fred Go to last post
6 371
Need Help with Totaling by CRBI
I'm not even sure how to explain this. I have a membership database in which I've created a form for the member's basic data-name, address, phone, etc....
January 7th, 2010 09:36 PM
by Steve[_77_] Go to last post
3 71
Blendcode table and multiple plants by Robbro
Toying with getting a cost system out of spreadsheets and into access. Most the tables are simple and easy to set up, but I'm debating our material blends...
January 7th, 2010 09:34 PM
by Fred Go to last post
1 102
counting yes in yes/no data types by KARL DEWEY
Do not us Count but Sum like this -- =Abs(Sum()) =Abs(Sum()) A 'Yes' is stored as a -1 (minus one) and the Abs function removes the negative sign. ...
January 7th, 2010 08:04 PM
by KARL DEWEY Go to last post
0 76
Design theory for maintaining historical address communications by icccapital
I was curious to get some ideas for the best way to maintain the address of mailers that had been sent out. So by way of example we send out mailers or...
January 7th, 2010 07:22 PM
by Fred Go to last post
4 127
making a row height automatically adjust to cell contents by John
In a form that I'm developing I have 4 columns and 5 rows. I would like for the row height of all rows to automatically adjust to accommodate the text entry...
January 7th, 2010 12:38 AM
by fredg Go to last post
2 85
How do I break a link to an external database but keep table data? by darkskwirl
I am trying to break the link to an external database while keeping all the data in the tables housed locally. It is possible I will loose access to the...
January 6th, 2010 10:40 PM
by KARL DEWEY Go to last post
1 92
Look up boxes by Chris
I have created a look up table and the fields are SuburbID (primary key) Suburb, State, District, Map Ref. Then I have created a form that allows me to put...
January 6th, 2010 06:24 AM
by John W. Vinson Go to last post
2 102
Data Validation Rule in Table Design by Steve Stad
Can you tell me how to write a data validation rule I can use in the table design mode for a phone number field that will not allow blanks (eg Not null) and...
January 6th, 2010 06:22 AM
by theDBguy[_2_] Go to last post
5 148
help designing query to get results by JoAnn
In my database of employees I have three date/time fields - Agency Start date, Rehire date (a lot of our employees only work part of the year) and Separation...
January 6th, 2010 02:53 AM
by JoAnn Go to last post
5 136
Show all from tables in my junction... by Maarkr
I've had this situation designing two different dbs recently and wanted to see if there was a better way to do it. This db has a Roster table with names and...
January 4th, 2010 08:00 PM
by Fred Go to last post
1 119
New Attachment field and Linked Table by LRidlen
I have just converted an exsiting database to Access 2007 format. It is split, front end and back end. I have created a new field in a tables database as...
January 4th, 2010 04:05 PM
by Jeff Boyce Go to last post
6 381
Set up my table by Revned
Hi, It's nice to be back here!! I am planning to make a database for Engineering Documentation I have the following fields tblDocumentList Document No ...
January 3rd, 2010 09:39 AM
by Revned Go to last post
4 132
How do I save the date a record was last modified in Access 2003 by Anne
How do I save the date a record was last modified in Access 2003? I know a little about Access databases, and need help with a database I designed. Any...
(Multi-page thread 1 2)
January 1st, 2010 12:46 AM
by Armen Stein[_2_] Go to last post
14 280
Post New Thread


Display Options
Showing threads 421 to 440 of 11610
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.