Project Problems!
Jan 29, 2008
Here is my problem i wish to overcome...
I have a numbers of swipecards that customers would purchase from me.
I wish to simplify the process..
cards are numbered 1 - 700
I wish to give a a certain customer cards numbered 33 - 60.
I would like some way of reporting that cards 33 - 60 have been removed from the 1 - 700 and to tell me what cards are remaining as well as cards missing that i need to order.
I can write in VB if that helps, but after a day of thinking about it my head is a mess *Grins*
But ideally id like to write something in VB that would check against a database...
I hope you understand and can offer a good explaination..
Regards,
P14
View Replies
ADVERTISEMENT
Apr 25, 2005
I have tables and forms setup but I have 3 general questions on how to finish the project.
1. Should I create a folder where all the files reside for instance, create a phone log folder, put the DB file into the folder and export XML's into the same folder?
2. How do I get the form to launch as a self-contained form without the Access application in the background?
3. How can I get this form and table to automatically update an XML spreadsheet whenever records are added?
4. How can I get the form to sort all records according to time logged? The time will be entered in manually and we need all the records to sort automatically by time in ascending order.
View 5 Replies
View Related
Apr 18, 2006
Hi guys. Back on the development trail having enjoyed a long break after the birth of my son :)
How quick one forgets!!
Project: My father-in-law would like me to develop a DB for his new company. They buy and sell plant hire (all done the old fashioned way, on paper).
His requirements are a little beyond anything I have attempted in the past so was hoping for some sound advice.
He would like to be able to record both Sales and Purchases. I have never worked with Stock before. What is the best method, any examples (did a search on stock prior to posting). He would also like to have VAT as an option (this stumped me on my last project!!).
Many Thanks,
Phil.
View 5 Replies
View Related
Mar 13, 2007
Hi People, great forum here and i've learned loads in a few hours ive found it :D
im just wanting a bit of information or some pointers as i cant seem to find anything on the forums about it, first off i have a DB (access) with a list of employees in i have variuos reports and other tables etc, what i want to be able to do is get access to work along side Word, -
i need each employee to fill out variuos forms that come in word format , i want to know if A, is it possible to auto fill a word document out with variuos information from the DB, as im pretty new to access and have no working knowledge of VB then im stumped - then B, i want to be able to save this in a folder on a network drive and have access to the form etc or scanned form etc for each employee.
any help would be great on this as my brain is havin an overload and i only have a certain time cale for the project
thanks in advance to anybody who can show me any pointers
View 1 Replies
View Related
Nov 12, 2007
this Project about computer company , the Boss of this company want from me to make database help him to know :-
Customer's Information.
what the customer's invoce , pay , remain.
Supplier's Information.
money come , money go.
that's not all , but it's the main points , I just want the any project similar to my project....... or at least , sites have examples for what I want.
NOTE : I attached Company.zip that contain Company.mdb and Company.accdb (they are the same) that what I made until now.
waiting for answer , and thanks in advance
View 3 Replies
View Related
Mar 13, 2008
Hey guys, new here and I need a little help with a project my boss wants me to complete.
Basically right now, he has a huge directory of quote sheets that he fills out whenever he wants to generate a quote for a customer (they are excel files, i've attached a picture of one). He wants me to create something that will scan through this directory file by file and extract certain pieces of information from each excel file, and put them into a database. The company I work for isn't too big, so i'm going to use access as the database.
I've also suggested building a new quote sheet in VB, and programming it so everytime the form is closed, the certain pieces of information he wants will be saved into the database. So I guess after this we can forget about Excel. But also, he wants to be able to bring up the entire quote sheet again if need be.
If you guys could please help me out, what would be the best way of going about doing this? Am I heading in the right direction as far as my thinking goes?
View 14 Replies
View Related
Mar 20, 2008
See wip,
28-Mar-08, 06:07 AM
View 8 Replies
View Related
Mar 27, 2008
hi every one,
how r u all
i really need your help
i asked my friend and he told me about u guys
my problem is :
i want to create a database for entering student marks ^^
but i don't know much in access so could u plz help me
i want to u make the Relations so that i can make any form to enter the data i made the relationships but there is problem " i can't enter marks for new student "
Please help i have to submit it this Saturday
i will appreciate for u guys if u make as soon as possible
The prince
this is my file
http://www.tntup.com/file.php?file=1fa534bffc053e8cc460cb9d27c34c5c
View 3 Replies
View Related
Sep 30, 2006
Hi,
I have a project about creating a data base of Foreign Trade, where I have to choose the country, then to determine the period (years).
so, could you please tell me how:
1- to link a combo box with a query (comob box of list of countries)
2- to link 2 combo boxes with a query of starting date and ending date
(the criteria is: >=[start date]and<=[end date] ).....should I separate this criteria and put it in to 2 columns of same data (years)...I tried it but it didn't work.
3- to link a Run Query command button with conditions mentiond above. When I established the command button, it showed the whole data base, so how can I link it with 2 conditions above.
Waiting your appreciated replies a.s.a.p.
Thanks,
View 9 Replies
View Related
Apr 13, 2006
Hi 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
View 2 Replies
View Related
Nov 27, 2005
Ok first off thank you for anyone who even reads this.
Iv been assigned a project in using Access 2003 and only Access 2003. Im stuck and getting frustrated and was wondering if anyone would mind helping me.
What my Prof wants is a Access database with a form to do the following
HE wants us to have menue with
5 sandwitch combinations
5 Side (combinations)
3 drink Combinations
2 desert combinations.
Ok he wants us to input 1 of each category as if we were ordering
then he wants us to order it and print out a Recipte with the following info.
Sub total
Tax
Total Purchase
How many Calories the entire order is.
Im attaching a .mdb file with what i have come up with but im not sure if its even going in the right direction. I would forever be in debt if someone would help me.
rename the wendys.txt in the zip file too wendys.mdb
View 1 Replies
View Related
Nov 27, 2005
mods could you please del this thread. thx
View 14 Replies
View Related
May 31, 2006
Ok, well basically i am trying to write my own database. and i have not the a very good working knowlage of access and some many bits that are over my head, Would any of you guys be willing to help me out with this?
I would be willing to pay someone to do this, if you could give me prices per hour ether here if permited. or via Private Message.
for comunication purposes i could use skype or msn messanger. as there will probably be some bits i would need to explain. I am a little bit of a perfectionist so i would try and explain as clearly as i can as to what i want. there is no desparate rush on this project altho july would be great, one of my friends was meant to be helping do this as he is good with access but i have been waiting for him to do this for about 6 months.
Thanks
Shrew
View 10 Replies
View Related
Jun 13, 2006
Lately I have been using my db's on computers which did not create them (my db's). I've been seeing this message sometimes;
Microsoft Access
You have modified a signed project. you do not have the correct key to sign this project. the signature will be discarded.
can someone point me in the right direction. I think I've been down this road before but forget the correct path:confused:
View 1 Replies
View Related
Dec 1, 2006
I have over the last few months been building my own Project management system.This is based around A Phase task principle but the phases and tasks are used to create an estimate for a project depending on how much time is assigned to each Task.The system can use multiply Estimates with different billing codes plus their is a billing code system where billing can be done by a default list of codes (Rates 1-5) Or assigned rates for a client.I'm not after any money for it and will make it available to members hear.If anybody want to look at it and maybe make suggestions on improvements or let me know of any errors that would be greatIt would be an mde with an mdb back end.You should be able to update the back end that I don't think will be a problem LOL When it comes to new versions.As I said I don't want ANYTHING For you using it but would be nice to get it working better.mickp.s Ill Post some pictures if ya want. And It is a work in progress?Please use this topic from now on http://www.access-programmers.co.uk/forums/showthread.php?t=121117 this is where the beta 1 downloads available from.
View 14 Replies
View Related
Feb 13, 2007
Hey guys,
I am a total NOOB when it comes to access....i am currently taking an access class at my college and its time for our first project. I really need help getting started cuz alot of the terminology is so new to me... I have been provided with a sheet of information and have to create a DB based on said information.
if anyone out there is feeling super generous with their time and is willing to help me through it...just to get me started..my aim is NIPPONLIFE86.ive found that its getting everything going that is the hardest...especially when im creating a database not just inputing data.:confused:
thanks so much for your time guys!
Kin
View 3 Replies
View Related
Apr 3, 2007
Does Access database support muliple users on the same data update, if so how many. What will be the best way to avoid locking up a field when somebody else is trying to update a different field within the system. It run on server:
confused: .
View 1 Replies
View Related
May 4, 2007
Hi all
I have extensively searched the forum to try and find an answer.
Im trying to develop a Project tracker database which will track the progress of my ongoing projects, does anyone out there have an example or another link to get me started.
I know MS Project would be the answer but we do not ned it in as much detail as this and they definately want it written in MS Access.
Many thanks for any help
View 4 Replies
View Related
Sep 28, 2007
Hi,
Have been asked to "update" an archaic database for a consultancy firm. The existing database is approx 20+ years old and appears to use .DBF files for storing the records.
Now, the DB itself I can do, but I've normally only written DB's for one or two users. So before even considering doing this work, I would be greatful for any advice on the following.
They use a central server linked to 8 user pc's. I assume I will therefore need a FE/BE database. Would it be useful to determine what version of MS Server Client they're using?
Using Standard Access 2000 or above, (i've still to confirm what version they require it written in) can a FE/BE database be created, that will be useable (speed / reliability etc)?, I'm told that they will have ~4 users using the system at any one time. Do I need to consider using SQL Server (and if so what level / version)?
From initial emails, the 4 main .dbf files are 50Mb each. I seem to recall that without using SQL Server, once a standard Access Database starts to exceed 200Mb it starts to cause operational issues. Is this correct?
Lastly, if anyone can point me to a good book / website that discusses the standard coding changes that need to be made when establishing connections etc in VBA for multiple user databases I would be extremely grateful.
Thanks in Advance
View 5 Replies
View Related
Oct 30, 2007
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,
View 10 Replies
View Related
Jan 10, 2008
Well...I started writting out what I wanted to do and realized that its so complicated to explain that I doubt anyone is going to read through it all. I am going to try and break it down in a simple start off question.
What are some ways to have users enter data into an Access database? I would prefer to use only Access and Excel. The users would need to be able to look up multiple records using a query I suppose, and then be able to edit the data. The only way I know how to do this now is to actually use Access and I wouldn't want everyone just messing around in access.
I really need to have a dialouge with someone to explain what I am trying to do and actually get some help...but I don't know anyone who knows database sytems well at all.
Anyone up for some IM/Yahoo/MSN/Gmail?
Oh yeah first post...
View 4 Replies
View Related
Jan 20, 2008
I am in need of assistance in producing a database. The database is simply a "log" or "record" which i need to work in the following ways:
> a user enters a password to log onto there own little area of which they can fill out forms asking thing such as: how many hours done, what they have done etc.
> an administrator can then log on and look at everyones accounts and print off reports etc.
I have had ago at this and made some progress but i am very stuck so any help is greatly appreciated.
Thankyou!
View 7 Replies
View Related
Oct 9, 2005
I'm having a problem that I have been trying to sovle for a while.
I have two tables. What I want to do is to have the user tick a box in one of the fields on table 1 and for it to mirror that change on table 2 in a specified field. I really don't know how to go about doing this. Any ideas? :confused:
Thanks Guys
Andy
View 1 Replies
View Related
Dec 2, 2004
am working on a Microsoft Access project for my computer tech class and I am stumped on a few things.
I have to do a payroll for all the employees on the project he gave us, I have to list their names, pay rate, and all tax rates when I put in another table. When I run the query and put all the requirements in the query and run it in datasheet view, it comes up with the employees name and every single type of payment and tax rates. So for IE, operations manager makes $18.75 a hour, but when I run the query it has 18.75, 15.00, etc for all the payrates given. How can I have it so just the pay rate and tax rate for just the person who is paid that??
I also have a Address book for all the workers. I need to group them by location of the stores(there are 3 store locations) and then sort the job location workers by last names, any help on how to do that??
I have the assignment scanned if anyone would want to see what all I have to do...
View 1 Replies
View Related
May 13, 2005
I've got an MS Access *.ade project as a front to an MS SQL Server 2000 database (both developed by myself)
From time to time *.ade project stops working properly and title of the main access window says "Project <Project name> (disconnected)"
I check the File -> Connection-> Data Link Properties and everything is o'key ('Test Successful') however on the 'Tables' tab there are still no tables shown, the title remains as 'disconnected' and form's data sources are not accessible
Nothing helps... any ideas?
View 1 Replies
View Related
Jun 6, 2005
Hi im in the process of starting a small project to be used at work. Basically I want an Access DB which will be used by about a dozen people, accessing it over a network drive. I want them to be able to do the standard create/edit/delete records and wotnot in different tables of the DB and also want some reports and search functions.
In the future I want room to make more advanced things in it.
Would I be best to do this all in Access with forms and reports, or maybe use VB for a frontend or even something else?
Dont have much experience with Access outside of the standard DB records stuff, will security and multi access be a problem with Access?
cheers
View 1 Replies
View Related
