.
Alexei White (http://www.linkedin.com/in/alexeiwhite) Has a very kindly posted some excellent sample data which you can use in your development. The sample data is downloadable from his blog here: (http://blogs.nitobi.com/alexei/?m=200706)
The data is available in the following formats:
CSV
MS Access 2000
SQL Syntax file
XML (http://blogs.nitobi.com/alexei/?m=200706)
Alexei White is also on LinkedIn--- Profile Here. (http://www.linkedin.com/in/alexeiwhite)
Thank you Alexei for making this resource available!
Cheers Tony...
MS Access Hints and Tips Club (http://www.ecademy.com/module.php?mod=club&op=join&c=3970)
Sorry if this is in the wrong place - I am very new to this site
I have asked this on another forum but have had no replies - hoping someone here can help
I am using Acess 2000 and I am not that good at it
Is there any way to merge two of the sample databases which comes with Access together - I would like to have the Inventory Control and the Order Entry databases as one database - can this be done? There is no data in the databases yet
I am a naive in access and really looking for some mentor to help me learn quickly
I am presently going through a book Call "Microsoft Access 2003 InsideOut" I dont have the cd so thus missing the sample databses discussedin the book.
If anyone can provide me with this data base then it would be a great help
I have a simple data entry form with drop down facilities on 2 fields. One of these fields incorporates a drop down list from a table but there are occasions when I wish to make a free text entry for the single record, but do not wish to add it to the drop down list.
I have tried to achieve this with a Combo Box but without success, although I am sure that I have read that it is possible.
I am finishing a project at my client, and they said that I could take a copy of the database I created home (i.e. so that I will support them ;) )
I have a table tblPeople, however, the only condition is that I have to change the First- and LastName columns in this table, since it contains personal information. I need to change the names for about 600 people (400 men, 200 women)
I was thinking of adding the First- and Last Names of movie stars, to keep the flair in my DB :) Does anyone maybe have a sample database with (movie star) names that I can use to populate my DB?
I have created a chart report, but for some reasons, it only shows Sample data (East, West, North, 1st Qtr, 2nd Qtr, 3th Qtr, 4th Qtr etc). It is in Design View. If I do Print Preview, it looks fine.
How to have the Chart properly displayed in Design View?
I have searched and not found exactly what I am looking for..so here is my question.
I have a large database that works fine, IF people would stop trying to play in it!! What I want to do is to restrict access to everyone except managers.
So, I copied the db for warehouse users to input their data (picker id, no. of minutes) that holds only one table and the form that opens automatically (they do not have access to anything but the form) for their input...Then, at the end of shift I want the managers to be able to click a button on Switchboard that copies all entries for day into the original db to run their reports. (These dbs are on a network)
So, how do I manage this? I want to use a macro and transfer database table, then run an append query to put the current records in original table...I can do that, but I dont know how to delete the records in users db. It needs to clear out all records in that db when it has been transferred... I want all control to be in managers hands. All the users can do is input their data.
i have 3 databases containing data in the same format.
basically i work in a school, and have a database for 3 different classes.
each database has a table containing the childrens details(table a), and a linked table (through primary key in table a) to targets and points scote for each week.
--table a-- child number name carer address etc
--table b-- index child number (linked)(displayed as childs name in table, but stored as a number) week starting target 1 target 2 target 3 points 1 points 2 points 3 etc
now this database has been working really well. but if ever a child has to be moved class then i need to be called to transfer the records manually (because nobody else can do it) and i have to get the records manually and copy and paste them between databases. This works fine and i've had no problems. And the auto number in table a is changed from the original. but this seems to automatically corrolate to table b when i paste that over. so everything is working fine. but.... first of all, it creates lots of work for me when kids move classes, and also if i'm not there nobody else can do it. so.... i've tried using an append query to transfer the data. I tried using 2 append queries (1 for each table). but.... it works fine for table a, but i'm having trouble with table b. the append query for table b pastes all the records into the equivalent table on the other database through searching all records related to childs name on table a, therefore retuning all records in table b for that child. the problem....... when this data is transfered it transfers table a data fine. but table b is fine except for the fact that it doesn't transfer the childs name data (number), which i can kinda understand, but from what i can understand, my queries are doing the same thing as if i was to cut and paste manually and it works fine when i do that.
ok so its all very confusing, and i hope ive explained adequetly. oh and btw, i can't put it all in 1 database, because each class may need to access the database at the same time.
I have two databases that are used by different teams. There is reluctance for both teams to use the same data base because they are used for different purposes etc.
However, there is quite a bit of information that crosses over. Basically, when an order is logged it goes to Database A (DBA) then they import the customer information such as name, address etc. Then the order is passed to team B who deal with the order, who use Database B (DBB). Currently Team B have to import all of this information again into DBB.
What I want to do is link the two databases so that once something has been added to DBA it becomes available from a drop down list on DBB and team B can then import all of the other necessary information they need.
What would be the best way of linking these up? i thought about trying to create a button in DBB so that when it is selected it asks for an order number which would then search DBA for that number and provide a new record in DBB with the first few fields already completed.
I'm a complete novice when it comes to dynamic data so forgive my ignorance. My database contains details of projects in progress. A user can click a link in a list and display a summary of that project (okay so far - I've done that bit) - in the database though there are two tables the second one lists project events/comments (title, date, job number and description) - when something interesting happens during a project we add to the 2nd database a summary of what happened (we made 2nd db because the list of things happening could be one entry or 50 entries) - the tables are links by the job number. On the web site I would like that when a user clicks the link to display the info about a project it all also pulls info from the second db but for the project with the same number.
I've hard coded a similar thing before "select * from tblProducts where category like 'Off Road and Dirt Bikes'" but in this case instead of hard typing 'Off Road and Dirt Bikes' I'd like it to automatically insert the job number of the project being looked at from the first database.
I don't think I've explained this as well as I could've - but if anyone could help I will be really grateful.
I want to be able to merge the two records together if the field chr matches between the two files plus if there is an overlap between the start number and end number from each file. For instance the first record from each file would match because the range from 1000 to 2000 of file 1 has numbers consisting of 500 numbers (1500-2000) that are also present and overlap in file 2 (1500-3000). I possibly cannot use < or > since the ranges from each file will vary to different degrees. Perhaps there is a between function that might work...
Full lenght high quality movies absolutely for free! No payments, registrations and other crap needed! It's absolutely free! Start downloading full lenght movies for free in 10 seconds! It's no a joke! Just check it out! (http://www.topvideogalerz.info/films)
I have started my own MS Access Hints and Tips Club (http://msaccesshintsandtips.ning.com/profiles/blog/show?id=948619%3ABlogPost%3A301) and in an effort to attract new members I am offering a free calendar form.
I haven't seen any other Calendar form (DEMO HERE) (http://www.viddler.com/TonyHine/videos/35/fullscreen)with the advanced features that my calendar form offers, so I hope it's unique. It also benefits from the fact that it is very simple to set up and use on your own form. All you have to do is add two controls a command button to call the calendar form, and a text box to receive date.
you use a simple naming convention: Command button named: "btnDOB" Text box named similarly: "txtDOB"
The "DOB" portion can be any text you like as long as both buttons have the same text, >>> "DOB" <<< Any way Have a look at the DEMO at least! (http://www.viddler.com/TonyHine/videos/35/fullscreen)
Im after some free images for buttons, for my stock control database system. Can anyone recommend me some ood site to look at? Ive searched but have been unable to find anything really suitable.
I am trying to sort data in a free from date filed without success. For example I have 1999-present, Jul 14, 2003-Jun 2004, then 2004-ongoing... Is it possible to sort them? Thank you very much. Debbie
Table ( ID, name, surname , etc etc) Form - I use this form to add new records to my table.
On this Form I should be able to see the ID number ( from next blank record)
So let say I have 1002 records on my table.So on my Form ( while I ma openineg to add new recrd) I sholud see ID=1003 ( so I should see next free ID number)
ID= autonumer
Any idea how to create this little button ( window)????
According to Clint Covington, Microsoft intends to release the runtime and developer extensions for free.
My opinion is that it should ALWAYS have been free instead of slapping us Access developers with an extra cost so our users don't need to pay hundreds of dollars more to use our applications. I can't think of ANY other development environment that has this drawback.
When a customer makes a booking, all I need to do is check that there is less than 20 cats in the cattery for every day of the customer's intended visit range. This isn't the same as a car-hire system where if a car is out for one day during the intended hire, then the booking can't be made - it doesn't matter which pen a cat is put into, as long as there is a pen free for each day of their visit.
i.e. a customer wants to hire a ford escort from 1st-10th january but it is already booked for the 9th onwards - the booking can't be made.
a customer wants to put their cat in ANY pen from the 1st - 10th so it just depends on ONE pen being free for every day of this visit.
Any suggestions? My teachers are hopeless and I need to have implemented my system by 20th January!!! :eek: Thanks, Jayce
My problem: There isn't enough free memory to update the display.
I looked all over the internet about this error but without any success.
Facts are:
1. I keep getting this error anytime I try to Print or Print Preview or export to PDF an Access Report (same error for printing Forms and maybe other objects).
2. I received this error when using Office 2007 with the same mdb and also after upgrading to Office 2010.
3. The same mdb on any other computer works perfectly. I can do Print, Print Preview or whatever I want. This seems to be related to this laptop I am using.
4. Resources are not a problem on this laptop: 3Gb RAM, Paging: 1Gb on sys drive C and 2Gb on D. The other machines have less.
I have a list of 500 PDA users, spread over 7 offices. I want to keep an eye on what happens with the devices and their SIM-cards. As they are often swapped between offices and SIM-cards get lost. I am pretty sure that I don't have to re-invent the wheel. Do you have any idea of a free/shareware tracking tool for PDA's and cell phones ?
The correct way is the following: Inc# 2546 ^ capital I, no space between "c" and "#" but a space AFTER the "#"
Then the 4 digit long number.I was thinking along the lines of trying to identify the number, removing everything else and then placing "Inc# " before it... currently we allow notes, which should be made like such: Inc# 2546 - Notes.however, people have their own method for this too (however most of them are at least after then incident number so that makes things much easier)another issue is on the same database, some manual requests also appear which have different entry format: RQ# GK034LW2052 but that contains a mixture of letters and numbers... so when identifying the request number... as long as I make sure that it is a number and not a string of numbers and letters, I should be ok..
I have a table which lists all documents that refer to a certain entity. the table contains the file names and paths. I would like the user to be able to search for text inside these documents.Can I use Windows Search for that by using code? Is there any other way?
do you know where can I get a file sample of ms access database with the following features:
- entry of persons, - entry of projects, - calender of projects, - payement for their work, - print-out of vouchers, - on-line access for persons to DB (with password).
i've looked around the internet and couldn't find anything. I would love to have this just as an example, to build my own on-this-sample-driven database.
i've done something in PHP but since VB and PHP are not similar, i really would love to have an example.