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
how do i calculate age by Shelley
I have tried using the current formula online ...namely... =DateDiff("yyyy", , Now())+ Int( Format(now(), "mmdd") Format( , "mmdd") ) but the program ...
November 9th, 2004 04:50 PM
by Joan Wild Go to last post
7 161
Automatically Check Checkbox by CMD
I'm building a database in which I would like to have checkboxes automatically checked on a summary form once certain other information has been entered into...
November 9th, 2004 12:42 PM
by Randy Go to last post
5 143
Add new data from Field1 into Field2 (& keep old Field2 data histo by AmyNYC
Not sure if this is possible, but would like to automatically add new data from Field1 into Field2, but keep data currently in Field2 as a history. Field1 =...
November 9th, 2004 12:18 PM
by Randy Go to last post
3 183
Fix memory leakage when you open Access forms > 300 times ,run ou. by Ifoundit
Try this test open any simple form and close again ,eventually MSAccess will bring up message not enough memory. eg try Northwind database opening categories...
November 9th, 2004 06:39 AM
by david epsom dot com dot au Go to last post
1 239
One to Many Relationships by Pointy Haired Boss
I am trying to build a one to many relationship where the One is a normal field named 'UserID' within the first table while the Many is a Primary Key named...
November 9th, 2004 02:17 AM
by David Seeto via AccessMonster.com Go to last post
8 178
SQL Statement by Wantula
I have two SQL statements, one is giving me the total Quantity available(from Stock table) and the other one is giving me the total number of Quantity sold...
November 9th, 2004 02:03 AM
by David Seeto via AccessMonster.com Go to last post
2 224
SQL Syntax Error by Wantula
Lynn Trapp asked me to post the actual SQL code so that it can be checked for error. The error is "Syntax error in FROM clause." SELECT Stock.Item,...
November 9th, 2004 02:01 AM
by David Seeto via AccessMonster.com Go to last post
3 230
SQL by Wantula
I decided to repost this question because the response i got didnt work, it was giving me this error" Syntax error in the FROM clause". Lynn Trap,...
November 9th, 2004 01:57 AM
by David Seeto via AccessMonster.com Go to last post
3 158
Setting Table Relationships- Why? by el zorro
When I first started working in Access, I would set relationships for all the tables. THen when I got "clever" and began writing lots of queries, I noticed...
November 8th, 2004 11:29 PM
by John Vinson Go to last post
4 437
Relationship Print Wizard by bw
Microsoft has an "Access 97 Relationship Print Wizard"...
November 8th, 2004 05:31 PM
by bw Go to last post
4 192
How can I specify elapsed time format (such as [mm]:ss in MS Exce. by Tangomeister
I want to specify elapsed time format that one can find in MS Excel. Specifically, I want to use :ss. The Access format did not allow me. Is there an...
November 8th, 2004 09:50 AM
by Jamie Collins Go to last post
7 110
Add list in single cell to view on web by Jiffy
Trying to list 3 items into a single cell on a table. Looks fine in MS Access, but once I upload the database to the web, the text wraps instead of being in a...
November 8th, 2004 01:19 AM
by Jiffy Go to last post
0 74
Office sp3 install reveals multiuser or database problem? by JohnMc
I recently installed the latest MS Office 2000 sp3 on a clients network. These 10 workstations were running fine with the original install of Office2000 until...
November 7th, 2004 10:39 PM
by John Vinson Go to last post
1 264
Access 2002 Help required please...... by Simonglencross
I am currently in the process of designing a database whic is going to be used to record sales, I need some advice on the following. a) each user (Sales...
(Multi-page thread 1 2)
November 7th, 2004 08:39 PM
by Joan Wild Go to last post
10 238
OLE Server not Registered win2k -> winxp by Ali Mikati via AccessMonster.com
i have an application that stores word documents and tif images, that works fine using acc2k, on win98 and win2k platforms, but on winxp, the word documents...
November 7th, 2004 07:33 AM
by Ali Mikati via AccessMonster.com Go to last post
0 308
Duplicate data by Rob Green
I am trying to maintain different state for filenames, so i have a table with the list of filenames, then in the main table i would link the filename field to...
November 7th, 2004 04:08 AM
by Ken Snell [MVP] Go to last post
3 643
What size can a access table handle before affecting performance? by Matt in UK
I have an assignment for updating (maintenance, version control documents)database analysis documents (dfd's, lds etc). One table is stock which is used most...
November 6th, 2004 07:15 PM
by John Vinson Go to last post
2 106
Table Structure for case tracking by Mattymoo
Hi. I’m relatively new to working out how to structure tables, so hope someone can help me I need to set up a case tracking database which tracks leads and...
November 6th, 2004 02:23 PM
by Jeff Boyce Go to last post
3 315
Access2000 templates by bets
Is there a template available for Access 2000 to use for design for analysis of a questionnaire?? I'm stumped...can't seem to make heads or tails of what I...
November 6th, 2004 09:06 AM
by Allen Browne Go to last post
1 95
Error 3190 - Too Many Fields Defined by Dan
MS Access 2002 SP3 Building a fairly complex financial forecast model. Several nested queries. Well into the nested query ran into Error 3190. Anyone know a...
November 6th, 2004 08:39 AM
by Evan Camilleri Go to last post
2 181
Post New Thread


Display Options
Showing threads 10501 to 10520 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:10 AM.


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