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 Reverse Sort Order Views
Working with many-to-many relationships in Access 2007 by lexrpcv
Hi, I'm new to Access but have been studiously using the help, tutorials, and forums. I seem to have the tables laid out but am now stuck at getting the...
June 30th, 2008 08:34 PM
by John W. Vinson Go to last post
8 119
Creating Expression for Sum of two fields by Nirav
Hi All, I am new userof access and I am creating a for where I have two fields. Ex. Score A (Combobox - 0, 1 or 2) Score B (Combobox - 0, 1 or 2) ...
September 30th, 2008 07:22 PM
by John W. Vinson Go to last post
8 205
Adding and Deleting records simultaneously in multiple tables by Bobk
I have inherited a table called "Bookings". This table cotains summary sales order data. It was loaded via a Form. I have been asked to build a detailed...
October 9th, 2008 02:42 PM
by Bobk Go to last post
8 203
ACCESS 2007: need help in database breakdown and table creation by Bob76
Am new at Access. Been studying books on Access 2007 and tables I've created are not efficient. Have feeling am going about it the wrong way. Currently...
October 22nd, 2008 03:10 AM
by Bob76 Go to last post
8 377
Building a shareholder database using access 2007 by nerak
I am trying to build a database for shareholders and the companies they are shareholders to. It has been quite a while since I build my last database and...
October 27th, 2008 04:59 AM
by nerak Go to last post
8 339
Access 2000 Duplicate Key by Gus
Hello, I have a split database that users access via the LAN. I have a table tblAgr_Check_Out (ChkO_ID, Date_Checked_Out, User_ID,FS_Agr_Num). The ChkO_ID...
October 23rd, 2008 11:24 PM
by Gus Go to last post
8 367
Establish relationship between tables using TWO fields by Ann Scharpf
I have a ChildID table and a ClinicVisits table. I want to ensure that the user cannot create a ClinicVisits record that does not have matching values for...
October 29th, 2008 08:45 PM
by John W. Vinson Go to last post
8 285
how to create staff rota from access database by Sion
can you help on setting a database telling who is working which day, what time and how many hours they are working each shift
November 3rd, 2008 10:57 AM
by Keith Wilby Go to last post
8 1,347
Dlookup Help Please by Dic_nutana
Hi hope you can help I am having problems with dlookup. I’m using access 2000 and I’m trying to retrieve the ‘email’ address contained in a table...
November 14th, 2008 07:32 PM
by Dic_nutana Go to last post
8 157
Calculating differences in Access by annie techwriter
Hello, I am calculating the number of days between an issue being Opened and Closed. That part works fine, but if I do not have a Closed date yet, the...
September 18th, 2008 06:46 PM
by annie techwriter[_2_] Go to last post
8 168
Fingerprint Scanner by Doctor Dan
I have been asked to develop an application which uses the persons fingerprint as his record identifier. Intsble design I am not sure how to code this...
August 29th, 2008 09:27 AM
by Brendan Reynolds Go to last post
8 276
Standard Operating Procedures - How to Manual by Joseph
I have been working on an SOP for about 3month now and am getting frustrated at it. The problem is that when I need to change something, formating the page,...
July 6th, 2008 04:09 AM
by Joseph Go to last post
8 174
How do I make a unique ID# for drop down box items? by saintjohn4059 via AccessMonster.com
Hi, I'm brand new to MS ACCESS and I am using MS ACCESS 2007. I would like to make a drop down list of different animal species for an animal shelter database....
July 3rd, 2008 08:12 PM
by strive4peace Go to last post
8 127
Public Function Problems by JudyB
I have the following function: Public Function CalcWeeks(DateStart As Variant, DateEnd As Variant) As Single If IsNull(DateStart) Then CalcWeeks = Null Exit...
July 20th, 2008 09:34 PM
by JudyB Go to last post
8 151
Reference Document by Dave
The db project I am working on has a unique serial number for each document. The procedure calls for the orignator to send the document forward to the next...
August 13th, 2008 11:00 PM
by Dave Go to last post
8 119
columns by JB
Hello I have a table with Clients (clientId as primary key) and another one with Calls & Activities (activID primary Key). The second table is used in a...
August 16th, 2008 02:44 PM
by JB Go to last post
8 136
Maintaining a history of item movement within an inventory databas by R. Blankenship (Deming Public Schools)
I have an inventory database to track technology assests in our school district. There are three main tables that deal with this process. Inventory...
August 14th, 2008 11:07 PM
by Fred Go to last post
8 96
child link to itself by inungh
I have a child table which has composite key ID and CID which both link to parent table like following. I would like to know is it bizard design like...
August 22nd, 2008 01:36 AM
by strive4peace Go to last post
8 204
Linking Many Surveys to one participant number by Metalmaniac
Hi there, I am creating a database for the entry of 4 different questionnaires for a number of different participants. Each participant number is unique and...
August 21st, 2008 04:59 AM
by tina Go to last post
8 134
Variable Field Names? by DumbWithData
I am trying to set up part of my database to track employee time. We have been simply doing this on an Excel sheet. I want to be able to enter the...
December 18th, 2008 02:45 AM
by Duane Hookom Go to last post
8 158
Post New Thread


Display Options
Showing threads 1021 to 1040 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:02 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.