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
Autonumber 0ne-One by acss
I have an invoice table and an invoice details table and i need to have the design accept duplicate invoice numbers since we receive same invoices from...
(Multi-page thread 1 2 3)
August 4th, 2009 02:06 PM
by BruceM[_4_] Go to last post
22 776
Default date question by acss
I have a FE/BE design with the BE residing in a network folder. The data entry form in this DB has a hidden date field with default Now() and some entries...
June 1st, 2008 03:22 AM
by boblarson Go to last post
1 119
Primary key to prevent duplicates by acss
I have an invoice DB and the primary key field is for the invoice number which is unique and should not be duplicated. I have just received duplicate...
June 5th, 2008 08:08 AM
by George[_14_] Go to last post
8 186
Preliminary design by acss
I am in the first stage of creating a DB that will be utilized by six people. They will be keying data and running queries during each month as invoices are...
May 5th, 2009 02:37 PM
by acss Go to last post
8 141
relationship inderteminate---Fred? by acss
On May 4th i made a posting and only now i am working on my DB...I receive the error of relationship inderteminate when using the INVOICE ID field from my...
(Multi-page thread 1 2)
May 18th, 2009 05:33 PM
by acss Go to last post
11 444
Date format in design by acss
I am creating a DB to track invoices and in the future i would like to run queiries or reports that would separate invoices from one month to the other. For...
June 1st, 2009 02:53 AM
by John W. Vinson Go to last post
6 250
Design Issue by acss
Creating a invoice tracking DB yet there is no standardization from the 7 different formats that customers send in. Some fields are always on invoices such...
June 9th, 2009 07:32 AM
by Tony Toews [MVP] Go to last post
6 174
Allow Duplicates by acss
i have a table for invoices and at times i receive a duplicate invoice number from another country. How do i set up a primary key (InvoiceID) and a secondary...
(Multi-page thread 1 2)
September 14th, 2009 12:25 AM
by Graham Mandeno Go to last post
19 307
Same invoice number- different country by acss
I have an invoice table with primary key of 5 digit text that is unique and i have a (customer id foreign key in invoice table)customer table that primary is...
August 6th, 2009 11:39 AM
by Daniel Haley Go to last post
3 184
Drop down list edit by acss
I have a drop down list on one of my forms that contains description selections for end users to pick from. The problem is that the field can not be edited...
March 31st, 2008 11:44 PM
by Evi Go to last post
2 100
Remove/Hide Toolbar by acss
How does one remove or hide the toolbar so end users do not have the option to play with the design? I only have one query that needs the export to excell...
March 28th, 2008 07:52 PM
by Evi Go to last post
1 138
Tables Normalized? by acss
I have three tables, one for vendor ID, another for centerID (which identifies country business cost location) and one for invoice information identfying...
February 8th, 2008 07:17 PM
by Amy Blankenship Go to last post
1 101
Time on date by acss
I have a date field that is set at short date and when a query is run is fills in the field with date and time. How does one prevent the time from being...
July 3rd, 2007 06:46 PM
by Jerry Whittle Go to last post
6 79
Primary key value by acss
I have a number data type in my primary key field and for some reason when i key in 016 it reverts to the number 16. What can be done so it does not remove...
June 29th, 2007 09:13 PM
by John W. Vinson Go to last post
3 68
how can I run an image viewer application from Access? by Ada
How can I attach images (in a folder) to a record and launch the image viewer from Access to view the images? Is there a Microsoft image viewer application...
August 30th, 2006 08:21 PM
by Neil Go to last post
1 61
Command button wizard won't start by Adam
Within the last week when I add a command button to a form the wizrd will not start. I have changed the registry key for sandbox from 3 to 2. That didn't...
March 15th, 2008 07:14 AM
by boblarson Go to last post
2 113
Help Tracking Hairdye by Adam
I am working on a database for a cosmetologist friend of mine and I'm trying to track hair dye inventory, and then subsequently be able to run a report...
February 23rd, 2006 02:20 PM
by Lynn Trapp Go to last post
3 76
Relationships?? by Adam
1. I have a one-to-many relationship. But everytime i go back to the relationship window Access automatically creates another relationship using the same table...
April 24th, 2005 06:14 PM
by Ken Snell [MVP] Go to last post
3 90
Hyperlink field by Adam
I hope this is the right Access sub-group for this post - apologies if not! I'm setting up a catalogue of our team's files. This is in Access, but the problem...
(Multi-page thread 1 2)
October 8th, 2004 04:27 PM
by Tim Ferguson Go to last post
12 305
Thanks! by Adam
Hi Everyone I just wanted to say a really big 'Thank you' to everyone who has helped me over the past year. Some of you may remember answering my many...
September 2nd, 2004 09:16 AM
by Allen Browne Go to last post
1 99
Post New Thread


Display Options
Showing threads 221 to 240 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 02:52 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.