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 04:23 PM
by Gina Whipp Go to last post
1 99
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 02:04 PM
by Ken Snell Go to last post
6 197
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 07:31 AM
by Duane Hookom Go to last post
1 164
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 03: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 04:57 PM
by Gina Whipp Go to last post
3 135
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 04: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 04:22 PM
by Fred Go to last post
6 362
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 08:36 PM
by Steve[_77_] Go to last post
3 70
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 08: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 07:04 PM
by KARL DEWEY Go to last post
0 75
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 06:22 PM
by Fred Go to last post
4 126
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 6th, 2010 11:38 PM
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 09: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 05: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 05:22 AM
by theDBguy[_2_] Go to last post
5 147
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 01: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 07: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 03:05 PM
by Jeff Boyce Go to last post
6 380
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 08: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)
December 31st, 2009 11:46 PM
by Armen Stein[_2_] Go to last post
14 278
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 07:30 PM.


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