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
Do I have to set the primary key to include primary key fields? by boooney
I have read that "in a junction table, you need to set the primary key to include the primary key fields from the other two tables. " If I do this, I keep...
April 15th, 2010 12:17 AM
by John W. Vinson Go to last post
3 850
Multiple id problem by Bird Byte
Hello. I have an instance that I'd like some input-suggestions on if anyone would be so kind. We have a vendor table with each vendor ID being unique. One...
April 14th, 2010 05:32 PM
by Bird Byte Go to last post
9 356
AutoNumber by Pam
Hi, I have a table that holds information for jobs. The job number is an auto number field. It has grown to a 5-digit number and users want to start over...
(Multi-page thread 1 2)
April 14th, 2010 01:40 PM
by Fred Go to last post
15 440
Make Table v. Append to Table: Need Some Expert Design Inputs by MJ
I am working on updates to a couple related databases (not linked by any tables) and have a question about virtues of Make Table vs Append queries. Make...
April 13th, 2010 07:27 PM
by John W. Vinson Go to last post
8 373
Trying to combine multiple records into one record in a Query by Rich/rerat
I am new to Access, and very little knowledge about SQL. I read allot about normalization, need to know if I went to far with it with my Family table. Here...
April 13th, 2010 06:22 PM
by Marshall Barton Go to last post
1 245
count the nulls in a report calculation by Rose
What is input into the label boxes to all count those fields within a grouping that a blank. The Category is RSVPDate -- Rose
April 13th, 2010 05:00 AM
by Duane Hookom[_4_] Go to last post
1 255
Linking forms and reports. by Rose
I am trying to find the easiest method to write code which would allow me to open a report from a form linking up to five fields. For example: I have a...
April 13th, 2010 12:58 AM
by Allen Browne Go to last post
1 239
MultiSelect List Box (pre Access 2007) by ShelleyS
I want to achieve (in Access 2003) what the built-in function in Access 2007 does by allowing users to select multiple items in a combo box or list box. See...
April 12th, 2010 02:46 PM
by Roger Carlson Go to last post
3 327
Interested in thoughts on keeping the integrity of historical data by hollyylloh
Just to be clear, I am not looking for an explanation of how relational databases work in this question, I have been creating relational databases for many...
(Multi-page thread 1 2)
April 12th, 2010 02:35 PM
by Fred Go to last post
17 408
Compile: File Not Found by szag via AccessMonster.com
HELP! I don't know what happened. I was just doing basic cleanup of forms and reports. Now any event that fires gives me an error - all based on "File...
April 12th, 2010 08:03 AM
by Gina Whipp Go to last post
1 384
Add table to split database by sweeneysmsm
I have a split Access Database on a network. I need to add a new table to the database. Do I export it to both the front end and the back-end or do I run a...
April 10th, 2010 11:12 PM
by sweeneysmsm Go to last post
7 291
Updating relationships by JonB
Here is my challenge. My work has a wretched almost unsearchable "database". I am trying to cobble together my own relational database from that...
April 10th, 2010 02:27 AM
by JonB Go to last post
5 287
Disable Tables by shm135
Hi, I have a database which links to another database on the network. I have linked 5 tables from database1 into database2. Users do not have access to...
April 9th, 2010 05:02 PM
by Jeff Boyce Go to last post
3 242
How can I use relationships to auto-create records in my subform? by Jareddxp
### How can I use relationships to auto-create records in my subform? ### Please Help! Using Access 2007, I am trying to create a "Classroom Database" where I...
April 9th, 2010 09:05 AM
by Allen Browne Go to last post
1 298
Attachment data type - not working in form by szag via AccessMonster.com
I haven't use the attachement data type before. I set up a field in my BE tables as an attachment data type. I placed this field in my FE form, but when I...
April 9th, 2010 05:11 AM
by Allen Browne Go to last post
3 271
Splitting database - terrible performance by szag via AccessMonster.com
I split my database recently and now I am experience terrible performance when designing my forms. It can take 10 seconds just to select a field and delete it....
April 8th, 2010 10:30 PM
by szag via AccessMonster.com Go to last post
4 218
Products/Services Table by dvvog
I am using Access 2007. I have a database for my Products/Services industry. I have a table containing my products/services, as well as a Work Order Form...
April 8th, 2010 06:53 PM
by Duane Hookom Go to last post
2 196
Circularly linking multiple records by jdpeterson
Hello, I have two tables I wish to link together. The first table contains records for multiple devices, i.e., two clocks, five radios. I need it to...
April 8th, 2010 04:48 PM
by jdpeterson Go to last post
0 206
HTML to RTF Access by Mike
Hi, I am looking for a way to convert a column on my table in Access that is Raw HTML to Rich Text. Thanks!
April 8th, 2010 04:20 PM
by Daniel Pineault Go to last post
1 217
Search for Words in Documents by Air Lancer
Hi, I'm trying to create a engineering database whereby there will be hyperlinks to engineering documents. I'm trying to create a query whereby I can search...
April 8th, 2010 04:19 PM
by Daniel Pineault Go to last post
1 238
Post New Thread


Display Options
Showing threads 121 to 140 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 04:12 AM.


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