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 Reverse Sort Order Last Post Replies Views
compound indexing? by barry
Hello everyone, I need to know if it is possible to index a combination of fields in a table. For example: &
June 17th, 2004 06:09 AM
by Gerald Stanley Go to last post
1 96
data source for a report by Barry
I'm trying to understand how to put data into a report. I am looking at the Northwinds Traders sample database, specifically at the "Sales Totals by Amount"...
January 10th, 2005 08:01 PM
by Duane Hookom Go to last post
1 224
Grouping components and updating locations by Barry A&P
I am working on a aircraft Parts management database. I am trying to find a way to relate or link Major assembly components, Sub assembly components, and...
October 10th, 2008 04:35 PM
by Barry A&P[_2_] Go to last post
4 240
Auto or user friendly split Database backups by Barry A&P[_2_]
I was suprized to find out that there is almost no post info on automatically backing up databases. the one post i found had code for SOON (shut one open...
July 10th, 2009 04:57 PM
by Armen Stein Go to last post
6 162
Row source Best practice?? by Barry A&P[_2_]
Since i am new to all this access stuff i have been tending to create new queries everywhere i need them instead of just creating stand alone queries (in the...
October 3rd, 2009 02:09 AM
by David W. Fenton Go to last post
7 269
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 265
Best Practice Value list or linked table? by Barry A&P[_2_]
I am beginning to wonder if i overcomplicate my database. i am going to add a field to my T_partnumbers for unit of measure (UOM) and can not decide if i...
November 24th, 2009 08:07 AM
by Barry A&P[_2_] Go to last post
4 363
Set Controls Default Value from another Control by Barry A&P[_2_]
I am working on a form for data entry where the user enters many records that may have similar information, i am trying to create a tab that would have all...
February 23rd, 2010 01:41 AM
by Barry A&P[_2_] Go to last post
3 271
pasted record in locked form crashes database by Barry A&P[_2_]
i have a form with a subform and on the main form i have a toggle button that locks the subform.. with this code !!.Locked = bLock this worked fine until i...
April 7th, 2010 01:34 AM
by Barry A&P[_2_] Go to last post
2 613
Suggestions to Split Transaction details by Barry A&P[_2_]
I have a simple database for keeping my checkbook (or all finances) straightened out. and i am looking for suggestions on how to make my deposits...
April 3rd, 2010 12:34 AM
by Steve[_77_] Go to last post
3 604
Conditional Formatting not working in report detail by Barry A&P[_2_]
i have an access2007 report that i am trying to setup conditional formatting where the user sets the "Alert Value" by a single record in a table here is my...
June 25th, 2009 06:05 PM
by Barry A&P[_2_] Go to last post
3 131
database Inputs from WAN??? by Barry A&P[_2_]
I apparently fell short on my research when i started this project,, i have spent all winter working on this Access database that works well on our LAN and i...
May 8th, 2009 02:25 PM
by Albert D. Kallal Go to last post
2 127
Sharepoint Migration, Need Home for backend by Barry A&P[_2_]
When i originally started this project we did some experimenting with linked tables from our sharepoint site, we verified some functionality with the linked...
April 20th, 2009 09:09 PM
by David W. Fenton Go to last post
2 127
Seperate ID Prefix and ID Number by Barry A&P[_2_]
I am playing with a barcode reader in my database. and from what i can figure out standard procedure is to set focus to a control then read the scanner. i...
March 17th, 2009 05:08 AM
by Barry A&P[_2_] Go to last post
2 128
Can not update records based on two queries by Barry A&P[_2_]
I have a form based on this query Browse_All_Query SELECT T_PartNumbers.PartNumberID, T_PartNumbers.PartNumber, T_PartNumbers.Description,...
March 5th, 2009 09:54 PM
by Barry A&P[_2_] Go to last post
6 163
Help on Handling Superceeded parts by Barry A&P[_2_]
I have a database to track parts being ordered. I have been having issues with parts that have been superceeded by newer parts. I have a Parts Table as...
February 18th, 2009 10:36 PM
by Fred Go to last post
1 65
Conditional format a Null Date by Barry A&P[_2_]
Conditional formatting doesnt seem to work for a null date. I want a DateCompleted control to turn red if there is a Null date. maybe something like on...
October 13th, 2008 12:31 AM
by Ken Sheridan Go to last post
1 121
What are AutoNumber Dangers by Barry A&P[_2_]
I recently viewed a post that said "autonumber is fine as long as you dont display it to the user..." Everything in my database references autonumbers!! ...
(Multi-page thread 1 2)
April 30th, 2010 02:22 PM
by Fred Go to last post
11 1,038
create a small stock control and sales database by Barry Claxton
My fishing club sells bait to members. I want to print receipts for each purchase listing items purchased and log the sales for stock inventory. Each product...
January 17th, 2007 12:23 AM
by Jeff Boyce Go to last post
8 178
Multiple Junction Tables? by Barry Moses
I have several tables that require many-to-many relationships; Would you create one Junction Table holding the PK's of all the other tables.....or would you...
September 23rd, 2005 08:52 AM
by [email protected] Go to last post
4 114
Post New Thread

Display Options
Showing threads 1001 to 1020 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 05:47 AM.

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