Search the web
Sign In
New User? Sign Up
ms_access · Help and advice for users of MS access
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 16862 - 16891 of 21712   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
16862
Hello all. I have a table named B401 MHC READINGS. The are COLUMNS with DATES as FIELDNAMES. I am calling a date from a query that works fine. I am trying...
Steve Shakeshaft
an_old_old_f...
Offline Send Email
Feb 1, 2005
4:59 pm
16863
Steve- No can do. Any row source you reference in the SELECT clause (unless it's in a Subquery) must also be in the FROM clause somewhere. ...
John Viescas
jlviescas
Offline Send Email
Feb 1, 2005
5:09 pm
16864
Thanks again John, Since I am likely the only one to use this database, I guess I'll chance it :) I'll just be sure to back it up often! Thanks again, -Roger...
Roger W
ready_roger
Offline Send Email
Feb 1, 2005
9:29 pm
16865
Salam to every one any body can help me regarding calculatin the balance in table Query Form ?????? how we can calculate auto this balance this is example only...
smuhammadaslam
Offline Send Email
Feb 2, 2005
8:32 am
16866
Greetings! Many webmasters and software companies already use outsourcing to increase their income. Try it one time and you will like it! Post your project for...
Rajesh India
rajeshaffil
Offline Send Email
Feb 2, 2005
10:51 am
16867
Thank you John, you have confirmed what I first thought. But I *thought* there may have been a neat way to interpret the *value* of a field as a column name....
Steve Shakeshaft
an_old_old_f...
Offline Send Email
Feb 2, 2005
1:48 pm
16868
Your first entry should show a Debit of 2000 to establish the opening balance. Then calculate the balance for each row like this: SELECT [Date], Description,...
John Viescas
jlviescas
Offline Send Email
Feb 2, 2005
2:15 pm
16869
John Thanks for all your help! Now I am stuck, I must have been taught all this stuff wrong to begin with. I need a query to calculate each indv average and...
mathews_mi
Offline Send Email
Feb 2, 2005
3:32 pm
16870
Mike- Who taught you? Courses: Start a new query on tblStudentGrades. Add the tblCourses and tblCourseExams tables. If you defined the tables correctly...
John Viescas
jlviescas
Offline Send Email
Feb 2, 2005
4:14 pm
16871
Wow, that is all semi-clear to me now, since it is all fairly new. Some foreign guy at the University of Central Florida was my instructor. I couldn't really...
mathews_mi
Offline Send Email
Feb 2, 2005
5:20 pm
16872
Aslam, Similar topic came up in another forum. You might find the desired feature covered in my sample db named RunningAccount. It is available at Rogers...
A.D.Tejpal
adt_y
Offline Send Email
Feb 2, 2005
5:40 pm
16873
I am not a programmer but have in the past created some "basic" access data bases. I am interested in creating a small database to keep track of my collection...
bottlesnmore
Offline Send Email
Feb 2, 2005
10:11 pm
16874
Dear Bottles- The most efficient way is to use a text field to store the path to the picture on your hard drive. But you'll have to write a bit of code to...
John Viescas
jlviescas
Offline Send Email
Feb 2, 2005
10:29 pm
16875
Use an image control. Set the Picture Type Property to "Linked". You will need some sort of default image (I use one called "error.gif" in the example below)....
Guy Harley
guyharleyaus
Offline Send Email
Feb 2, 2005
10:31 pm
16876
Question: Does anyone know how to deleat a replicated database file within Office 2000? I went ahead and created a new database from the replicated one and it...
Donna
dfwtcm
Offline Send Email
Feb 3, 2005
12:53 am
16877
Going a little off topic, there is a superb freeware php script available called "Gallery" available on the web. If you like the sound of a web solution for...
Steve Shakeshaft
an_old_old_f...
Offline Send Email
Feb 3, 2005
8:39 am
16878
Hi Everybody, I exported a table into another DB and I noticed that I lost a few entries. Any help how I could restore the table without re-entering the data....
asorin_ca
Offline Send Email
Feb 3, 2005
5:45 pm
16879
Get with your data admin to see if he has a back up. asorin_ca <asorin_ca@...> wrote: Hi Everybody, I exported a table into another DB and I noticed that...
Lonnie Johnson
prodevmg
Offline Send Email
Feb 3, 2005
6:44 pm
16880
Did Access display any error messages when you exported the table? If not, the entire table should be there - unless the original was corrupted in some way....
John Viescas
jlviescas
Offline Send Email
Feb 3, 2005
7:32 pm
16881
No error message. I did not try again and have no intention, what if I loose more data? The data was lost from the original table, sorry for not specifying...
asorin_ca
Offline Send Email
Feb 3, 2005
8:52 pm
16882
Export won't delete records. Something else happened. You could try copying the table to a new name (select the table in the DB window, click copy, click...
John Viescas
jlviescas
Offline Send Email
Feb 3, 2005
11:45 pm
16883
Do you know for sure that records are missing, or are you just assuming they are because the ending value for an autonumber field has changed? If you ...
Mike Bisson
erpguruwannabe
Offline Send Email
Feb 4, 2005
12:39 am
16884
You are right, I am just assuming because I got a smaller autonumber after the action. I will try this. Thanks ... assuming they ... If you ... field in ... ...
asorin_ca
Offline Send Email
Feb 4, 2005
2:41 am
16885
Glad I mentioned it then :) ... From: "asorin_ca" <asorin_ca@...> To: <ms_access@yahoogroups.com> Sent: Thursday, February 03, 2005 9:41 PM Subject:...
Mike Bisson
erpguruwannabe
Offline Send Email
Feb 4, 2005
1:46 pm
16886
I am trying to create a combo box that is filtered to list only those items that are related to an item that is selected in a previous combo box. I followed...
AitkensS
Offline Send Email
Feb 4, 2005
5:43 pm
16887
Follow this link to examples of cascading combo boxes: http://rogersaccesslibrary.com/TableOfContents3.asp#C Ed Tesiny EdTesiny@......
Tesiny, Ed
eptept50
Offline Send Email
Feb 4, 2005
6:37 pm
16888
I have form that runs a process using DAO recordsets. I have built a progress bar on the form. This progress bar has worked with other recordset processing....
Lonnie Johnson
prodevmg
Offline Send Email
Feb 5, 2005
1:53 pm
16889
Also posted in MS_Access_Pros: Lonnie- If you're doing a lot of heavy processing in DAO with transactions enabled, DAO might not be releasing the CPU to Access...
John Viescas
jlviescas
Offline Send Email
Feb 5, 2005
2:30 pm
16890
Aitkenns I have used that functionality before and I posted a database in the files section that shows how I did it. The name of the file is "Combo Box...
Sean
sean48_48
Online Now Send Email
Feb 5, 2005
5:15 pm
16891
How do I do SUM in a field query? I've forgot...
ucooven
Offline Send Email
Feb 5, 2005
8:19 pm
Messages 16862 - 16891 of 21712   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help