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...
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...
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...
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...
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....
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 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...
Mike- Who taught you? Courses: Start a new query on tblStudentGrades. Add the tblCourses and tblCourseExams tables. If you defined the tables correctly...
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...
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...
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...
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...
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)....
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...
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...
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....
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...
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....
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...
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...
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 ...
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 ... ...
Glad I mentioned it then :) ... From: "asorin_ca" <asorin_ca@...> To: <ms_access@yahoogroups.com> Sent: Thursday, February 03, 2005 9:41 PM Subject:...
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...
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....
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...
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...