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
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
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
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
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
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
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
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
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
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
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
Removing Lookup Field from Table by Grant
Running Access XP How does one remove a lookup field from a table. I have gone into the relationships area and there are no relationships visible. Go into...
May 12th, 2004 04:49 AM
by Jeff Conrad Go to last post
5 592
dates by
hi everyone! does anyone know how to filter a recordset for a specific date. for example. i keep some dates in an access database of cpr training. i am making...
May 12th, 2004 01:56 AM
by Grant Go to last post
2 686
Table Design - Input Mask by Cheval
This is not a drop dead issue, yet is there a way to remove empty input mask entries or old ones that have been created? I've seemed to have collected a few...
May 12th, 2004 12:25 AM
by Cheval Go to last post
0 717
Table History for Newbie by MadCrazyNewbie
Hey Group, I have a table with the following Feilds: MobilePhoneID, PrimaryUser, DepartmentID, CallOptions, MobileNumber, SDC, GPRSTarrif (Lookup to Another...
(Multi-page thread 1 2)
May 11th, 2004 11:36 PM
by rpw Go to last post
16 789
Input Mask not working ? by TonyB
Hi, I have an input mask on a text field in an access 2000 table, which is very simple LL\ 00\ LLL (Three groups of characters, 1st letters, 2nd numbers,...
May 11th, 2004 11:26 PM
by Corrina Burnley Go to last post
4 730
Lines of data by Lisa
I have a user who needs to put up to 25,000 lines of data in a table a year. We will be generating weekly and montly reports from this database. They have...
May 11th, 2004 11:05 PM
by Eric Butts [MSFT] Go to last post
1 313
Error on opening Table by Sherrie
I set up a temporary table to be able to copy names & values via the internet to excel and then into my database. I only used it once, and now whenever I...
May 11th, 2004 10:51 PM
by Eric Butts [MSFT] Go to last post
1 429
not DMAX or MAX by rpw
hi everyone, sorry for the length of this post, but before i state the problem, i'd like to provide enought support info. here's the layout of the db - i've...
May 11th, 2004 07:46 PM
by rpw Go to last post
4 727
Unable to update field in a linked table by Ted
I have a database that is entirely dependant on an Excel workbook and 14 worksheets through linked tables. The spreadsheet is used to forecast needed...
May 11th, 2004 07:31 PM
by Ted Go to last post
2 519
Validation linking by Marv
Right now I have two forms/tables in ACCESS. The first is my working table... the second is a table I import from HQ that says what my current seat order is. ...
May 11th, 2004 05:53 PM
by Tim Ferguson Go to last post
1 305
Post New Thread


Display Options
Showing threads 11501 to 11520 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 01:16 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.