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
Linked table manager looking at the wrong location by M Skabialka
On a FE/BE Access 2007 database the IT team asked me not to use a mapped drive letter but the server name and path (UNC) when linking tables. I changed the...
June 1st, 2009 01:43 PM
by M Skabialka Go to last post
4 333
appending more than 255 characters into a Memo field by Paul
I'm trying to run an append query that that concatenates data from one Text field and two Memo fields into a single Memo field in the destination table....
June 1st, 2009 05:53 AM
by Paul Go to last post
7 243
Date format in design by acss
I am creating a DB to track invoices and in the future i would like to run queiries or reports that would separate invoices from one month to the other. For...
June 1st, 2009 02:53 AM
by John W. Vinson Go to last post
6 250
Link to mdb on a website by franky
I have a Access 2000 database on my computer and want to create links to another Access 2000 database on a website. Is this possible? If so, how? I've...
May 30th, 2009 10:41 PM
by Chris O'C via AccessMonster.com Go to last post
2 219
Database defaults to open as form... by jcallahan
I have an inherited database, it opens in form view with no toolbar and I can't seem to get it to open in desing view. Any tips? The creator of the...
May 30th, 2009 12:48 AM
by John W. Vinson Go to last post
2 326
Relationships and Form Question by Confused
I'm new at this and trying to do it by the book and would appreciate some guidance on the layout. I have tables (Customers and Contacts) that I related...
May 29th, 2009 02:17 PM
by Fred Go to last post
6 264
Data sheet reversed when it opened by Foster1
I opened by table in data sheet view and it is backwards. The table is ok. How do it get it to go back?
May 29th, 2009 04:57 AM
by fredg Go to last post
1 188
Need to un-Normalized by Anthony Fontana
I am not sure if this question has been asked, or even if this is the correct forum, but I'll have a go at it anyway. I understand the benefits of...
May 28th, 2009 10:43 PM
by Steve[_70_] Go to last post
7 217
One field, multiple e-mail addresses - mail merge? by Ryan P[_3_]
Hi, I'm designing a database to keep track of my agency's volunteers - we were using an outdated Excel spreadsheet before and a hack-job of a Word document...
May 28th, 2009 02:26 PM
by Bernard Peek[_3_] Go to last post
6 257
New key fields? by PayeDoc
Hello All I have a table that already has an autonumber key field called , which must be retained. For reason I won't bore anyone with, I now need to add...
May 28th, 2009 02:19 PM
by Bernard Peek[_3_] Go to last post
3 202
Table Setup & Normalization by toolman74
I recently got the suggestion to create a Contacts table which would have ALL names & addresses in it - whether it's our employee, our vendor, or our client....
May 28th, 2009 06:25 AM
by toolman74 Go to last post
4 189
Relationships, back end by Len B[_2_]
Hope this is the appropriate group to ask. I have two general questions and one a bit more specific. (a) Are relationships defined in the back end effective...
(Multi-page thread 1 2)
May 28th, 2009 03:50 AM
by tina Go to last post
14 352
Access Pivot Chart by [email protected]
Hi Everyone, I recently created a pivot chart (line graph style) with the results of a union query. (My new query contains assets for multiple businesses by...
May 27th, 2009 09:50 PM
by [email protected] Go to last post
0 212
Sentence Case by madarame
Hi there. I'm designing a database and I would like to add a feature in the database where surnames entered in the table should be converted automatically to...
May 27th, 2009 12:35 AM
by Jeff Boyce Go to last post
2 158
search field by Bob76
my "Search" field at the bottom of the database is partially covered by the horizontal scroll bar..How do i move the partition bet "Search" and horizontal...
May 26th, 2009 05:45 PM
by Clifford Bass[_2_] Go to last post
1 127
Subdatasheet Name keeps resetting to [Auto] by Paul
I have been told that you can improve performance of an Access database by turning off the Subdatasheet Name property of the tables that don't require this...
May 26th, 2009 03:57 PM
by AG[_3_] Go to last post
6 315
can you count and retrieving by periods? by Logsheet pencil pusher
I have report data that I want to retrieve by periods for specific locations. Each report period is six months in length, and I want to retrieve location...
May 26th, 2009 02:58 PM
by Logsheet pencil pusher Go to last post
2 186
updating data from a read-only linked table without creating a new table by Paul
I need to run some update queries nightly where the sources are read-only tables in SQL Server. However, it seems that if any of the underlying tables in a...
May 26th, 2009 02:19 PM
by Manoj Rai Go to last post
5 171
Access or Excel - which is the way to go for my project? by CB
Hi all, This is the first time in almost a decade that I’m creating a database from scratch. I don’t think I normalized my last one properly so I’m...
May 25th, 2009 08:05 PM
by tina Go to last post
7 149
Problems with removing relationship by Brad
I am running into a strange problem with Access 2007 table relationships. Earlier, I set up a relationship between our Customer table and a state table...
May 24th, 2009 10:01 PM
by Brad Go to last post
4 169
Post New Thread


Display Options
Showing threads 1121 to 1140 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:48 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.