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
Numeric field is rounding up by Brook
I have a numeri field that is set for two decimal places. However, when I enter a number 6.80, it rounds up to 7.00. Does anyone have any ideas /...
July 29th, 2004 02:27 AM
by John Vinson Go to last post
2 103
entries are automatically duplicating by Bud G
I have set up a database with a members table and a payments table. I need to be able to apply payments to an individual member... all goes well until members...
July 29th, 2004 02:48 AM
by Bud G Go to last post
3 131
Database Design Advice by Diana
Hi, I am creating a database for server parts. My company has 8 servers onsite at one of our largest customers for the sole purpose of using the parts in...
July 29th, 2004 06:01 AM
by tina Go to last post
3 135
automatically date a field by Rebecca
I have a field in table . I need it to automatically enter the date anytime any of the fields in the Memberfile table is changed. But I don't need or want it...
July 29th, 2004 09:31 AM
by Larry Daugherty Go to last post
4 143
Time always set to 12:00:00 AM by gavin
In Access create a date/time field with format dd/mm/yyy hh:mm:ss ampm In VB.net update field with Now() function. Date appears correctly but time is always...
July 29th, 2004 09:38 AM
by M.L. Sco Scofield Go to last post
1 110
Tracking Inventory by Diana
Hi, I am creating an inventory database that tracks server parts. (Specifically I have 8 servers, the parts within each server vary.) I want the quantity of...
July 29th, 2004 06:33 PM
by Tim Ferguson Go to last post
1 115
Default Value Question by Bill
I am trying to figure out how to set the default value of a field called email. I want the default value to be pulled from the inputed data in a field called...
July 29th, 2004 06:52 PM
by Tim Ferguson Go to last post
1 98
Appending 2 tables by Dennis H
I start with tables x and y. Link DIST and OBS1 I get query1 with a select query. I want to get Query WANTED. I've tried NOT linking. TABLE...
July 29th, 2004 07:31 PM
by Go to last post
1 114
Leading zeros by Lynne
I am developing a database with 135 fields, many of which must output right-justified with leading zeros with the sum of the characters entered and the zeros...
July 29th, 2004 10:11 PM
by Pat hartman Go to last post
2 114
Security-enabled database by See
I am a student trying to convert a secured 97 access database to access 2003. I am having a few problems. First, I was sent a copy of the shared database and...
July 29th, 2004 10:15 PM
by Pat hartman Go to last post
3 219
Indeterminate relationship by Dennis Snelgrove
What would cause a relationship to be "Indeterminate" in Access XP? I've got two tables, and I'm trying to set up a simple One-to-Many relationship. I've done...
July 29th, 2004 10:26 PM
by John Vinson Go to last post
6 202
2 Column Combo Box by Chris
I am trying to create a 2 column combo box using the lookup wizard. But I want whatever field I choose in a column to be saved in the record. If I choose a...
July 29th, 2004 10:28 PM
by Pat hartman Go to last post
1 135
to link or not to link? by Carlee
Hi There, I use lookup tables to allow users a quick pick list. For example, tblLookupColor, tblLookupTestType etc. Typically i create these tables and use...
July 29th, 2004 10:33 PM
by Pat hartman Go to last post
4 126
Is it possible.... by Dan Myers
Hello, I need to know, is it possible to do a find or a search in multiple fields in a table. I've got 4 fields of serial numbers in my table and I am having...
July 30th, 2004 12:05 AM
by RK Go to last post
2 190
negative autonumber by
I have an ID field set to autonumber. The table has a primary key combined of three other fields, ID is not one of them The table is being populated via a form...
July 30th, 2004 03:23 AM
by Jay Vinton Go to last post
2 493
tables with msys* by John Stevenson
I have recently started using Access 2003 and notice that when I make a new database it automatically will add tables that begin with msys (as example...
July 30th, 2004 06:31 AM
by Allen Browne Go to last post
2 153
Validation rule by Ashley
I would like a field in my table to have 5 characters. If the entry have less than 5, a Zero adds to the front of data. If enter 345D. It should correct to...
July 30th, 2004 01:28 PM
by ASP.Confused Go to last post
5 107
Excel field truncated on import...help? by Steve Newton
Hi. I am using Access 2000 to import data from an Excel spreadsheet with the Get External Data command. A couple of the columns in the Excel spreadsheet...
July 30th, 2004 05:19 PM
by Steve Newton Go to last post
1 152
Need a design suggestion by BobV
Hopefully this is the right newsgroup to ask this (and I apologize up front--this is probably going to get kind of long).....it crosses so many lines it's hard...
July 30th, 2004 06:37 PM
by rpw Go to last post
5 438
I have found a efficient way to flirt... by [email protected]
Hello ! I just wanted to answer you that finally I found a very efficient solution to solve my love and flirt problems. Everything is on the site...
July 30th, 2004 07:40 PM
by [email protected] Go to last post
0 132
Post New Thread


Display Options
Showing threads 461 to 480 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 10:51 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.