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
Table / query Design by sam
Hi, I'm wanting to set this up but am unsure of the best way to go about it. All I have is basically a 'service' which will belong to particular areas...
August 13th, 2004 03:32 AM
by Duane Hookom Go to last post
7 212
100 YES/NO fields by TonyTOCA
I want to design a table to store data on labtest aquisitions, to print out labels later. It will be a list with 100 different tests, every test with its own...
August 13th, 2004 12:00 PM
by TonyTOCA Go to last post
6 136
Sum total calculation by
Hello, I would like to obtain a sum total on reports for billing codes that identify patient charges.I have various codes so i want to specify them by their...
August 13th, 2004 12:51 PM
by Jeff Boyce Go to last post
3 159
Look up wizard by L&P
We are trying to design a table that has a look up field. We want it to look up from another tables look up field, which is a list. Can we do this?
August 13th, 2004 01:34 PM
by Van T. Dinh Go to last post
2 162
Field suddenly changed to symbols now crashes db by Scott
I had a field in one record that suddenly changed into boxes and characters indicitive of encryption. Now when I change the field it immediately crashes the...
August 13th, 2004 01:36 PM
by Van T. Dinh Go to last post
1 275
Check constraints by Aaron Abdis
Hello, I have a table called Company_Locations. There is a field named Is_Main. For any given COMPANYID, i want that only one Location can have the...
(Multi-page thread 1 2)
August 14th, 2004 04:19 AM
by TC Go to last post
11 246
Alter Table Query to Change Accept Zero Length Property ? by DCCNET.NEWS
I need to set the Allow Zero Length property of a column to true programmatically. Is there a way to use an ALTER TABLE query to modify an existing...
August 14th, 2004 08:10 AM
by Allen Browne Go to last post
1 317
data design question by PF
Hi all, I have a product table where each prod can have from 1 to 10 suppliers What is the correct way to build those tables? tblProd tblLink ...
August 14th, 2004 11:59 AM
by Douglas J. Steele Go to last post
1 225
Text vs. number by
I was under the impression that a field should always be formatted as text if the contents were not going to be used in calculations, so I formatted fields...
August 14th, 2004 04:20 PM
by M.L. Sco Scofield Go to last post
4 284
How to phrase If/Then clauses in the control source field by
Hello, This is a continuation of an earlier thread about Parsing strings from one field into many. I making a database,that contains five fields of overlap and...
(Multi-page thread 1 2)
August 14th, 2004 04:22 PM
by M.L. Sco Scofield Go to last post
13 1,431
movies by Craig Alexander Morrison
www.legalcopyright.com "Craig Alexander Morrison" wrote in message news:... www.fast.com "cordelia sheppard-riley"...
August 15th, 2004 05:30 AM
by Craig Alexander Morrison Go to last post
0 307
movies by cordelia sheppard-riley
where can i download a copy of the village , spiderman2 , or catwoman that actually work?
August 15th, 2004 05:38 AM
by Craig Alexander Morrison Go to last post
2 174
Zip Code Tables by Dave
I would like to be able to enter a zip code into my form and have the city and state automatically fill in from a table. Where can you go to import zip code...
August 15th, 2004 08:49 PM
by Alphonse Giambrone Go to last post
3 191
Allow Zero length property not working when using create table sql statement by EK
Access 2000 will allow me to insert a blank into a field with the Allow zero length property set to no. Here is what I did. Created a table in access with...
August 16th, 2004 02:48 PM
by EK Go to last post
2 482
Changing the Tables Name by ASPatel
I have to design a database which will have 2 Tables Table1 and Table2. When data in Table1 Changes i can generate a number thru query1/Expr1(based on data...
August 16th, 2004 04:09 PM
by Rebecca Riordan Go to last post
1 181
Normalizing table with repeating groups and existing relationships - How? by Steve Newton
Folks, I have inherited an Access 2000 database that contains about 50 records. The database is not normalized, but I'd like to make it so without having to...
August 16th, 2004 04:35 PM
by Steve Newton Go to last post
2 344
Field Formatting (Eric Butts) by Jaye
Hi Eric, Mant thanks for that tip. However I have more than one word in the field ie An address field could have something like New Gate Street in which case...
August 16th, 2004 05:47 PM
by Roger Carlson Go to last post
2 193
tables by Ashley Horsley
Hi, I was wondering if you could help, this is for my A-Level in ICT. I have to create a database in which students details, and course grades are stored. The...
August 16th, 2004 06:34 PM
by tina Go to last post
3 148
Date Format by Date Formating Problem
I have an import file (from Excel) that has a date in the following format: yyyymmdd I have created an input mask that adds a forward slash / to the date when...
August 16th, 2004 06:41 PM
by Tim Ferguson Go to last post
3 637
How to Relate Customers by Ronnie
I have designed a database with ten tables linking them with foreign keys. I have had a request however which I could use some advice on. One of my tables is...
August 16th, 2004 06:47 PM
by Tim Ferguson Go to last post
5 333
Post New Thread


Display Options
Showing threads 581 to 600 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 06:07 AM.


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