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 Views Reverse Sort Order
Table Structure Help by Ron A.
I am needing some assistance in creating a solid table structure in creating a database that stores vehicle permenant waiver items (items that will not be...
March 31st, 2010 07:26 PM
by Ron A. Go to last post
3 956
How to use and store a diamond or inverted delta symbol by Jen
I have a database where they need to select, store and view either a diamond or inverted delta symbol to designate a certain item. Is there an easy way to do...
December 12th, 2007 10:23 AM
by Jamie Collins Go to last post
3 956
How to change existing table record value by VBA and How to add newrecord in existing table by VBA by K[_4_]
Hi all, I got table in my database with name "tbldata" and i have two fields in that table with the name "Ticket_No" and "Amount". In "Ticket_No" filed column...
May 18th, 2010 09:20 AM
by XPS35 Go to last post
1 953
Clients and multiple accounts by lanjoudun
I'm building a database for my personal training business, and currently I ran into a huge pickle and don't know how to bite it. My problem is this, a client...
July 7th, 2009 02:10 AM
by tina Go to last post
9 952
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 949
Auto populate field in table by gm via AccessMonster.com
I have an Access data base that has acumulated 7 years of HR info. We plan to moving this info to HR Application. The new application has a field called field...
April 30th, 2010 01:53 PM
by Gopb via AccessMonster.com Go to last post
3 946
Accessing Database design mode by luv2bike2
There is an DB that was create well before my time at my job and I have very little experience with Access and need some help here. Access 2003, XP SP3. ...
May 27th, 2010 09:12 PM
by luv2bike2 Go to last post
5 945
Sorting data by Rob H
I have a table named Items, in this table the items are defined by Name, Size, and Format. When first setting up the table I added a few of my items to get...
March 17th, 2010 03:39 PM
by Fred Go to last post
3 945
Could Not Open Table "MSysAccounts" by Shawn
I have a shortcut to my database on my desktop. There's no problem getting into the database from her. As soon as I attempt to get into the database...
June 30th, 2006 07:15 PM
by SusanV Go to last post
1 944
MS Access Table Design Look Up??? by Laura1 via AccessMonster.com
I am trying to design a budget database and I want to have consistent categories and expense. I have a table with Category and Expense It looks something like...
April 30th, 2010 05:15 AM
by Laura1 via AccessMonster.com Go to last post
2 942
Table design question by Mark
Hi All, I just wanted to see if the design of some fields in the table are standard practice. The database admin set up a Code_Desc table with fields...
May 12th, 2010 08:54 PM
by XPS35 Go to last post
2 942
Database for VBA by KB
I am building a database catalogue of all our reports and want to include the SQL and VBA used in the reports. I have added a memo field to hold this data...
March 18th, 2010 09:30 PM
by Gina Whipp Go to last post
6 941
Linking To Excel by Dkline
I have the same problem. All of the underlying Excel spreadsheets are maintained by other people. If one them opens the file for editing, you're locked out. I...
April 27th, 2004 04:07 PM
by Dkline Go to last post
0 940
CaseManagement by Joe
Hi all, Just created a database to keep track of case management for clients. I have all demographics, types of case management intervention, but I'm having...
April 25th, 2010 12:14 AM
by roccogrand Go to last post
3 939
Default to data in a different table? by Flopbot
I know this might seem technically wrong and therefore, I haven’t found advice on how to do it on these postings. I have an Access 03 table...
April 30th, 2010 12:53 AM
by Flopbot Go to last post
2 938
String with Varying Letter followed by Incremented Number by Tat[_2_]
I'm new to Access and really don't even know how to ask what I need to know, but I'll give it a shot and maybe you brilliant folks can figure out what I...
March 13th, 2010 12:28 AM
by Bill Go to last post
3 937
referential integrity and lookup by buggirl
Hi all, I want to enforce referential integrity between two fields in two separate tables: tbl FishTaxonomy (includes the full name, common name, and...
April 30th, 2010 08:47 PM
by John W. Vinson Go to last post
2 937
Field Validation Rule to Exclude Ampersand by Ken Hudson
I am trying to create a validation rule for a table field that will prevent the use of the ampersand character (&). InStr(1,,"&",1)0 does not work. What is...
March 17th, 2010 03:16 PM
by Ken Hudson Go to last post
3 935
Change blanks to 0 (zero) by Jodie
I need to do an update to change all blank fields to a 0 (zero). In the criteria, I have tried IsNull and it is not returning any of the blank records. I...
March 20th, 2010 10:26 PM
by John W. Vinson Go to last post
5 932
Time Calculations by James Mitchell
I have set up a 'simple' database for inputting times spent on jobs and created a query whereby an individuals statistics can be calculated for a month. The...
April 28th, 2004 04:23 PM
by Allen Browne Go to last post
1 927
Post New Thread


Display Options
Showing threads 161 to 180 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:25 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.