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
How to compute partial sums? by Siegfried Heintze
I have a bunch of restaurant receipts in a database and I want to sum all the items of each receipt. Each row of the result set would be a receipt number and...
December 18th, 2007 08:18 PM
by Dale Fye Go to last post
5 132
How to select only most recent records? by Siegfried Heintze
I have a table implementing the time sheets. Each row contains a worker's name (text, primary key), start time and stop time (date/time). This is updated...
August 18th, 2006 04:38 PM
by KARL DEWEY Go to last post
4 74
How to query on differences between times by Siegfried Heintze
I have a table with fields called start and stop of type date/time. These represent the start and stop times various scheduled tasks. How would I write an sql...
April 26th, 2006 12:59 AM
by '69 Camaro Go to last post
2 97
Long (403 character) URLs stored in hyperlinks? by Siegfried Heintze
I'm using perl to store urls in fields of type hyperlink. It seems that it truncates them to 255 characters. Is this a problem with the perl DBI or MS Access?...
September 19th, 2005 11:37 PM
by Douglas J. Steele Go to last post
1 95
How to delete table contents and reset autonumber counters by Siegfried Heintze
When I delete my table contents (but not the table definitions) the auto number counters are not reset. Is there a way to reset them? Thanks, Siegfried
September 7th, 2005 05:22 AM
by Allen Browne Go to last post
1 149
How to implement JobTitle:JobPosting Relationship? by Siegfried Heintze
I want to establish a one to many relationship where multiple JobPostings share a common JobTitle. This is to implement the user interface where the user can...
September 6th, 2005 05:12 PM
by Siegfried Heintze Go to last post
9 145
How to programmatically edit table and column comment fields by Siegfried Heintze
How do I write a program to CRUD (create, read, update & delete) comment fields in columns, tables and other entities? Thanks Sieg
September 7th, 2005 03:46 PM
by Allen Browne Go to last post
7 253
How to implement many-to-many? Do I need primary key defined? by Siegfried Heintze
If I have table student and table classes (1) What is your favorite naming convention to creating the many-to-many table that holds the foreign keys for...
September 2nd, 2005 03:46 PM
by Siegfried Heintze Go to last post
7 109
How to automate creation of database? by Siegfried Heintze[_2_]
The following code results in "No Such interface supported". What am I doing wrong? I'm trying to create an Access database. thanks, Siegfried ...
June 12th, 2008 02:46 AM
by Allen Browne Go to last post
1 65
Wanted: help with minimal ADO.NET in VS 2008 by Siegfried Heintze[_2_]
I have created a simple three column database where the first column is auto-increment. Can someone help me change my program so that it reads the entire...
June 18th, 2008 09:31 AM
by Stefan Hoffmann Go to last post
4 75
automatically create primary key by concatonation? by Sienna
In my table tblLandLocations I want to create a field that I would use as a primary key, but that takes information entered into other fields and then...
June 6th, 2009 10:06 PM
by Armen Stein Go to last post
2 112
Upper Case by sierralightfoot
In design view, in an access table, under format a text field: What is the expression ( like "" that forces capitalization) to forced upper case for the...
June 28th, 2007 04:14 PM
by sierralightfoot Go to last post
8 106
validation rule for time field by signal2182
We have a SQL database using Access project files to run forms etc. There is a field where the user must enter the time. The time must be either :15 or :45...
June 8th, 2006 09:06 PM
by KARL DEWEY Go to last post
1 64
splitting field into 2 by Sillie_J
I am working with Access tables given to me by a client and incorporating their data into a larger database. The old tables have the first name and last name...
January 7th, 2006 02:19 PM
by nanne Go to last post
4 73
images AND text on command buttons by Sillie_J
Hello, Is there a way to put a .bmp image AND text on the same command button? The captions property has text in it, but when I place a .bmp image into...
August 13th, 2005 12:14 AM
by Duane Hookom Go to last post
1 80
Access Photo Image Database by Silver76
Hey Guys After doing countless hours of design for an access image database for roughly 5000 images and climbing. I wanted to include a thumbnail of each in...
February 21st, 2007 01:12 AM
by Damian S Go to last post
1 64
Creating a database for my images by Silver76
Hi folks i am trying to locate a template in order to catalogue my photos. I have a bout 5000 images and want to insert Thumbnails which reference back to...
February 6th, 2007 05:11 AM
by Don Go to last post
2 55
Basic Database Design by Silvex
Hi people. I am attempting to develop a new database and I’m new on Access. It will work (I hope!) like this: Database has 4 Tables: tblCategory...
(Multi-page thread 1 2)
July 24th, 2007 04:50 PM
by LauriS Go to last post
11 288
Database Design by silvex
Hi! I'm trying to make a Database for registration of my clients, and I'm stucked in one code. (I'm a "rockie" on the Access, unfortunately not like Hamilton...
July 17th, 2007 12:02 AM
by silvex Go to last post
2 80
Designing a patient management by Simba
Being a newbie to access, I have been given a task of creating a db for the patient management and tracking. This DB will have around 50 patients per year....
March 10th, 2010 07:26 PM
by Simba Go to last post
4 219
Post New Thread

Display Options
Showing threads 10001 to 10020 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 06:18 AM.

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