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
Need to have a field always have 13 characters & insert leading ze by WolfDog
I need to create a table that includes a field that has to have 13 characters (numbers) in it. If the user only enters 9 digits (or 11), it needs to insert...
(Multi-page thread 1 2)
September 22nd, 2009 03:38 PM
by BruceM via AccessMonster.com Go to last post
10 162
Limiting Due dates to the current month (when the data is queried) by Bob Waggoner[_2_]
In a calibration database I have a query that calculates due dates. I'd like to limit the query to just the calibrations due in the current month. How do I...
September 22nd, 2009 01:48 AM
by John W. Vinson Go to last post
3 111
AutoLookup in List Box by Donna
I am new to Access 2007 but have a lot of experience with the older versions of Access and the wizard use to ask if you wanted to find a record based on what...
September 22nd, 2009 12:44 AM
by Larry Daugherty Go to last post
2 102
Old data format to new format - Not compatible with old Input Mask by Chris Lines
Guys Old format for a file number = ADMLH/04/01. I use input mask LLLLL/00/00;0 for it. Work has now changed the file number to LH/09/01. The old input mask...
September 21st, 2009 11:34 PM
by Chris Lines Go to last post
2 93
conditional list box by RNicole
I am building a table with several list boxes. When entering a record, I want the user's selection in one list box to effect the choices in another list...
September 21st, 2009 06:30 PM
by John W. Vinson Go to last post
2 186
Scheduling PMs on Tue and Thursday instead of every five days by Bob Waggoner[_2_]
My database is set up to remind maintenance of PMS due based on the last done date. Now maintenance is asking for specific equipment to be PM'd on Tuesday...
(Multi-page thread 1 2)
September 21st, 2009 05:53 PM
by Bruce Meneghin Go to last post
10 194
Conversion of Excel Matrix by Runnik
I have an Excel spreadsheet that is set up as follows: A B C D E ...
(Multi-page thread 1 2 3)
September 21st, 2009 09:48 AM
by Keith Wilby Go to last post
20 260
Dialog box prevents record deleting by Rich Stone
I have a database with standard record function buttons. However, my 'Delete' button seems to have a problem. When I add vb code to bring up a custom dialgog...
September 21st, 2009 08:24 AM
by Rich Stone Go to last post
5 128
Bound Date/Time field to automatically display the current date by Billiam
I have a bound form which has a field called WorkDate which I would like to default to todays date...it also still needs to be able to be changed to a...
September 20th, 2009 11:13 PM
by Billiam Go to last post
2 147
Database Structure by Josh Davis
i had just a quick question about database structure. In order to maintain referential integrity in a database how would i set up a database in Microsoft...
September 19th, 2009 11:00 PM
by Michael Gramelspacher Go to last post
4 108
Access 97 to Access 2007 issues by Scott
I am trying to convert a database designed in Access 97 to Access 2007. I don't find the interface at all intuitive and I'm getting frustrated. Things that...
September 19th, 2009 03:51 PM
by Gina Whipp Go to last post
3 123
Combobox time by Billiam
I have a reference/lookup table named StartTime, StartTimeID PK, autonumber, with field StartTime (format date/Time, medium time format) I bulit a form on...
September 19th, 2009 01:49 AM
by Duane Hookom Go to last post
3 109
Linking tables in Access 2007 by Paul S
I've been using Access 2003 for some time now. I just started using 2007 (not a big fan at all). In 2003 I could open Link Tables window just by a macor and...
September 18th, 2009 11:23 PM
by Paul S Go to last post
3 93
Auto fill certain fields in a data entry form Access 2003 by cbianco
I want to enter some data in a form, hit the enter key and have the date filled in for the next record and the focus set to the field below the date...
September 18th, 2009 07:25 PM
by Jeff Boyce Go to last post
4 115
Access 97 and linked tables by Ticotion
Hi I have an old access 97 database where several tables are linked to other databases for no reason at all. In order for me to "clean" up the database I...
September 18th, 2009 06:19 PM
by Jeff Boyce Go to last post
4 181
Unsplit database by Petemeister2k
Hello, I've split a database, but now need to unsplit it so that I can add a password to the back end database (and have the application work without...
September 17th, 2009 05:36 PM
by Petemeister2k Go to last post
3 202
Avoiding One to One Tables by oldblindpew
I cannot ignore warnings given elsewhere in this forum against tables with many fields and the temptation to break them apart into a series of one-to-one...
(Multi-page thread 1 2 3)
September 17th, 2009 12:53 AM
by Gina Whipp Go to last post
26 243
Can this be done in access and where can i find information on how by Bruce
Is it possible to track changes to individual records in a database? I would like to track changes made to any field in any record. The time the change was...
September 16th, 2009 05:40 PM
by PieterLinden via AccessMonster.com Go to last post
1 64
Putting two subfields within a field by PieterLinden via AccessMonster.com
Describe this with just nouns (things) and verbs (relationships). Sounds like it's a simple relationship... A has {many} HasFeature( Phrase (PK1), Feature...
September 16th, 2009 05:28 PM
by PieterLinden via AccessMonster.com Go to last post
0 55
FILE LOCKING IN SQL DATABASE - ERROR 3197 by AndrewDB
Hi All, I really will appreciate help in this one. I have an Access 2007 client linked to a MySQL database which I connect to using ODBC. At times when...
September 16th, 2009 11:31 AM
by AndrewDB Go to last post
0 77
Post New Thread


Display Options
Showing threads 721 to 740 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 11:59 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.