473,763 Members | 1,908 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

How to Fix this database - Customer Orders.rar (0/1)

I have a database that was built for us by a gentlemen from Sri Lanka.
The database was supposed to have an invoice that could be edited
after it was created and also there was supposed to be a feature that
when the invoice was created that it would also create a balance for
the customer and allow me to record the payments the customer makes
and apply it towards the balances. It was also supposed to show
backorders. Also on the invoice it was also supposed to sort by
category and than product number. Is there any hope on fixing it and
if so how or should I look elsewhere for someone else to create it. I
have fooled with this guy for 6 months and I gave up as he wasn't
getting anywhere.
Nov 29 '06 #1
3 1572
Here is the database

On Tue, 28 Nov 2006 21:47:50 -0600, sy*****@mywdo.c om wrote:
>I have a database that was built for us by a gentlemen from Sri Lanka.
The database was supposed to have an invoice that could be edited
after it was created and also there was supposed to be a feature that
when the invoice was created that it would also create a balance for
the customer and allow me to record the payments the customer makes
and apply it towards the balances. It was also supposed to show
backorders. Also on the invoice it was also supposed to sort by
category and than product number. Is there any hope on fixing it and
if so how or should I look elsewhere for someone else to create it. I
have fooled with this guy for 6 months and I gave up as he wasn't
getting anywhere.
Nov 29 '06 #2
<sy*****@mywdo. comwrote
>I have a database that was built for us by a gentlemen from Sri Lanka.
The database was supposed to have an invoice that could be edited
after it was created and also there was supposed to be a feature that
when the invoice was created that it would also create a balance for
the customer and allow me to record the payments the customer makes
and apply it towards the balances. It was also supposed to show
backorders. Also on the invoice it was also supposed to sort by
category and than product number. Is there any hope on fixing it and
if so how or should I look elsewhere for someone else to create it. I
have fooled with this guy for 6 months and I gave up as he wasn't
getting anywhere.
Very likely, for someone to spend the time and effort to analyze a database
with months of work in it (even, or perhaps especially, ineffective work),
you are going to have to find a consultant or contractor and pay them.
That's not the kind of question that is likely to be handled in a newsgroup.
That said, this is also not the place to solicit employment or contract
work.

The way you _can_ use this newsgroup to find someone to do work is to look
at the answers people have given to questions here. Some answers will stand
out, and then you can try to contact the person directly to ask if they do
"remote contracting." Some do, and some do not, who participate here. And,
sometimes, people will contact you directly, but if you don't see examples
of what they can do in the newsgroup, you may end up with another
ineffective contractor.

There are newsgroups with "jobs" in the title where you can find people who
want to work, and there are employment sites, of course. Over they years,
there have been some free or inexpensive sites where database developers
could post their credentials and availability. I don't know of one that is
currently operating that I would recommend.

Your description of the database does not sound awfully complex, and if
there isn't a lot of detail that you left "unsaid," I would agree that 6
months seems a rather long time to accomplish those simple specifications.

Larry Linson
Microsoft Access MVP
Nov 29 '06 #3
Hi.
Is there any hope on fixing it and
if so how or should I look elsewhere for someone else to create it.
If you have the time and the inkling to learn yourself, you can ask
questions and we'll answer them for you. If you don't have the time or
desire, then you should find a professional Access database developer to
develop your databases, not "the cheapest guy I could find." Professional
database developers may cost more per hour, but they take far fewer hours
because they're experienced and know how to do tasks correctly the first
time. The tasks you've outlined should have taken several hours to a day or
so depending upon the complexity, not six months.

Job solicitations are not welcome in this forum, but you can easily find
expert Access database developers by reading the questions and answers in
the Access newsgroups. After a short while you'll be able to determine who
consistently gives high quality answers, not guesses, because they know what
they're talking about. Many who answer questions here in the Access
newsgroups are also consultants and have a contact E-mail address or Web
page with contact information in their posts' signatures.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

<sy*****@mywdo. comwrote in message
news:b7******** *************** *********@4ax.c om...
>I have a database that was built for us by a gentlemen from Sri Lanka.
The database was supposed to have an invoice that could be edited
after it was created and also there was supposed to be a feature that
when the invoice was created that it would also create a balance for
the customer and allow me to record the payments the customer makes
and apply it towards the balances. It was also supposed to show
backorders. Also on the invoice it was also supposed to sort by
category and than product number. Is there any hope on fixing it and
if so how or should I look elsewhere for someone else to create it. I
have fooled with this guy for 6 months and I gave up as he wasn't
getting anywhere.

Dec 3 '06 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
1669
by: James Armstrong | last post by:
Hi all, (warning - long post ahead) I have been tasked with designing a database for my company which will store trade information (it is a financial firm). It will need to export this info into an excel file while converting some of the data into an export format (example - we use B for buy, the firm we export to uses BY). Eventually, accounting will also need reports from the data.
8
5030
by: RibGnaw | last post by:
Long, long ago when Access 97 first hit the streets a sample database called Northwind was shipped with it. At that time a number of articles had been posted on the correct procedure to remove all the sample data. Does anyone out there still have this information?
8
1590
by: mesut | last post by:
Mybe it's a stupid question but : I'm starting to learn VB.NET. I have some basic skills. I'm from Mainframe world and I have same question to make my DATABASES (tables and relation) I would like to make ask my question by example. Let's say I'm a sales company I'm selling products to customers. Okay? I have these tables (databases) and fields and I have these questions. I have created these tables in VB.NET Database Connections IDE...
1
2599
by: Magnus | last post by:
I'm testing walkthrough saving data to a Database (Multiple Tables). http://msdn2.microsoft.com/en-us/library/4esb49b4(VS.80).aspx In the famous Customer/Order example, I'm getting referential integrity problems "The INSERT statement conflicted with the FOREIGN KEY constraint..." if the identity/primary key column is "out of sync" with the identity value in the database. I can easily acheive this f.ex. by pressing add new record,...
76
272531
MMcCarthy
by: MMcCarthy | last post by:
Normalisation is the term used to describe how you break a file down into tables to create a database. There are 3 or 4 major steps involved known as 1NF (First Normal Form), 2NF (Second Normal Form), 3NF (Third Normal Form) and BCNF (Boyce-Codd Normal Form). There are others but they are rarely if ever used. A database is said to be Normalised if it is in 3NF (or ideally in BCNF). These steps are descibed as follows: Note: When attribute...
0
9566
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9389
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10149
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
9943
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
6643
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5410
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3918
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3529
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2797
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.