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
2007 StartUp Properties by JDrown
Back in the days of Access 2003 and before, Access supported the creation and management of the following custom...
July 17th, 2009 05:56 AM
by Allen Browne Go to last post
1 353
How do I code an e-mail address in an controls input mask? by Row Autofit, cell formatting[_2_]
I need to code both the table field and a form control with an input mask format, i.e. for example The length before the @ symbol can be...
July 17th, 2009 05:12 AM
by fredg Go to last post
1 175
Forcing Upper case of field at table level? by Yuta
Am using Access 2003. When designing a table, if I use '' to format a field the field does not display anything in a listbox on a form. When I remove the ''...
July 17th, 2009 01:45 AM
by Yuta Go to last post
2 194
Migration to SQL Server by MP
Hi everyone, We have Desktop Application developed in Access 2003/2007. We have more than 50 clients using this application and now we want to convert back...
July 16th, 2009 11:33 PM
by kathy montoya Go to last post
1 165
Need an example of importing from Excel to Access by M Skabialka
A user has asked that some of his spreadsheets be combined into an Access database. Each workbook has multiple sheets, with most of them being charts using...
July 16th, 2009 11:20 PM
by Clif McIrvin[_2_] Go to last post
3 160
Relational Database Join types by WindandWater
Hello, I have a seemingly simple question: In general when joining tables I assume we generally use the default option which is an inner joing/ both tables...
July 16th, 2009 08:15 PM
by David Portas Go to last post
4 162
Creating Field With combo of autonumber and text by Benjamin
Hello, I'm looking to create a field that has both an autonumber component and a static text portion. So, instead of having as an ID# the simple autonumber...
July 16th, 2009 07:04 PM
by KARL DEWEY Go to last post
3 132
Linking tables by Lyonrem
Help please Im stuck! I have two tables one for enquiries and another for orders. I have all the contact details in the enquiries and want this to transfer...
July 16th, 2009 01:34 PM
by Allen Browne Go to last post
1 121
Not To Mess Up by Replacing Relationships with Different Primary K by A.P.[_2_]
Hi Guys! I have a questions. In my database there is a field called customer id. it is present in two tables and used to build a relationship one -many...
July 15th, 2009 11:26 PM
by Steve[_72_] Go to last post
1 137
Table design with many similar fields by RichardGarfield via AccessMonster.com
Hi I am designing a classical music database and am a bit stuck on how to manage the movements of a work. I have a table Work (primary key WorkID and linked...
July 15th, 2009 08:24 PM
by Piet Linden[_2_] Go to last post
8 240
Error at Runtime (Function not available in querie expressions) by Gerry
I have an access program that is packaged and distributed on a network in my office. The program runs great on some machines and on others it doesn't. I get a...
July 15th, 2009 08:15 PM
by Gerry Go to last post
6 172
Yes / No field auto populate based on expiration date (Access 2003) by Chris
Hello, I have been challenged with making a yes/no field either stay on or off based and contract end date field in my table. I am using Access 2003. So for...
July 15th, 2009 07:57 PM
by Jeff Boyce Go to last post
1 157
User-defined Outlook fields in Access by Harry
Is there a way to have Access display user-created fields from Outlook? I have added user-defined fields to Outlook 2007 to capture addtional contact...
July 15th, 2009 06:37 PM
by Harry Go to last post
2 137
Spare parts "used on" code by Mark S
I have an existing inventory database that is used for spare parts for other equipment. There are currently about 7000 spare parts for about 50 different...
July 15th, 2009 02:16 PM
by Fred Go to last post
2 131
Table structure for workplan by SF[_4_]
Can I use Access to store workplan that have the following structure? If yes how? N° Main Activities Year 2009 Lead (Support) Jul Aug Sep ...
July 15th, 2009 01:58 PM
by Fred Go to last post
1 132
Error 3191 in Access by Christopher
I'm in design view creating a table. When I tried to save the table, I get the following error message: Cannot define field more than once. (Error 3191)...
July 15th, 2009 03:09 AM
by John W. Vinson Go to last post
7 221
Skip a line of code and continue by Bob Waggoner[_2_]
I have a "Check Work" button a user can click to see if they've completed a record. Can anyone show me a bit of code that simply pops up a list of skipped...
(Multi-page thread 1 2)
July 15th, 2009 01:18 AM
by tina Go to last post
10 455
How to create a running total on a table by Stephanie
Hi: I have a question on how to set up running total field in a table. More specifically, i have a "Bank" master table and I want the "Balance to date"...
July 14th, 2009 11:15 PM
by Jeff Boyce Go to last post
1 147
looking for direction... Access or Excel by jorgesalazar via AccessMonster.com
Very much a newb with access and have the need to improve upon a db created by another that has grown in popularity by the big guy (boss)... looking at it i...
July 14th, 2009 09:29 PM
by jorgesalazar via AccessMonster.com Go to last post
3 125
Too many indexes by Doctor
my table tblClients has too many indexes. I've deleted and deleted indexes just to make the tables that I absolutely must enforce RI. Some I will just have...
July 14th, 2009 06:49 AM
by Tony Toews [MVP] Go to last post
3 188
Post New Thread


Display Options
Showing threads 961 to 980 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 12:51 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.