I am currently doing my A Level ICT Coursework, my exam board is AQA.
The problem i have encountered is as follows:
I have a form, containing a sub form, within this subform i have a macro which i want to take me to another created form but when doing that copy a certain value in a record across to the new form.
For example.
Subform - Orders
Record to be copied - Order Quantity (within the sub form)
Macro button pressed within the sub form
New form opened
Record in the new form - Adjust Amount (this is where i want the copied data to be input.
Hi there, I am having a couple of problems with access.
I have a bit of a problem trying to get access to open microsoft word with a mail merge already set, i really want to have it so i can click a button in access, and it will address a letter in MS word ready to type in, without having to go into word every time and set up a mailmerge. Can you help me with this?
My project is for a financial advisor. There are 3 tables, client data, link table and a policies table. They are linked with relationships.
Also...
Each client has a Total renewal commission earnt. Each Policy has a renewal commission earnt. I want to be able to add the data each month from the policy renewal commision earnt, to the clients total renewal commission earnt, and then reset the policy renewal commission at the end of the month.
At the end of each month a letter comes through with each policy number, and the amount earnt. I want the user to be able to type this information in for each client and then be able to print a report at the end of the month( it has to be claimed ). At the end of the month this all wants resetting, but the amount wants to be added to the clients details. Each client may have more than one policy, each policy may have more than one client.. which is why there is a link table. Is this possible?
I also have a field called Total initial income on the clients record. I want this to be a calculated field from all the policies they hold. The policies all have a "Initial Income", but each client often has more than one policy... how do i get it to add up all the initial incomes from the policies they hold then put it in the clients records? I think this needs an update query but i am not sure how.
If you can help me with any of this please do! Even if its just a bit you might know,.... Thanks Steve
My main experience is with MySQL and PHP so I'm kindof stumbling around in the dark here. Heres my story:
We recieved a new server and migrating from (Windows Server 2000, IIS 5.0, Access 2000) to (Windows Server 2003, IIS 6.0, Access 2003) has been nothing but problems.
I have setup IIS to work with ASP, I've also setup a system DSN. The access file was copied over from the previous server. We're running Access 2003 and now I can't seem to get this ASP script to work.
When I try to upload a file to the script I get this error:
Line: 42 Char: 7 Error: HELP!!! Error: [Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement expected 'DELETE','INSERT','PROCEDURE','SELECT', OR 'UPDATE'. Code: 0 Url: (URL address blocked: See forum rules)
Its included in a file called FileRead.htm here is the part that refers to the error lines: Code: var TheFile, FileStrm;// Retrieved field namesvar M_ssn, M_inits, M_Lname, M_Fname, M_DSSN, M_ruc, M_paycode;var M_normamt, M_payamt, M_pgrp, M_poe, M_pltcd, Payrollnum, Payrolldate;// var Trash, FieldData, FieldNames;var TrashLineNum = 1;// Create the file Stream Object (ReadOnly)TheFile = new ActiveXObject("Scripting.FileSystemObject");FileStrm = TheFile.OpenTextFile(FName,1,false);// Setup the Database Connectionvar SQLCommand, TheRS, TheConnection, DSNString, Commands, MyDC;FieldNames = new Array("ssn","inits","lname","fname","dssn","ruc","cco", "payamt","normamt","notsureone","pgrp","poe", "pltcode","recstatus","paychgflg","paystatuscode", "payrollnum","payrolldate");// Connect the the DatabaseDataLib.ConToDB();MyDC = DataLib.GetDC();// Get Payroll NumberPString = prompt("Enter Payroll Number","025");Payrollnum = parseInt(PString,10);// Get Payroll DateDString = prompt("Enter Payroll Date","20000101");Payrolldate = DateLib.FromMil(DString);// Setup the Database Connectionvar NumRecs = 0;//MyTest = DataLib.GetRS("PaydayUpdate1");alert("About to cross into the CurExtract!!!");MyRS = DataLib.GetRS("SELECT * FROM CurExtract");
I set an alert after this line but it doesn't pop up.
ANY HELP WOULD BE VERY GREATLY APPRECIATED. I'll be checking this very frequently.
I would like to convert a database, which was made for me, in order to enable it to be used on my current system.
I get the error message below when trying to open the database in Microsoft Access 2003.
The database was made using Microsoft Access 2.0.
Will I need Microsoft Access 2.0 to update/delete the database all the time?
Or can I convert this to be used with Microsoft Access 2003?
I have tried opening the file exclusively and I get the same error.
I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.
http://images6.theimagehosting.com/error.6de.PNG
Thank you very much for your help and all responses are appreciated, Sam
I would like to convert a database, which was made for me, in order to enable it to be used on my current system.
I get the error message below when trying to open the database in Microsoft Access 2003.
The database was made using Microsoft Access 2.0.
Will I need Microsoft Access 2.0 to update/delete the database all the time?
Or can I convert this to be used with Microsoft Access 2003?
I have tried opening the file exclusively and I get the same error.
I have selected Show Help and it advises me to import all the objects from the database into a new database. This can`t be achieved as I can`t open the file to retrieve the contents.
http://images6.theimagehosting.com/error.6de.PNG
Thank you very much for your help and all responses are appreciated, Sam
What I would like to know about Microsoft SQL Server & Access 2003 : I am a novice at creating my own database. I would like to use Microsoft SQL Server & Access 2003 . I have in the last 3 months read all I can about creating a database in Microsoft Access 2003 . Now I need to learn about Microsoft SQL Server, and it is very different from Access 2003. I have purchase many bussiness applications over the last 5 years, and fount that over software are to rigid, as I need something very specifil to my bussness. If you intend to reply, please be very specific & in plain English.
Can someone help me ?
1Can Microsoft SQL Server 2000 work with Microsoft access 2003. a.Is this do-able .
2Can Mysql also work with Microsoft access 2003
3What is the difference between Microsoft SQL Server & Mysql.
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?
Hi there, thanks guys for your help with my last problem. I am so close to finishing my coursework now, once I have this last bit done all I have to do is make a few simple queries to search the data and write up about it. I am having a problem with my database ( yes, I know the database is a bit all over the place but i just need to finish it now... besides, the exam board don't even ask to see the working model, just screenshots! )
In my database, there are a few tables. The main ones are Policies, Client data, Link and commission.
Policy table - Holds all info about the policy Client data - Holds all data about the client Link table - Links the client to a policy using the client reference and policy number. One client may have many policies, and one policy may be held by many clients. Commission table - This i think is the problem table. needs to store a policy number, the client it is linked to, and the commission earnt by that client/customer, along with the date ( it is renewal commission ). The reason this is not with the link table is because one client may earn lots of commissions from all the different policies and this needs to be able to be stored along with the date.
Sooo... I have a form based on a query, the query asks the name of provider for a policy. The form then displays all policies held with that provider, and using the policy number, through the link table... it retrieves the client data from that. So, the same client may appear twice is he/she holds two policies with that provider, and the same policy number may appear twice, but never the same policy number and client reference twice. The query does find the data I want it to. It then shows it in the form. The problem is, two fields I want to edit ( linked to the commission table to type in a commission, and a date... as I want it to then store the commission, date, reference number and client number in it in the commission table)... it won't let me edit it.
I have no idea why, I have a feeling it may be to do with the relationships. I find it hard to explain exactly what it is I need it to do but I hope I have explained well enough for someone to help me... in short..
The form should make it possible to search for a policy provider, show all policies by them and clients with the policies, then store the commission data ( typed in ) along with the date ( typed in ), client number and policy number. It gets so far,.. then fails. Another problem is that sometimes the form just comes up blank!
I'm sure this would be very easy for someone to show me where i'm going wrong and some help would be so greatly appreciated!
To see what i mean, please open the database, on the main switchboard there is a button saying "add data from commission sheet"... please open this, select a provider ( I left one in (( I know spelt it wrong )) and it will display all policies with them as the provider ( allience and lester ), you will find two are held by a person named Stephen Martins ( not real ). the commission and date part can't be edited.
If it helps: the first form you will see ( to select provider ) is called frm_select_commission. This opens the next form called frm_add_commission, which is based on a query called qry_select_name_of_provider. The query gets its criteria value from the box on the frm_select_commission form. My teacher said he didn't know what it could be but it could be something to do with how the relationships are. Please help me Thankyou so much! Steve
P.S THE LINK TO THE FILE IS: http://www.nutty.tripod.com/Financial_advising_database.mdb
Ok so I have a new project. I have run all queries and appended them to my tab inventory. My mission is to take all of the query's and create a table that combines all missing parts info (I.E.> date, part#, plant, location, inventory, reorder pt.) How do i do this and if you need more information please message me back. I would greatly appreciate any help.
I have a report writer in access which i use to generate reports from act! (a CRM software by sage).
Recently, there has been some changes and development in act! software (we added new fields into it). I am trying to update the tables in access with the new fileds, but am not able to do so.
For a databse which I am going to create, I would like to have an authentication system which utilises the database users which I specify, however instaed of using a password the idea would be to use a fingerprint scanner to logon. T^his would be for an A - Level IT project and I would seriously like to know how to integrate biometric security into a database. If anyone knows how to do this please post CLEAR instruction possibly with some SCREENSHOTS if possible.
This query is in relation to an Access 97 database.
A problem that we are consistently having is that whenever people are using the database under different user names, it only allows one user at a time to use it. So basically if three of us are on it updating files or enquiring on client details, two of us are locked out leaving only one in. Any help in this matter is greatly appreciated.
Please consider the situation below: There is a central server and there are many client PCs connected to the server. On each client PC, there is an access database file that will be frequently updated by the user of the PC.
What I want to do is to allow the user on each of the client PC to backup their database file to the central server;
At the server side, it is free to use any architecture(eg using file system or another database to store the file) to facilitate the backup purposes. One of simplest solution is to upload the entire database file to the central server everytime. However, the problem is the access database file on each client PC is quite big, hence it is better not to upload the entire file but only to upload the updated data to the central server.
Is there a way to synchronise the data with central server without upload the entire database file? What kind of architecture should built up in the central server if there is a way?
First up, a pre-emptive request to excuse me if I show my ignorance - I'm not really an Access user/developer, I'm a SCM person.
We have a team that develops Access dbs and they are looking to integrate better with ClearCase. At present, they use the UNIX client and transfer whole, binary Access dbs, then source-control the binary file. They would like to be able to integrate better - my understanding, from them, is that VSS will control individual tables/forms, etc. I assume this is because it integrates via the SCC interface.
I cannot find anything about the SCC interface in my Access tool (just part of the Office distribution handed out to all desktops here) apart from a reference to Office XP Developer.
Can anyone provide me with any more information (even if that is just to point me elsewhere)?
Using VSS is not an option, by the way - the SCM standards specify ClearCase or Subversion (which would access the SCC interface via the PushOK proxy).
Hi there, I am doing a project for my A level computing, and for my mum's financial advising.
I am to assume no knowledge of computing on her part, and so i cannot make it up to the end user to know how to mailmerge. I was wondering if you could help. I can have it in a query, form or table form, whichever is best for this, but i need to be able to make a button which exports a record into a MS word mailmerge. This is just to make a simple letterhead. I need a button that says " Write to client ", and once it is clicked it needs to open a letter addressed to them. This is my problem. I have noticed when the data is in a report, there is an export to MS Word button, which is very close to what i want as i could use that and get a good enough mailmerge, but is there a way to run this from a macro or using VB? I did VB last year for my computing project and so i understand a fair amount of it. I want to just make one word document, which will open as mailmerged with the clients data. Please help if you can, I am sure it is possible as i can see you can mailmerge from access, and there is even a button to do it.... kind of, i just need to be able to make my own. Thankyou so much for your help. Steve ( Microsoft Access 2003 )
I work for a College within my area and have recently been asked to create a database for storing and testing data. With mild experience, I believe I have done well so far but a co-worker asked me the other day if there was a way to create or modify the hotkeys in Access. I've tried researching this on the Net and only found lists of which hotkeys do what. If anyone knows whether or not adjusting hotkeys is doable, please let me know.
I am trying to sort out some data. Because it is too huge for microsoft excel, I have to use Access to open it. But when I managed to open the data and wish to edit the data, it keep popping out this message "Updating data in a linked table is not supported by this ISAM"
I have 2 combo boxes. When the form loads the user selects a value from the combo box if the value is not 10 or 99 i want the user to be able to select a value from the list in the combo box else i want it to put in 0, 173 respectively when i put the formula in the control source i can get the values 0 and 173 to work but if the user selects a different value then i am unable to select any thing from the list?? can someone please help me thanks
hi everyone i just want to ask how to create a database microsoft access and connect it to my webpage...like for example a certain content in my web is downloads (music, videos etc.). then i want to add another music in my web..how can i do that in microsoft access hope u can help me guys...thanks!
I will firstly give you the low down on the business that I am doing the database for. It is a Car Restoration Business, where we deal with vintage/classic/muscle cars and restore them to the former glory.
I do not know Microsoft Access very well, I have attached a file with what I think is a databae I could be wrong. The main function of this database is to search for suppliers for a specific car part for a specific car.
So if I want to find a doorhandle for a 1970 Ford Mustang, I need the suppliers pertaining to those criterias to come up.
I am having trouble with the format of dates comming from access, if I view a table in access with a field of Date/Time the date is formatted correctly as dd/mm/yyyy, but when I retreve the date from my ASP page the format changed to mm/dd/yyyy. I can successfully change the format using a date format function but is there a way of getting access to send the date in the correct format in the first place or know why it's doing this. I am using access 2003 and the following connection string
I have a database that will be used by a few users who are not very comfortable with Microsoft Access. I have a login screen and a introduction/splash popup. I was wondering if it is possible to bypass the Microsoft Access pop-ups that ask the user if they want to "block unsafe code.." or The security popup that says "This file may not be safe" so that the users go right to the login screen I created within the database. I am worried that there will be variations in answering/clicking these Microsoft Access questions thus causing a variety of complaints when trying to access the database. Thank you
Hi, I am trying to open an access database (Access2002) from my computer ( C: est ) and I receive the error : Microsoft Access cannot open this file. This file is located outside your intranet or on an untrusted site.
We have a database on our network server which I cannot open. I get the following error everytime I try to access it.
This file is located outside your or on an untrusted site. Microsoft Access will not open the file due to potential security problems. To open the file, copy it to your machine or an accessible network location.
I think it has to do with a Microsoft Jet 4.0 Service Pack 8 security update. However, I cannot find the update to uninstall. Others can access the database located on the network, but some get a pop-up that allows them to say "no" and access the file. The pop-up has the following message:
Security Warning: Unsafe expressions are not blocked. Do you want to block unsafe expressions?
