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
make the default value the current date/time by andrew
does anyone know what expressions to use when making the default value of a date/time field to the current date and time ? thanks in advance.
May 12th, 2004 05:55 AM
by andrew Go to last post
2 518
Autonumber foreign keys and subforms by Ed Havelaar
Hi, Hope someone can help. Here's the scenario: I have two MSAccess tables MainTab and SubTab. MainTab has an autonumber 'id' column as primary key. ...
May 12th, 2004 07:34 AM
by John W. Vinson Go to last post
3 855
tempmsysaccessobjects by Chris B
When I try to compact my db I get an error that says my table tempmsysaccessobjects already excists. How do I fix this? Chris
May 12th, 2004 07:38 AM
by John W. Vinson Go to last post
1 305
How to update a field with the value from another table? by Chris
Hi, I would like to know how to update a field with the value from another field from another table? For example: I have Table1, StatusField. and Table2,...
May 12th, 2004 09:28 AM
by Chris Go to last post
2 533
Remove leading 0's from Text field by Bruce
I have a text field with leading zeros. Is there a way to strip these off in Access 2000. thks Bruce
May 13th, 2004 12:03 AM
by John Vinson Go to last post
3 460
Can I format a Linked Table by Sarah W
Hi Guys Here is the scenario. I have linked a table from a SQL database to MS Access. There is a text field in that SQL database table which carries more than...
May 13th, 2004 01:04 PM
by Jeff Boyce Go to last post
2 431
increasing amount of text allowed in field by Larry
I'm trying to increase the amount of text allowed in a field..... I've increased the size of the field but I'm limited to approx. 1/3 of the field for text.
May 13th, 2004 07:36 PM
by Larry Go to last post
4 603
Validation Listing by Marv
I am sorry I caused confusion with not explianing it fully. First what I have: Table 1 has a full listing of data. I work off this listing, so if there is a...
May 13th, 2004 08:42 PM
by Marv Go to last post
2 346
At-your-survey db. Using a temp table for customised forms. by Jesper F
Dear everyone and Mr. Hookom, I have a questionaire db much like the "At Your Survey" db. I'd like to have customised input forms for each questionaire as...
May 14th, 2004 12:08 AM
by Adrian Jansen Go to last post
1 445
Changing a back-end database from code by Miguel A. Velez
I'm making some changes to a Ms Access 97 application. In order to support some functionality changes, I need to make a couple of changes to the structure of...
May 14th, 2004 02:16 AM
by Jeff Boyce Go to last post
4 411
Using camera to insert image object! by Neil
I have updated office to office XP & in the selcetion drop down list of XP of insert object when using Access it no longer offers insert "Image Object" which...
May 14th, 2004 07:10 AM
by Neil Go to last post
0 723
Linking Date Fields by Nicci
I have a date field. I want to link it to another date field so when a date is entered in the first date field, a date one month later is shown in the second...
May 14th, 2004 01:00 PM
by Jeff Boyce Go to last post
2 422
Access links by PI
How do I link a command button to an access report?
May 14th, 2004 01:08 PM
by Jeff Boyce Go to last post
2 279
How do you print reports from selected check boxes in a form that is related to one record? by Ray
How do you print reports from selected check boxes in a form that is related to one record?
May 14th, 2004 01:09 PM
by Jeff Boyce Go to last post
1 666
create table based on two tables. by brigid
I have two tables, some of the fields are the same in both tables. I would like to create a table that shows the common field, and which includes data from...
May 14th, 2004 01:11 PM
by Jeff Boyce Go to last post
2 733
Need help changing a excel sheet to a access DB, NOT Linked by Greg
Hi ; I could use a tip here. I need to convert a Excel spreadsheet, single page, 10 fields, approx 700 records into a MS Access standalone database... as if I...
May 15th, 2004 01:52 AM
by Jeff Boyce Go to last post
3 642
Database will not allow more than one user. by Chaplain Doug
Access 2002. This error just started happening. It happens with all my databases. When a second person tries to open one of my databases (.mdb), and another...
May 15th, 2004 01:53 AM
by Jeff Boyce Go to last post
3 259
Considering using Access by Joe Rivera
I own and operate a taxi company in CT and need to computerize my operation. A friend has suggested using access to store our accounts, reservations, print...
May 15th, 2004 03:47 AM
by TC Go to last post
7 392
Multiple Many-To-Many Tables by Tom
Hello, I am familiar with using a junction table for a "many-to-many" relationship. However, I'm not exactly sure how I could string multiple "many-to-many"...
May 15th, 2004 03:47 AM
by TC Go to last post
7 2,159
Best Option for Table Design by MT DOJ Help Desk
Access 2000 I've been working on a small flashcards database as a learning project. I have the following 2 tables: Side A - Contains the text for side A of...
May 15th, 2004 04:14 AM
by Adrian Jansen Go to last post
3 399
Post New Thread


Display Options
Showing threads 101 to 120 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 12:19 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.