I'm programming a booking system for a singer as a school project (beginner, very limited knowledge). The table 'booking' includes fields showing expenses incurred for the singer's gigs. The field names are 'expense incurred 1', 'expense incurred 2', & 'expense incurred 3'. These fields are linked to the 'expense' table via lookup wizard, which contains expense names e.g. petrol, food, drink, and expense costs for each e.g. petrol would be '£20.00', food '£10.00', and none '£0.00' etc.
I was wondering how it would be possible via a query, to have just one 'expenses' field in the 'booking' table - i suppose this would involve bringing all three values entered and the costs of these added together to get all expenses incurred listed in the same field i.e. 'food, drink, petrol', and the field next to it having totalled the expenses i.e. '£40.00'.
I tried this question a few weeks ago, but I'm trying again.
I have 2 Access 2002 files. One has a sort order of ascii and one has a sort order of international. I need them to both have the same sort order. It doesn't matter which one. Right now I get the above error message on one of them.
How can I change the sort order so that I can import Paradox files like I used to? :eek:
[Microsoft][ODBC Microsoft Access Driver] Selected collating sequence not supported by the operating system
To give you an idea of whats goin on... I took an excel file used xls converter and made it into a access database... I uploaded the database to the server and this is the error I got in dreamweaver... So I tried to used the MySQL Migration Tool Kit to make this a MySQL database and THis is the error I got when I was trying to execute the bulk transfer... Any Ideas? Please?
the databases functionally normally with no issue. I have several databases one for each project and they are all having this issue. It doubles the size of the DB after the failure. This seems to tell me that the crash is just after the DB is ready to rewrite the database compacted. I run C&R about every 2 weeks and have a spread sheet tracking DB size prior to and after C&R. The compactions run from about 1% to 15% the norm seams to be 4% to 6%. The size of the DBs run from 65KB to 100KB.
Hi, I need to colour code fields in my database based on whether the data entered is a guess, derived data or factual data...
I have no idea how to do this! Apart from create a field corresponding to each field in my database with the values 1-3 in (1 for guess, 2 for derived etc) but I'm pretty sure this will dash any hopes I have of getting normal form in my database.
Anyone know an easy way to do this? As far as I know conditional formatting won't work as it's the user that tells the database what colour code to use for each field.
Hi, I would like to know how to do the following scenario in Access 2000.
Imagine I have a table, which has two fields X and Y. User can only enter either field X or Y, but not both. How to check the above case while user is real-time keying in the fields of the table?
I have two tables linked together with one-one relationship with primary key. The form has been created using a select query using these two tables. total fields at present is 253(table1=25 fields, Table2=228 fields Total = 253 fields)
Now my problem is I have to add 20 fields more to the above. so the total fields now is 273 fields but it is not accepting and giving the error as "Too many keys defined 3190".
I have a database that currently has security in place so that users input their own usernames and passwords to access the database. The users have recently been added to a windows 2000 server and I want to be able to use their windows 2000 server logon credentials to provide them with automatic access to the database. Is there anyone out there who knows how to set this up? It is a rather urgent request if you could get back to me either on this forum or via email
I am opening and closing a series of Excel 2000 Workbooks using Access 2000 VBA and want this sequence to be able to complete without any human intervention.
However, there are 2 instances when this stops and waits for a human option to be selected:
1. When the spreadsheet is password protected 2. When the spreadsheet has automatic links I get the message:
"The Workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?"
How can I code it so that in situation 1 it skips this file and in situation 2 it automatically defaults to do not update?
If I have a report in MS Access 2000 generated based on the criteria selected of a project with work order "9999" with the labor costs, materials costs and the Totals of each crew1, crew2,... and I would like to have those expenditures populated in corresponding cel in Excel for each crew, HOW would I do it?
To think it out loud, could I create a button on a form, so when I select the criteria for the work order, and when I click the button, it should refresh/update the Exel file with the new data...?? How do I write VBA code for that...?
I have recently been doing a conversion for my boss for a access 2000 database (both front and backend) to a MSSQL backend.
I finished the conversion today (as quite a lot of the code / queries ran slow due to access running the queries locally rather than on the server). And tested it on my and my boss's machine with no problems so he gave the go ahead to update everybody to our new mssql 2000 backend with the modified frontend.
This is when the problems started; We had two different sets of forms for accessing one of our databases systems - the log system, one is the original dynaset based form, and the other is a newer set which uses snapshot views and preforms updates via queries. Nobody uses the old dyanset system apart from my boss and one of the administrative team as they have things on that window which they need to see. About 30 minutes into the release of the new database the system frooze up on my bosses computer and nobody could create a new log (the server was timing out). I assumed this had something to do with the old dynaset's creating locks on the table.
I offlined the database and kicked everybody out of the front end, turned it on again and tied again, this time banning everybody from the dynaset system. Within 10 minutes another computer frooze up, again with a timeout on the insert query. I discovered that after you had added a new log to the database it would timeout on all subquent additions (something it hadn't done during testing) . Further investigatiion showed it was the snapshot list window causing the error, so coded the add log window to close the list before preforming the insert query and then reopen it afterwards. This allowed my machine to make multible additions without flaw. So I released a new client to everybody. 15 minutes later it was timing out again, but this time there you could not even make one new record.
I checked for locks on the table though the server management table and couldn't find any for the Log table. I have restarted the SQL server box and with no avil. So I reverted our backend to the access mdb file and told people to use the old client.
I am at a complete lose to why this is happening, if anybody has had any expericences like this or knows the cause please tell me.
Some information on the database in question.
It was made as an access 2 database all intergrated into one file, then it was seperated into two files (frontend and backend). Upgraded to Access 97, then to 2000 before this final update to MSSQL 2000.
The log system has two main tables. The first is the log title / info table which links (one to many) to a log entry table. This problem only occurs on the main log table and does not appear to be reoccurring anywhere else within the database. The main log table has just under 18,000 rows in it.
I had converted a Access (shared) DB from 97 to 2000. Now when more then one person open it it tells the others that it has been opened in an admin state denying the other users the ability to open. I checked the options and toggled back and forth to exclusive and back to shared, with no luck. Any ideas?
I just got a new machine with office 2003 but it doesn't include ms access. Can I use access2k with this new version of office?? so I can do reports and put them into word etc??
I created a db in access 97. It has tabkes, queries, forms, modules and reports Now i am trying to convert it into access 2000 but .... thats why i am here.
Here is what i am doing: 1- open access 2000 2- go to tools, db utilities, convert db to 2002 3- select the access 97 db
After that access 2000 starts to make the convertion and at the end it display an error like:
"Microsoft Access has encountered a problem and needs to close. we are sorry for the inconvenience."
Also gives me the option to repair the db and restart access.
At the moment the company Im with uses Access 2000, however ive been told by a few people that Access 2000 had alot of issues and it would be worth informing the company to upgrade to 2003 asap. Is there any major concerns with 2000? Some of the databases currently being used are very large and complex. Any chance data could be lost/displayed incorrectly? etc
:confused:I have created a small DB to keep track of meetings. Main Form customer Sub form meetings with customer At the end of each meeting I make notes on the sub form and enter an agreed date for next meeting. Q 1. I would like the sub form to open at new record, or last record and with the agreed meeting date CARRIED OVER to the new record form. Have unsuccessfully tried (among many) DoCmd.GoToRecord , , acNewRec Q 2 I love the idea of having a sub form, but am unsure when creating reports how to ask for information from “last record”.
thanks have spent hours looking thru messages and closest I found was Dmax but not sure how or where to find/use this.
I'm new to MS Access. I want to know about compressed/reindexed databases.
What happens when a database is compressed? What happens when a database is reindexed? Why is it important to periodically compress and reindex a database?
I have records in the database that I need to pull up by local time zones, what would be the most effective way to do this?
I have a form that submits to an access database which has auto number enabled.. Trouble is that some of the submissions are missing and the database skips an ID number.
I need to develop an application that works in 2002. I tried to take a 2002 mdb, convert in 2002 to 2000 and try it on my machine at home. It didn't work and I couldn't find the missing reference. I then took an mdb that was originally a 2000 format, converted it to 2002 and it worked fine. So what I want to do is develop the app in 2000 and just convert it over to 2002. This allows me to work on it from home which is pretty important since my deadline is creeping closer. Am I ok doing this or am I courting disaster? Or is there another way of doing this?
Is there a way in Access 2000 that I can set up a users table? Basic info:
Name Phone Number Fax Number
Then every time the database is opened they are prompted for their name?
I have a database that has a Fax Cover Sheet within the DB, when they click the Fax Cover Sheet Form I want their information to automatically be generated into the form based on the information from the original table.
How unusual is it for a database to become MUCH smaller when converting it from 2000 to 2003 formats. I mean 600megs to 10 megs. And as far as I can tell all the records are intact....!
I have a rather large project that has been developed in Access 2000. Generally all my distributions have been to PC's with Access available. However, I do find that there are a few that don't. Obviously this is where Run time would be useful. Having never used it I have a few questions if someone could possibly help:-
1 If I have a program developed in Access 2k can it be converted to the MOD version to include runtime? 2 If there is a conversion process is it automatic or does it require extensive reworking of the project? 3 Is it still possible to purchase MOD 2000 or do I need to get an updated version and if so will that still work with Office 2k?
How do I copy the results of a query to a new table that serves as an archive? How can I then clear or reset the original query?
I am doing a project that records the names of students who have had more than 5 merits in school. I want to use this data to generate a certificate to give out at assembly and to send a letter home. I have run a count query but want to send the results to another table which acts as an archive. I want to have the original query reset. Can anybody give me any suggestions?
