I have inherited an Access project from a former employee. My school currently keeps all grades in an Access program. Right now we just assign numerical values and those are turned into grades (I cannot actually find this table). Overall it works well, however, we now have classes where we need to input Pass/Fail and Audit.
View RepliesPlease Help
I am new to this place
Developing Asp pages in Dreamweaver MX 6
In Access, 4 fields
ID( AutoNumber), A(Number), B(Number), Tot(Number), Result(Text)
After entering numbers in A & B, how to input total automatically
Can I set something in the Default Value in the properties of Tot
Like =A+B
Whats the code ?
Next, If the Tot > 25, I want to display "Fail" in Result otherwise "Pass"
Yours friend Anish from INDIA
vu3apq@hotmail.com
I have about 20 columns in a query and each row is a customer.
The columns are either pass/fail but are text fields and not a yes/no set up. I want to get the percentage of a pass in the column.
Hi Forum,
I am trying to create a access database system which will show classes, students, attendance, progress report, teachers, departments etc...
i have repeatedly failed in accomplishing this database as i dont have the knowledge.
the place that i get messed up is for example the attendance, i want it so that i can select a date and then all the students associated with that class showup. so 1 date and a list of student only on that class.
another problem was adding a progress report for every class and individual students.
this is for a community based school which teachings on saturdays, there are over 15 volunters who do not get paid to teach but are still willing to give something back to the society.
i beg you guys out there, you all are geniuses!!! please help us design this simple system. please if somebody already knows where i can get a system like this free of charge then let me know ASAP!
I would like to thankyou in advance for reading thins messge.
Hi Forum,
I am trying to create a access database system which will show classes, students, attendance, progress report, teachers, departments etc...
i have repeatedly failed in accomplishing this database as i dont have the knowledge.
the place that i get messed up is for example the attendance, i want it so that i can select a date and then all the students associated with that class showup. so 1 date and a list of student only on that class.
another problem was adding a progress report for every class and individual students.
this is for a community based school which teachings on saturdays, there are over 15 volunters who do not get paid to teach but are still willing to give something back to the society.
i beg you guys out there, you all are geniuses!!! please help us design this simple system. please if somebody already knows where i can get a system like this free of charge then let me know ASAP!
I would like to thankyou in advance for reading thins messge.
I am developing database for my school. I am done with everything except the examination aspect where i need to indicate students position in every subject beside their overall position according to the sum of all the subject scores. How to indicate student position in subjects.
View 2 Replies View RelatedHello forum!
Im pretty new to access and im trying to create a database for the company i work at so that to begin with they can log details on all hardware they have.
See the image attatched, at the moment i wish to store details on there computers and also on other hardware is it ok sofar?
http://img210.imageshack.us/my.php?image=erd9xa.jpg
Hi,
I have discovered a problem with my database and wonder if anyone here can point me to the best solution...
The problem is this... when I took our company database over about 3 years ago it was around 45MB... now it is almost 350MB and growing steadily.
I have today discovered the main cause of this... the audit trails on a couple of the tables. If I remove these 2 fields only from the database it cuts it down to under 100MB. The Audit trail is quite important for us and so I'd like to keep it if I can. It is stored in a memo data type (the data is well over the 255 char limit of a text box). Is there any other better way to store this data or is there anything I can do to reduce the size of the memo data type?
Any advice would be greatly appreciated!
I am trying to create a simple audit trail (which I got directions online) in my Database (and have posted a copy here) but am getting an error on the second form (and this will be a subform eventually) -The Audit Trail instructions say to put four fields in my table which feeds the form - CreateBy=Text, CreateDate=Date/Time and default to =now(), ModBy=text, and ModDate=Date/Time.
Then to add code to the Current and BeforeUpdate events on the form as you will see in my forms attached. I created a test database with very little data (called AuditTrackingTest2DBLp-attached). I created the first table (tblCustomers) and then created the form (FormCustomerInput) and then I added code to this form on the Current and BeforeUpdate as I was instructed in my notes and it recorded my changes perfectly in the tblCustomers.
I then created a new table called tblCustomerOrders and then a form (FormCustomerSubOrders) based on this table and added the same code to this form and it is giving me an error message in the code Compile Error: Variable not defined.
Is there way a to get this audit trail module to work with a form in Datasheet view? It works fine with a form in Single Form view; I can open the table where the audits are saved and everything looks good. But when implemented on a form in datasheet view, nothing happens. I don't get any errors and nothing is saved to the audit table.
Link : [URL] ....
Here's the vba code:
Sub AuditChanges(IDField As String, UserAction As String)
On Error GoTo AuditChanges_Err
Dim db As DAO.Database
Dim rsT As DAO.Recordset
Dim ctl As Control
Dim datTimeCheck As Date
Dim strUserID As String
[Code] ...
You call it in the BeforeUpdate event like so:
Code:
Private Sub Form_BeforeUpdate(Cancel As Integer)
'Track all changes made to the record
If Me.NewRecord Then
Call AuditChanges("Asset_ID", "NEW")
Else
Call AuditChanges("Asset_ID", "EDIT")
End If
End Sub
I have a button on my main db, that opens a second db using hte following code:
----------------------
'Dealing with external objects, use inline error trapping
On Error Resume Next
Dim appAccess As Object
Dim db As Database
Dim strAppPathName As String
Dim strAppName As String
Dim strTimesheetPathName As String
[Code] ....
This code works great to open the other db, and handles wheter the other db is already open or not, but I cant seem to pass the variable to the other db using the startup switch /cmd.
I suspect if I used the shell method it would pass the cmd , but I havnt found any way to test if the db is already open with the shell method.
How can I pass a variable to the other db when opening it using VBA?
Good afternoon, I have a form with a subform and in the first txtbox of the subform in the GotFocus event I have a little procedure which checks the txtboxs on the parent to make sure that there is data in all four of the txtboxes. This works great the first time and it pops up a msgbox and it even setsfocus on the txtbox with no data in it, but if I tab into the subform a second time and there still is no data in one of the txtboxs on the parent form, nothing happens, no message and no setting focus on the txtbox with no data in it. Does anyone know of a way to get this procedure to re-set everytime a user tries to enter the subform? Thank you in advance to anyone offering and ideas and suggestions.
View 8 Replies View RelatedHi all
I am new to this forum and to Access. I have expierience with visual basic.
I am making a program in access for saving data when someone borrows something from you, to keep track of all your borrowed stuff.
Here are my questions.
1) How can I write code for buttons to change the records (movenext, movelast,...) + how can I change the current record? + how can I control a scrollbar via code?
2) How can I change the current recordsource via code and how can I run previously made query statements via code?
3) How can I change the ShowDropButtonWhen property from a combobox via code?
4) How can I control a FlexGrid via code?
5) How can I open another Form with a press on a button via code?
6) How can I save and load an OLE/object image and how can I show them via an ActiveX control?
Thats about it folks
If anyone can point me in the right direction or can give me an example database, I would be very happy:)
Greetz
Frederik
Hi,
I am responsible for creating a database for a school project, and am having some problems relating the two tables of the database together. Please keep in mind that I have no prior Access experience, and know very little about the program. Here is my situation, any help would be greatly appreciated:
Taking the perspective of a product vendor in a store (i.e. selling soda to a grocery store), I am trying to create a database which allows me to run a query for authorized products in certain stores. I have a products table which has all available products the company sells, and then I have a Stores Table for the different stores which carry the company's product. I want to know how to set up and join each table so that if a certain product is not authorized in a certain store, it will not show up in a query.
Again sorry for the shallow description, any help would be greatly appreciated.
Thanks,
Help! I am trying to think of a way I can use an excel worksheet as a data form in Access. A little background to the problem. A pre-school that I have been helping have a excel spreadsheet in place that they use as a kind of booking register which also works out the termly costs for each child based on the number of sessions attended. Is there any way I can inport or link this to a database so monthy invoice's and goverment figures can be printed automatically.
View 1 Replies View RelatedI have a database that I previously ran successfully on a Windows XP system. I recently received a new PC with Windows 7 Enterprise (32 bit) that is having issues with running queries from the same database. I am still running the same version of Access (2003) on the new laptop but the queries seem to stall out and Access becomes non-responsive. Can switching from one operating system to another cause this issue? I am really just starting to use Access, so I am a novice at troubleshooting and thought that I would ask this question before digging deeper.
View 6 Replies View RelatedIf I use this INSERT it works fine :
Code:
strSQL = "Insert into tblParkeerbeheer_log select * from parkeerbeheer where [ID] = " & Forms![parkeerbeheer]![fldID].Value & ""
DoCmd.RunSQL strSQL
But if I want to do the same with multiple records with Pnummer (personell number) as criteria in the WHERE clause :
Code:
strSQL = "Insert into tblParkeerbeheer_log select * from parkeerbeheer where [Pnummer] = " & Forms![parkeerbeheer]![Pnummer].Value & ""
DoCmd.RunSQL strSQL
It asks me to prompt the personell numer, while that number is present within the prompt box
OK I'll start by giving some background detail. This is my major project and I am creating a system for the school library. I am using Microsoft Access 2003. I have made a query and my end user will type in the date that a book is loaned out. My database then automatically fills in the duration it is loaned for, the date is due back. What I hope someone on here can tell me is:
Can I get the current date on my database. So that it updates all the time to always keep the current date. Then I can make it automatically work out how many days late the book is (if it is).
Anyone who can answer this question or point me in the right direction is a hero!
Thanks, Michael.
EDIT: OK I have found how to make the late field update automatically. Late: Date()-[DateDue]. But surely if it can do this and know the current date for use in an equation it can display the current date? Anyone know how to do this?
Hey guys,
I am designing a library system for an A2 project and i was just wondering if i could have a validation rule to prevent a copy from bieng borrowed if there was allready a record for a book in the database with no value for returned field. (meaning it hasnt been returned and its currently out) Im pretty noobie at access
LOAN__PUPIL_COPY___BORROWED_____Returned
100001 1001 10001 17 November 2004
100002 1002 10002 20 November 2004
100003 1003 10003 17 November 2004
100004 1004 10004 18 November 2004
100005 1005 10005 20 November 2004
100006 1006 10006 20 November 2004
100007 1007 10007 20 November 2004
100008 1008 10008 20 November 2004
100009 1009 10009 20 November 2004
100010 1010 10010 20 November 2004
This is how it looks at the moment. Im not sure where you would add a validation rule. The records in this table will be kept, and when a book is returned a date is added to the returned field. MANY thanks for anyones input, ive been brain storming it for weeks but i dont think i can do it without any code of some some sort.
Fenny
I have an Access database update process that is run from the Win7 scheduler. I have attempted to instantiate or reference Outlook and send an email indicating the status of the process.
Outlook fails for some reason, but it works fine interactively regardless of whether Outlook is running or not.
I am now thinking of trying SendObject instead.
I split my database into a FE and BE to simplify the upgrading of the clients copy. I had a chance to implement that change today and except for this error all seems to be well.
The error is "Invalid Operation 3219 " and flags this line of code "Set rsTable = dbsCurent.OpenRecordSet("Import650tbl, dbOpenTable, dbAppendOnly) " when the error is triggered. The table Import650tbl is a temporary holding table to which I enter imported records. I then add some supporting information and then the records are added to live data table for further processing. After the data is added to the live table the information in the Import650tbl is deleted by a query to be ready for tomorrows processing.
This error prevents the process from working. I got around the problem by deleting the link to the BE for this table and creating the table in the FE. After that all was well.
Question: Why does the above OpenRecordSet fail on the linked table?
In short, I want to know which records fail to append based on violating the primary key. (Win 7, Access 2010 32bit) Similar to how Access creates import table errors, but for append violations...
The DB takes a daily data dump. Failures to append (in this DB) indicate a status of "complete" that needs to be re-examined. (A true complete will not be present in the daily file). The daily file also contains all new daily work, thus it isn't just a list of "completed" tasks to re-examine.
I have a report that needs to be set up in 2 columns using the school year, 2012-2013, 2013-2014, etc. My issue is this. The columns go down the page and continue on the right side for column 2 in the correct order. Is there a way to have the columns break for the school year?
I currently have this:
2012-2013 2014-2015
2012-2013 2014-2015
2012-2013 2014-2015
2013-2014 2015-2016
2013-2014 2015-2016
I need this:
2012-2013 2012-2013
2012-2013
2013-2014 2013-2014
2014-2015 2014-2015
2014-2015
2015-2016 2015-2016
I am trying to create a report which is basically a School Certificate. The requirement is that I need to print the Issue Date, means the current system date be printed in ENGLISH WORDS rather Alpha-numeric format, i.e.: instead of 11 Mar 2012, I need some thing like this: Eleven March Two Thousand and Twelve.
View 4 Replies View RelatedI have a data base in which there is a table where each record describe properties of one fishing trip. The first column in the table is a number (unique but not autonumber format) and I already made 10,000 records with only this index number . Now me and others in my lab are entering data to this table for each of the records.
The data entry is done using form which show one record at a time (lets call it "sail_info_F").
I made another form which has only two elements:
1. text box in which I enter a number
2. button which opens the data entry form ("sail_info_F") showing the record with the same index number as the number I enter on the text box.
(the code for this button is "DoCmd.OpenForm "sail_info_F", , , "[RECORD_NUMBER]=" & Me.TEXT_BOX_NAME"
So far so good and it does open the form in the wanted record. BUT when the form opens I can't use the buttons I have placed in this forms which move between records. Those were made with the wizard, and are working OK when I open the form directly without using the second form (The one which opens "sail_info_F" on a specific record).
Most of the project is done...I am stumped on calculating a field for the report...any help is greatly appreciated..thanks so much.
Use a Microsoft Access database to create the tables and column headings show in Figures 1-3 and discussed in the Background section. Create the tables in the design view. Populate the tables with the data as shown. Make sure you create a composite primary key field for the ORDERS table. The key should consist of the fields Invoice Number and Product Number to allow customers to order more than one item.
Customer
Customer NumberCustomer SchoolCustomer StreetCustomer CityCustomer StateCustomer ZipContact Name
105Central High123 Main StreetDenverCO80208Mary
107Central Middle35 South ParkDenverCO80278Sue
423JKF Elementary69 5th AvenueCheyenneWY90200Pat
516Toddler Time8000 ParkwayFt. CollinsCO80487Jan
799Georgetown High819 Rt. 909BoulderCO80303Jack
Product
Product NumberProduct NameProduct Price
10001Paper Plates$10.00
10002Paper Cups$20.00
10003Plastic Knives$18.00
10004Plastic Glasses$25.00
10005Paper Napkins$12.00
Orders
Invoice NumberCustomer NumberProduct NumberDateQuantity
1107100019/24/20054
21071000310/3/20053
31071000510/3/20055
44231000511/4/20054
57991000111/15/200510
67991000211/15/20052
Now establish relationships between your tables.
Creating Queries and Reports
Creating a Select Query
The owner wants to find out how much of each product is selling for the date ll/15/2005. Develop a query in the design view to give that information using the headings Date, Product Name, and Quantity. Save the query as Today’s Sales.
Creating another Select Query
Tomorrow, the owner is going to be in Denver, CO, and she would like to call on the customers there personally. Make a query to display the contact name, school, and street address ONLY for those schools in Denver. Save the query as Denver Schools.
Generating a Sales Report
Finally, make a report to show the dollar amount sold to each customer for each product. To create the report, you will need to:
•Make a query first and then bring that query into the Report Wizard.
•The query will contain a calculated field for Total Owed.
•The query should show the fields Customer School, Customer City, Date, Product Name, Quantity, and the calculated field, Total Owed.
•Name this query “Report Data”
•The report will be grouped by Customer School and Customer City, with subtotals for each school’s sales and a grand total.
•Make sure you delete any bogus total lines, and make all appropriate fields currency.
Deliverables
Three tables
Query output: Today’s Sales
Query output: Denver Schools
Query output: Report data
Report: Current School Sales
Defined relationships (I can press the relationships button and will see that the relationships between tables are defined)