Seeking Assistance Of Access Developer For A Small Project
Mar 30, 2007
Hi all,
I've read this forum for quite a while, but just now registered and this is my first post. It's full of great information and I really appreciate all I've learned!
I'm looking to contract / hire an Access Developer for a small project. Essentially, it's taking a CSV file, importing it into Access, then exporting the data within certain parameters into an Excel spreadsheet. There are a few other small details that pertain to how the data is handled in the actual db itself, but that is the overall picture of the project. It's rather small, but is above my Access knowledge level.
My most important goal is getting the DB functional, but then taking the finished product and breaking it down to learn from it.
Please PM me if you're available to assist on this project. Have a great weekend!
View Replies
ADVERTISEMENT
Sep 18, 2005
Hi all,
I am new here, I am never one to ask for help, but I am desperate to get some assistance and hoping someone may be able to help me. I have just basic knowledge of MS Access, but no where near the skills needed to acheive what I am needing.
To explain, I am involved with a national memorial of all the Truck drivers who have been killed on our roads. I have a database in access, (near 1000 individuals and sadly growing) but wanting to create it into a form style. I also need to add a photograph of each deceased person and a second photograph of the plaque which they are on. Years ago I saw a form which I was impressed with, it looked so professional but never had the oportunity to investigate or disect it :)
I am hoping sks who will enjoy the challenge may be able to assist me.
more about the memorial can be seen at www.tarcuttamemorial.com
Thanks Dianne
View 2 Replies
View Related
Jul 10, 2005
a link is created between 2 sites
a circuit can travel over any given site
dataflow is from the left going towards the right
if site b fails, so does site c, d, e, f
but A still lives on
so how do I create a relationship between the tables to answer the queries correctly?
a site has many links, and a link has many circuits.
a circuit has many links
its a many-to-many relashonship.
I created a junction table to provide for the link circuit relationship.
I just need to know how to ask if site c is down, give me the link and circuit that is effected.
Or give me all the links and circuits effected.
The other site_1 table is there to eliminate data duplication for start abd end site which is just a site in the sites table. Its a form of normalization.
Any help would be appreciated.
Thanks,
-Jon
View 2 Replies
View Related
Oct 14, 2005
I’ll do the best I can to explain what I would like my program to do, maybe you can give me a little bit more guidance.
Alright – I have a database with the following 3 tables
Assets – Asset ID (PK)
Inventory – no PK
Preventative Maintenance – no PK
I created corresponding forms for each table, each with the same name.
Here is what I can do as of now:
Assets form - I am able to enter the asset #, description, serial #, hours between PM (preventative maintenance), and starting hours (same as an odometer) which I have set to 0.
Inventory form – Able to enter Part#, Asset ID (this allows the user to distinguish which asset this part was made for), Part Type, Part Description, Vendor, Location, Quantity, Individual Price, Total Price, Tax (Of the currency fields I just mentioned, I have it setup calculate the Total Price by multiplying the quantity * individual price. I also set it up to calculate 7% sales tax within the form)
Preventative Maintenance – The first field is PM# (auto number), Asset ID (distinguish which asset is being worked on), Date Checked In, Time In, Time Out, Current Hours, PM Performed, Part #, Quantity Used.
Well hopefully I haven’t just thrown a lot of information your way. So now that I have given you what my project can do, let me try and explain what I want it to do. And please keep in mind that I have been trying every which way I can to create the proper relationships, or foreign and primary keys, but that concept still passes by me at times.
I want to be able to know that if I have 10 tires for asset 1500, and I perform a PM on Asset 1500 and use 2 tires, that I will have 8 remaining. Maybe I just am missing the simple solution here, but I have been trying for days. Also, that value 8 should be the new on hand value within the inventory. I need it to update.
If I have 10 tires with part # TIR1500, and then I receive 2 more a few days later, how can I get the quantities to correspond? It seems as though I was able to work this out through queries to get the correct info, but due to the relationships I tried setting up, when I got to the PM and the quantity used, it threw my totals off.
View 1 Replies
View Related
Jul 5, 2007
Hi,
I am fairly new to access and still am not sure I fully understand how to do what I would like.
I have a fairly large database for community participants... On the "master database" if you will, I am entering either the child or parent who may participate in the programs - with their demographic information.... (some participate in various programs, or only one)
On master table, each participant is given an autonumber and identified by which programs he or she may be participating in.
On a sub tables, I would like to take attendance for each program.
Is there a way, I can create a table for one program and for access to identify all particpants from a particular program, pull in participant name and allow for entry.
1. Is this possible?
2. IF so, will this create a problem if the participant is in multiple programs?
3. I am trying to minimize the reentry of participants, and if new members are added at a later date, that access automatically places these names on the sub tables of attendance///
Thank you for any and all help you are able to provide....
M
View 6 Replies
View Related
Jan 16, 2008
Hello,
We are looking for an Access Developer for a small business. You must be in the New York City area and willing to come in for an interview. I will check this board every 1-2 days.
Thank you.
View 5 Replies
View Related
Aug 29, 2005
Hello,
I have an Access application I need to package for redistribution. Following the instructions on MSDN, I purchased Visual Studio Tools for Office 2003 to acquire the Access Developer Extensions which include the Package Wizard.
After installing VSTO, I found that Access Developer Extensions are not included. Can anyone tell me where I can get a copy of Access Developer Extensions? Is the Package Wizard available for download anywhere? Perhaps someone with an MSDN subscription would be nice enough to make this available to me?
Are any instructions availalbe for creating an installation file for an Access MDE file and including the Access Runtime?
Thanks,
Redluv@gmail.com
View 6 Replies
View Related
May 4, 2006
Is there anyone based in or near Nottinghamshire (UK) who would be interested in reviewing the current database system we use at our office? We are a skiing holiday company and the database is fairly complex.
It was created about ten years ago and over time has had various bits and pieces added on etc. and I am under the impression it is currently a mess!
I am looking for a professional database developer, not an amateur who fancies themselves as such! If anyone can help, please post your details and credentials and I'll give you a shout.
Cheers.
View 1 Replies
View Related
Feb 3, 2008
Hi,
I have installed Access Developer Extensions and Access Runtime but still I can not see the "developer" option in menu. Can someone please help me to find this option.
SF
View 1 Replies
View Related
Feb 14, 2005
Hi Guys,
I hope I am in the right forum area. I have just upgraded to XP Home and have a choice of Office systems to install. However I have Office 97 Developer Edition that I use for Access Databases and this must be installed. I can also install either Office 2000 or Office XP Professional. What are the problems with having any of these combinations and Access 97 with the developer.
I have heard that there may be licencing issues or I may have to install in a particular order. Any advice would be appreciated.
Many thanks
Chris
View 2 Replies
View Related
Feb 16, 2006
Guys,
I need some good books for Access developers.. I want to what Access really can do.. I know create tables and queries.. How about create stored procedures and triggers using VBA in Access? Or any other more complex tasks in Access. I want to know more about this.
Thanks.
View 1 Replies
View Related
May 4, 2005
I forked out nearly £600 for Visual Studio.NET Professional Special Edtion, which was advertised as coming with the Visual Studio Tools for Microsoft Office. Which it did. I checked the Microsoft site and they advertised the VSTO as coming with the Access Developer Extensions, so I went ahead with the purchase.
Now I've since found out that the Access Developer Extensions are yet again separate from all this, so I will have to spend more money. That annoys me but I can live with it (I've no choice really), but where can I purchase the Access Developer Extensions CD? I have scoured the web and haven't found a single source, but apparently it does exist. As an additional note, I am based in the UK.
View 5 Replies
View Related
Nov 10, 2005
I have an existing MS Access/MySQL app that I need an experience developer to develop further. The existing application is fairly complex, so experienced developers only.
View 2 Replies
View Related
Dec 24, 2005
Hi,
I've finally opened the Visual studio for MS Office systems tools box and found the access 2003 developer extension CD and loaded it,
I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case.
Sure enough I was right again, Can any one help?
My problem is when I open the custom startup wizard or the custom package wizard it opens a form that is suppose to have templates to choose from so to get started, How ever there are no templates in the form the form is blank. Which leaves me stuck with no options to get started.
All I installed on my PC is the access 2003 developer extensions, did I not install some thing I should of?
Thanks; Any Help will be greatly appreciated.
View 1 Replies
View Related
Apr 12, 2006
Hi,
I wonder if it is necessary for the client machine in which a deployment (with runtime) is going to be installed, to have also installed any Access version or if the runtime deployment licence is enough.
Thank you,
Gilbert
View 2 Replies
View Related
Jun 6, 2007
hi,
how and where can i download Access 2007 Developer Extensions?
or
does anybody knows when it will be released if not so.?
View 1 Replies
View Related
Jul 10, 2007
This is a repeat of an old thread but all the Microsoft links have been broken because of Office 2007
We are trying to deploy an Access 2003 runtime solution for about 6 users and I would *like* to download a free version of the Access 2003 Runtime. Any idea where I might get it from?
Failing that we would buy it but I want to know exactly what to buy/what works/etc Upgrading to Office 2007 is not an option at the moment.
Martin
View 2 Replies
View Related
Dec 10, 2007
This may be a realy dumb question so before i ask it a will say i have just recently installed office 2007 with access and the access developer extentions but have been developing in access for over 10 years.
Now here i go. Just imagine im say this in a really slow dumb voice.
'Where do i find the "Package Solution Wizard" to create my MSI setup package?'
Now thats cant be too hard. I installed the package and the documetation suggests this: "To start the Package Solution Wizard, click the Microsoft Office Button, click Developer, and then click Package Solution."
But i do not see a "developer" menu item.
Maybe my dumb question should be "Why dont i have a developer option in my access menu?"
Any clues? :confused:
View 2 Replies
View Related
Feb 20, 2008
Hello,
As some of you probably noticed there is a bug in de access 2007 developer extensions.
When you package your solution and for the root install folder you select (all users) you get a warning when you startup your packaged solution.
When you select current user you dont get a message.
Does anybody know if this problem is solved by microsoft?
View 5 Replies
View Related
Feb 27, 2008
A few days ago I had a Vista-crash. I reinstalled Vista (Ultimate) and
Microsoft Office 2007 Professional. Before this crash, I installed Access
2007 Developer Extensions and it worked perfect. But since I reinstalled
Office 2007, the Developer Extensions option doesn't appear anymore in the
Office button. I tryed with the Access Options - Add-ins - Manage COM Add-ins
- GO - Add - Program Files - Microsoft Office - Office12 - ADDINS -
AccessDE.DLL - OK. This was not successfull: Any suggestions? Thanks
Luc Ringoir
Belgium (Europe)
balloonplanning@skynet.be
View 1 Replies
View Related
Aug 31, 2005
I'm considering re-writing my access97 database to access 2003
and turning it into a self-executing db for distribution to computers that don't have any versions of access installed.
I was told purchasing Microsoft visual studio tools for office 2003, which has access 2003 developer extensions, could do this.
Does any body have any experience with trying to accomplish this? And if so, are there any tek-tips that you can recommend to make this maybe a little easier, I'm not sure what it will do to .mdb file?
Thanks--any suggestions will be much appreciated.
View 6 Replies
View Related
Dec 24, 2005
Hi,
I've finally opened the Visual studio for MS Office systems tools 2003 box and found the access 2003 developer extension CD and loaded it,
I've been reading the overviews on the CD as always it sounds easy to use, how ever through experience on APPs that is not always the case.
Sure enough I was right again, Can any one help?
My problem is when I open the custom startup wizard or the custom package wizard it opens a form that is suppose to have templates to choose from so to get started, How ever there are no templates in the form the form is blank. Which leaves me stuck with no options to get started.
All I installed on my PC is the access 2003 developer extensions, did I not install some thing I should of?
Thanks; Any Help will be greatly appreciated.
View 3 Replies
View Related
Nov 29, 2006
Hello friends.
Do you know anything about a new Developer Extension for Access 2007 ?
Thank :) :)
View 1 Replies
View Related
Apr 4, 2007
Hi,
I saw many posts in here. Most of the posts are said that we need to use Access Developer Edition to distribute the Access Runtime for our clients.
Can we just buy/use the Access RunTime Modules and unlimited licenses without using Access Developer Edition?
View 2 Replies
View Related
Dec 11, 2006
After almost 10 years developing MS Access applications for the government, I'm attempting to write an effective resume to begin my job search. I've single-handedly designed, tested and implemented over 40 small to medium sized applications to handle everything from classified document management to personnel tracking to event planning. Most of these systems were fairly complex with pages of VBA code, automation and FE/BE structure to allow concurrent users.
I'm having a terrible time verbalizing the work I've done with Access while making it sound impressive to companies using larger, more robust systems like SQL Server or Oracle.
With the stigma that comes with Access, I would love to know how Access resumes could be written to accurately portray the ability to design logical schema, design intelligent interface and define system requirements while conveying that the skill to perform these tasks translates to other systems as well.
Can anyone here (PatHartman, ghudson, et al) provide:
A) a sample resume for an Access developer?
B) sample language to include in an Expert Access Developer resume?
I thank all of you, in advance, for your time and any assistance you can provide.
Happy coding!
View 4 Replies
View Related
Mar 7, 2007
Hello,
When I view my orders page, there is nothing displayed.
I have to query this by Orders.aspx?CustomerID=Sam to display Sam`s orders.
Is there a way that Sam can view all his orders as Sam is the username and the CustomerId?
I specified this query string, but to no avail:
SELECT DISTINCT [OrderID], [CustomerID], [OrderDate], [TotalPrice] FROM [Orders] WHERE ([CustomerID] = ?)
Thanks,
Jane
View 5 Replies
View Related
