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 Replies Views Reverse Sort Order
Slow running reports by Kieran H
I'm running an Access based reporting application in two environments. The older, MS Access 2000 version has been running for years without issue. If I run...
April 27th, 2010 01:16 PM
by Kieran H Go to last post
0 791
Hyperlink field / Allowing Full Menu's by szag via AccessMonster.com
I have a hperlink field that I want users to be able to Add, Open ect on my form. It works until I uncheck the "Allow Full Menu" in the Access Options area....
May 3rd, 2010 12:40 PM
by szag via AccessMonster.com Go to last post
0 790
TEMPLATE EXCEL, 31 DAY ROW, MONTH COLUMNS,2004 by ARNIE B
I WOULD LIKE TO ACCESS A TEMPLATE THAT WOULD HAVE DAYS ON THE ROWS AND MONTHS IN THE COLUMNS. DOES ODDICE 2002 HAVE SUCH A TEMPLATE, IF NOT WHERE CAN I FIND A...
January 21st, 2005 07:25 PM
by Tim Ferguson Go to last post
3 790
Table History for Newbie by MadCrazyNewbie
Hey Group, I have a table with the following Feilds: MobilePhoneID, PrimaryUser, DepartmentID, CallOptions, MobileNumber, SDC, GPRSTarrif (Lookup to Another...
(Multi-page thread 1 2)
May 11th, 2004 11:36 PM
by rpw Go to last post
16 789
Text Field Size - Access 2007 by WSR[_2_]
I'm creating a database of text fields. I expect some data to exceed 255 characters. What is the maximum field size of a text field? Can I increase the text...
April 6th, 2010 03:41 PM
by WSR[_3_] Go to last post
2 789
Design a table to include external file links by Spence
I'd like to create a table that has two/three fields. 1) a description of what the linked file is and 2) the hyperlink to the file. I'll have one more field...
February 10th, 2005 06:22 PM
by Tony Vrolyk Go to last post
3 788
validation for one field based on another by andrew w[_2_]
I have two fields and I wish to validate one to depend on the other This what I would like to happen if field1 = text1 or text2 or text3 field2 must be...
March 29th, 2010 08:00 PM
by Steve[_77_] Go to last post
1 787
Crosstab query question by DMainland
I use a crosstab query in a database as a first step in recalling multiple monetary transactions made on the same day that, when added together, exceed...
March 29th, 2010 09:27 PM
by John W. Vinson Go to last post
2 785
Need help with table set-up and Thanks! by KARL DEWEY
project number in my data table will be truncated. I know that it will be impossible to establish referential integrity Use an Autonumber field as primary...
May 27th, 2010 09:49 PM
by KARL DEWEY Go to last post
0 784
Clearing yes/no fields by Dan
I have a yes/no field that I tag if I want to send a bill to various people. After I have sent the bill I want to clear the field so I can use the field at...
March 14th, 2010 10:01 PM
by Jerry Whittle Go to last post
1 782
Other table design solutions for storing multiple employee ID's by laskowv
I have a table which holds the ID, DivisionID, Division term (ex: 2007-2009, 2009-2011), followed 10 fields (type = number) for the 10 officer positions. I...
July 8th, 2009 05:45 AM
by laskowv Go to last post
4 781
Using Lookup Query with Calculated Value in Table ComboBox by Matthew Pfluger[_2_]
Hello all, This question takes a complicated setup, but I'll try to keep it brief. I have a database with a main table (tblMain) and a lookup table...
April 24th, 2010 12:48 AM
by Jeff Boyce Go to last post
2 780
Database Design Idea by andycambo
I’m looking to create, in my view, a complex database in Access 2007 and would like your advice and views on my design plan. First I will explain what the...
(Multi-page thread 1 2 3)
July 29th, 2009 02:02 PM
by Gina Whipp Go to last post
23 780
Setup ? by daisy
Hi, I am trying to create an access database that has historical data and new data is imported in monthly. I need it to be able to check each time if it's a...
March 25th, 2010 01:05 AM
by daisy Go to last post
4 779
Compile error. in table-level validation expression. (Error 3320) by Donna via AccessMonster.com
I'm using the default value Now() for a Date/Time field in a table. It has been working fine for over a year. All of a sudden I'm getting the above message. ...
March 21st, 2005 09:04 PM
by Donna via AccessMonster.com Go to last post
2 779
Autonumber 0ne-One by acss
I have an invoice table and an invoice details table and i need to have the design accept duplicate invoice numbers since we receive same invoices from...
(Multi-page thread 1 2 3)
August 4th, 2009 02:06 PM
by BruceM[_4_] Go to last post
22 776
"Free" ip address in asset database, not remove? by Sandroid[_3_]
Win 7, access 2007 , tables: device and ip, relation (device.ipIP, foreign)one-to-one(ip.ID, primary) when I delete an device from device table using form it...
May 11th, 2010 07:36 PM
by Sandroid[_3_] Go to last post
0 775
How do you do an inner join... by jj
on just a PART of a field? Here's the structure so far: Access 2000, 3 tables (Furniture, Titles, Descriptions), no joins. Here's the design & some sample...
April 28th, 2004 12:26 PM
by Gerald Stanley Go to last post
1 775
how to get rid of "Add new field" by Sybolt
Hi all, We have just made the transfer to Access 2007. Apart from the ribbon layout, which I believe only requires some time to get used to, I have a question...
April 16th, 2010 02:30 PM
by Al Campagna[_2_] Go to last post
1 774
International Addresses by T'Kai
I have been asked to create a database capable of handling both international and US addresses. Does anyone have any idea how to handle this efficiently? ...
June 1st, 2004 11:21 PM
by Jay Vinton Go to last post
5 773
Post New Thread


Display Options
Showing threads 301 to 320 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 01:57 PM.


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