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
Comparing for Duplicate rows by rsue
My "imported or linked" database has duplicate rows. The (columns) fields I need to extract only need one row for each entry in the invoice field. Please tell...
May 19th, 2004 08:18 AM
by John Nurick Go to last post
1 428
Copy Data by John
I have a database that tracks transactions for internal comany use (intrabank transfers, wire transfers, etc.). Many of these entries are similar period to...
May 19th, 2004 08:18 AM
by John Nurick Go to last post
1 465
Create a new temp table and populate with n blank records by Gareth Mercer
Hiya, I am attempting to create a table with n blank records in it, where n is a vairable inputted on a form. How would I go about this as it is driving me...
May 19th, 2004 01:38 PM
by Jeff Boyce Go to last post
3 638
Access AutoNumber Feature by Keith Davis
Is there a way to get the AutoNumber feature in Access to begin incrementing at a number other than 1? For example, to begin the numbers assigned to a customer...
May 19th, 2004 06:04 PM
by Pavel Romashkin Go to last post
4 335
Need help with Tables Design and Relationships by Tom
I need to come up with a design for the tables listed below. Although I provided some general information about the relationships as well, I am not too sure...
(Multi-page thread 1 2 3)
May 19th, 2004 06:51 PM
by rpw Go to last post
24 1,667
Accounting by Michael Wong
Hi, For educational purpose, does anyone have some links to sites where I can get a functional Access database on an Accounting system (inventory...
May 19th, 2004 09:00 PM
by Joan Wild Go to last post
2 373
Creating a Survey by Terri
I have some experience using Access, but I've been asked to tackle a new problem, and I'm lost. My church is creating a survey to assess priorities and...
May 19th, 2004 09:07 PM
by Joan Wild Go to last post
1 673
Cannot join 1:M table into M:M tables by Tom
I recently posted a question about multipe M:M relationship tables. In one reply, RPW responded with the following: ************* Although the following is...
May 19th, 2004 10:16 PM
by rpw Go to last post
4 1,030
auto populating by Ryan
Hello, not sure how to do this but what I need to do is have one table get info for a field by pulling information from 2- 3 other fields and then use this...
May 20th, 2004 06:39 AM
by John Vinson Go to last post
2 308
question creating multiple front-ends by Amit
MS Access 2K, Windows XP ======================== I have a database which is to be used by multiple "groups" of users, and each group may have different...
(Multi-page thread 1 2)
May 20th, 2004 09:42 PM
by Tim Ferguson Go to last post
12 682
Assigning a Specified Unique ID by M Johnson
I have a table already populated with distinct records and I need to add a field where I can assign a unique ID. I want the unique ID for the first record to...
May 20th, 2004 10:01 PM
by Tim Ferguson Go to last post
5 429
Reports created from forms by CRAIG KELLY
Hi, I have a database which has quite a lot of queries built upon other tables and queries, they are all linked by a primary key called RUN NUMBER. The data...
May 21st, 2004 01:32 AM
by Jeff Boyce Go to last post
1 687
Error message "Invalid Argument" by ann
I get an error "invalid argument" in one of my tables' on the last record of the table the word '#error' is in every field. It will lock me up and it will not...
May 21st, 2004 02:27 AM
by Duane Hookom Go to last post
1 659
Calculation problem by Steven Voorhees
I took on a project at my work, that has me stumped now. I am trying to get this done, since currently, the raw data is entered into an Excel spreadsheet, that...
May 21st, 2004 03:00 PM
by Jeff Boyce Go to last post
3 579
Northwind by Mike
I want to modify the Northwind db example. Looking at the design, I want to include another 3 or 4 tables that follow the schema of the "Order Details". If I...
May 21st, 2004 03:03 PM
by Rose Go to last post
3 725
Table relationships by dw
Hello, all. We have an Access db that we use as a front-end to a SQL Server db, with the SQL Server tables linked in via ODBC. Is there any way...
May 21st, 2004 05:39 PM
by Tim Ferguson Go to last post
1 243
trying to pull 2 fields from another table into this table by E Taylor
I have a database which has multiple tables. There is a table for products which has various columns including ProductID, CategoryID, Product_Name...
May 21st, 2004 06:17 PM
by John Vinson Go to last post
3 504
Forms and tab controls and tables by King FSST
I am using Microsoft Access 97. I have created a form with a tab control. On it I have added six pages. These six pages each link to six tables. However, at...
May 21st, 2004 06:47 PM
by Lynn Trapp Go to last post
2 516
Table design - multiple entries for a field by Carrie
Hello, I have 3 tables - employees, performance evals, and error codes. The error codes is more of a look-up table that is indexed by a unique number. The...
May 22nd, 2004 04:02 AM
by DDM Go to last post
1 468
Make a field lookup dependent on the value in another field of a record? by Susan A
I am trying to do the same thing, but am not sure what you mean by "set your Form to appear in datasheet view (same look as a Table)" (from Eric's...
May 22nd, 2004 09:10 PM
by WaltS [MVP WMC] Go to last post
8 1,098
Post New Thread


Display Options
Showing threads 141 to 160 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 01:00 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.