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
Format of temporary variables by KenB
I have a pointer stored in TempVars!MyIndex Within DLookup( or DSum( references to TempVars!MyIndex work fine but IIf(tblField = TempVars!MyIndex,...
November 9th, 2009 09:02 PM
by KenB Go to last post
0 122
Invoicing database design by [email protected]
I am designing a database that includes the simple (!) functionality of producing invoices (not an accounting package). I understand the convention is to...
(Multi-page thread 1 2)
November 9th, 2009 01:10 PM
by BruceM via AccessMonster.com Go to last post
11 467
(Object invalid or no longer set) by Mark A. Sam[_3_]
My client's database is suddenly issuing this message and users need to close and open the db. The Access database is on one server and the backend (SQL...
November 7th, 2009 05:08 AM
by Gina Whipp Go to last post
5 172
Appending table autonumber problem by MTSmith
I am appending one table to another. The autonumber field in table1 ends at 989. When I append the second table's records, it jumps the number from 989 to...
November 7th, 2009 12:41 AM
by MTSmith Go to last post
5 180
Store similar types of records all in one table or separate tables? by tryit
Suppose you want to have four different types of records. Each of these records have numerous fields in common, and a few fields that are unique to each type...
November 6th, 2009 10:07 PM
by tryit Go to last post
2 172
Field Privacy by autlew
I have a database that I need the SSN number for employees as the key. I want to make it so I can input the SSN number when I add an employee but make it so...
November 6th, 2009 06:32 PM
by John W. Vinson Go to last post
2 186
Where should relationships be created? by lpierce819
I am trying to clarify where the prefered location is for relationships. I am working as a contract employee to "cleanup" a database created by someone...
November 6th, 2009 04:55 PM
by Gina Whipp Go to last post
9 209
Date Format by Grant Dayton
I want to have my report display a date format for example 11-05-09, i want it to display as 2009-11 (YYYY-MM). Can this be done? I couldn't figure out if I...
November 5th, 2009 11:49 PM
by John W. Vinson Go to last post
2 123
Show employees and others in combo box by BruceM via AccessMonster.com
I am trying to figure out a way to show employees and non-employees in a combo box. The training database includes training records. Training may...
November 5th, 2009 11:46 PM
by Jeff Boyce Go to last post
3 150
Need to have two autonumber fields in one table by plisvb via AccessMonster.com
Hello, I've created an inventory dbase for a grocery warehouse and initially I created one table for different types of invoices: 1) Incoming 2) Outgoing 3)...
November 5th, 2009 08:58 PM
by plisvb via AccessMonster.com Go to last post
3 169
Need Help Updating Table by Brent Sweet
I have a form that has some fields on it. When you click a button it opens another form that the first form passes data to. For instance Form 1 is customer...
November 5th, 2009 07:33 PM
by Daryl S[_2_] Go to last post
4 128
Need guidance for Inventory dbase, want to avoid calculated field. by plisvb
Hello All, I've searched through countless "calculated fields" threads but I've never found an answer to my question. I'd like to know the best way to set...
(Multi-page thread 1 2 3)
November 5th, 2009 02:44 PM
by plisvb via AccessMonster.com Go to last post
24 502
real estate database design by deb
I 'm creating a database with several commercial buildings, lots of tenants and lots of car parking spaces - some spaces are included in the lease and some...
November 5th, 2009 12:42 AM
by deb Go to last post
7 138
Birding Life List design by cwyse
Hi, I'm trying to create an MS Access database to store bird sightings. I think I've created all the tables that I need, and tried to form the...
November 4th, 2009 08:28 PM
by cwyse via AccessMonster.com Go to last post
7 331
Access auto numbers by ksgolfer
I have just started using access 2007. I used 2000 in the past. I need help with handling auto numbers. In my 2000 data base I had a Serial Number field that...
November 4th, 2009 02:13 PM
by Jeff Boyce Go to last post
3 228
25 Hosting Web www.ivys.es by tesddalws
Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web...
November 4th, 2009 12:50 PM
by tesddalws Go to last post
0 161
Strategy for groups within recordset by BruceM via AccessMonster.com
I couldn't think of a good, brief subject line for this thread. I have an Employee database with EmployeeID (PK), FirstName, LastName, etc. Some employees...
November 3rd, 2009 09:09 PM
by BruceM via AccessMonster.com Go to last post
4 213
Defining Relationships/Primary Keys between two tables by ScottMsp
Hello, I am having difficulty in designing a database and specifically creating the correct relationships and primary keys. Right now I have two tables that...
November 3rd, 2009 08:11 PM
by Bernard Peek[_3_] Go to last post
4 122
Need help with several many to many relationships by shoup
Hi, and thanks for your help. I am creating a database for creating multiple choice tests. I keep getting stumped because there are several many to many...
November 2nd, 2009 07:12 PM
by Jeff Boyce Go to last post
8 257
Student class payments by Nomy
Hi, I building a database for karate classes and payments. I have these tables: tblStudents - for basic info (name, address etc) tblKarateCls - a lookup...
November 2nd, 2009 05:11 PM
by Jeff Boyce Go to last post
6 144
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 08:59 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.